Azure Synapse ETL & Data Warehouse Engineer

Hamilton Lane Incorporated; Philadelphia (Philadelphia County); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading financial services firm is seeking an ETL Data Engineer to develop and maintain data engineering processes using Python (PySpark) in Azure Synapse Analytics. The role involves designing effective data storage structures, implementing data quality checks, and collaborating with cross-functional teams. Ideal candidates should have a Bachelor's degree in Computer Science, significant ETL experience, and proficiency in SQL. This position offers opportunities for growth in a dynamic environment.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Proven experience in ETL data engineering using Python (PySpark).
• Proficiency in using Azure Synapse Analytics, including Notebooks and Pipelines.

Responsibilities

• Develop and maintain ETL processes within Azure Synapse Analytics.
• Design effective data storage structures using data warehousing concepts.
• Implement data quality checks and validation processes.

Skills

ETL data engineering

Python (PySpark)

Azure Synapse Analytics

SQL querying

Data modeling

Data quality checks

Git (Azure DevOps)

Data visualization tools

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Key Vault

Power BI

Tableau

Job description

A leading financial services firm is seeking an ETL Data Engineer to develop and maintain data engineering processes using Python (PySpark) in Azure Synapse Analytics. The role involves designing effective data storage structures, implementing data quality checks, and collaborating with cross-functional teams. Ideal candidates should have a Bachelor's degree in Computer Science, significant ETL experience, and proficiency in SQL. This position offers opportunities for growth in a dynamic environment.