Data Engineer
Job Overview
Skills & Requirements
Python
Essential skill for this role
SQL
Essential skill for this role
Access
Essential skill for this role
Teams
Essential skill for this role
Qualifications & Education
About the Role
Data Engineer
Curated brief to help you tailor your application.
Role Overview
Start by showing recruiters you understand the team's mission and environment.
Hamilton Lane is looking to expand our team to satisfy the needs of our growing client base. Hamilton Lane is built on collaboration, teamwork and integrity. Our employees pursue excellence and always strive to do the right thing. We invest in our employees, clients and partner relationships, as well as, in the technology and resources necessary to remain competitive, working in a competitive environment that inspires innovation.
What we do:
As a recognized leader in providing Private Markets Solutions to clients across the globe, we manage approximately $140.9 billion in discretionary assets and have oversight of an additional $845.3 in non-discretionary assets as of June 30, 2025.
As an ETL Data Engineer, you will play a critical role in our expanding data engineering team. You will be responsible for designing, developing, and maintaining ETL data integration processes primarily using Python (PySpark), Azure Synapse Analytics Pipelines, and other Azure Synapse Analytics resources, ensuring the accuracy and availability of data for our analytical need. You will work closely with data scientists, analysts, and other stakeholders to deliver high-quality, well-organized data for insights and decision-making.
- The OpportunityWe are seeking a talented ETL Data Engineer with strong experience in Python and Azure Synapse Analytics to join our dynamic team.
- ETL Data EngineeringDevelop and maintain ETL data engineering processes using Python (PySpark) within Azure Synapse Analytics Notebooks, and/or Azure Synapse Analytics Pipelines, to ensure efficient data extractions, transformation, and loading.
- Data WarehousingApply your expertise in data warehousing, understanding star schemas, facts, and dimensions, to design and build effective data storage structures in a Massively Parallel Processing (MPP) SWL Pool.
- Data Source ExpertiseExtract data from various sources, including REST APIs, SWL database tables, and CSV files.
- Azure Synapse Analytics ExpertiseUtilize your deep knowledge of Azure Synapse Analytics to design and optimize data notebooks/pipelines for scalability and performance.
- Data Fabric ConceptsContribute to the implementation and understanding of other Data Fabric concepts, such as data lakes, lakehouses, delta lakes, and data cataloging, to enhance data management capabilities.
- Data ModelingCollaborate with data architects to create data models and schemas that align with business requirements.
- Data QualityImplement data quality checks and validation processes to maintain data accuracy and consistency.
- Performance TuningIdentify and resolve performance bottlenecks and optimize ETL data notebooks/pipelines to meet SLAs.
- Monitoring and TroubleshootingMonitoring ETL jobs, diagnose issues, and implement solutions to ensure data pipeline reliability.
- DocumentationMaintain comprehensive documentation of ETL data engineering processes, data flows, and data transformations.
- CollaborationWork closely with cross-functional teams to understand data requirements and provide support for data-related initiatives.
- Security and ComplianceEnsure data security and compliance with data governance and privacy standards.
Skills Snapshot
Double down on these tools and frameworks in your application.
Reward & Progression
See how compensation, benefits, and growth are framed.
At Hamilton Lane, our benefits philosophy is simple: to provide our employees with a competitive suite of benefits and services to help navigate through the complexities and challenges of working, living, raising a family, and eventually retiring.
To do this, Hamilton Lane offers the following benefits:
Enhancing Your Physical and Emotional Health
Employees have access to healthcare coverage, mental health resources, health & fitness reimbursement program, and Wellness Rewards Program.
Developing Your Career
Tuition and certification reimbursement programs are available, along with continual education and development trainings for you to grow with Hamilton Lane.
Supporting Your Family & Community
For our communities, Hamilton Lane provides paid time off to volunteer and compensates for referring qualified candidates that join our team.
For growing family, we offer an adoption reimbursement program, paid time off for new parents and newlyweds, and provide travel support for nursing parents.
Safeguarding Your Financial Wellbeing
Hamilton Lane contributes to retirement programs and offers an employee stock purchasing plan.
We offer a competitive salary, annual discretionary bonus and a comprehensive benefits package which includes: Medical, Prescription, Dental, Paid Time Off, 401k plan, Life and Disability Insurances, Tuition Reimbursement, Employee Stock Purchase Program, Health Club Reimbursement and Flexible Spending Accounts.
Hamilton Lane is an affirmative action-equal opportunity employer. All qualified applicants will be considered for employment without regard to their race, color, creed, religion, sex, pregnancy, national origin, ancestry, citizenship status, age, marital or partnership status, sexual orientation, gender identity or expression, disability, genetic predisposition, veteran or military status, status as a victim of domestic violence, a sex offense or stalking, or any other classification prohibited by applicable law.
If you need a reasonable accommodation to complete your application, please contact Human Resources at [email protected].
Hamilton Lane is not accepting unsolicited assistance from search firms for this employment opportunity. Please, no phone calls or emails. All resumes submitted by search firms to any employee at Hamilton Lane via-email, the Internet or in any form and/or method without a valid written search agreement in place for this position will be deemed the sole property of Hamilton Lane. No fee shall be paid in the event the candidate is hired by Hamilton Lane as a result of the referral or through other means.
Get Expert Application Review
Boost your chances of landing this role with a professional application review from our expert consultants.
Available exclusively to Skill Farm members