ETL Data Engineer, Python, Snowflake

🕒 Setembro 3

🔔 Pennsylvania – Remoto

🔔 Pennsylvania – Remote

⏰ Tempo Integral

🟡 Pleno

🟠 Sênior

🔙 Engenheiro Backend

👻 Score fantasma 10%

O que significa: quão provável esta vaga está aberta sem contratação ativa.Como ler: 60% ou mais significa que achamos que é uma vaga fantasma. Pontuações mais baixas preocupam menos.Como pontuamos: tempo em aberto, republicações, vagas abertas vs tamanho do time, rapidez para fechar vagas, e se o salário está divulgado.Observação: é uma estimativa de dados públicos, não um julgamento da empresa. Vagas reais podem ter pontuação alta, então use como uma dica, não como um fato.

Candidatar-se

Encontrar Vagas Remotas Similares

Configurar Alerta de Email para Novas Vagas

📊 Verifique sua pontuação de currículo para esta vaga

Melhore suas chances de conseguir uma entrevista verificando sua pontuação de currículo antes de se candidatar.

Enviar Currículo

Hamilton Lane

SiteLinkedInTodas as Vagas

501 - 1000 funcionários

Fundada em 1991

💼 Consultoria

🛡️ Seguros

💸 Finanças

💰 $77.500.000 Post-IPO Equity - Hamilton Lane em 2025-09

Consulting • Insurance • Finance

Hamilton Lane é uma empresa global de gestão de ativos de mercados privados que oferece estratégias de investimento e soluções em primários, secundários, crédito direto, capital próprio direto, infraestrutura e ativos reais, imóveis, capital de risco e crescimento, e patrimônio privado. A empresa oferece serviços personalizados e institucionais, plataformas de dados e tecnologia proprietárias para informar investimentos e relatórios, além de educação e soluções gerenciadas para uma ampla base de clientes, incluindo investidores institucionais, de patrimônio e seguradoras. Com ativos significativos sob gestão e foco em mercados privados, a Hamilton Lane combina gestão de investimentos, soluções orientadas ao cliente e tecnologia baseada em dados.

Descrição

• 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

🎯 Requisitos

• 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

🏖️ Benefícios

• 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