ETL Data Engineer, Python, Snowflake

🔥 0 minutes ago

🔔 Pennsylvania – Remote

🔔 Pennsylvania – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🔙 Backend Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Hamilton Lane

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 1991

💼 Consulting

🛡️ Insurance

💸 Finance

💰 $77.5M Post-IPO Equity - Hamilton Lane on 2025-09

Consulting • Insurance • Finance

Hamilton Lane is a global private markets asset management firm that provides investment strategies and solutions across primaries, secondaries, direct credit, direct equity, infrastructure & real assets, real estate, venture capital & growth, and private wealth. The firm offers customized and institutional services, proprietary data and technology platforms to inform investing and reporting, and education and managed solutions for a broad client base including institutional, wealth and insurance investors. With significant assets under management and a focus on private markets, Hamilton Lane combines investment management, client-driven solutions, and data-backed technology.

📋 Description

• Design, develop, and maintain 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 for enterprise analytics and reporting • Design, build, and optimize modern Snowflake cloud data solutions • Implement and manage Snowflake databases, schemas, tables, views, streams, tasks, stages, and stored procedures • Leverage Snowflake virtual warehouses, data sharing, time travel, and automated scaling for performance and cost efficiency • Design and implement scalable enterprise data warehouse solutions using dimensional modeling, star schemas, facts, and dimensions • Extract and ingest data from REST APIs, relational databases, SaaS applications, flat files, and cloud storage platforms • Develop and maintain ingestion frameworks for structured and semi-structured data • Contribute to data lakes, lakehouses, data mesh architectures, enterprise data catalogs, and integrations between Snowflake and Azure/cloud-native services • Collaborate with data architects and business stakeholders on logical and physical data models • Establish and enforce data engineering standards and best practices • Implement automated data quality controls, validation frameworks, and monitoring processes • Support data governance initiatives and organizational standards • Monitor and optimize Snowflake workloads, ETL/ELT processes, and SQL queries • Analyze warehouse utilization and recommend performance and cost-efficiency improvements • Monitor pipelines and platform operations, diagnose issues, and implement long-term reliability solutions • Support production environments and participate in incident resolution • Maintain documentation for pipelines, data flows, transformations, data models, and operational processes • Partner with cross-functional teams to understand requirements and provide technical data expertise • Implement access controls, masking policies, governance frameworks, and other security, privacy, and compliance measures

🎯 Requirements

• Bachelor’s 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 extracting, transforming, and loading data from REST APIs, relational databases, cloud storage, and flat-file sources • Experience with Snowflake features including virtual warehouses, streams, tasks, stages, Snowpipe, secure data sharing, and performance optimization • Advanced SQL development skills, including complex queries, performance tuning, and optimization of large-scale data workloads • Experience with dimensional modeling, star schemas, fact tables, and dimension tables • Familiarity with cloud-based data ecosystems and integration services, particularly Microsoft Azure • Experience with Git and Azure DevOps or similar platforms for source code and CI/CD pipelines • 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 ability to work collaboratively in a fast-paced environment with evolving priorities • Experience with big data technologies, machine learning, data science platforms, or advanced analytics is preferred • Experience with Power BI, Tableau, or similar data visualization tools is a plus • Familiarity with Agile delivery methodologies and DevOps practices is desirable • Preferred technologies include Snowflake, Python/PySpark, SQL, Azure Data Lake Storage, Azure Data Factory or equivalent orchestration tools, Azure Key Vault, Git/Azure DevOps, Power BI, REST APIs, CI/CD, and Terraform preferred

🏖️ Benefits

• Healthcare coverage • Mental health resources • Health & fitness reimbursement program • Wellness Rewards Program • Tuition and certification reimbursement programs • Continual education and development trainings • Paid time off to volunteer • Compensation for referring qualified candidates who join the team • Adoption reimbursement program • Paid time off for new parents and newlyweds • Travel support for nursing parents • Employer contributions to retirement programs • Employee stock purchasing plan