remoteonsite
AVP, Data Warehouse, Tech Lead - LPL Financial Global Capability Center
Software Engineer
Lead a high‑performing data warehouse team, architecting scalable ETL pipelines and data models on AWS, while driving innovation with Python and Spark to deliver actionable insights for financial advisors.
About the role
Key Responsibilities
- Architect, develop, and maintain enterprise‑grade data warehouse solutions on AWS, ensuring high availability and performance.
- Design and implement robust ETL pipelines using Python, Spark, and SQL, optimizing for scalability and maintainability.
- Lead a cross‑functional team of data engineers, providing mentorship, code reviews, and fostering a culture of continuous improvement.
- Collaborate with business stakeholders to translate complex requirements into efficient data models and dashboards.
- Drive data quality initiatives, establishing governance, monitoring, and automated testing frameworks.
Requirements
- 10+ years of experience in data warehousing, with 5+ in a leadership role.
- Proficiency in AWS services (Redshift, S3, Glue, Lambda) and big‑data tools (Spark, Hive).
- Strong programming skills in Python and SQL, with experience in version control and CI/CD pipelines.
- Excellent communication and stakeholder management abilities.
- Hands‑on experience with data modeling, performance tuning, and data governance best practices.