Heidrick & Struggles Logo

Heidrick & Struggles

Senior Data Engineer

Posted Yesterday
In-Office
Chicago, IL, USA
120K-130K Annually
Senior level
In-Office
Chicago, IL, USA
120K-130K Annually
Senior level
Design, build, and maintain scalable Snowflake-based data pipelines and models. Own end-to-end solutions from requirements to deployment, optimize performance and cost, enforce data governance and quality, mentor junior engineers, and collaborate with data science, analytics, and business stakeholders to enable reliable self-service analytics and AI.
The summary above was generated by AI

Heidrick & Struggles is the world’s foremost advisor on executive leadership, driving superior client performance through premier human capital leadership advisory services. For more than 70 years, we’ve delivered value for our clients by leveraging unrivaled expertise to help organizations discover and enable outstanding leaders and teams. Learn more at www.heidrick.com

Job Description:

Who We Are:

Heidrick & Struggles is a premier provider of global leadership advisory and on-demand talent solutions, serving the senior-level talent and consulting needs of the world's top organizations. In our role as trusted leadership advisors, we partner with our clients to develop future-ready leaders and organizations, bringing together our services and offerings in executive search leadership assessment and development, organization and team acceleration, culture shaping and on-demand, independent talent solutions. Heidrick & Struggles pioneered the profession of executive search more than 70 years ago. Today, the firm provides integrated talent and human capital solutions to help our clients change the world, one leadership team at a time.®  

Additional information on the firm can be found at www.heidrick.com. 

The Role

We are seeking a highly skilled, hands‑on Senior Data Engineer with 4–5 years of experience to help shape and scale our data foundation in support of Heidrick & Struggles’ mission to transform executive search and leadership advisory through data‑driven insights. As a senior member of the data engineering team, you will own complex data solutions, drive best practices, and mentor junior engineers while ensuring our data platform is scalable, governed, and reliable.

You bring a builder’s mindset and strong sense of ownership, connecting deeply to business needs to design robust pipelines, standardize structures, optimize performance, and enable trusted, self‑service analytics and AI across the firm. This role sits at the intersection of engineering and business strategy, requiring close collaboration with data science, analytics, product, and business stakeholders.

Responsibilities

  • Design, develop, and maintain scalable, secure data pipelines, data models, and warehouse/lake environments, primarily on Snowflake.

  • Own end‑to‑end data solutions from requirements gathering and design through implementation, testing, deployment, and iteration.

  • Partner closely with cross‑functional stakeholders to translate business problems into robust data solutions, ensuring data is accessible, trustworthy, and actionable.

  • Promote and contribute to best practices in data engineering (coding standards, testing, observability, documentation, and CI/CD).

  • Mentor and support junior data engineers through code reviews, pairing, and guidance on design and implementation.

  • Perform performance tuning, cost optimization, and reliability improvements in Snowflake and associated data pipelines.

  • Contribute to documentation of data models, dictionaries, data flow maps, and metadata to support transparency and data governance.

  • Collaborate with technical teams and stakeholders to implement data capture, ETL/ELT, validation, and QA, including automated quality checks and monitoring.

  • Support the development and enforcement of data governance, access controls, and security policies in partnership with data governance and security teams.

  • Stay up to date on emerging technologies, tools, and best practices in data engineering and bring forward recommendations that evolve our data platform.

Required Qualifications

  • Bachelor’s degree in Computer Science, Software Engineering, Information Technology, Data & Analytics, Data Science, or a related field, or equivalent practical experience.

  • 4–5 years of experience building and maintaining data lake/warehouse solutions and production‑grade data pipelines.

  • Expert‑level proficiency in SQL, including complex queries, optimization, and stored procedures for data processing (expected “10/10” SQL capability).

  • Hands‑on experience with Snowflake (data modeling, performance tuning, and cost management).

  • Proficiency in Python for data processing, orchestration, and automation.

  • Experience designing, implementing, and operating ETL/ELT pipelines using modern pipeline tools and orchestration frameworks.

  • Demonstrated experience mentoring or guiding junior engineers and contributing to team‑level technical decisions.

  • Solid understanding of data warehousing concepts, data modeling, and best practices for structured and semi‑structured data.

  • Familiarity with CI/CD practices and tools (e.g., Git‑based workflows, automated testing, deployment pipelines).

  • Excellent written and verbal communication skills, with the ability to explain complex technical concepts to non‑technical stakeholders.

Preferred Qualifications

  • Experience with modern data stack tools such as FiveTran, or similar technologies.

  • Exposure to data governance, data quality frameworks, and master or reference data management initiatives.

  • Experience working in agile environments and leading workstreams or key stories within a cross‑functional team

Pay Range Guidelines for this Position:

The salary range for this position is 120000 USD to 130000 USD. Compensation is based on several factors including but not limited to education, work experience and skills. In addition to your salary, Heidrick & Struggles offers discretionary bonuses (subject to eligibility requirements) and a comprehensive benefits package including: medical, dental, vision, disability leave, parental leave, paid time off and 401k contribution (all benefits are subject to eligibility requirements). Note: we have a location based compensation structure; there may be a different range for candidates in other locations.


Heidrick & Struggles is an equal opportunity employer committed to hiring qualified protected veterans and individuals with disabilities. All qualified applicants will be considered for employment without regard to race, color, religion, creed, age, sex, national origin, gender identity or expression, sexual orientation, disability, marital status, veteran or military status, or citizenship status.

HQ

Heidrick & Struggles Chicago, Illinois, USA Office

233. South Wacker Drive, Chicago, IL, United States, 60606

Similar Jobs

Yesterday
Easy Apply
Remote or Hybrid
United States
Easy Apply
118K-179K Annually
Senior level
118K-179K Annually
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Design, build, and operate large-scale data platforms and Spark/PySpark pipelines. Enable data integration, modeling, quality, and observability. Build MCP servers and AI-augmented tooling, mentor engineers, and lead cross-functional projects to deliver reliable data products.
Top Skills: Ai AgentsApache IcebergAuroraAWSAws RdsAzureDatabricksDbtFivetranGCPGoogle BigqueryMcp ServersMs Sql ServerMySQLOraclePostgresPysparkPythonSnowflakeSparkSQL
2 Days Ago
Hybrid
Chicago, IL, USA
120K-160K Annually
Senior level
120K-160K Annually
Senior level
Artificial Intelligence • Cloud • Information Technology • Legal Tech • Productivity • Software
Own and operate the iMData platform: design and build Databricks-based ETL pipelines using PySpark and medallion architecture, create gold-layer star schemas, migrate assets from Synapse to Databricks, implement CI/CD and Terraform IaC, ensure data security and observability, mentor junior engineers, and collaborate with stakeholders and ML engineers to deliver production-grade analytics and AI-ready data.
Top Skills: Apache KafkaAzure DatabricksCi/CdCollibraDatabricksDatabricks Asset Bundles (Dabs)Databricks Mcp ConnectorDelta LakeGithub ActionsInformaticaMicrosoft Event HubMicrosoft SynapsePower BIPysparkPythonSalesforceSparkTerraformZendesk
14 Days Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
120K-201K Annually
Senior level
120K-201K Annually
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Design, build, and maintain scalable Spark-based ETL pipelines and computed tables in a central data lake. Integrate structured and unstructured IoT, sensor, and external data for analytics, model training, and dashboards. Collaborate with Data Science, Analytics, and ML teams to ensure reliable, high-quality customer-facing datasets.
Top Skills: AirflowAWSAzureDagsterData LakeDatabricksDelta LakeETLGCPGitGitPrefectPysparkPythonRest ApisSparksqlSQL

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

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account