• The Data Engineer is responsible for architecting, developing, and managing data solutions across the Microsoft Power Platform and Dynamics 365 Finance & Operations (F&O) ecosystem. This role focuses on building scalable, secure, and reliable data pipelines and integration frameworks that enable seamless data movement, transformation, and analytics across Power Platform, Azure, and enterprise systems. The Data Engineer works closely with functional, development, and analytics teams to ensure D365 and Power Platform environments are optimized for data integrity, performance, and business intelligence.

Data Architecture & Integration Design
 

• Design and implement data integration architectures connecting D365 Finance, Power Platform (Dataverse, Power Apps, Power Automate), and external enterprise systems.
   
• Develop robust data pipelines using Azure Data Factory, Logic Apps, or Power Automate for batch and real-time data movement.
   
• Build and maintain Dataverse data models, including tables, relationships, and security roles.
   

Data Transformation & Management
 

• Engineer and optimize ETL/ELT workflows to transform, cleanse, and load financial and operational data from multiple sources.
   
• Leverage Dataflows and Power Query (M language) for in-platform data shaping and enrichment.
   
• Configure and manage D365 Data Management Framework (DMF) entities for master data, transaction data, and recurring imports/exports.
   

Performance, Security, and Governance
 

• Implement data governance policies including ownership, lineage, versioning, and audit trails.
   
• Apply row-level security (RLS) and Azure Active Directory (AAD) role mapping for controlled access.
   
• Monitor data refresh performance, error handling, and automation health across environments.
   

Analytics Enablement & Collaboration
 

• Partner with Power BI developers to expose optimized datasets for analytics and executive dashboards.
   
• Integrate D365 and Power Platform data into Azure Synapse, Data Lake, or Fabric for advanced reporting.
   
• Document integration flows, schema mappings, and reusable data assets for ongoing operations.
   

Automation & Continuous Improvement
 

• Use Power Automate and Logic Apps to orchestrate recurring data operations and workflow triggers.
   
• Collaborate with D365 developers to align extensions and APIs with data design standards.
   
• Continuously refine data models and processes to improve efficiency, maintainability, and reliability.

Qualifications:

• 5+ years of experience in data engineering, integration, or analytics architecture within Microsoft’s business applications ecosystem.
   
• Deep technical expertise with Microsoft Power Platform (Dataverse, Power Apps, Power Automate) and Dynamics 365 Applications, particularly Finance and Sales Enterprise
   
• Proficiency in Azure Data Factory, Logic Apps, Power Query (M), and SQL.
   
• Experience working with D365 Data Entities, OData endpoints, and REST/JSON APIs.
   
• Strong understanding of data modeling, normalization, and data warehousing principles.
   
• Familiarity with Azure Synapse, Data Lake, or Microsoft Fabric for enterprise reporting enablement.
   
• Knowledge of CI/CD pipelines, Git repositories, and environment promotion using Azure DevOps.
   
• Excellent communication skills, with the ability to collaborate effectively across functional and technical teams.