Lead Data Analyst

At LPL s Global Capability Center, youll find a collaborative culture where your voice matters, integrity guides every decision, and technology fuels progress. Your skills, talents, and ideas will redefine whats possible. LPLs 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.

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.

Key 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 long term strategy.

• Translate complex business, regulatory, and analytical requirements into well structured 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 decision making 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 cloud enabled 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 We Are Looking For

We are looking for experienced, self directed data professionals who:

• Thrive in complex, fast paced environments

• Take ownership of data design decisions

• Communicate clearly with both technical and business partners

• Balance hands on modeling work with strategic thinking

• Champion data quality, consistency, and governance

Required Qualifications

• 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 hands on experience with:

  • Enterprise data modeling tools (e.g., Erwin or similar)

  • SQL and relational database concepts

  • Logical, physical, and dimensional (star/snowflake) modeling

• Proven 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 problem solving 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 knowledge sharing mindset

Preferred Qualifications

• Experience with cloud native 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