Data Engineer
Job Description
Janus Henderson is seeking a Data Engineer to join its Denver technology team on a hybrid schedule. The role focuses on designing, building, testing, deploying and supporting ETL and ELT workflows that integrate internal systems with external data vendors, while scheduling jobs to meet daily SLAs for data warehouses and data lakes.
Responsibilities
- Design, development, testing, installation and support of complex data extract transformations, ETL, and ELT programs, using PL/SQL, Informatica Power Center 10.x and earlier models.
- Develop integrations between internal systems, as well as external data vendors using RDMS databases, flat files and cloud storage.
- Develop job schedules using Autosys to meet daily SLAs for the enterprise data warehouse and appropriate technology applications, using key design and development concepts for Data Lakes, Data Warehouses and Data Marts.
- Implement ETL / ELT pipelines within and outside of the data warehouse using SQL.
- Perform unit and integration tests and support UAT testing.
- Remote work permitted 2 days a week.
Requirements
- Bachelor’s degree in Information Systems, Computer Science, Electronics Engineering, or a related field.
- 7 years of progressively responsible experience with PL/SQL, Informatica Power Center 10.x and earlier models.
Technologies
- PL/SQL
- Informatica Power Center 10.x and earlier models
- Autosys
- SQL
Compensation
Salary: USD 169,062 per year
Location
Denver, CO (hybrid)
Division
Technology Delivery
Benefits
- Annual discretionary bonus opportunity from the profit pool.
- Comprehensive total rewards package including competitive compensation, pension/retirement plans, and various health, wellbeing and lifestyle benefits.
Why work for us
- A career at Janus Henderson is more than a job; it is about investing in a brighter future together.
- Our mission is to help clients define and achieve superior financial outcomes through differentiated insights, disciplined investments, and world-class service.
- Our values: Clients Come First Always, Execution Supersedes Intention, Together We Win, Diversity Improves Results, Truth Builds Trust.
- If our mission, values, and purpose align with your own, consider applying.
Nearest Major Market
Denver