Engineer II, Data

Overview

Hands-on Data Services Developer on the Reference Data Master team within LPL's Data & Analytics organization, building scalable party reference data solutions that support client onboarding, KYC/AML, regulatory reporting and operational efficiency.

What you'll do

• Design, develop and maintain party reference data services and pipelines supporting clients, counterparties, issuers and legal entities.
• Build and enhance cloud-native data solutions using AWS services such as Glue, Lambda, EventBridge, S3, RDS (Aurora/Postgres), and MSK/Kinesis.
• Develop and maintain APIs and data services to deliver party data to downstream systems such as CRM, trading, compliance and reporting platforms.
• Contribute to modernization efforts by migrating legacy party data systems from on-premise platforms to scalable, cloud-based architectures.
• Integrate and manage third-party data providers (e.g., S&P Global Markit, Dun & Bradstreet, KYC/AML vendors) to ensure accurate ingestion, enrichment and synchronization of party data.
• Implement data mastering capabilities including deduplication, survivorship rules, identity resolution and golden record creation.
• Ensure data quality, reliability and lineage through validation frameworks, monitoring and metadata management.
• Build resilient, observable systems with appropriate logging, alerting and fault-tolerant design patterns.
• Collaborate with architecture, security and governance teams to ensure compliance with data privacy, regulatory and cybersecurity standards.
• Participate actively in Agile delivery processes including backlog refinement, sprint planning, code reviews and production support.
• Mentor junior developers and contribute to coding standards, design reviews and engineering best practices.

What you'll need

• 5+ years of experience in data engineering or software development with a strong focus on enterprise data platforms.
• 3+ years of experience building data pipelines, APIs and event-driven architectures (using Python).
• Hands-on experience working with party or entity reference data domains.
• Strong proficiency with AWS services, including Glue, Lambda, EventBridge, S3, RDS (Aurora/Postgres), and MSK/Kinesis.
• Experience with data mastering concepts such as identity resolution, source system prioritization and golden record management.
• Solid background working with relational and cloud-native data stores such as Snowflake, Aurora, Postgres, MSSQL, or similar.
• Familiarity with CI/CD pipelines, infrastructure-as-code (Terraform) and modern DevOps practices.
• Strong problem-solving skills with the ability to work independently on complex technical challenges.
• Effective communication skills and the ability to collaborate across technical and business teams.

Nice to have

• AWS certification(s).

Details

• Location: Hyderabad.