Principal Engineer I, BI & Analytics

Invesco Ltd

Hyderabad City Taluka

Hybrid

PKR 33,195,000 - 49,793,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive Compensation
Flexible, Hybrid Work
30 days Annual Leave + Holidays
Life Insurance
Retirement Planning
Medical Insurance for Employee and Fam

Job summary

Invesco Ltd is seeking a Principal Data Engineer to own end-to-end data flows in a MS SQL data mart. You will design, implement, and optimize data models, ETL/ELT pipelines, and complex SQL queries to deliver actionable insights for leadership.

Responsibilities include data quality, monitoring, and collaboration with BI analysts. Hybrid workplace, with a mix of office presence and remote work.

Qualifications

  • Minimum 8 years in a SQL Server database environment (design, loading, performance, security).
  • Strong SQL skills: CTEs, subqueries, joins, temp tables.
  • ETL/ELT experience with Airbyte, dbt or AWS Glue.
  • AWS services: S3, IAM, Lambda; data pipelines.
  • Experience with Airflow and/or Stonebranch UAC for workflows.
  • SSIS development and data flow transformations.

Responsibilities

  • Design, develop, and maintain robust database solutions for insights.
  • Build data models supporting BI and self-service reporting.
  • Develop and optimize ETL/ELT pipelines for diverse sources.
  • Write complex SQL queries and optimize performance.
  • Ensure data quality, availability, and documentation.

Skills

SQL Server
Data modeling
ETL/ELT
Airflow
Snowflake
Power BI
SSIS
AWS
T-SQL

Tools

Airbyte
dbt
AWS Glue

Job description

As one of the world’s leading independent global investment firms, Invesco is dedicated to rethinking possibilities for our clients. By delivering the combined power of our distinctive investment management capabilities, we provide a wide range of investment strategies and vehicles to our clients around the world. If you're looking for challenging work, intelligent colleagues, and exposure across a global footprint, come explore your potential at Invesco.

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.

The role will be responsible for leading the creation, maintenance, and support of the data mart environment, including T-SQL tables, stored procedures, views, and functions. The Principal Data Engineer will be responsible for ensuring all process and data imports are functioning as designed and any issues are addressed in a timely and efficient manner. In addition, they will work on setting up and maintaining ETL processes for the data mart utilizing the most appropriate tool for the type connection and data source.

All work is done in partnership with their counterparts in other functions within Business Intelligence to ensure consistency of the data services and deliverables that BI & Analytics provides, as well as in partnership with their Business and/or Technology counterparts.

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 ensure 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:
  • Is comfortable in a fast-paced, dynamic work environment

  • Can manage multiple tasks simultaneously, pays close attention to detail

  • Possesses exceptional oral and written communications skills

  • Feels comfortable participating in Team discussions and share 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 / No)

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.

Why Invesco

In Invesco, we act with integrity and do meaningful work to create impact for our stakeholders. We believe our culture is stronger when we all feel we belong, and we respect each other’s identities, lives, health, and well-being. We come together to create better solutions for our clients, our business and each other by building on different voices and perspectives. We nurture and encourage each other to ensure our meaningful growth, both personally and professionally.

We believe in diverse, inclusive, and supportive workplace where everyone feels equally valued, and this starts at the top with our senior leaders having diversity and inclusion goals. Our global focus on diversity and inclusion has grown exponentially and we encourage connection and community through our many employee‑led Business Resource Groups (BRGs).

What’s in it for you?

As an organization we support personal needs, diverse backgrounds and provide internal networks, as well as opportunities to get involved in the community and in the world.

Our benefit policy includes but not limited to:

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

In Invesco, we offer development opportunities that help you thrive as a lifelong learner in a constantly evolving business environment and ensure your constant growth. Our AI enabled learning platform delivers curated content based on your role and interest. We ensure our manager and leaders also have many opportunities to advance their skills and competencies that becomes pivotal in their continuous pursuit of performance excellence.

To know more about us

About Invesco: https://www.invesco.com/corporate/en/home.html

About our Culture: https://www.invesco.com/corporate/en/about-us/our-culture.html

About our D&I policy: https://www.invesco.com/corporate/en/our-commitments/diversity-and-inclusion.html

About our CR program: https://www.invesco.com/corporate/en/our-commitments/corporate-responsibility.html

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Prin. Solutions Architect I, Invest Tech
Prin. Solutions Architect I, Invest Tech

Invesco Ltd • Hyderabad City Taluka

On-site
PKR 33,195,000 - 47,026,000
Flexible, Hybrid Work
30 days annual leave
Life Insurance
+1
Eng I, Eng Run
Eng I, Eng Run

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 1,800,000 - 3,000,000
Hybrid Work
Life Insurance
Medical Insurance for Employee and Fam
+3
Adv. Data Steward II, Data Office
Adv. Data Steward II, Data Office

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 1,400,000 - 2,500,000
Flexible Hybrid Work
Annual Leave 30 days
Life Insurance
+7
Eng. I/II, Eng Run
Eng. I/II, Eng Run

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 1,800,000 - 2,400,000
Competitive compensation
Flexible, Hybrid work
30 days annual leave + public holidays
+9
Eng. II, Eng Run
Eng. II, Eng Run

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 80,000 - 1,200,000
Competitive Compensation
Flexible, Hybrid Work
Career Development Programs
+3
Senior Analyst, Client Analytics
Senior Analyst, Client Analytics

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 1,800,000 - 2,800,000
Flexible, Hybrid Work
Life Insurance
Medical Insurance for Employee and Fam
Prin. Eng. I, Invest Tech
Prin. Eng. I, Invest Tech

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 4,000,000 - 9,000,000
Competitive Compensation
Flexible, Hybrid Work
30 days Annual Leave + Public Holidays
+3
Adv Software Engineer II, Enterprise Practices
Adv Software Engineer II, Enterprise Practices

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 4,000,000 - 6,000,000
Competitive Compensation
Flexible, Hybrid Work
30 days’ Annual Leave + Public Publics
+6
Sr. Eng. II, Invest Tech
Sr. Eng. II, Invest Tech

Invesco Ltd • Hyderabad City Taluka

Hybrid
PKR 1,800,000 - 3,200,000
Competitive compensation
Hybrid work
30 days annual leave
+3
Sr. Eng. I, Invest Tech
Sr. Eng. I, Invest Tech

Invesco Ltd • Hyderabad City Taluka

On-site
PKR 1,800,000 - 3,000,000
Competitive compensation
Flexible, Hybrid Work
30 days annual leave + holidays
+3
Top locations