Senior Data Engineer
$160,555–$160,555 year
HybridRosemont, Illinois, United States
Job Summary
Design, develop, and continuously improve complex data systems, including ODS, staging, data warehousing, and data marts. Build and test complete data pipelines using SQL, Python, and SSIS, while creating CI/CD pipelines via Azure DevOps. Ensure data governance by implementing lineage, quality checks, and classification, and prepare technical specifications and design documents. Mentor less experienced team members and optimize data delivery through process automation. Work in a hybrid role requiring one week in the Rosemont, IL office, with a salary of $160,555 plus bonus eligibility.
Required Qualifications
- Bachelor's degree in Computer Science, Computer Engineering, Information Systems, Engineering, Math, or a related field of study
- 7 years of experience in a related occupation
- Master's degree in Computer Science, Computer Engineering, Information Systems, Engineering, Math, or a related field
- 5 years of experience in a related occupation (alternative to Master's degree)
- 5 years of experience in Data Engineering, designing, implementing data persistence, data processing, and data integration
- 5 years of experience in designing and building complete data pipelines moving and transforming data for ODS, Staging, Data Warehousing and Data Mart
- 5 years of experience in processing semi-structured and unstructured files using Microsoft SSIS and SQL
- 3 years of experience with medium-scale data and query optimization techniques
- Experience with Data Warehouse concepts, including 3NF and the Dimensional data model
- Experience in implementing and validating data lineage, quality checks, classification
- Experience in creating, enhancing, and supporting ETL/ELT processes to ensure business continuity, meet best-in-class standards and offer high performance
- Experience in analyzing the requirements, preparing technical specifications and detailed level design documents
- Experience in building CICD pipelines for data pipelines using Azure DevOps
- Requirement to physically be in the Rosemont, IL office once a week
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.