• Build and maintain ELT pipelines using Fivetran and custom integrations that ingest data from source systems including Procore, Salesforce, ERP platforms, and internal databases into Snowflake • Develop, test, and document dbt models that transform raw data into clean, reliable datasets for analytics and reporting across Finance, Production, Supply Chain, and Engineering • Build dimensional models and staging layers following team conventions, ensuring data is structured for optimal Tableau dashboard performance and ad-hoc analysis • Write and maintain dbt tests, monitor data freshness, and investigate data quality issues when they arise, owning resolution through to root cause • Work with APIs and data connectors to integrate new data sources, troubleshoot ingestion issues, and ensure reliable data flow into the warehouse • Maintain clear documentation for data models, pipeline configurations, and business logic so the team can understand and extend your work • Partner with business stakeholders to understand data needs, clarify requirements, and deliver datasets that answer real operational questions • Monitor query performance and pipeline efficiency, identifying opportunities to optimize warehouse costs and model run times • Participate in code reviews, follow Git workflows and CI/CD practices, and contribute to improving the team’s development processes • Stay current with modern data stack tools and practices, bringing ideas for improvement back to the team • Use AI coding assistants and agent-based tools to accelerate pipeline development, code generation, testing, and documentation. Manage AI agents as part of your daily workflow to increase throughput and quality

Are you an experienced electrician who would like to use your brain more and your back less? Are you a self-starting individual who thrives on challenges and enjoys working independently? Do you like to see how things are made? Do you enjoy travel and not being tied to an office or the same work environment every day? Do you want to help build a successful company while also developing skills that will propel your career? Who we are: Rozel, a subsidiary of Guidant Power, provides arc flash evaluations and electrical safety training to industrial and commercial clients nationwide. Since 2011 we have completed thousands of evaluations for well-known companies in healthcare, energy, and manufacturing. We are adding a data collector to our team to help make workplaces safer. If you have 480V 3-phase factory experience we want to talk with you! Who we need: We are looking for an individual with prior industrial electrical experience to travel to customer sites and collect information on their electrical distribution systems. We expect you have experience working in well-run industrial facilities, and can read and understand one line diagrams. You should be able to identify components within the electrical distribution system and describe how they function. Following our safety procedures, you will be required to open live equipment to record data. We are looking for an individual who can work independently as well as with a team. Most of your time will be spent alone, and you must be efficient, able to manage time effectively, understand your limitations and ask for help when necessary. Although you will be alone on site, you will be constantly communicating with our team during the site visit, so there is plenty of support if you need it. What you'll do: - Travel to job sites to conduct arc flash evaluations - Open equipment and record equipment information- via photos, paper, and electronic means - Read and understand one line drawings and make edits to create accurate as-built drawings - Utilize online document storage to retrieve and upload data, as well as spreadsheets to enter information - Communicate with engineering and the customer to answer questions and ensure accuracy - Apply labels to electrical equipment - Conduct yourself professionally at all times because you are the company's interface with our customers. Be able to observe and inquire about other opportunities where the company may be able to help. - Use your brain, not your brawn, we want someone who can use their experience to accurately describe electrical distribution systems so our engineers can efficiently model them. - You’ll get to see how stuff works. From ice cream factories, to tires, to hospitals, to nuclear power plants, you will be working with a wide variety of customers whose names you will know. What you bring to the table: - Industrial experience (previous experience with arc flash evaluations a plus, or an electrical engineering degree) - Ability to travel (valid driver’s license, air travel) - Live within an hour of a major airport - Ability to work efficiently on laptops and tablets and be proficient using applications similar to Google drive, spreadsheets, Google photos, and pdf files. - Proven teamwork and collaboration skills working in a small, highly focused and interactive team Additional Information: - Must be able to lift 50 pounds and walk, stand, and crawl for extended periods - You must reside in the USA - We are not currently providing employment visa sponsorship - This is a 100% travel position What we offer: - Compensation package commensurate with experience and skills - Health insurance - 401(k) - Flexible working policy We are seeking a teammate with the values, skills, and passion to build Guidant Power into the premier partner for electrical safety, reliability, and safety services. Even if you don’t check all the boxes above, but you bring a unique ability to help us fill this important role, we’d love to hear from you. Pay: $80,000.00 - $100,000.00 per year Benefits: - 401(k) - Health insurance Schedule: - 10 hour shift - 8 hour shift - Monday to Friday - Year round work License/Certification: - Electrical License (Preferred) Work Location: On the road This is a Remote (work from home) position.

