Sr. Data Engineer 5164

Tier4 Group; Deerfield (IL); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Tier4 Group is seeking a Senior Data Engineer in Deerfield, IL, to support enterprise data initiatives. This role involves designing and optimizing data pipelines, ensuring data quality, and integrating data from multiple systems. Key qualifications include strong SQL skills, experience with Azure Synapse, and a background in data modeling. Candidates should possess an undergraduate degree in Computer Science or related field and be able to work collaboratively in a hybrid environment.

Qualifications

• Experience designing and supporting data pipelines.
• Strong SQL skills for complex queries.
• Hands-on experience with Azure cloud services.

Responsibilities

• Design and maintain automated ETL/ELT data pipelines.
• Optimize data pipeline performance for efficiency.
• Prepare datasets for business intelligence and analytics.

Skills

Designing data pipelines (ETL/ELT)

Strong SQL skills

Experience with Azure Synapse Analytics

Working knowledge of data modeling concepts

Experience with Microsoft Power BI

Education

Undergraduate degree in Computer Science or related field

Tools

Microsoft SQL Server

Azure Data Factory

Power BI

Job description

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