Lead Data Engineer

Job Description Summary

For over forty years, HarbourVest has been home to a committed team of professionals with an entrepreneurial spirit and a desire to deliver impactful solutions to our clients and investing partners. As our global firm grows, we continue to add individuals who seek a collaborative, open-door culture that values diversity and innovative thinking.

In our collegial environment that’s marked by low turnover and high energy, you’ll be inspired to grow and thrive. Here, you will be encouraged to build on your strengths and acquire new skills and experiences.

We are committed to fostering an environment of inclusion that promotes mutual respect among all employees. Understanding and valuing these differences optimizes the potential of both the individual and the firm.

HarbourVest is an equal opportunity employer.

This position will be a hybrid work arrangement, which translates to 2-3 days minimum per week in the office.

The data architect will work toward the transformation of our firm’s data infrastructure, primarily using the Microsoft data stack on prem and in Azure.

The resource joining us will partner with product owners, data owners, project managers, business users, data engineers, and infrastructure engineers to form complete end-to end-solutions. The resource will enjoy working in an evolving, fast-paced environment, and bring a work style marked by high energy, flexibility, quick learning, and collaboration.

• Successful track record delivering on data-platform projects of significant scale and complexity, involving modern data platform implementations (data lakes, data lakehouses, logical data warehouses, etc.)
• Expertise in developing, presenting, and implementing data models aligned with the needs of business applications
• Confidence and skill in building and communicating data-flow schematics understandable to both business and technical teams

• Partner with cloud engineers to design and implement the Azure-based and Snowflake-based resources supporting development, QA, UAT, and production environments
• Analyze business and technical requirements as basis for delivering sophisticated conceptual, logical, and physical data models
• Prepare data-flow schematics at multiple levels of detail, indicating the pros and cons of alternative design patterns
• Design and build data validations, transformations, normalizations, reports and extracts, and integration processes, using Azure and Snowflake data stacks
• Create and implement CI/CD pipelines
• Organize work and adhere to thorough work tracking, using Agile techniques
• Coordinate and contribute to the technical work of a team of 4-6 resources, including contractors

• Advanced SQL and Python knowledge
• Proficiency in Azure Data Environment (Synapse, Databricks, Data Factory, Azure DevOps), plus related capabilities in Snowflake
• In-depth experience with data modeling tools and knowledge of sophisticated data modeling techniques/approaches
• Highly collaborative attitudes and work style; welcoming the inputs of others
• Confidence and skill to document work items and explain deliverables, to enhance overall team productivity
• Capability to balance demands of scope, schedule, and budget
• Demonstrable experience as a technical leader

• Bachelor's degree

• 10-12 Years

#LI-Hybrid