Senior Data Engineer

• Design, build, and optimize robust, scalable, and reliable data pipelines to ingest and process data from a wide variety of sources.

• Develop and maintain our data warehousing solutions (e.g. Snowflake), including maintenance of an advanced RBAC model to ensure data governance throughout all data tooling.

• Ensure data quality and integrity by implementing data validation frameworks, monitoring systems, and anomaly detection protocols.

• Architect and manage cloud-based data infrastructure.

• Orchestrate batch machine learning pipelines. Work closely with data scientists to orchestrate code based on data science and product requirements, getting alignment on optimizations when necessary.

• Collaborate with stakeholders, including data scientists, analysts, and product managers to understand data requirements and deliver actionable solutions.

• Improve performance, efficiency and optimize cost of existing data systems and processes.

• Work alongside Data and Engineering leadership to weigh tradeoffs in build vs buy decisions and tradeoffs in product roadmap vs technical initiatives.

• Work with internal software engineering teams to define architectures and best practices for ingesting data into the data warehouse and making aggregated data and metrics from the data warehouse available to our production applications.

• Interact with vendors to craft the adoption of new technology and infrastructure for the team.

• Designs, develops, and evaluates AI agents and reusable skill libraries to drive developer productivity and automate team workflows — including prompt engineering, tool integration, and performance evaluation using platforms such as Snowflake Cortex AI and LangGraph.

• Architects and governs secure integrations between enterprise AI tools (Claude, Cursor, Gemini, Slack, etc.) and the data warehouse, ensuring data access controls, auditability, and compliance standards are maintained across the AI toolchain.

• Take part in an on-call rotation. Work with Engineering leadership to define SLAs and alerting policies for our systems.

• Lead and participate in incident management, ensuring clear and timely communication with stakeholders.

• Write new and enhance existing technical and functional documentation on Data Engineering-owned systems and standards. Proactively address gaps in existing team standards, SLAs, operating principles, and documentation and work with leadership to scope and implement improvements in these areas.

• Be a leader, mentor, and subject matter expert for the team, stakeholders, and peers. Foster a collaborative environment that drives solutions forward at a larger scope.
• Bachelor’s degree in Computer Science, Engineering, or a related field or equivalent professional experience.

• 5+ years experience in data engineering.

• Expert proficiency in SQL and strong programming skills in Python.

• Proven experience building and orchestrating data pipelines using dbt and Airflow

• Hands-on experience developing data solutions in a major cloud environment, with a strong preference for Microsoft Azure.

• Solid understanding of BI-tooling integrations with a cloud data warehouse, with a strong preference for PowerBI

• Solid understanding of event-driven architecture and the use of messaging systems like Kafka to enable real-time data flow.

• Experience with a modern cloud data warehouse like Snowflake, Databricks, BigQuery, or Redshift.

• Familiarity with CI/CD, microservice architecture, domain driven design, data contracts

• Solid understanding with best practices around data security/privacy, role-based access control

• Experience with machine learning concepts, frameworks, and infrastructure

• Excellent written and oral communication and presentation skills
• Take advantage of excellent benefits, including medical, dental, vision, life, and disability coverage.

• Invest in your future with our matching 401(k) program.

• Build relationships and take part in learning opportunities through our Employee Resource Groups.

• Enjoy office wide engagement activities, team events, happy hours and more!

• Leave the suit and tie at home; our dress code is casual.

• Work in the heart of downtown Chicago, IL!

• There are CTA and L train stops walking distance from the office and you can store your bike safely inside of the building.

• Sweat it out at the LifeStart gym in our office building that includes brand new Peloton bikes, top-of-the-line equipment and personal training options.

• Maximize your wellness with free counseling sessions through our Employee Assistance Program

• Get paid to work with your friends through our Referral Program!

• Take time to manage your physical and mental health - we offer company paid holidays, paid vacation time and wellness days.

• Receive 100% paid parental leave when you become a new parent.

• Get relocation assistance! If you are not local to the area, we offer relocation packages.

The base salary range for this position is $150,000 - $187,000, plus bonus and benefits. The range displayed on each job posting reflects the pay range for the position across all locations. Within the range, individual pay is determined based on work location, job-related skills, experience, relevant education or training.