About the role
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.
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. 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. Competitive Compensation Flexible, Hybrid Work 30 days Annual Leave + Holidays Life Insurance Retirement Planning Medical Insurance for Employee and Fam