Developer - London, United Kingdom - Janus Henderson Investors

Description

Why work for us?

A career at Janus Henderson is more than a job, it's about investing in a brighter future together.

Our Mission at Janus Henderson is to help clients define and achieve superior financial outcomes through differentiated insights, disciplined investments, and world-class service. We will do this by protecting and growing our core business, amplifying our strengths and diversifying where we have the right.

Our Values are key to driving our success, and are at the heart of everything we do:

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, we would love to hear from you

Your opportunity

You will be a developer in the Client Reporting Product Team within Distribution Technology. The Client Reporting Product team partners with Marketing, Reporting Operations and Data Management teams in Technology to build data integration solutions for the automation of a wide variety and high volume of reports.

This role requires a significant set of technical skills, including a deep knowledge of SQL database and multiple programming languages. The ideal candidate has strong software development skills and can 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.

You will not only need excellent problem-solving skills, but you should also be able to see the strategic impacts of any cross-team dependencies and escalate where necessary.

You will require strong teamwork skills.

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 designed and built in the cloud, so you would have experience in one or more cloud platforms.

• Understand cloud computing, 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
• 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
• Work within the team as directed to automate and 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 tool 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
• 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 Janus standards and procedures for data movement

What to expect when you join our firm

• Hybrid working and reasonable accommodations
• Generous Holiday policies
• Excellent Health and Wellbeing benefits including corporate membership to ClassPass
• Paid volunteer time to step away from your desk and into the community
• Support to grow through professional development courses, tuition/qualification reimbursement and more
• All-inclusive approach to Diversity, Equity and Inclusion
• Maternal/paternal leave benefits and family services
• Complimentary subscription to Headspace – the mindfulness app
• All employee events including networking opportunities and social activities
• Lunch allowance for use within our subsidized onsite canteen

Must have skills

• Working knowledge of Azure DevOps (Git, build and release pipelines), Python, databricks, and snowflake as a requirement. Nice to haves are: PowerBI, and Attunity Replicate
• Significant information technology and/or application development, database development and/or python scripting experience
• Must have experience with SQL Server (2014/16) and Oracle 11g
• Ability to write, test/debug, and tune complex queries
• Write stored procedures and stored functions
• Experience with architecture principles and design best practices
• Must have experience with data modeling in an Enterprise Data warehouse and data marts
• Autosys or comparable job scheduler (control-M or Tivoli)

Nice to have skills

• Azure Certifications: Optional, relevant Azure certifications, such as Azure Developer or Azure Solutions Architect, demonstrate expertise in Azure services.
• Monitoring and Logging: Familiarity with Azure monitoring and logging tools to track application performance and diagnose issues.
• Security Awareness: Awareness of common security vulnerabilities and best practices for securing web applications, especially when handling user data.
• UI Frameworks and Libraries: Knowledge of UI frameworks and libraries such as Bootstrap, Material Design, or similar tools to expedite UI development.
• Azure Active Directory B2C: Experience in configuring and integrating Azure Active Directory B2C for user identity and access management in web applications.
• NET Development: Strong proficiency in .NET development, including ASP.NET Core, ASP.NET MVC, C#, and related technologies for building web applications.
• Azure Services: Familiarity with various Azure services, including but not limited to Azure App Service, Azure Functions, Azure Storage, Azure SQL Database, and Azure Active Directory.
• RESTful APIs: Understanding of RESTful API design and consumption for communication with backend services and data retrieval.
• Authentication and Authorization: Experience implementing secure authentication and authorization mechanisms in web applications, including OAuth2, OpenID Connect, and JWT tokens.
• Database Skills: Proficiency in working with databases, particularly SQL databases like Microsoft SQL Server or Azure SQL Database or Snowflake
• Agile Methodologies: Experience with Agile development methodologies like Scrum or Kanban for project management and collaboration.