Principal Engineer 1 - BI & Analytics
No salary listed
Expert
Hyderabad, Telangana, India
HybridWork in the designated office at least four days per week, with one day outside an Invesco office.
Data & AnalyticsData Engineering
About the job
Requirements
- Minimum of 8 years of experience in a SQL Server database environment, including database design, data loading and unloading, performance tuning, and security best practices.
- Strong expertise in writing complex SQL queries using common table expressions, subqueries, joins, and temporary tables.
- Solid experience with ETL/ELT processes and tools such as Airbyte, dbt, or AWS Glue.
- Proficiency in AWS cloud services such as S3, IAM roles and 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 developing SSIS packages and using data flow task transformations.
- Strong knowledge of data modeling concepts and best practices.
- Ability to manage multiple tasks simultaneously and pay close attention to detail.
- Strong oral and written communication skills, including communicating with junior members and senior management.
- Ability to participate in team discussions and share feedback.
- Ability to manage competing priorities and work independently as well as collaboratively.
- Ability to work effectively with technical and business staff across geographic areas.
Responsibilities
- Design, develop, and maintain robust database solutions that deliver actionable insights to leadership and cross-functional teams.
- Build data models that support Business Intelligence and self-service reporting while 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 that 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 data 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 in data management.
- 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.
- Lead the creation, maintenance, and support of the data mart environment, including T-SQL tables, stored procedures, views, and functions.
- Ensure that processes and data imports function as designed and address issues in a timely and efficient manner.
- Set up and maintain ETL processes for the data mart using appropriate tools for the connection type and data source.
- Partner with counterparts in Business Intelligence and with business and technology teams to ensure consistent data services and deliverables.
Desired Qualifications
- Knowledge of Snowflake.
- Familiarity with BI tools such as Power BI.
About the company
Invesco provides investment management services to retail and institutional clients worldwide. It manages a broad mix of assets, including mutual funds, exchange-traded funds (ETFs), and private equity, and earns revenue mainly from management fees on assets under management. The company serves clients in more than 150 countries, offering diverse investment opportunities across public and private markets. Its product line relies on market performance, meaning returns and assets under management rise and fall with financial conditions. Invesco differentiates itself through its global footprint and range of investment vehicles, aiming to grow assets under management by attracting clients and offering access to a wide set of investment options. The company’s goal is to deliver value for clients by managing assets responsibly and efficiently while expanding its global presence and assets under management over time.
Company Size
501-1,000
Company Stage
IPO
Headquarters
Henley-on-Thames, United Kingdom
Founded
1935
Get referred to Invesco
See people who can refer or advise you
Simplify's Take
What believers are saying
- August 31, 2026 AUM hit $2.562 trillion after $27.6 billion August inflows.
- Q2 2026 record $45.1 billion inflows lifted adjusted operating margin to 37.5%.
- The new platform targets custom mandates, SMA growth, and hybrid implementation by year-end 2026.
What critics are saying
- Invesco Core Real Estate-USA carries a $2.2 billion redemption queue and 20% fee cuts.
- Fundamental equities lost $7.7 billion in Q2 2026, led by institutional liquidations.
- SEC's Sept. 11, 2026 default judgment against Invesco Alpha hurts compliance credibility.
What makes Invesco unique
- QQQ and ETFs drove $30.1 billion inflows in Q2 2026, anchoring Invesco's brand.
- Solutions & Custom Strategies unifies public, private, active, and passive products globally.
- China and India joint ventures plus Asia-Pacific leadership deepen local distribution and access.
Help us improve and share your feedback! Did you find this helpful?
Benefits
- Unlimited Paid Time Off
- Hybrid Work Options
- 401(k) Company Match
- Health Insurance
- Parental Leave
- Employee Stock Purchase Plan