Senior Data Warehouse Lead - Snowflake & AWS

lplfinancial; Fort Mill (SC); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Hybrid work model (Austin or Fort Mill

Job summary

LPL Financial is seeking a Data Warehouse Technical Lead to drive design, development, modernization, and support of enterprise data warehousing. The role centers on Snowflake, AWS, DBT, and SQL, and requires leading a team, mentoring engineers, and partnering with stakeholders to deliver scalable data solutions.

This is a hybrid role with offices in Austin or Fort Mill. The ideal candidate will have hands‑on data engineering experience, strong leadership, and a track record of delivering

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• Master's degree preferred.
• Minimum of 10 years of experience in Data Engineering, Data Warehousing, Analytics Engineering, or Data Architecture, or related disciplines.
• Minimum of 5 years of hands‑on experience developing and supporting enterprise data warehouse solutions using Snowflake and cloud‑based data platforms.
• Advanced SQL development experience, including query optimization, performance tuning, troubleshooting, and data validation.

Responsibilities

• Lead the design, development, enhancement, and support of enterprise data warehouse solutions using Snowflake and AWS cloud technologies.
• Build and maintain scalable ETL/ELT pipelines, data integrations, and transformation frameworks supporting Finance, Reporting, and Analytics use cases.
• Develop, optimize, troubleshoot, and review complex SQL queries, data models, and data warehouse structures.
• Drive technical design and implementation of cloud‑native data solutions using AWS services including S3, Glue, Lambda, MWAA, and Redshift.
• Partner with business stakeholders, analysts, architects, and engineering teams to translate business requirements into scalable and performant data solutions.
• Establish and promote best practices for data quality, governance, security, monitoring, and operational excellence.
• Support data warehouse modernization, cloud migration, and enterprise data platform initiatives.
• Mentor data engineers and technical analysts while providing technical leadership and guidance across projects.
• Oversee solution deployment, testing, production support, and continuous improvement activities.
• Work in a hybrid work environment in LPL's Austin or Fort Mill offices, effectively partnering with business and technology teams across multiple locations.

Skills

Data Warehousing

Cloud Data Engineering

Data Governance

Technical Leadership

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Master's degree preferred

Tools

Snowflake

AWS

DBT

SQL

Python

Redshift

Job description

LPL Financial is seeking a Data Warehouse Technical Lead to drive design, development, modernization, and support of enterprise data warehousing. The role centers on Snowflake, AWS, DBT, and SQL, and requires leading a team, mentoring engineers, and partnering with stakeholders to deliver scalable data solutions.

This is a hybrid role with offices in Austin or Fort Mill. The ideal candidate will have hands‑on data engineering experience, strong leadership, and a track record of delivering