> Markdown version of [/jobs/ext/2702125-lead-data-warehouse-technical-analyst](https://www.wearedevelopers.com/jobs/ext/2702125-lead-data-warehouse-technical-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Warehouse Technical Analyst - **Company:** LPL Financial - **Location:** Fort Mill, SC, United States (Remote available) - **Experience:** Expert - **Salary:** $115,600.0 - $192,600.0 - **Contract:** Permanent contract - **Skills:** Airflow, Amazon Web Services, Amazon S3, Data Analysis, Cloud Computing, Cloud Engineering, Information Systems, Databases, Continuous Integration, Data Architecture, Data Validation, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Security, Data Systems, Data Warehousing, Github, Python (Programming Language), PostgreSQL, Meta-Data Management, Microsoft SQL Server, Operational Data Store, Oracle (Applications), Performance Tuning, Query Optimization, Cloud Services, Solution Deployment Descriptor, SQL Databases, Enterprise Data Management, Freeform SQL, Cloud Platform System, Informatica Powercenter, Snowflake, Information Technology, Deployment Automation, Data Analytics, AWS Data Analytics, Cloud Migration, Terraform, Data Pipelines - **Published:** September 4, 2026 - **Apply:** https://lplfinancial.wd1.myworkdayjobs.com/External/job/Fort-MillCharlotte/Lead-Data-Warehouse-Technical-Analyst_R-053137-1 ## About the Role 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., * 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. ## Description 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., * 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Infrastructure as Code: The Developer's Secret Weapon](https://www.wearedevelopers.com/videos/1221-infrastructure-as-code-the-developer-s-secret-weapon) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Implementing Feature Environments with AWS and Terraform](https://www.wearedevelopers.com/videos/531-implementing-feature-environments-with-aws-and-terraform) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023)