LPL Financial
What if you could
build a career where ambition meets innovation? At LPL Financial, we empower professionals to shape their success while helping clients pursue their financial goals with confidence.
What if you could
have access to cutting‑edge resources, a collaborative environment, and the freedom to make an impact? If you're ready to take the next step, discover what’s possible with LPL Financial.
Job Overview LPL’s Enterprise Data Warehousing team is working to build enhanced data and insights capabilities by transforming them into Cloud applications. We are looking for a technical leader to drive the implementation and adoption of Cloud warehouses across multiple applications. This is a very hands‑on role and will be working with a motivated team in a fast‑paced environment.
Responsibilities
Lead the design, development, enhancement, and cloud migration of the enterprise Data Warehouse, ensuring alignment with business goals and data governance.
Manage full lifecycle delivery from requirements gathering to production deployment across on‑premise and cloud platforms (Snowflake, AWS).
Architect scalable cloud data solutions using Snowflake, DBT, and AWS‑native services (S3, Lambda, Glue, Airflow).
Implement ELT/ETL pipelines using tools like DBT.
Lead, coach, and mentor onshore and offshore development teams to deliver high‑quality software solutions.
Act as a technical escalation point, resolving issues and proposing alternative solutions to ensure system reliability and performance.
Serve as the subject matter expert in database application delivery and optimization, with deep expertise in Oracle and Microsoft SQL Server.
Oversee release management and post‑production support to ensure smooth transitions and minimal business disruption.
Lead application migration efforts to cloud‑based architectures and support remediation of existing implementations accessing data warehouses and lakes.
Requirements
Bachelor’s degree in computer science or related field.
15+ years of experience in IT, with 8+ years in Data Warehouse development and support.
Deep expertise in Snowflake, AWS services, and modern ELT tools.
Proven experience in conceptual, logical, and physical data modeling.
Advanced SQL skills and experience with enterprise databases.
Core Competencies
Exceptional communication skills—able to translate technical concepts into business language.
Strong organizational and planning abilities with a process‑driven mindset.
Proven ability to manage multiple priorities in a fast‑paced environment.
Commitment to excellence in service delivery and execution.
Collaborative mindset with cross‑functional team engagement.
Preferences
Experience in coding technologies like Python, Scala, and SQL.
Experience with Informatica, Data Lake, Hadoop, MapR is a big plus.
CI/CD, GitHub, and Octopus or equivalent experience is a plus.
Experience in Fin-Tech industry is a plus.
Strong understanding of Data Vault, Lakehouse, and Hub architectures.
Familiarity with Generative AI tech stack, such as OpenAI GPT, Claude, or similar; prompt engineering and fine‑tuning for business use cases; integration of LLMs into data workflows and applications (e.g., chatbots, summarization, code generation).
Pay Range $115,575–192,625/year. 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.
#J-18808-Ljbffr
build a career where ambition meets innovation? At LPL Financial, we empower professionals to shape their success while helping clients pursue their financial goals with confidence.
What if you could
have access to cutting‑edge resources, a collaborative environment, and the freedom to make an impact? If you're ready to take the next step, discover what’s possible with LPL Financial.
Job Overview LPL’s Enterprise Data Warehousing team is working to build enhanced data and insights capabilities by transforming them into Cloud applications. We are looking for a technical leader to drive the implementation and adoption of Cloud warehouses across multiple applications. This is a very hands‑on role and will be working with a motivated team in a fast‑paced environment.
Responsibilities
Lead the design, development, enhancement, and cloud migration of the enterprise Data Warehouse, ensuring alignment with business goals and data governance.
Manage full lifecycle delivery from requirements gathering to production deployment across on‑premise and cloud platforms (Snowflake, AWS).
Architect scalable cloud data solutions using Snowflake, DBT, and AWS‑native services (S3, Lambda, Glue, Airflow).
Implement ELT/ETL pipelines using tools like DBT.
Lead, coach, and mentor onshore and offshore development teams to deliver high‑quality software solutions.
Act as a technical escalation point, resolving issues and proposing alternative solutions to ensure system reliability and performance.
Serve as the subject matter expert in database application delivery and optimization, with deep expertise in Oracle and Microsoft SQL Server.
Oversee release management and post‑production support to ensure smooth transitions and minimal business disruption.
Lead application migration efforts to cloud‑based architectures and support remediation of existing implementations accessing data warehouses and lakes.
Requirements
Bachelor’s degree in computer science or related field.
15+ years of experience in IT, with 8+ years in Data Warehouse development and support.
Deep expertise in Snowflake, AWS services, and modern ELT tools.
Proven experience in conceptual, logical, and physical data modeling.
Advanced SQL skills and experience with enterprise databases.
Core Competencies
Exceptional communication skills—able to translate technical concepts into business language.
Strong organizational and planning abilities with a process‑driven mindset.
Proven ability to manage multiple priorities in a fast‑paced environment.
Commitment to excellence in service delivery and execution.
Collaborative mindset with cross‑functional team engagement.
Preferences
Experience in coding technologies like Python, Scala, and SQL.
Experience with Informatica, Data Lake, Hadoop, MapR is a big plus.
CI/CD, GitHub, and Octopus or equivalent experience is a plus.
Experience in Fin-Tech industry is a plus.
Strong understanding of Data Vault, Lakehouse, and Hub architectures.
Familiarity with Generative AI tech stack, such as OpenAI GPT, Claude, or similar; prompt engineering and fine‑tuning for business use cases; integration of LLMs into data workflows and applications (e.g., chatbots, summarization, code generation).
Pay Range $115,575–192,625/year. 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.
#J-18808-Ljbffr