Principal Engineer I, BI & Analytics

About Invesco 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. 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  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.

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