Principal Engineer I, BI & Analytics

Invesco

Hyderabad

Hybrid

INR 1,500,000 - 2,500,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Competitive Compensation

Flexible, Hybrid Work

30 days’ Annual Leave + Public Holidays

Medical Insurance for Employee and Family

Employee Stock Purchase Plan

Job summary

Invesco is seeking a Principal Data Engineer for the Business Intelligence & Analytics team in Hyderabad. The role involves designing and maintaining database solutions and enhancing data models for actionable insights. The ideal candidate will have 8+ years of SQL Server experience and strong expertise in ETL processes.

This full-time position offers a flexible workplace model, allowing employees to work in-office three days a week. Competitive benefits including 30 annual leave days and medical insurance for employees and family are available.

Qualifications

Minimum of 8 years of experience in a SQL Server database environment.
Strong expertise in writing complex SQL queries.
Solid experience with ETL/ELT processes and tools.

Responsibilities

Designing and developing database solutions to deliver actionable insights.
Building data models that support Business Intelligence.
Collaborating with BI developers and analysts.

Skills

SQL queries

ETL/ELT processes

Data modeling

AWS cloud services

Apache Airflow

BI tools (Power BI)

Tools

MS SQL Server

Airbyte

dbt

AWS Glue

SSIS packages

Snowflake

Job description

Job Description

As one of the world’s leading asset managers, we are solely dedicated to delivering an investment experience that helps people get more out of life. If you’re looking for challenging work, smart colleagues, and a global employer with a social conscience, explore your potential at Invesco.

The Department

Because Invesco understands data and the products created from data are the lifeblood of our business, we have created a global BI & Analytics Team within the Technology and Operations. Our mission is to empower 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, enabling senior leaders to access, interpret, and act on critical business information.

Your Role

The Principal Data Engineer sits within the Business Intelligence & Analytics function as a part of the Tech and Ops, reporting to the Manager Data. The Engineer will be part of a small Team that owns the end-to-end process of managing the availability, reliability, and accessibility of data in a MS SQL data mart.

You will be responsible for:

Designing, developing, and maintaining robust database solutions to deliver actionable insights to leadership and cross-functional teams.
Building data models that support Business Intelligence (BI) and self-service reporting, adhering to both industry and function-specific standards.
Developing and maintaining data models optimized for analytics and reporting.
Writing complex, efficient SQL queries using best practices and modern methodologies.
Designing, building, and maintaining scalable ETL/ELT pipelines to ingest data from diverse internal and external sources.
Optimizing SQL queries and ETL jobs for performance and cost efficiency.
Ensuring the scalability, reliability, and maintainability of data pipelines.
Collaborating with BI developers and analysts to ensure data availability, quality, and usability.
Providing technical support for data-related issues and troubleshooting data pipeline failures.
Implement monitoring and alerting mechanisms for proactive issue detection.
Maintaining comprehensive documentation for data flows, schemas, and processes.
Continuously improving existing systems and processes by applying innovative solutions, best practices, and strategic thinking in data management.
Implementing processes to detect and resolve blocking, deadlocks, and inefficient queries.
Proactively addressing data quality issues and ensuring data integrity across systems.
Owning the end-to-end data flow process and understanding various data types and their business context.

The experience you bring:

Minimum of 8 years of experience in a 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 like 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 on Snowflake.
Strong knowledge of data modeling concepts and best practices.
Familiarity with BI tools such as Power BI is a plus.

Your Abilities:

Comfortable in a fast-paced, dynamic work environment.
Can manage multiple tasks simultaneously, pays close attention to detail.
Possesses exceptional oral and written communication skills.
Feels comfortable participating in team discussions and sharing feedback.
Able to communicate with all levels including junior members and senior management.
Is 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.

Full Time / Part Time

Full time

Worker Type

Employee

Job Exempt

Yes

Workplace Model

At Invesco, our workplace model supports our culture and meets the needs of our clients while providing flexibility our employees value. As a full‑time employee, compliance with the workplace policy means working with your direct manager to create a schedule where you will work in your designated office at least three days a week, with two days working outside an Invesco office.

Benefits