Azure Data Engineer - Dynamics 365 & Power BI

Hybrid Environment in Troy MI

Overview / Summary

The Data Engineer is responsible for developing, maintaining, and optimizing the organization's data platform, with a primary focus on transforming raw data into structured, report-ready datasets. This role works heavily with data sourced from Microsoft Dynamics 365 via Synapse Link, transforming "Bronze" raw data into curated "Silver" datasets within the organization's data lake. These curated datasets support reporting, analytics, and business decision-making across departments.

The role is also responsible for automating data pipelines, enabling report delivery, and assisting in the creation of reports and dashboards within the Microsoft ecosystem, including Power BI, Azure, and Synapse. The ideal candidate combines strong data engineering expertise with the ability to collaborate closely with business stakeholders to deliver meaningful insights.

Key Responsibilities Data Engineering & Data Platform

• Design, build, and maintain data pipelines to transform raw "Bronze" data into curated "Silver" datasets

• Develop and maintain data structures within the data lake to support reporting and analytics

• Work with data sourced from Dynamics 365 via Synapse Link and other internal systems

• Create and maintain data models using joins, transformations, and normalization to improve usability and performance

• Ensure data quality, consistency, and integrity across datasets

• Validate authenticity of "Gold" data to source

• Maintain and optimize performance of data transformations and queries

• Support integration between data sources, reporting tools, and downstream systems

• Assist in defining and evolving data architecture standards across Bronze, Silver, and Gold layers

• Build and maintain datasets used for reporting and analytics

  Reporting & Analytics

• Create and enhance Power BI dashboards and reports based on business needs

• Work with stakeholders to define reporting requirements and translate them into technical solutions

• Optimize data for efficient reporting and visualization performance

  Automation & Integration

• Automate data refreshes, report delivery, and scheduled processes

• Build workflows and automation for data movement and reporting pipelines

• Support integration and automation within the Microsoft ecosystem, including Azure services and Power Platform

  Business Collaboration & Support

• Work directly with business stakeholders including Finance, Operations, and Supply Chain teams to understand reporting needs

• Translate business requirements into data models and reporting solutions

• Support ad-hoc data requests and analysis as needed

• Provide guidance on best practices for data usage and reporting

  Documentation & Governance

• Document data pipelines, transformations, and architecture

• Ensure proper data governance practices are followed, including naming standards and documentation

• Maintain visibility into how data flows from source systems to reports

  Required Qualifications

• 3+ years of experience in data engineering, data analytics, or a related role

• Experience working with Azure data platforms such as Data Lake, Synapse, or similar technologies

• Strong SQL skills and experience working with relational data

• Experience building data transformations and working with structured and unstructured datasets

• Experience supporting reporting and analytics workflows

• Strong understanding of data modeling and data pipeline concepts

• Strong problem-solving and analytical skills

• Experience working with Microsoft Dynamics 365 data including Synapse Link and Dataverse

• Experience with Power BI including dashboard creation, data modeling, and DAX

• Experience with medallion architecture (Bronze / Silver / Gold)

• Familiarity with Azure services such as Data Factory, Synapse, or Power Platform

• Experience with data integration across multiple systems including ERP and eCommerce platforms

• Exposure to Databricks or similar tools is a plus

  Soft Skills

• Ability to operate in a fast-paced environment with shifting priorities

• Strong collaboration skills across business and technical teams

• Self-driven with the ability to own data pipelines and reporting solutions end-to-end

• Detail-oriented with a focus on data accuracy and consistency

• Strong communication skills with the ability to explain complex data concepts in simple terms

  What Makes HTC A Great Place To Build Your Future

HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you'll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You'll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.

At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.

Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.

LI-Hybrid #LI-NC1 #AzureDataEngineer #NowHiring #MichiganJobs