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
Assumes additional duties as assigned
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.