Sr. Data Engineer

Job Description

Position: Senior Data Engineer

Location: Deerfield, IL (hybrid onsite 2 days a week)

Employment Type: Contract-to-hire

Overview

The Senior Data Engineer supports enterprise data unification and analytics initiatives by designing, building, and optimizing scalable data infrastructure. This role is a key contributor to an enterprise-wide ERP transformation based on Microsoft Dynamics 365, enabling consistent, reliable, and timely data across business units. Working within a Data & Analytics team, the Senior Data Engineer partners closely with analytics, business, and technology stakeholders to deliver a trusted, unified data foundation that supports reporting, dashboards, and advanced analytics.

What You Will Do

• Design, build, and maintain automated ETL/ELT data pipelines that ingest and transform data from Microsoft Dynamics 365 and legacy systems into an Azure Synapse data lake and enterprise data warehouse

• Monitor, optimize, and support data pipeline performance to ensure reliable, timely data refreshes and efficient resource utilization

• Implement data quality checks, validation rules, and cleansing processes to ensure data accuracy, consistency, and readiness for enterprise-wide analysis

• Support data unification efforts by integrating data from multiple business units and systems without altering source system integrity

• Contribute to the design and evolution of enterprise data models, including dimensional and star schemas, to support standardized reporting and unified business definitions

• Define and maintain master data structures and relationships that enable analysis across both ERP and non-ERP data sources

• Prepare curated and optimized datasets for business intelligence and analytics use cases, including Power BI dashboards and self-service reporting

• Write and optimize SQL queries and develop new pipeline components to support reporting, analytics, and ad hoc data needs

• Collaborate with business analysts, business intelligence developers, ERP specialists, and other stakeholders to translate reporting and analytics requirements into technical solutions

• Apply data engineering and analytics best practices, including version control, documentation, code review, and performance tuning

• Support data governance standards related to security, privacy, access controls, and overall platform scalability and reliability

What We Are Looking For

Technical Qualifications Required

• Experience designing, developing, and supporting data pipelines (ETL/ELT) that integrate data from multiple systems

• Strong SQL skills, including writing and optimizing complex queries, joins, and stored procedures in Microsoft SQL Server or comparable relational databases

• Hands-on experience with Azure Synapse Analytics, Azure Data Factory, or similar cloud-based data warehousing and integration platforms

• Experience working with large datasets in cloud or hybrid data environments

• Working knowledge of data modeling concepts, including fact and dimension tables and schema design for analytics and reporting

• Experience supporting business intelligence tools, particularly Microsoft Power BI, including datasets and dataflows

• Ability to use scripting or programming languages such as SQL, Python, or PySpark for data transformation and automation

Preferred

• Experience integrating data from enterprise resource planning or customer relationship management systems, including Microsoft Dynamics 365

• Familiarity with Azure Synapse Link for Dataverse or similar ERP data extraction and synchronization approaches

• Exposure to Apache Spark within Azure Synapse environments

• Knowledge of data quality, profiling, or validation frameworks

• Experience with legacy Microsoft business intelligence tools such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), or SQL Server Reporting Services (SSRS)

Core Competencies

• Clear and effective communication with both technical and non-technical stakeholders

• Strong problem-solving skills and attention to detail when working with complex data sets

• Ownership and accountability for data quality, reliability, and outcomes

• Collaborative mindset and ability to work effectively across cross-functional teams

• Adaptability in a changing enterprise and transformation-driven environment

• Ability to translate business needs into scalable technical solutions

Preferred Qualifications

• Approximately 3–5 years of professional experience in data engineering, analytics engineering, or a related role

• Approximately 1–3 years of experience in data modeling or database design for analytics use cases

• Undergraduate degree or equivalent experience in Computer Science, Information Systems, or a related field

• Experience working in a multi-business-unit or enterprise environment, including data unification or consolidation initiatives