AVP Data Warehouse Lead

LPL Financial; Austin (TX); Hybrid; USD 116,000 - 193,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 is seeking an experienced Data Warehousing Lead (Finance) to direct enterprise data and analytics solutions powered by Snowflake and AWS. You will bridge business stakeholders with data engineering, architects, and analytics consumers to deliver scalable, trusted data products that drive business value.

The role requires strong business analysis, product ownership, and deep finance knowledge, owning the backlog, defining requirements, and partnering with engineering for reporting

Qualifications

• 10+ years in Data Engineering, Data Warehousing, Analytics Engineering, or Data Architecture.
• 5+ years leading business requirements, backlog, and delivery in Finance or similar domains.
• Advanced SQL development, performance tuning, data validation.
• AWS-based ETL/ELT pipelines and modern data engineering practices.
• Bachelor’s degree; Master’s preferred in related field.

Responsibilities

• Own product roadmaps, backlogs, sprint planning, and release planning to maximize value.
• Lead requirements management: requirements gathering, data mapping, user stories, acceptance criteria, UAT coordination.
• Define business rules, KPIs, data lineage, and reporting requirements in Finance domains.
• Design, develop, enhance, and support data warehouse solutions using Snowflake and AWS.
• Build scalable ETL/ELT pipelines and data transformations for Finance, Reporting, Analytics.
• Develop and optimize complex SQL queries and data models for enterprise warehousing.
• Collaborate with stakeholders, analysts, and engineering to translate requirements into solutions.
• Establish data quality, governance, and operational excellence practices.
• Support data warehouse modernization and cloud migration initiatives.
• Work in a hybrid environment in Austin or Fort Mill with cross-location teams.

Skills

Data warehousing

Snowflake

AWS

SQL

ETL/ELT

Product ownership

Finance domain

Education

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

Master's degree preferred

Tools

Snowflake

AWS

DBT

PostgreSQL/Oracle/SQL Server

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 an experienced Data Warehousing Lead (Finance) to lead the strategic planning, requirements management, and delivery of enterprise data and analytics solutions powered by Snowflake and AWS cloud technologies. This role serves as the critical bridge between business stakeholders, data engineering teams, architects, and analytics consumers to ensure the successful delivery of scalable, high-quality data products that drive business value.

The ideal candidate combines strong business analysis, product ownership, and data warehousing expertise with deep financial services knowledge. This individual will own the data product backlog, drive prioritization decisions, define business requirements, and partner closely with engineering teams to deliver trusted, business-aligned reporting and analytics solutions.

Responsibilities

• Own and manage product roadmaps, delivery backlogs, prioritization, sprint planning, and release planning activities to maximize business value and ensure alignment with enterprise data and analytics objectives.
• Lead business analysis and requirements management activities, including requirements gathering, process modeling, data mapping, user story creation, acceptance criteria definition, UAT coordination, and release readiness planning.
• Leverage Finance domain expertise to define business rules, KPI calculations, reconciliations, data lineage, and reporting requirements while monitoring product adoption, stakeholder satisfaction, and continuous improvement opportunities.
• 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.
• 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.
• 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

• Minimum of 10 years of experience in Data Engineering, Data Warehousing, Analytics Engineering, or Data Architecture, or related disciplines.
• Minimum of 5 years of experience leading business requirements, product ownership, backlog management, and delivery of enterprise data warehouse, analytics, or reporting solutions within Finance or other business domains.
• 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.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field; Master's degree preferred.

Core Competencies

Data Warehousing & Analytics Platforms

• Strong Snowflake experience supporting enterprise data warehouse, reporting, analytics, and business intelligence solutions.
• Expertise with Enterprise Data Warehouses (EDW), Operational Data Stores (ODS), Data Marts, dimensional modeling, and analytical data structures.
• Strong understanding of data warehouse architecture, data lineage, performance optimization, scalability, and reporting enablement.
• Experience supporting Finance, Enterprise Reporting, Analytics, FP&A, Accounting, and Business Intelligence workloads.

Product Ownership & Requirements Leadership

• Experience owning product roadmaps, delivery backlogs, prioritization, sprint planning, and release planning for enterprise data and analytics solutions.
• Strong business analysis and requirements management experience including requirements gathering, user stories, acceptance criteria, data mapping, and process modeling.
• Experience coordinating User Acceptance Testing (UAT), release readiness activities, stakeholder communications, and change management.
• Ability to translate business objectives into scalable data warehouse, reporting, and analytics solutions.

Finance & Business Domain Expertise

• Experience partnering with Finance, Reporting, Analytics, and Data Engineering teams to define KPI calculations, business rules, reconciliations, and reporting requirements.
• Strong understanding of financial reporting concepts, controls, auditability, data governance, and operational reporting.
• Experience documenting data lineage, source-to-target mappings, business definitions, and reporting requirements.
• Ability to identify opportunities for product adoption, process improvement, and business value realization.

Cloud Data Platforms & Engineering

• Working knowledge of AWS cloud data services including S3, Glue, MWAA, Lambda, and Redshift.
• Experience with DBT, SQL, data transformation frameworks, ETL/ELT processes, and cloud-based data platforms.
• Ability to partner effectively with Data Engineering teams on platform enhancements, modernization initiatives, and cloud migration efforts.
• Understanding of data integration, orchestration, automation, monitoring, and operational support practices.

Data Governance & Quality

• Strong understanding of data governance, metadata management, master data concepts, and data security principles.
• Experience implementing data validation, reconciliation processes, operational controls, and data quality frameworks.
• Ability to ensure the accuracy, consistency, reliability, and integrity of enterprise reporting and analytics solutions.

Leadership & Stakeholder Management

• Experience serving as a data lead, technical analyst lead, product owner, or subject matter expert for enterprise data warehouse initiatives.
• Strong communication, stakeholder engagement, presentation, and relationship-building skills.
• Ability to collaborate across Finance, Analytics, Data Engineering, Architecture, and Operations teams.
• Experience working within Agile delivery environments and guiding cross-functional teams toward successful outcomes.

Preferences

• Financial Services industry experience preferred.
• Experience working within large-scale enterprise reporting and analytics environments.
• Experience with PostgreSQL, Oracle, SQL Server, and other enterprise database technologies.
• AWS Certification and/or Snowflake SnowPro Certification preferred.
• Experience supporting cloud migration, platform modernization, or M&A integration initiatives.

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. Additionally, LPL Total Rewards package is highly competitive, designed to support your success at work, at home, and at play – such as 401K matching, health benefits, employee stock options, paid time off, volunteer time off, and more.

Principals only. EOE.

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.

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].