Hands-on engineering role to design, build, and maintain scalable ETL/ELT data pipelines, data warehouses and lakes, and data models. Optimize batch and near-real-time processing, implement query optimization and data quality checks, support AI data workflows, and collaborate with architects, analysts, and stakeholders.
This is a hands-on engineering role focused on designing efficient data pipelines, improving data infrastructure, and enabling teams to leverage data effectively.
Responsibilities- Design, build, and maintain scalable data pipelines and ETL/ELT workflows to ingest and transform data from multiple sources
- Develop and optimize batch and near real-time data processing pipelines for analytics and reporting
- Build and maintain data warehouse and data lake structures to support business intelligence and analytics use cases
- Implement and maintain data models that support efficient querying and reporting
- Improve performance and scalability of data systems through query optimization, indexing, and partitioning strategies
- Implement data quality checks, monitoring, and logging to ensure reliability of data pipelines
- Exposure to AI initiatives and experience building data pipelines supporting AI workflows
- Work with data architects and engineering teams to implement scalable data platform designs
- Collaborate with analysts, BI developers, and business stakeholders to deliver data solutions that support business needs
- Maintain documentation for data pipelines, data models, and data workflows
Bachelor's/Master's in Engineering 5-8 years
Similar Jobs
Artificial Intelligence • Consumer Web • Information Technology • Real Estate • Software • PropTech
Lead Analytics Engineer responsible for end-to-end data solution design, evolving data architecture, mentoring engineers, driving data health and observability, enabling cross-functional measurement, and contributing to roadmap and decision-making.
Top Skills:
Automated Testing PipelinesBi ToolsCi/CdDbtEltETLSemantic LayerSQL
Fintech • Machine Learning • Payments • Software • Financial Services
Lead a team of developers on technology projects, collaborate on cloud-based solutions, and mentor peers while utilizing various programming languages and technologies.
Top Skills:
AWSCSSDockerGoHTMLJavaJavaScriptKubernetesNoSQLOpen Source RdbmsPythonSQLTypescript
Financial Services
The Senior Analytics Engineer will create scalable data systems, ensure data quality, support cross-functional teams, and communicate insights effectively.
Top Skills:
AirflowAWSDbtMetabasePower BIPythonRedshiftSQLTableau
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
