Cloud ETL Data Engineer — Python & Snowflake

Hamilton Lane; Conshohocken (Montgomery County); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health insurance

Tuition reimbursement

Volunteer time off

Employee stock purchase plan

Job summary

Hamilton Lane is seeking an ETL Data Engineer to design, develop, and maintain scalable data pipelines using Python, PySpark, and Snowflake. You will work with data architects, scientists, and analysts to deliver trusted data products for analytics and reporting.

The role emphasizes cloud data platforms, data modeling, and performance optimization, with strong collaboration across teams and a focus on data quality and governance.

Qualifications

• Bachelor’s degree in Computer Science, IT, Data Engineering, or equivalent.
• Experience building data pipelines from REST APIs, databases, and cloud storage.
• Proficient with Snowflake features, ETL/ELT design, and SQL tuning.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using Python (PySpark) and Snowflake.
• Build reliable ingestion, transformation, and loading processes for analytics.
• Leverage Snowflake features to optimize performance and cost efficiency.
• Collaborate with data architects, scientists, and business stakeholders.
• Develop data models balancing performance and maintainability.

Skills

Python

PySpark

SQL

Data Modeling

Cloud data platforms

Education

Bachelor’s degree in Computer Science / IT / Data Eng

Tools

Snowflake

Azure Data Factory

Git

Azure DevOps

Power BI

REST APIs

Job description

Hamilton Lane is seeking an ETL Data Engineer to design, develop, and maintain scalable data pipelines using Python, PySpark, and Snowflake. You will work with data architects, scientists, and analysts to deliver trusted data products for analytics and reporting.

The role emphasizes cloud data platforms, data modeling, and performance optimization, with strong collaboration across teams and a focus on data quality and governance.