ETL Data Engineer: PySpark & Azure Synapse Expert

HL002 Hamilton Lane Advisors, LLC; Erwinna (PA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Healthcare coverage

Tuition reimbursement

Paid volunteer time

Retirement program contributions

Job summary

HL002 Hamilton Lane Advisors, LLC in Pennsylvania is seeking a talented ETL Data Engineer to join their expanding team. The role requires strong experience in Python (PySpark) and Azure Synapse Analytics to develop and maintain ETL processes that ensure data accuracy for analytical needs.

Benefits include healthcare coverage, tuition reimbursement programs, and retirement plan contributions. Join a dynamic workplace that values collaboration and innovation.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.
• Proven experience in ETL data engineering using Python (PySpark) for REST APIs, SQL database tables, and CSV files.
• Strong SQL skills with optimization experience.

Responsibilities

• Develop and maintain ETL processes using Python (PySpark) within Azure Synapse Analytics.
• Collaborate with data architects to create data models aligned with business requirements.
• Implement data quality checks to maintain accuracy and consistency.

Skills

ETL data engineering

Python (PySpark)

Azure Synapse Analytics

SQL

Version control (Git)

Problem-solving

Communication skills

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Synapse Analytics Notebooks

Power BI

Tableau

Job description

HL002 Hamilton Lane Advisors, LLC in Pennsylvania is seeking a talented ETL Data Engineer to join their expanding team. The role requires strong experience in Python (PySpark) and Azure Synapse Analytics to develop and maintain ETL processes that ensure data accuracy for analytical needs.

Benefits include healthcare coverage, tuition reimbursement programs, and retirement plan contributions. Join a dynamic workplace that values collaboration and innovation.