Principal Engineer I, BI & Analytics

5210 Invesco (India) Private Limited - SEZ Unit; Hyderabad; Hybrid; INR 1,500,000 - 2,000,000; Full time

Benefits offered by this job

Competitive Compensation

Flexible, Hybrid Work

30 days’ Annual Leave + Public Holidays

26 weeks Maternity Leave, Paternal Leave, Adoption Leave

Life Insurance and Medical Insurance

Retirement Planning and Employee Stock Purchase Plan

Childcare Facility and Employee Assistance Program

Job summary

5210 Invesco (India) Private Limited - SEZ Unit is seeking a Principal Data Engineer to manage data processes in Hyderabad. This role involves designing database solutions and optimizing SQL queries to provide actionable insights to leadership.

The ideal candidate will have a minimum of 8 years of experience in MS SQL Server and strong capabilities in ETL processes. This position offers a competitive compensation package and a hybrid work schedule.

Qualifications

• Minimum of 8 years of experience in an MS SQL Server database environment.
• Strong expertise in writing complex SQL queries using CTEs and joins.
• Solid experience with ETL/ELT processes and tools.

Responsibilities

• Design, develop, and maintain database solutions for actionable insights.
• Build data models for Business Intelligence and reporting.
• Optimize SQL queries and ETL jobs for performance.

Skills

MS SQL Server expertise

Complex SQL queries

ETL/ELT processes

AWS cloud services

Data modeling concepts

Apache Airflow and/or Stonebranch UAC

SSIS package development

Tools

Airbyte

dbt

AWS Glue

Power BI

Job description

Job Description

As one of the world’s leading independent global investment firms, Invesco is dedicated to rethinking possibilities for our clients. If you’re looking for challenging work and exposure across a global footprint, this role is for you.

The Department

Invesco’s global BI & Analytics Team within Technology and Operations empowers leaders across the company with actionable data insights that drive informed decision‑making. We deliver rich analytics solutions through our BI platform and custom web tools.

Your Role

The Principal Data Engineer works within the Business Intelligence & Analytics function, part of Tech and Ops, reporting to the Manager of Data. The engineer will own the end‑to‑end process of managing the availability, reliability, and accessibility of data in an MS SQL data mart, including T‑SQL tables, stored procedures, views, and functions.

Responsibilities

• Design, develop, and maintain robust database solutions to deliver actionable insights to leadership and cross‑functional teams.
• Build data models that support Business Intelligence and self‑service reporting, adhering to industry and function‑specific standards.
• Develop and maintain data models optimized for analytics and reporting.
• Write complex, efficient SQL queries using best practices and modern methodologies.
• Design, build, and maintain scalable ETL/ELT pipelines to ingest data from diverse internal and external sources.
• Optimize SQL queries and ETL jobs for performance and cost efficiency.
• Ensure the scalability, reliability, and maintainability of data pipelines.
• Collaborate with BI developers and analysts to ensure data availability, quality, and usability.
• Provide technical support for data‑related issues and troubleshoot pipeline failures.
• Implement monitoring and alerting mechanisms for proactive issue detection.
• Maintain comprehensive documentation for data flows, schemas, and processes.
• Continuously improve existing systems and processes by applying innovative solutions, best practices, and strategic thinking.
• Implement processes to detect and resolve blocking, deadlocks, and inefficient queries.
• Proactively address data quality issues and ensure data integrity across systems.
• Own the end‑to‑end data flow process and understand various data types and their business context.

Qualifications

• Minimum of 8 years of experience in an MS SQL Server database environment, including database design, data loading/unloading, performance tuning, and security best practices.
• Strong expertise in writing complex SQL queries using CTEs, subqueries, joins, and temporary tables.
• Solid experience with ETL/ELT processes and tools such as Airbyte, dbt, or AWS Glue.
• Proficient in AWS cloud services such as S3, IAM Roles, Policies, and Lambda for database and data pipeline solutions.
• Experience orchestrating data workflows using Apache Airflow and/or Stonebranch UAC, including workflow design, scheduling, monitoring, and troubleshooting.
• Deep experience in developing SSIS packages and utilizing all data flow task transformations.
• Good to have knowledge of Snowflake.
• Strong knowledge of data modeling concepts and best practices.
• Familiarity with BI tools such as Power BI is a plus.

Abilities & Skills

• Comfortable in a fast‑paced, dynamic work environment.
• Can manage multiple tasks simultaneously, paying close attention to detail.
• Possesses exceptional oral and written communication skills.
• Comfortable participating in team discussions and sharing feedback.
• Able to communicate with all levels, including junior members and senior management.
• Adept at managing competing priorities.
• Can work both independently and as part of a team.
• Ability to work effectively with technical and business staff across geographic areas.

Employment Details

Full‑time employee. Exempt position. Workplace model: employee works a hybrid schedule—at least three days in the designated office and two days working outside an Invesco office, in coordination with the direct manager.

Benefits

• Competitive Compensation
• Flexible, Hybrid Work
• 30 days’ Annual Leave + Public Holidays
• 26 weeks Maternity Leave, Paternal Leave, Adoption Leave
• Life Insurance, Group Personal Accident Insurance, Medical Insurance for Employee and Family
• Retirement Planning, Employee Stock Purchase Plan
• Near‑site Childcare Facility, Employee Assistance Program, Annual Health Check‑up
• Study Support, ESG Commitments and Goals, Mentoring Programs