ETL Data Engineer (Python & Snowflake)

Join Hamilton Lane a global leader in private markets as we scale to meet the demands of our growing client base. Here youll work with ambitious highperforming teams built on integrity candor and collaboration backed by our market-leading data and technology. We invest heavily in our people and our partners giving you the platform to enrich lives safeguard futures and grow your career.

What We Do
As one of the largest private markets investment firms globally we provide innovative solutions to institutional and private wealth investors around the world specializing in flexibility and full-spectrum access. We currently employ approximately 800 professionals operating in offices throughout North America Europe Asia Pacific and the Middle East and have $1.0 trillion in assets under management and supervision composed of $146.1 billion in discretionary assets and $871.5 billion in non-discretionary assets as of December 31 2025.

The Opportunity:
We are seeking a talented ETL Data Engineer with strong experience in Python and Snowflake to join our dynamic team.

As an ETL Data Engineer you will play a critical role in our expanding data engineering team. You will be responsible for designing developing and maintaining scalable data integration solutions primarily using Python (PySpark) Snowflake and modern cloud data platform technologies ensuring the accuracy reliability and availability of data for analytics and business decision-making.

You will work closely with data architects data scientists analysts and business stakeholders to deliver high-quality well-structured data products that support advanced analytics reporting and operational use cases.

If you are passionate about data engineering enjoy building modern cloud data platforms and are eager to leverage Snowflakes capabilities to drive business value wed love to hear from you.

Your responsibilities will be to:

Data Engineering & ETL Development

• Design develop and maitain scalable ETL/ELT data pipelines using Python (PySpark) Snowflake and cloud-native integration technologies.
• Build reliable efficient and reusable data ingestion transformation and loading processes to support enterprise analytics and reporting needs.

Snowflake Data Platform

• Utilize Snowflakes architecture and capabilities to design build and optimize modern cloud data solutions.
• Implement and manage Snowflake objects including databases schemas tables views streams tasks stages and stored procedures.
• Leverage Snowflake features such as virtual warehouses data sharing time travel and automated scaling to maximize performance and cost efficiency.

Data Warehousing

• Apply expertise in dimensional modeling star schemas facts and dimensions to design and implement scalable enterprise data warehouse solutions within Snowflake.
• Develop data models that balance business requirements performance and maintainability.

Data Source Integration

• Extract and ingest data from a variety of sources including REST APIs relational databases SaaS applications flat files and cloud storage platforms.
• Develop and maintain robust ingestion frameworks supporting structured and semi-structured data formats.

Cloud Data Architecture

• Contribute to the design and implementation of modern data platform concepts including data lakes lakehouses data mesh architectures and enterprise data catalogs.
• Support integration between Snowflake and cloud-native services across Azure and other cloud platforms.

Data Modeling & Design

• Collaborate with data architects and business stakeholders to develop logical and physical data models aligned with business objectives.
• Establish and enforce data engineering standards and best practices.

Data Quality & Governance

• Implement automated data quality controls validation frameworks and monitoring processes to ensure accuracy consistency and completeness.
• Support data governance initiatives and maintain adherence to organizational standards.

Performance Optimization

• Monitor and optimize Snowflake workloads ETL/ELT processes and SQL queries to meet performance objectives and service-level agreements.
• Analyze warehouse utilization and recommend improvements to performance and cost efficiency.

Monitoring & Troubleshooting

• Monitor data pipelines and platform operations diagnose data and performance issues and implement long-term solutions to ensure reliability and availability.
• Support production environments and participate in incident resolution activities.

Documentation

• Maintain comprehensive documentation for data pipelines data flows transformations data models and operational processes.

Collaboration

• Partner with cross-functional teams to understand business requirements and provide technical expertise on data-related initiatives.

Security & Compliance

• Ensure data security privacy and regulatory compliance through the implementation of appropriate access controls masking policies governance frameworks and industry best practices.

Your background will include:

• Bachelors degree in Computer Science Information Technology Data Engineering or a related field; or equivalent professional experience.

• Relevant certifications such as SnowPro Azure Data Engineer Associate or other cloud data platform certifications are a plus.

• Proven experience developing data pipelines that extract transform and load data from REST APIs relational databases cloud storage and flat-file sources.

• Demonstrated experience working with Snowflake features including virtual warehouses streams tasks stages Snowpipe secure data sharing and performance optimization.

• Advanced SQL development skills with the ability to write complex queries tune performance and optimize large-scale data workloads.

• Experience with data modeling techniques including dimensional modeling star schemas fact tables and dimension tables.

• Familiarity with cloud-based data ecosystems and integration services particularly within Microsoft Azure.

• Experience managing source code and CI/CD pipelines using Git and Azure DevOps or similar platforms.

• Knowledge of data integration best practices data governance frameworks and enterprise data management principles.

• Strong analytical and problem-solving skills with exceptional attention to detail.

• Excellent verbal and written communication skills and the ability to work collaboratively in a fast-pace environment with evolving priorities.

• Experience with big data technologies machine learning data science platforms or advanced analytics is preferred.

• Experience with data visualization tools such as Power BI Tableau or similar platforms is a plus.

• Familiarity with Agile delivery methodologies and DevOps practices is desirable.

Preferred Technologies

• Snowflake
• Python/PySpark
• SQL
• Azure Data Lake Storage (ADLS)
• Azure Data Factory (or equivalent orchestration tools)
• Azure Key Vault
• Git/Azure DevOps
• Power BI
• REST APIs
• CI/CD and Infrastructure ad Code (Terraform preferred)

Benefits

At Hamilton Lane our benefits philosophy is simple: to provide our employees with a competitive suite of benefits and services to help navigate through the complexities and challenges of working living raising a family and eventually retiring. To do this Hamilton Lane offers the following benefits:

Enhancing Your Physical and Emotional Health

Employees have access to healthcare coverage mental health resources health & fitness reimbursement program and Wellness Rewards Program.

Developing Your Career

Tuition and certification reimbursement programs are available along with continual education and development trainings for you to grow with Hamilton Lane.

Supporting Your Family & Community

For our communities Hamilton Lane provides paid time off to volunteer and compensates for referring qualified candidates that join our team.

For growing family we offer an adoption reimbursement program paid time off for new parents and newlyweds and provide travel support for nursing parents.

Safeguarding Your Financial Wellbeing

Hamilton Lane contributes to retirement programs and offers an employee stock purchasing plan.

Hamilton Lane is an affirmative action-equal opportunity employer. All qualified applicants will be considered for employment without regard to their race color creed religion sex pregnancy national origin ancestry citizenship status age marital or partnership status sexual orientation gender identity or expression disability genetic predisposition veteran or military status status as a victim of domestic violence a sex offense or stalking or any other classification prohibited by applicable law.

If you need a reasonable accommodation to complete your application please contact Human Resources at .

Hamilton Lane is not accepting unsolicited assistance from search firms for this employment opportunity. Please no phone calls or emails. All resumes submitted by search firms to any employee at Hamilton Lane via-email the Internet or in any form and/or method without a valid written search agreement in place for this position will be deemed the sole property of Hamilton Lane. No fee shall be paid in the event the candidate is hired by Hamilton Lane as a result of the referral or through other means.