Engineer II Full Stack Reporting

LPL Financial Global Capability Center; Telangana; On-site; INR 1,500,000 - 3,000,000; Full time

Job summary

LPL Financial Global Capability Center in Hyderabad seeks an Engineer-II to join a fast-paced data/UI/API engineering team. The role blends data engineering, UI development, and modern API work to deliver analytics-ready datasets and intuitive interfaces.

You will collaborate with data producers and analytics partners to validate data, build consumption APIs, and ensure governance and observability across datasets.

Qualifications

• 6+ years in data engineering in Angular/full-stack 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, data lineage, metadata, and data quality practices.
• Strong SQL skills (Snowflake, PostgreSQL, or similar).
• Familiarity with Iceberg table format.
• Proficiency with Git/GitHub workflows.

Responsibilities

• UI Development: Build/enhance Angular UI components for dataset discovery, schema preview, quality insights, and interactive browsing.
• API Development: Build high-performing REST/GraphQL APIs with entitlement controls and caching, pagination, and filtering.
• Data Validation & Observability: Validate new/enhanced datasets, monitor data quality, schema checks, and drift detection.
• Collaboration: Work with data producers, analytics teams, and engineering partners to validate data readiness and governance.

Skills

Data engineering

Angular/full-stack

AWS (Glue/S3/Lambda)

SQL (Snowflake/PostgreSQL)

Spark/ETL pipelines

GitHub workflows

Tools

Glue

S3

Lambda

API Gateway

IAM

Snowflake

PostgreSQL

Apache Iceberg

GitHub

Job description

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.

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