Sr. Data Engineer with Experience in Migrating Reports from ERPs (Onsite-TX)

About the Role

We are seeking a Sr. Data Engineer to design, build, and optimize enterprise data solutions across our Microsoft ecosystem. This role focuses on Microsoft Fabric, Power BI, and Azure data services (including Azure Data Factory, Azure Data Lake, and Azure SQL Database/Data Warehouse) to support analytics, operational reporting, and self-service BI.

About You

• Bachelor s degree in computer science, Information Systems, Data Engineering, Data Science, Software Engineering, Applied Mathematics, or a related technical field; equivalent experience considered.
• 7+ years of experience in data engineering roles, with significant hands-on background in development/engineering background.
• Strong SQL and data modeling skills:
  • Design and optimization of relational and analytical models; complex queries and tuning.
  • Experience with stored procedures, views, indexing strategies, and query performance diagnostics.
• Proven track record designing and governing Power BI solutions:
  • Enterprise datasets/semantic models, DAX, RLS, and deployment pipelines.
  • Creating and supporting Power BI reports and dashboards, including maintaining legacy content while transitioning to new data sources.
  • Experience migrating reports and datasets from legacy ERP systems such as JD Edwards to Dynamics 365, including side-by-side reconciliation and validation.
• Hands-on experience with Microsoft Fabric or similar Azure services:
  • Worked with Lakehouse/Warehouse, Power BI reports, and semantic models.
  • Implementing governance, security, and performance best practices.
  • Experience creating and managing Microsoft Fabric data pipelines or Azure Data Factory, including orchestration, monitoring, and error handling.
  • Expertise in Python for data engineering, advanced transformation, automation, and integration tooling, including scripting for Fabric, Data Factory, and API-based integrations.
• Experience with DevOps and ALM for Power Platform, Fabric, and Azure resources (e.g., Azure DevOps or GitHub Actions).
• Solid understanding of security, identity, and compliance:
  • Azure AD/Entra ID, OAuth, service principals/managed identities, and secrets management.
  • Awareness of controls needed for SOX/ITand public-company environments.

Nice to have

• Experience with reporting and analytics for Dynamics 365
  • Building or supporting Power BI / Fabric-based reporting on top of D365 data.
  • Migrating reports and datasets from legacy ERP systems (e.g., JD Edwards) to Dynamics 365, including side-by-side reconciliation and validation
• Experience with Dynamics 365 (F&O and/or CE) and its integration capabilities:
  • Data entities, Dataverse, OData/REST APIs, webhooks, and export-to-data-lake patterns.
  • Understanding of core D365 data models and key financial/operational processes.
• Experience with additional Azure services (e.g., Azure Functions, Service Bus, Event Grid, API Management, Data Factory beyond Fabric scenarios).