Data Engineer Azure & Dynamics 365

Job Title: Data Engineer (Azure & Dynamics 365)

Location: Deerfield IL (Hybrid- 2days/week)

Initial 6 Months Contract later Fulltime

Client: Premistar

Overview

The Data Engineer will be responsible for building and optimizing the organizations data infrastructure in support of a large-scale enterprise systems transformation initiative. This initiative focuses on implementing Microsoft Dynamics 365 to unify systems standardize processes and improve real-time data visibility across the organization.

In this role the Data Engineer will design develop and maintain robust data pipelines and centralized data platforms (data lake and data warehouse) consolidating data from Dynamics 365 and legacy systems into a scalable unified source of truth.

Experience and Qualifications

Undergraduate degree or equivalent in Computer Science Information Systems or a related field required.

3 5 years of hands-on experience in the design development and support of data pipelines (ETL/ELT processes).

3 5 years of experience writing and optimizing SQL (T-SQL) queries and working with Microsoft SQL Server or similar relational databases.

1 3 years of experience in data modeling and database design.

Prior experience in private equity backed industrial or multi-business-unit companies is a plus.

Skill Requirements

Strong SQL programming skills particularly with Microsoft SQL Server including the ability to write efficient T-SQL queries create stored procedures and perform performance tuning on database operations.

Hands-on experience with Azure Synapse Analytics or similar cloud data warehousing technologies including using Synapse or Azure Data Factory to create and orchestrate data pipelines transform data at scale and manage data lakes/warehouses.

Familiarity with Microsoft D365 (Dynamics 365 Finance & Operations and/or Customer Engagement) or similar ERP/CRM systems.

Proficient in Microsoft Power BI or comparable BI visualization tools including an understanding how Power BI datasets and dataflows work.

Knowledge of DAX and Power BI performance tuning is a plus as is experience with SSRS or other Microsoft BI stack components (e.g. SSIS/SSAS).

Strong understanding of data modeling concepts and tools.

Experience with master data management or data cataloging in a unified data environment.

Familiarity with data quality and profiling tools (i.e. using SQL or Python to implement data validation).

Comfort with a programming or scripting language (e.g. Python PySpark or SQL scripts) to transform and manipulate data within pipelines.

What You Will Do (Key Responsibilities)

Design build and maintain ETL/ELT processes that ingest and transform data from multiple sources (including Microsoft Dynamics 365 ERP and legacy systems) into the organizations Azure Synapse data lake and data warehouse.

Implement data cleansing validation rules and quality checks to ensure data from various business units and systems is accurate consistent and ready for enterprise reporting and analytics.

Contribute to the design and expansion of enterprise data models and schemas (e.g. star schema in the data warehouse) to support evolving reporting needs and standardized business processes.

Partner with analytics and BI teams to enable self-service reporting and advanced analytics capabilities.

Prepare curated datasets for Power BI dashboards by writing efficient SQL queries and developing new data pipeline components as needed.

Collaborate with cross-functional teams-including business analysts data scientists and ERP specialists-to understand data requirements tied to enterprise system implementations and business initiatives.

Follow and promote best practices in data engineering and analytics development (version control code reviews documentation) while continuously optimizing existing data processes.

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex pregnancy sexual orientation gender identity national origin age protected veteran status or disability status.