Perform design, documentation, development, testing, installation and support of complex data ETL/ELT pipelines, using Azure Databricks and Snowflake
Experience in tools and data like MSCI, Barra, or other investment systems with Attribution, Analytics, and Risk
Five years of experience developing, maintaining and supporting ETL/ELT programs with various target/source types and transformation logic, technologies may include Informatica Power Center v10.x, Microsoft SQL Server SSIS, stored procedures, Azure Databricks
Provide testing support where necessary. Participate in the design and evolution of Dev Ops for Global Client Analytics.
Create associated scheduling logic for data pipelines using scheduling tool such as Autosys or Azure Databricks job scheduling framework
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.
Experience building data pipelines using Azure Databricks and integrating with Snowflake. Experienced using Python, Spark for ETL.
Experience using scheduling tools such as Autosys
Experience with Power BI reporting tool along with DAX formula
Must be familiar with Agile delivery methodology and have participated in the writing of user stories and all agile ceremonies.
Experience in Financial Services is a plus Competencies required In addition to putting clients first, acting like an owner, and succeeding as a team, the competencies for this role include:
Self-motivation; possessing a natural ability to take initiative and progress projects and initiatives with minimal support.
Strong written and verbal communication and reasoning skills.
Time management and planning; managing personal workload effectively, setting realistic and achievable targets, managing expectations and delivering to those targets. Compliance requirements At a minimum the role will require you to:
Place the interest of Janus Henderson’s Clients first, act in accordance with TCF (Treating Customers Fairly) principles
Understand and follow laws and regulations applicable for your role, seeking the help of your supervising manager or Compliance if additional guidance is required
Understand and abide by all Janus Henderson policies applicable to your role, and seek support/guidance of the policy owner guidance when required
You are ultimately accountable for your actions and responsible for seeking further information on any or all of the above as necessary.