Data Engineer II

​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 (Nasdaq: HSII) 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 looking for a highly skilled, curious, and driven Data Engineer II 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 key member of our data engineering team, you will play a critical role in building and maintaining the data infrastructure that powers analytics, AI, and operational efficiency across the firm.

You’ll bring a builder’s mindset to data. To us, context is paramount and connecting you into the needs of the business will best enable you to unlock the potential in our data in designing robust pipelines, standardizing structures, optimizing performance, and enabling scalable, governed access to information. This role sits at the intersection of engineering and business strategy, requiring close collaboration with data science, analytics, product, and business stakeholders to ensure the right data is accessible, trustworthy, and actionable. A successful candidate stays up to date on emerging technologies, best practices and new capabilities to best contribute their voice to new and emerging needs.

Heidrick Labs is a pioneering research and innovation division dedicated to transforming organizational leadership through cutting-edge insights, advanced analytics and AI built on-top of powerful and differentiated data. Our multidisciplinary team combines expertise in data science, psychology, and business strategy to develop forward thinking solutions that help companies navigate complex workplace challenges. We don't just study the future of work—we help organizations create it.

Responsibilities

• Contribute to the design, development, maintenance and evolution of scalable data pipelines, data structures, source systems and warehouse/lake environments.
• Partner closely with cross-functional stakeholders to manage, structure, and analyze data from various sources to solve business problems.
• Adept at managing projects from inception to completion.
• Contribute to documentation of data models, dictionaries, data flow maps, and metadata to support transparency and data governance.
• Hands on support of the current ETL processes, share responsibilities for monitoring the current data pipelines and processes.
• Effectively manages project requirements, ensures timely delivery, and maintains high-quality standards.
• Ability to find opportunities, assess problems, effectively recommend and implement the best solution.
• Partner with technical teams and stakeholders to implement data capture, ETL, validation, and QA.
• Your methodical and intentional approach, crucial for establishing a focused context, will be vital in supporting diverse team efforts while you manage multiple projects and navigate priorities, always ensuring quality and timeliness.
• Contributes to the development and enforcement of data governance and security policies.
• Staying abreast of the latest developments in technology and data management practices.

Required Qualifications

• BS in Computer Science, Software engineering, Information technology, Data and Analytics, Data science or equivalent degree.
• 3 - 4 years of experience with building and maintaining data lake and data solutions.
• Strong understanding of data structures, database objects, data normalization and data transformation techniques required.
• Proficiency in SQL with the ability to write complex stored procedures for data processing.
• Familiarity with Snowflake preferred.
• Knowledge of pipeline tools.
• Proficiency in python required.
• Experience in building highly insightful dashboards using visualization tools (Power BI preferred).
• Thorough understanding and ability to lead through the agile and waterfall methodologies.
• Excellent written and verbal communication skills required.
• Strong analytical, troubleshooting and problem-solving skills.
• Familiarity with CI/CD using Git.

Preferred Qualifications

• Familiarity with Snowflake preferred.
• Experience with FiveTran is preferred

Pay Range Guidelines for this Position:

The salary range for this position is 95000 USD to 112000 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.