Lead Data Analyst

TEST JOB PLEASE DO NOT APPLY

Where Ambition Meets Innovation

At LPL’s Global Capability Center, you'll find a collaborative culture where your voice matters, integrity guides every decision, and technology fuels progress. Your skills, talents, and ideas will redefine what's possible. LPL's success reflects its exceptional employees, who together pursue one noble purpose: empowering financial advisors to deliver personalized advice for all who need it. We’re proud to be expanding and reaching new heights in Hyderabad.

Join us as we create something extraordinary together.

At LPL Financial Global Capability Center, you'll find a collaborative culture where your voice matters, integrity guides every decision, and technology fuels progress. Your skills, talents, and ideas will redefine what's possible. LPL's success reflects its exceptional employees, who together pursue one noble purpose: empowering financial advisors to deliver personalized advice for all who need it. We are proud to expand in Hyderabad.

Join us as we create something extraordinary together.

Job Overview:

LPL Financial is seeking an Assistant Vice President, Tech Data Analyst / Data Modeler in our Enterprise Data Modeling team within the Data & Analytics organization. This role is ideal for an experienced technical leader with deep expertise in enterprise data modeling and data analysis function, cloud-native architecture, and enterprise data engineering. You will be responsible for contributing the data strategy, design, and delivery of scalable, secure, and high-quality party data solutions that support critical business functions including client onboarding, account life cycle management, KYC/AML, regulatory reporting, and operational efficiency.

Responsibilities:

• Data Modeling & Design: Lead the design, review, and optimization of enterprise logical and physical data models, ensuring alignment with business requirements, data architecture standards, and longterm strategy. Translate complex business, regulatory, and analytical requirements into wellstructured data models that support operational and analytical use cases. Define and enforce data modeling standards, naming conventions, and best practices to minimize data redundancy and ensure consistent enterprise semantics. Perform reverse engineering of existing databases and SQL artifacts to document, rationalize, and modernize data models.
• Data Analysis & Domain Expertise: Develop deep domain knowledge across client, account, asset, transaction, and advisor data domains. Analyze data patterns, gaps, and anomalies to support business decisionmaking and data quality initiatives. Partner with business and data analysts to ensure accurate interpretation of data requirements and business intent.
• Governance, Metadata & Quality: Actively support data governance initiatives, including: Business Glossary and semantic definition development, Data dictionaries for logical and physical models, Data lineage and impact analysis, Reference and master data modeling. Contribute to data profiling and data quality assessments using cloudenabled and enterprise data tools. Ensure regulatory, supervisory, and audit considerations are incorporated into data design.
• Collaboration & Delivery: Collaborate with data architects, solution architects, engineers, DBAs, and product teams to ensure data models are implementable and aligned with the enterprise data roadmap. Participate in Agile delivery processes, including backlog refinement, sprint planning, and design reviews. Provide technical guidance and design mentorship to junior data analysts and modelers. Support evaluation and adoption of new tools, techniques, and platforms to improve enterprise data management capabilities.

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 a related field (advanced degree preferred).
• 10+ years of experience in data analysis, data modeling, data architecture, or data governance roles.
• 8+ years of handson experience with: Enterprise data modeling tools (e.g., Erwin or similar), SQL and relational database concepts, Logical, physical, and dimensional (star/snowflake) modeling
• Ability to translate complex data concepts into clear business value, and vice versa.
• Experience working in financial services, fintech, wealth management, or highly regulated industries.

Core Competencies

• Advanced data modeling and database design expertise
• Strong analytical and problemsolving skills
• Deep understanding of enterprise data domains and systems of record
• Agile delivery experience (Jira, Confluence)
• Excellent written and verbal communication skills
• Ability to influence without authority
• Mentorship and knowledgesharing mindset

Preferred Qualifications

• Experience with cloudnative data platforms such as AWS and Snowflake.
• Knowledge of data pipeline transformations and modern analytics architectures.
• Background in wealth management, advisory platforms, or brokerage systems.
• Experience supporting regulatory or supervisory reporting use cases.
• Familiarity with data governance, metadata management, and cataloging tools.
• AWS certifications (e.g., Solutions Architect) are a plus.

LPL Global Business Services, LLP - PRIVACY POLICY