Data Integration Analyst

The Data Integration Analyst connects our ERP and business systems to a single, trusted analytics platform built on Microsoft Azure and Microsoft Fabric. You will design and run the pipelines that bring ERP data into the lakehouse, model it for BI reporting, and use AI tools to speed up integration work and surface insights. You will partner with Finance, Operations and IT to turn raw transactional data into reliable data products the business uses every day., Data integration and ingestion

• Build and maintain pipelines that extract data from ERP systems (e.g., Epicor, Dynamics 365, SAP) and other sources into Azure and Microsoft Fabric.
• Design batch and incremental loads using Fabric Data Factory, Azure Data Factory, Dataflows Gen2 and notebooks.
• Map ERP tables and business objects (GL, AP, AR, inventory, orders) to target data models, and document source-to-target logic.
• Monitor pipeline runs, troubleshoot failures and tune performance and capacity cost.

Data modeling and BI enablement

• Organize data in the Fabric lakehouse and warehouse using a medallion (bronze, silver, gold) structure.
• Build semantic models and support Power BI dashboards and reports for Finance and Operations.
• Write and optimize SQL, and use Python or PySpark for transformation where needed.

Data quality and governance

• Implement validation, reconciliation and completeness checks between ERP sources and reporting outputs.
• Apply security, access controls and data classification using Microsoft Purview and Fabric workspace roles.
• Support audit and SOX requirements with documented, controlled data flows.

AI and automation

• Use AI tools (Copilot in Fabric and Power BI, Azure OpenAI, Azure AI services, GitHub Copilot) to speed up pipeline development, documentation and analysis.
• Prepare clean, well-governed data sets for AI and machine learning use cases.
• Identify opportunities to automate manual data processes.

Collaboration

• Gather requirements from business stakeholders and translate them into technical designs.
• Work with ERP administrators, IT and analytics teams on system changes, releases and upgrades.
• Maintain clear documentation and contribute to data standards and best practices.

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Finance or a related field, or equivalent experience.
• 3+ years of experience in data integration, data engineering or BI development.
• Hands-on experience with Microsoft Azure data services (Azure Data Factory, Azure Data Lake Storage, Azure SQL or Synapse).
• Experience ingesting and modeling data from at least one major ERP system, with a working knowledge of finance and operations data (GL, AP, AR, inventory, orders).
• Working experience with Microsoft Fabric (lakehouse, warehouse, pipelines or Dataflows Gen2).
• Strong SQL skills and experience building data models for reporting.
• Experience with Power BI or a comparable BI tool (Tableau, Qlik), including semantic models and DAX.
• Practical use of AI tools to support development, analysis or documentation., * Microsoft certifications such as Fabric Analytics Engineer Associate (DP-600), Fabric Data Engineer Associate (DP-700), Azure Data Engineer, or Power BI Data Analyst (PL-300).
• Experience with Python or PySpark in notebooks.
• Familiarity with ERP integration tools and APIs (OData, REST, Dataverse, SAP connectors).
• Experience with Azure OpenAI, Azure AI services or building AI-ready data sets.
• Exposure to Microsoft Purview, data governance or master data management.
• Experience with Git, Azure DevOps and CI/CD for data pipelines.
• Understanding of SOX and internal controls over financial reporting data.

Core competencies

• Analytical problem solving: traces data issues to the root cause across systems.
• Attention to detail: delivers accurate, reconciled data that Finance can rely on.
• Communication: explains technical topics clearly to non-technical stakeholders.
• Business acumen: understands how ERP processes drive financial and operational reporting.
• Continuous learning: keeps current with Azure, Fabric and AI capabilities.
• Ownership: manages multiple priorities and follows work through to completion.

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Retirement plan