Janus Henderson Investors Data Test Engineer in Denver, Colorado

Janus Henderson Global Investors is a leading independent global asset manager, dedicated to delivering the best outcomes for clients through a broad range of actively managed funds.

We provide our institutional, retail and high net-worth individuals with access to skilled investment professionals representing a broad range of asset classes including, equities, fixed income, multi asset and alternatives.

We are a team of independent thinkers who work tirelessly to help our clients achieve their goals – and we do it by fostering an energetic and collaborative culture that ensures our people love the place they work.

Headquartered in London, Janus Henderson is a truly global asset manager with a diverse geographic footprint, managing assets from 27 offices globally and employing more than 2,000 staff.

Overview of the Role

Devise and execute an effective data test strategy that promotes a quality data platform solution. Partner with various functions in understanding business need, helping devise testable data architectures, validating data implementations and creating scalable test solutions through automation.

Duties and Responsibilities

  • Works closely with data architects, data developers and other delivery team members to ensure overall quality of centralized data platform solution

  • Deeply understands enterprise data architecture, related data principles and impacts to downstream systems; participates in architecture activities ensuring testability and ability to address both technical and business requirements

  • Collaborates with other Data Test Engineers in helping define, evolve and promote enterprise data test strategy

  • Executes tests against database objects including tables, views, schema changes, stored procedures, ETL scripts and ad hoc SQL statements

  • Performs validations using complex SQL statements and other tools (e.g. Query Analyzer, Redgate, etc.)

  • Creates scalable test solutions through the identification, implementation and maintenance of test automation frameworks

  • Responsible for all functional and regression testing activities related to assigned scope

  • Provides testing estimates and meets project testing timelines

  • Collaborates with delivery team and/or business partners in troubleshooting root cause of issues

  • Reports bugs/errors discovered per standardized tools and processes

  • Promptly communicates discovered risk to delivery team and Quality Assurance manager

  • Looks for opportunities to improve test execution and delivery

  • Mentors less experienced members of the team

Other Functions

Assumes additional duties as assigned

Supervisory Responsibilities

None

Technical Skills and Qualifications

  • Expert knowledge of practices, procedures and principles of testing

  • Strong understanding of the software development lifecycle including basic agile principles

  • Experience with utilizing (or architecting) test automation frameworks

  • Deep understanding of relational databases

  • Expert knowledge of complex SQL, database validation and querying tools

  • Good understanding of data warehousing architectures (e.g. hub and spoke)

  • Good understanding of master data management concepts; experience with CADIS a plus

  • Experience with ETL tools such as Informatica and overall testing of ETL solutions

  • Strong communication and problem solving skills with the ability to work as a team

  • Ability to work closely and effectively with developers in an agile environment

  • High desire to understand how things work with a demonstrated ability to learn things quickly

  • Strong interpersonal skills

  • Excellent analytical and organizational skills

  • Excellent written and verbal communications skills

  • Ability to manage multiple assignments, priorities, and projects in a demanding environment

  • Experience testing asset management solutions and/or corporate services technology is a plus

  • 5+ years testing experience

  • 5+ years of developing and/or testing data solutions

  • Bachelor’s Degree or equivalent experience required

Ongoing competence in the role to be assessed by:

  • Annual Performance Appraisal

  • Completion of all assigned Compliance training

Working Environment/Physical Activities

  • PC usage up to 100% of the time

  • Office equipment such as telephone, fax and copier

  • Overtime, early morning availability and weekend hours may be required

Janus Henderson Investors (including its subsidiaries) will not maintain existing or sponsor new industry registrations or licenses where not supported by an employee’s job functions (as determined by Janus Henderson Investors at its sole discretion).

All applicants must be willing to comply with the provisions of Janus Henderson Investors' Investment Advisory Code of Ethics related to personal securities activities and other disclosure and certification requirements, including past political contributions and political activities. Applicants’ past political contributions or activity may impact applicants’ eligibility for this position. Janus Henderson Investors is an equal opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. All applications are subject to background checks.