Data Engineer (MS Dynamics 365)

Work Setup: Remote (Philippines-based)
Experience Level: Mid to Senior (3–6 years)
Shift: Nightshift (Flexible)

Who We Are

Clicktek Consulting and yGen Innovations deliver end-to-end RPO (Recruitment Process Outsourcing) services to enterprise clients across multiple industries. Our team works embedded with client organizations to solve complex talent and technology challenges at scale.

We are building experienced Data Engineers who have worked with Dynamics 365 CRM or Dataverse. We care more about strong data engineering fundamentals and real CRM data experience than about any single platform. If you can get clean, reliable data out of D365 / Dataverse and into an analytical environment, we want to hear from you.

What the Work Looks Like

Depending on the engagement, Data Engineers typically work on:

• Extracting and integrating Dynamics 365 CRM data out of Dataverse (Sales, Customer Service, Marketing, Field Service apps) into an analytical platform using Synapse Link, Azure Data Factory, APIs, or similar approaches.
• Navigating the Dataverse data model and CRM entity structure (Accounts, Contacts, Leads, Opportunities, Cases) to build reliable, analytics-ready datasets.
• Building and maintaining data pipelines on a modern data platform such as Microsoft Fabric, Azure Data Factory, Databricks, or equivalent.
• Querying Dataverse (FetchXML, Web API / OData, or the SQL endpoint) to retrieve, validate, and reconcile CRM data.
• Handling CRM-specific data quirks such as soft deletes and state codes, plugin-triggered field changes, and polymorphic lookup relationships.
• Preparing and delivering data that feeds Power BI semantic models in close partnership with BI teams.
• Implementing data quality checks, testing, and monitoring across pipelines.
• Collaborating with stakeholders across US, EMEA, and APAC time zones.

What We Look For

Must Have

• Availability to work nightshift hours (flexible schedule).
• 3+ years of hands-on experience as a Data Engineer (or BI / Analytics Engineer) on cloud data systems.
• Strong data engineering fundamentals on any modern data platform such as Microsoft Fabric, Azure Data Factory, Databricks, Synapse, or Snowflake, including building and maintaining data pipelines.
• Hands-on experience with Dynamics 365 CRM or Dataverse (extracting, integrating, or modeling CRM data).
• Working understanding of the Dataverse data model and CRM entity structure (Accounts, Contacts, Leads, Opportunities, Cases).
• Strong SQL and Python skills.

Strong Advantage

• Dimensional modeling and building datamarts for BI and analytics (star/snowflake schemas, SCDs).
• Experience ingesting Dataverse data via Synapse Link for Dataverse or an equivalent managed export path.
• Proficiency with FetchXML and the Dataverse Web API / OData.
• Practical experience handling CRM data quirks such as soft deletes/state codes, plugin-triggered field changes, and polymorphic lookups.
• Hands-on Power BI development including semantic models and DAX.
• Working knowledge of the broader Azure data stack (ADF, Databricks, Synapse Analytics, ADLS Gen2) or an equivalent such as Snowflake.
• Familiarity with data quality frameworks and monitoring best practices at scale.

Nice to Have

• Microsoft certifications such as PL-300, DP-700 (Fabric Data Engineer), or DP-203.
• Exposure to the wider Power Platform (Power Apps, Power Automate).
• Background in CPG, life sciences, or wellness industries.

Tools and Platforms We Work With

Experience with any of these is a strong advantage. You do not need all of them.

• Dynamics 365 CRM
• Dataverse
• Synapse Link
• Microsoft Fabric
• Azure Data Factory
• Databricks
• Synapse Analytics
• Power BI
• SQL / Python
• Snowflake

Why Join Us

• Own the CRM-to-analytics data path end to end, from Dataverse extraction through to BI delivery.
• Work across a modern cloud data platform supporting a global life sciences organization.
• Collaborate with BI, analytics, and commercial stakeholders across multiple regions.
• Remote, full-time setup for Philippines-based candidates.