Engineer II, Full Stack Reporting

LPL Financial LLC; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

LPL Financial LLC is hiring an Engineer‑II in Hyderabad to drive data engineering, UI development, and API work. You will build Angular-based UI components for dataset discovery, design and expose robust REST/GraphQL APIs, and ensure data quality and observability across platforms.

Expect collaboration with data producers, analytics teams, and engineering partners to validate data readiness, govern datasets, and deliver analytics-ready datasets for consumption.

Qualifications

• 6+ years in data engineering in Angular/full-stack roles.
• Strong Angular experience (services, components, RxJS, modules).
• AWS experience with Glue, S3, Lambda, API Gateway, IAM.
• Ability to interpret/optimize pipelines in Spark, Glue, Python, and dbt.
• Understanding of Medallion architecture; Data modeling (star schema).
• Strong SQL skills (Snowflake, PostgreSQL)
• Familiarity with Iceberg table format
• Proficiency with Git/GitHub workflows

Responsibilities

• UI Development (Angular): Build/enhance UI components for dataset discovery, schema preview, quality insights, and interactive data browsing; integrate APIs into Angular services, modules, components.
• API Development (REST/GraphQL): Build high-performing APIs for data access, metadata retrieval, dataset previews, and export workflows; include pagination, filtering, entitlement controls, caching, throttling.
• Data Validation, Quality & Observability: Validate new datasets; integrate schema checks, monitoring, drift detection; investigate issues and implement improvements.

Skills

Angular development

Full-stack engineering

AWS (Glue, S3, Lambda, API Gateway, I​

Spark/Glue/Python/dbt

SQL

Data modeling

Git/GitHub

Data validation & quality

Data lineage & metadata

Tools

Snowflake

Apache Iceberg

dbt

Power BI

Tableau

ThoughtSpot

Glue

API Gateway

S3

GraphQL

REST APIs

Job description

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. We’re seeking a Engineer‑II with strong experience in data engineering, UI development, API engineering, and AWS cloud technologies.

Role Focus

This role focuses on enabling high‑quality analytics consumption by building curated datasets, high‑performing APIs, and intuitive UI integrations. You will work with data producers, analytics teams, and engineering partners to validate data readiness, design consumption APIs, enhance UI‑driven data experiences, and ensure datasets are accessible, governed, and analytics‑ready. This role blends data engineering + UI engineering + modern API development in consumer‑facing capacity.

Key Responsibilities

• UI Development (Angular) Build or enhance Angular UI components for dataset discovery, schema preview, quality insights, and interactive data browsing. Integrate APIs into Angular services, modules, and components using RxJS and state management. Improve UX for dataset search, navigation, and metadata visibility.
• API Development (REST/GraphQL) Build high‑performing APIs for data access, metadata retrieval, dataset previews, and export workflows. Implement: Pagination, filtering, and advanced query parameters; Entitlement‑aware access controls; Caching, throttling, and performance enhancements; Bulk vs. micro consumption flows. Create SDK‑style examples, reusable integration templates, and client libraries.
• Data Validation, Quality & Observability Perform deep data validation for new or enhanced datasets. Integrate schema checks, monitoring workflows, and drift detection. Investigate anomalies and consumer‑reported issues; implement long‑term improvements.

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.

Required Qualifications

• 6+ years in data engineering in Angular/ full‑stack engineering roles
• Practical Angular experience (services, components, RxJS, modules)
• AWS experience with Glue, S3, Lambda, API Gateway, IAM
• Ability to interpret/optimize pipelines in Spark, Glue, Python, and dbt.
• Understanding of: Medallion architecture; Data modeling (star schema, semantic layers, wide tables); Data lineage, metadata, and data quality practices
• Strong SQL skills (Snowflake, PostgreSQL, or similar)
• Familiarity with Iceberg table format
• Proficiency with Git/GitHub workflows

Preferred Qualifications

• Database Knowledge (Plus): Snowflake Cloud Data Warehouse, Apache Iceberg, PostgreSQL
• Hands‑on experience designing or consuming REST/GraphQL APIs is a plus
• Experience with data catalogs (Glue Catalog, DataHub, Alation, Collibra)
• Understanding of OAuth/OIDC, token‑based authentication, API gateway patterns
• Experience with consumer analytics tools (Power BI, Tableau, ThoughtSpot)
• Understanding of governance, classification, and metadata frameworks
• Proven impact improving data discoverability, access patterns, or consumer experience

LPL Global Business Services, LLP - PRIVACY POLICY