[Remote] Data Engineer

Note: The job is a remote job and is open to candidates in USA. Hamilton Lane is a global leader in private markets, seeking a talented ETL Data Engineer to join their dynamic team. The role involves designing, developing, and maintaining ETL data integration processes primarily using Python and Azure Synapse Analytics, ensuring data accuracy and availability for analytical needs.ResponsibilitiesETL Data Engineering: Develop 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 loadingData Warehousing: Apply 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 PoolData Source Expertise: Extract data from various sources, including REST APIs, SWL database tables, and CSV filesAzure Synapse Analytics Expertise: Utilize your deep knowledge of Azure Synapse Analytics to design and optimize data notebooks/pipelines for scalability and performanceData Fabric Concepts: Contribute to the implementation and understanding of other Data Fabric concepts, such as data lakes, lakehouses, delta lakes, and data cataloging, to enhance data management capabilitiesData Modeling: Collaborate with data architects to create data models and schemas that align with business requirementsData Quality: Implement data quality checks and validation processes to maintain data accuracy and consistencyPerformance Tuning: Identify and resolve performance bottlenecks and optimize ETL data notebooks/pipelines to meet SLAsMonitoring and Troubleshooting: Monitoring ETL jobs, diagnose issues, and implement solutions to ensure data pipeline reliabilityDocumentation: Maintain comprehensive documentation of ETL data engineering processes, data flows, and data transformationsCollaboration: Work closely with cross-functional teams to understand data requirements and provide support for data-related initiativesSecurity and Compliance: Ensure data security and compliance with data governance and privacy standardsSkillsBachelor's degree in Computer Science, Information Technology, or a related field; or equivalent work experience, with certifications related to data engineering or data science (e.g. Azure Data Engineer) being a plusProven experience in ETL data engineering with significant expertise in using Python (PySpark) to perform data extraction, transformation, and loading from REST APIs, SQL database tables, and CSV filesProficiency in using Azure Synapse Analytics resources including Notebooks, Pipelines, Linked Services, and Azure Key VaultDemonstrated ability to write complex SQL queries, optimize query performance, and work with both SparkSQL and MS SQL to effectively extract, transform, and load dataKnowledge of data integration best practices and toolsExperience with version control systems, such as Git (Azure DevOps)Strong problem-solving and analytical skills, with a keen attention to detailExcellent communication skills, both verbal and written, with the ability to work collaboratively in a team environment with shifting prioritiesFamiliarity with big data technologies, machine learning, and data analysis preferredExperience with data visualization tools (e.g. Power BI, Tableau) and Agile Methodologies a plusBenefitsEmployees have access to healthcare coverage, mental health resources, health & fitness reimbursement program, and Wellness Rewards Program.Tuition and certification reimbursement programs are available, along with continual education and development trainings for you to grow with Hamilton Lane.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.Hamilton Lane contributes to retirement programs and offers an employee stock purchasing plan.Company OverviewHamilton Lane is a private market investment firm that serves institutional and private wealth investors worldwide. It was founded in 1991, and is headquartered in Bala Cynwyd, Pennsylvania, USA, with a workforce of 501-1000 employees. Its website is http://hamiltonlane.com.Company H1B SponsorshipHamilton Lane has a track record of offering H1B sponsorships, with 2 in 2025, 1 in 2024, 2 in 2020. Please note that this does not guarantee sponsorship for this specific role.