Sr Engineer, Reporting

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

Job summary

LPL Financial Global Capability Center is seeking a Senior Engineer to drive the development of the LPL Intelligence Marketplace in Hyderabad. This pivotal role involves designing and optimizing advanced analytics and enterprise BI solutions, ensuring trusted insights for business growth.

The ideal candidate will have over 7 years of related experience, strong SQL skills, and be proficient in tools like Tableau and Power BI. Join us and contribute significantly in a collaborative environment that values your input and promotes innovation.

Qualifications

• 7+ years of experience in cloud-based enterprise data access with BI tooling.
• Demonstrable experience in Tableau, Power BI, and Alteryx.
• Advanced SQL query writing and data analysis skills.

Responsibilities

• Lead development of the LPL Intelligence Marketplace for certified data access.
• Design and maintain enterprise BI solutions and reporting systems.
• Build and optimize ETL/ELT pipelines for data integration.

Skills

Tableau

Power BI

Alteryx

SQL

Python

R

Education

Bachelor’s degree in Data Science, Computer science or related field

Master’s degree preferred

Tools

ETL/ELT tools (Alteryx, SSIS, Informatica, Talend)

Data warehousing (Snowflake, Redshift, BigQuery, Synapse)

Cloud platforms (AWS, Azure, GCP)

Data governance & cataloging tools (Collibra, Alation, Atlan)

Job description

What if you could build a career 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.

Job Overview

We are seeking a creative and hands‑on senior engineer with extensive experience delivering top technical solutions, delivering data experience design to build and optimize a marketplace for data access, and exceptional experience in advanced analytics and enterprise reporting and BI solutions. This role will be pivotal in bridging business needs with data discoverability and use, ensuring our customers have access to trusted insights to drive our business forward.

Responsibilities

• Lead the development and delivery of the LPL Intelligence Marketplace, enabling consumers to discover and use certified data and AI assets through a unified experience
• Design, develop, and maintain enterprise BI solutions, including data models, data marts, and reporting systems
• Build and optimize ETL/ELT pipelines to extract, transform, and load data from diverse sources into centralized repositories (data warehouses, data lakes)
• Develop and maintain dashboards, reports, and visualizations using Tableau, Power BI, and Alteryx
• Collaborate with business stakeholders to gather requirements, translate business needs into technical solutions, and deliver actionable insights
• Ensure data quality, integrity, and consistency across all BI deliverables; implement data validation and reconciliation processes
• Support and enhance data governance, cataloging, and lineage initiatives to ensure compliance and transparency
• Optimize database queries, data models, and reporting performance for scalability and efficiency
• Troubleshoot and resolve data-related issues, supporting business users and analysts in their data needs
• Document BI processes, data flows, and technical specifications; provide training and support to end users
• Stay current with BI trends, tools, and best practices; recommend and implement improvements to BI architecture and processes

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

• 7+ years of experience cloud‑based enterprise data access delivering through business intelligence tooling, with at least 5 years focused on delivering data and enterprise‑level BI solutions for advanced analytics
• Bachelor’s degree in Data Science, Computer science or related field; Master’s degree preferred
• Demonstrable hands‑on experience with:
  • Advanced development experience in Tableau, Power BI, and Alteryx for dashboarding, data preparation, and advanced analytics
  • Data modeling and warehousing: designing star/snowflake schemas, building data marts, and optimizing for analytical workloads
  • ETL/ELT development: building and maintaining pipelines using tools such as Alteryx, SSIS, Informatica, Talend, or db>
  • SQL: advanced query writing, performance tuning, and data analysis
  • Scripting/programming: Python or R for data processing and automation
  • Strong UI experience; experience in delivering custom UI for data portal solutions preferred
• Strong understanding of data governance, data quality, and security best practices
• Advanced experience with Tableau, with preferred experience in Alteryx and PowerBI as well

Core Competencies

• Excellent communication and stakeholder management skills; heavy interaction with business customers is required

Preferences

• Experience in financial services or other regulated industries is a plus, wealth management experience preferred
• Advanced knowledge and experiencing in delivering data access/discoverability experiences – delivering quality trusted data for analysts to use
• Experience with enterprise‑scale BI deployments and self‑service analytics enablement
• Demonstrated use of AI/ML tools to augment engineering and BI productivity
• Familiarity with data cataloging, lineage, and metadata management tools
• Knowledge of advanced analytics, machine learning, or statistical modeling.
• Advanced analytics user interface and design experience
• BI or cloud certifications (e.g., Tableau Desktop Specialist, Microsoft Certified: Data Analyst Associate, AWS Certified Data Analytics)

Skills & Tools

• Tableau, Power BI, Alteryx
• SQL, Python, R
• ETL/ELT tools (Alteryx, SSIS, Informatica, Talend, dbt)
• Data warehousing (Snowflake, Redshift, BigQuery, Synapse)
• Data governance & cataloging (Collibra, Alation, Atlan)
• Cloud platforms (AWS, Azure, GCP)
• Version control (Git), CI/CD for BI assets