Sr. Data Engineer 5164

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