Enterprise Data Engineer (Azure & Dynamics 365)

Job Description

Job Description

Job Title: Enterprise Data Engineer (Azure & Dynamics 365)

Location: Deerfield, IL (Hybrid)

Position: Full-Time Direct Hire

TalentFish is casting a line for an Enterprise Data Engineer! This is a full-time hire opportunity with our premier client.

Overview

The Enterprise Data Engineer will be responsible for building and optimizing the organization's 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 organization's 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.

Compensation and Employment

This role requires authorization to work in the U.S. without current or future visa sponsorship. The expected salary range for this position is $120,000 - $140,000 per year, depending on experience and qualifications. This role qualifies for full comprehensive employee benefits such as medical, dental, vision and life insurance, 401(k), paid time off (PTO) and more!

TalentFish is committed to pay transparency and equal opportunity. The salary range provided is in compliance with applicable state and federal regulations. All offers are contingent upon the completion of a background check, which may include but is not limited to reference checks, education verification, employment verification, drug testing, criminal records checks, and any required certifications or compliance requirements based on the end client's background check policies and applicable laws.

TalentFish is an employee-owned company pioneering a new realm in talent acquisition. We are redefining IT staffing by evolving AI, video screening, and our unique platform. TalentFish focuses on providing the best employee, consultant, and client experience possible.