Job Summary The Data Engineer – Asset Management Analytics supports internal Asset Management and Asset Accounting customers by delivering AI-driven analytics products that support asset onboarding and improve portfolio health, asset performance, operational decision-making, and accounting readiness. This role partners with Asset Management, Asset Accounting, Finance/Investor Reporting, Risk, and Operations to translate business requirements into reliable data sets, repeatable calculations, and automation across both operational and financial reporting workflows. A core emphasis of the position is (1) asset onboarding—organizing and normalizing incoming data tapes and documents into internal systems and models with strong quality controls; (2) investor reporting—developing queries and logic for complex investor reports and waterfall calculations, then streamlining and automating those workflows using modern technology, including LLM-enabled document intelligence where appropriate; and (3) asset accounting support—enabling subledger accounting, reconciliations, and integrations into supported general ledger systems.Responsibilities - Support asset onboarding end-to-end: understand and parse data tapes to define/refine portfolio composition, map fields to internal models, and reconcile inconsistencies across sources. - Gather, organize, inventory, and load source documents and data into destination internal systems with clear traceability and audit-ready documentation. - Normalize incoming data (units, naming conventions, identifiers, hierarchies, dates) to work with internal models; identify gaps, exceptions, and remediation needs. - Validate data and documents for quality and completeness using automated checks and reconciliation (schema/constraints, cross-field validation, duplicate detection, tie-outs to source totals) and targeted manual review. - Partner with Finance/Investor Reporting to understand investor report requirements and develop robust SQL/Python queries that produce accurate, repeatable, and auditable data sets for complex recurring reports. - Develop and maintain calculation logic for investor reporting and distribution waterfalls (cash flows, allocations, fees, reserves, performance metrics) with strong controls, testing, and variance analysis. - Partner with Asset Accounting and Finance to define and maintain accounting-ready data sets, event-to-accounting mappings, and controls that support period-end close, reconciliations, and auditability. - Support subledger accounting workflows and integrations into supported GL systems by developing data transformations, interfaces, tie-outs, and exception reporting for journal entries, balances, and account activity. - Automate and streamline onboarding and investor reporting workflows by building parameterized pipelines, standardized datasets, templated outputs, and monitoring/alerts to reduce cycle time and manual effort. - Leverage LLMs to accelerate development and unlock value from large document sets (e.g., extraction, classification, summarization, grounded Q&A/search) to support onboarding and reporting, with appropriate governance and human review. - Deliver stakeholder-ready outputs through Power BI dashboards and operational reporting (progress, completeness, defect rates, variances, and SLA performance). - Collaborate with Data Engineering/IT to improve data quality, lineage, and access controls across Snowflake and PostgreSQL; deploy solutions reliably and securely. Qualifications - Bachelor’s or Master’s degree in Data Science, Statistics, Computer Science, Engineering, Economics, Finance, or a related quantitative field. - 5+ years of experience in data science/analytics in a financial services environment (e.g., asset management, banking, insurance, fintech, credit/loan portfolios, structured finance). - CFA (Chartered Financial Analyst) candidacy/charterholder preferred, or comparable credentials/experience (e.g., FRM, CAIA, MBA with finance focus). - Strong Python and SQL skills, with experience building production-quality data pipelines, validation checks, and repeatable transformations. - Experience working with Snowflake and PostgreSQL, and delivering investor- and stakeholder-ready outputs through Power BI. - Experience supporting investor reporting and/or finance analytics, including complex recurring reports and waterfall/distribution calculations (preferred). - Experience supporting asset accounting, subledger accounting, and GL integrations, including reconciliations, journal-entry support, and controls for accounting data pipelines (preferred). - Familiarity with supported GL systems and accounting data structures (e.g., chart of accounts, trial balance, journal entries, subledger-to-GL tie-outs) is strongly preferred. - Experience with asset onboarding, data tape ingestion, and reconciling third-party data and documents into internal systems (preferred). - Hands-on experience applying LLMs to enterprise data and large document corpora (e.g., extraction/classification/summarization and grounded retrieval such as RAG) in a way that is accurate, traceable, and secure. - Strong communication and stakeholder management skills; ability to translate ambiguous requirements into structured deliverables and clear exception reporting. - Familiarity with Git, orchestration/workflow tools (e.g., Airflow), and responsible AI practices (privacy, security, PII handling, model risk) is a plus.

• Design, develop, and optimize scalable data pipelines using Databricks (highest priority) • Build, automate, and maintain ETL/ELT workflows aligned with organizational standards • Support data modeling, data quality, and pipeline orchestration within cloud environments • Collaborate with cross-functional teams to deliver reliable, production-ready data solutions • Leverage Microsoft Fabric for analytics, data integration, or reporting needs (medium priority) • Provide support for legacy systems when needed, including SQL Server, SSIS, SSRS, and SSAS • Develop and maintain data integrations and pipelines involving Oracle database environments