Senior Data Engineer in Mundelein

We are looking to expand our Data Engineering team to build modern, scalable data platforms for our internal investment desks and portfolio companies. You will contribute to the firm’s objectives by delivering rapid and reliable data solutions that unlock value for Cerberus desks, portfolio companies, and other businesses. You’ll do this by designing and implementing robust data architectures, pipelines, and workflows that enable advanced analytics and AI applications. You may also support initiatives such as due diligence and pricing analyses by ensuring high-quality, timely data availability.

» Strong technical foundation: Degree in a STEM field (or equivalent experience) with hands-on experience in production environments, emphasizing performance optimization and code quality.

\n

» Python expertise: Advanced proficiency in Python for data engineering, data wrangling and pipeline development.

\n

» Cloud Platforms: Hands-on experience working with Azure. AWS experience is considered, however Azure exposure is .

\n

» Data Warehousing: Proven expertise with Snowflake - schema design, performance tuning, data ingestion, and security.

\n

» Workflow Orchestration: Production experience with Apache Airflow (Prefect, Dagster or similar), including authoring DAGs, scheduling workloads and monitoring pipeline execution.

\n

» Data Modeling: Strong theoretical and practical understanding of relational and dimensional modeling. Proficient in dbt, including writing modular SQL transformations, building data models, and maintaining dbt projects.

\n

» SQL Databases: Extensive experience with PostgreSQL, SQL Server (or similar), including schema design, optimization, and complex query development.

\n

» Version Control and CI/CD: Familiarity with Git-based workflows and continuous integration/deployment practices (experience with Azure DevOps or Github Actions) to ensure seamless code integration and deployment processes.

\n

» Communication and problem-solving skills: Ability to articulate complex technical concepts to technical and non-technical stakeholders alike. Excellent problem-solving skills with a strong analytical mindset.

\n

» Infrastructure as Code (Nice to have): Production experience with declarative infrastructure definition - e.g. Terraform, Pulumi or similar., » Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.

\n

» Relevant certification from Azure, AWS, GCP, IBM, Snowflake, dbt

» Design, build, and maintain scalable, cloud-based data pipelines and architectures to support advanced analytics and machine learning initiatives.

\n

» Develop robust ELT/ELT workflows using tools like Snowflake, MS Fabric, dbt, ADF, Airflow, and Relational DBs like SQL Server and PostgreSQL, to transform raw data into high-quality, analytics-ready datasets.

\n

» Collaborate with data scientists, analysts, and software engineers to ensure seamless data integration and availability for predictive modeling and business intelligence.

\n

» Optimize data storage and processing in Azure environments for performance, reliability, and cost-efficiency.

\n

» Implement best practices for data modeling, governance, and security across all platforms.

\n

» Troubleshoot and enhance existing pipelines to improve scalability and resilience.

\n

\n

Sample Projects You Work On

\n

Financial Asset Management Pipeline: Build and manage data ingestion from third-party APIs, model data using dbt, and support machine learning workflows for asset pricing and prediction using Azure ML Studio. This includes ELT processes, data modeling, running predictions, and storing outputs for downstream analytics.

\n

\n, » 5 days a week in-office: We believe in the power of in-person collaboration to drive innovation, mentorship, and velocity. This role is based in our office five days a week - ideal for those who thrive in high-energy, team-centric environments.

\n

» Global exposure: Be ready to travel! This role offers occasional cross-continental and international travel opportunities, giving you the chance to engage with global teams, portfolio companies, and cutting-edge tech initiatives around the world.

\n

\n

Work Authorization

\n

We are unable to sponsor or transfer employment visas at this time.

\n

\n

The base salary for this position is expected to be between $160,000.00 and $200,000.00. The base salary offered to the chosen candidate will be commensurate with a candidate’s relevant experience and other qualifications for the position, as determined by the Company in its sole discretion. In addition to base salary, this position is eligible for an annual discretionary bonus [which is often a meaningful portion of the compensation package], and a robust benefits package.

Established in 1992, Cerberus Capital Management, L.P., together with its affiliates, is one of the world’s leading private investment firms. Through its team of investment and operations professionals, Cerberus specializes in providing both financial resources and operational expertise to help transform undervalued and underperforming companies into industry leaders for long-term success and value creation. Cerberus holds controlling or significant minority interests in companies around the world.

\n

\n

Cerberus Technology Solutions is an operating company and subsidiary of Cerberus Capital Management. We are a new, but growing team of AI specialists - data scientists, software engineers, and technology strategists - working to transform how an alternative investment firm with $65B in assets under management leverages technology and data. Our remit is broad, spanning investment operations, portfolio companies, and internal systems, giving the team the opportunity to shape the way the firm approaches analytics, automation, and decision-making.