Janus Henderson Investors Data Developer in Denver, Colorado
We are a leading independent global asset manager, dedicated to delivering the best outcomes for our clients through a highly diversified range of actively-managed products. We are truly global, supporting our individual and institutional investors across a range of products, encompassing equities, fixed income, multi-asset and alternatives. Our high-energy and collaborative culture at Janus Henderson helps our client achieve their goals and ensures that our people love the place they work.
Our culture is the foundation for how we interact with clients and one another as part of our unique, people-focused work environment. We support a flexible hybrid working model that allows teams to build a strong and positive culture by inspiring innovation and increasing collaboration. Currently our hybrid working model allows employees to work 2 or more days in office and the remaining time remotely.
Employees and Managers will discuss and determine what schedule works best for them and the team, with additional flexibility available based on the role, business needs, and individual circumstances.
JHI Workplace Practices is subject to change as the future of work within our organization evolves.
The Global Technology department plays a crucial role in supporting the success of the business. We are responsible for developing and implementing state-of-the-art software and hardware maintenance to support our fund management, trading,
distribution and operational areas with secure, stable and resilient technology platforms.
Overview of the role
As a Data Developer, you will be working with Distribution Reporting teams and Data Management teams in Technology with a main focus on building data integration solutions for the automation of our Distribution Reporting. This role requires a significant set of technical skills, including a deep knowledge of SQL database and multiple programming languages. You will use your software development skills and ability to pick up new technologies and assist in all aspects of the team’s work such as development using data warehouse and master data vendor platform tools.
The distribution data space is in a transition period. Significant data assets are located in on-premise hardware and software, such as Oracle, Informatica, Autosys, and Microsoft SQL Server. Currently Janus Henderson is embarking on an effort to consolidate data stores from all of our global locations and provide an efficient and reliable set of distribution ready data for use in all reporting teams. This consolidation is being crafted and built in the cloud, so you will gain experience in one or more cloud platforms.
Duties and responsibilities
Use data to discover tasks that can be automated
Perform unit and integration tests, as well as support UAT testing
Provide estimates, work independently and meet deadlines
Manage the releases and the related builds in each environment
Perform development, testing, and support of data ETL/ELT programs (pipelines), using such tools as AWS Glue, Azure Data Factory, Informatica or similar ETL/ELT platforms, as well as knowledge of data warehousing, data mart, and data lake concepts and processes
Collaborate with the team to improve existing data designs and data models, including relational table structures, using Unix Shell Scripting, Oracle, SQL Server, Azure SQL Data Warehouse, or Amazon Redshift
Support and learn the associated scheduling logic for data pipelines using scheduling tools such as Autosys or Airflow
Read and translate logical data models and use ETL skills to load the physical layer, based on an understanding of timing of data loads, data transformation, and optimization of ETL load performance
Provide production support and test approaches for data management projects
Coordinate with infrastructure teams as required
Work on the integration of data pipeline metadata with Informatica Enterprise Data Catalog
Assist with the automation of data quality and testing checks of data pipeline code
Work within the agile delivery methodology, picking up data development tasks within a 2-week sprint, providing work estimates for tasks to project management, and participating in agile ceremonies
Following existing standard methodologies and procedures for data movement
Work closely with Janus Henderson Technology (business analysts and developers) and Janus Henderson business personnel on efforts of various scope
Carry out additional duties as assigned
Technical skills and qualifications
Knowledge of cloud computing
Working knowledge of Azure DevOps (Git, build and release pipelines), Python, databricks, and snowflake as a requirement. Familiarity with PowerBI, and Attunity Replicate are helpful
5 years+ experience in information technology and/or application development
3 years+ database development and python scripting experience
Experience with SQL Server (2014/16) and Oracle 11g required
Ability to write, test/debug, and tune complex queries
Able to write stored procedures and stored functions
Experience with architecture principles and design practices
Must have experience with data modeling in an Enterprise Data warehouse and data marts
Autosys or comparable job scheduler (control-M or Tivoli)
Understanding about Data Lakes, Data Warehouses and Data Marts
Have in-depth knowledge of at least one high-level programming language
Be able to apply a basic understanding of cloud-native applications to write code
Understand of the use of containers in the development process
In addition to putting clients first, acting like an owner, and succeeding as a team, the competencies for this role include:
A good teammate while taking the collegiate approach to work circulating important information and contributing to team discussion
Excellent problem solving skills and analysis skills. Able to understand complicated issues, distill them into useful components and identify practical / pragmatic solutions
Self-motivated with an enthusiastic approach who is a completer-finisher able to work on own initiative with a focus on ownership to resolution.
Ability to communicate, present, influence, reason and demonstrate the ability to articulate information technology concepts to non-technology personnel in a clear and compelling manner
Ability to deliver on full workloads and exceed high expectations while remaining focused and organised in a fast-paced environment
The base salary range for this position is $90,000 - $100,000. This range is estimated for this role. Actual pay may be different.
Annual Bonus Opportunity: Position is eligible to receive an annual discretionary bonus award from the profit pool. The profit pool is funded based on Company profits. Individual bonuses are determined based on Company, department, team and individual performance.
Benefits: Janus Henderson is committed to offering a comprehensive total rewards package to eligible employees that includes; competitive compensation, pension/retirement plans, and various health, wellbeing and lifestyle benefits. To learn more about our offerings please visit the Why Join Us section on the career page here (https://www.janushenderson.com/careers/) .
Janus Henderson (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 at its sole discretion).