Prin. Eng. I, Eng Corp

As one of the world’s leading asset managers, Invesco is dedicated to helping investors worldwide achieve their financial objectives. 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, smart colleagues, and a global employer with a social conscience, come explore your potential at Invesco. Make a difference every day

**Job Description**:
Qualifications:

- Bachelor's or Master's degree in Computer Science, Computer Engineering, or equivalent field
- 5+ years of experience in data engineering and database management
- Expertise in SQL to explore and manipulate huge datasets and DBT for data transformation and pipeline development
- Experience with relational databases (e.g., PostgreSQL, MySQL, MS-SQL)
- Experience with data warehouse/data lake technologies (e.g., Snowflake, Redshift, Bigquery, Databricks)
- Strong knowledge in Snowflake architecture and concepts
- Strong working experience in Snowflake using warehouses, stored procedures, streams, snow pipes, tasks, stages, storage integration, ingestion frameworks and tools etc
- Ability to develop ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake SnowSQL
- Strong hands-on experience with requirements gathering analysis, coding, testing, implementation, maintenance, and review
- Extensive development experience using Python and other scripting languages (Perl, shell etc.) and OOPs concepts
- Experience in working with AWS, MS Azure, or other cloud providers
- Experience with AWS services such as Lambda or S3, AWS Certification
- Good hands-on experience on scheduling tools such as Airflow, Control M, Autosys scheduling tools
- Good hands-on experience with PL/SQL Oracle programming. (Writing sql queries, stored procedure, functions, triggers etc.)
- Possessing outstanding technical and analytical skills with strong business knowledge
- Experience in Agile methodologies (Kanban and SCRUM), communication, and interpersonal skills
- Experience with data visualization tools like Power BI, Tableau.
- Experience on power platform is a plus

**Responsibilities**:

- Develop and test scalable automated architectures that enable data extraction and transformation for predictive or prescriptive modeling
- Design and build data pipelines, architectures, and data structures that allow for the efficient flow of data from various sources into our data warehouses
- Develop and implement data models, data mapping, and visualization techniques to help stakeholders understand and analyze complex data sets
- Develop and maintain data dictionaries, data lineage, and data governance policies to improve our understanding of the data we work with
- Collaborate with other internal teams to identify key data needs and automate data processing and analysis wherever possible
- Stay up-to-date with emerging technologies, trends, and best practices in data engineering and continuously improve our data infrastructure and processes
- Write and maintain ETL (Extract, Transform, Load) scripts and workflows
- Create data visualizations, reports, and dashboards that provide insights to stakeholders

Full Time / Part Time

Full time

Worker Type

Employee

Job Exempt (Yes / No)

No

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
- R