AVP, Tech Data Engineer
LPL FinancialAbout the role
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.
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 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)
#LI-Hybrid
Pay Range:
$115,575-$192,625/yearCompany Overview:
LPL Financial Holdings Inc. (Nasdaq: LPLA) is among the fas
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s