Lead Data Warehouse Technical Analyst

LPL Financial LLC; Fort Mill, Charlotte (SC, NC); Hybrid; USD 120,000 - 190,000; Full time

Benefits offered by this job

401K matching

health benefits

employee stock options

paid time off

volunteer time off

Job summary

LPL Financial LLC is seeking a Data Warehouse Technical Lead to drive design, development, modernization, and support of enterprise data warehousing solutions. You will lead technical design, mentor team members, and partner with business stakeholders while hands-on in data engineering, performance optimization, and production support—hybrid work in Austin or Fort Mill.

The ideal candidate has 10+ years in data engineering/warehousing, strong Snowflake and cloud experience, and advanced SQL

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (Master's preferred).
• 10+ years in Data Engineering, Data Warehousing, Analytics Engineering, or Data Architecture.
• 5+ years hands-on with Snowflake and cloud data platforms.
• Advanced SQL development, optimization, debugging and data validation.

Responsibilities

• Lead design, development, enhancement, and support of enterprise data warehouse solutions.
• Build and maintain scalable ETL/ELT pipelines and data integrations.
• Develop and optimize complex SQL queries and data models.
• Drive cloud-native data solutions using AWS services (S3, Glue, Lambda, MWAA, Redshift).
• Mentor engineers and collaborate with stakeholders; ensure data quality and governance.

Skills

Snowflake

AWS

DBT

SQL

ETL/ELT

Python

Apache Airflow MWAA

Education

Bachelor's degree in Computer Science/IS/Engineering or related field

Master's degree preferred

Tools

PostgreSQL

Oracle

SQL Server

Informatica PowerCenter

Apache Airflow

Terraform

GitHub

Job description

Where Ambition Meets Innovation Build a career that matches all your initiative with an impressive dose of innovation. From cutting-edge resources and a collaborative environment to the freedom to make an impact and more, you’ll find the ingredients you need at LPL Financial to shape your success while helping clients pursue their financial goals.

Job Overview

LPL Financial is seeking a highly motivated and experienced Data Warehouse Technical Lead to drive the design, development, modernization, and support of enterprise data warehousing solutions. This role will play a critical part in advancing our cloud-based data platform and analytics capabilities that support Finance, Enterprise Reporting, and Business Intelligence initiatives across the organization. The ideal candidate is a hands-on data engineering leader with deep expertise in Snowflake, AWS, DBT, SQL, and enterprise data warehousing. This individual will lead technical solution design, mentor team members, and partner closely with business stakeholders while remaining actively involved in data engineering, performance optimization, and production support activities.

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.

What are we looking for?

We’re looking for strong collaborators who deliver exceptional client experiences and thrive in fast-paced, team-oriented environments. Our ideal candidates pursue greatness, act with integrity, and are driven to help our clients succeed. We value those who embrace creativity, continuous improvement, and contribute to a culture where we win together and create and share joy in our work.

Requirements

• 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.
• Experience designing and implementing scalable ETL/ELT pipelines using AWS cloud technologies and modern data engineering practices.

Core Competencies

Data Warehousing & Architecture

• Advanced Snowflake development and administration experience.
• Expertise in Enterprise Data Warehouses (EDW), Operational Data Stores (ODS), Data Marts, and dimensional data modeling.
• Strong understanding of data warehouse architecture, performance optimization, and scalability best practices.
• Experience supporting Finance, Enterprise Reporting, Analytics, and Business Intelligence workloads.

Cloud & Data Engineering

• Strong AWS data engineering experience including S3, Glue, MWAA, Lambda, and Redshift.
• Hands-on experience building and supporting cloud-native ETL/ELT pipelines.
• Experience with DBT, Python, and modern data transformation frameworks.
• Expertise in data integration, orchestration, automation, and monitoring.

Data Governance & Quality

• Strong understanding of data governance, data quality, metadata management, and data security principles.
• Experience implementing data validation, reconciliation, and operational controls.
• Ability to ensure accuracy, reliability, and integrity across enterprise data platforms.

Technical Leadership

• Experience serving as a technical lead, senior engineer, or subject matter expert on enterprise data warehouse initiatives.
• Ability to lead technical design discussions and provide mentorship to data engineers and technical analysts.
• Strong communication, stakeholder management, and cross-functional collaboration skills.
• Experience working within Agile delivery environments.

Preferences

• Financial Services industry experience preferred.
• Experience with PostgreSQL, Oracle, SQL Server, and other enterprise database technologies.
• Experience with Informatica PowerCenter and Apache Airflow (MWAA).
• Experience with Terraform, GitHub, CI/CD pipelines, and DevOps automation practices.
• AWS Certification and/or Snowflake SnowPro Certification preferred.
• Experience supporting cloud migration, platform modernization, or M&A integration initiatives.
• Experience working within large-scale enterprise reporting and analytics environments.

Pay Range

Pay Range: $115,600.00 - $192,600.00 Actual base salary varies based on factors, including but not limited to, relevant skill, prior experience, education, base salary of internal peers, demonstrated performance, and geographic location.

Benefits

• 401K matching
• health benefits
• employee stock options
• paid time off
• volunteer time off
• and more

Company Overview

LPL Financial Holdings Inc. (Nasdaq: LPLA) is among the fastest growing wealth management firms in the U.S. As a leader in the financial advisor-mediated marketplace(6) , LPL supports over 32,000 financial advisors and the wealth management practices of approximately 1,100 financial institutions, servicing and custodying approximately $2.3 trillion in brokerage and advisory assets on behalf of approximately 8 million Americans. The firm provides a wide range of advisor affiliation models, investment solutions, fintech tools and practice management services, ensuring that advisors and institutions have the flexibility to choose the business model, services, and technology resources they need to run thriving businesses. For further information about LPL, please visit www.lpl.com. At LPL, independence means that advisors and institution leaders have the freedom they deserve to choose the business model, services, and technology resources that allow them to run a thriving business. They have the flexibility to do business their way. And they have the freedom to manage their client relationships, because they know their clients best. Simply put, we take care of our advisors and institutions, so they can take care of their clients. For further information about LPL, please visit www.lpl.com. Join the LPL team and help us make a difference by turning life’s aspirations into financial realities. Principals only. EOE.

Information on Interviews

LPL will only communicate with a job applicant directly from an @lplfinancial.com email address and will never conduct an interview online or in a chatroom forum. During an interview, LPL will not request any form of payment from the applicant, or information regarding an applicant’s bank or credit card. Should you have any questions regarding the application process, please contact LPL's Human Resources Solutions Center at [phone].

Additional Information

EAC 5.19.26 LPL Financial is the nation’s largest independent broker-dealer.* Our company is widely known for its financial strength, exceptional service, and favorable industry reputation among financial professionals. To understand who we are, it’s important to know our core belief: financial guidance is a fundamental need for everyone. LPL Financial creates the space to let you do what you do best – create personal, long-term client relationships that turn financial aspirations into realities. Each year, thousands of financial professionals successfully manage billions of dollars in assets. Because our company is not too big and not too small, you can seize the opportunity to make a real impact. To learn more about our organization visit our About LPL page. * As reported by Financial Planning magazine, June 1996-2019, based on total revenue.