Go to job search

Finance Systems Data Architect and Engineer

Janus Henderson, City of Westminster

Finance Systems Data Architect and Engineer

Salary not available. View on company website.

Janus Henderson, City of Westminster

  • Full time
  • Permanent
  • Onsite working

Posted today, 21 Dec | Get your application in now to be one of the first to apply.

Closing date: Closing date not specified

job Ref: cc316d20d14649628eceef0ebfd30be8

Full Job Description

  • Develop multi-year roadmaps aligned with business and architecture strategy and priorities
  • Develop secure and high-quality production code, and reviews and debugs code written by others
  • Serve as the function's go-to subject matter expert on Finance and HR reporting data
  • Define the strategic Data Architecture and standards including path from current state to target state
  • Creates conceptual, logical and physical data models including data flows
  • Advise on software and application patterns to deliver the future state
  • Able to provide requirements to data developers at a low level as foundation for them to build code
  • Able to perform data reconciliations at a row level to identify causes of data quality issues and advise data developers on fixes or co-ordinate with source system SMEs to resolve issues at source
  • Champions the firm's culture of diversity, equity, inclusion, and respect Participate in all phases of the agile systems development life cycle, including requirements analysis, design (including code design and code reviews), development, testing and deployment, picking up data development tasks within a 2-week sprint, providing work estimates for tasks to project management, and participating in agile ceremonies
  • Carry out other duties as assigned
    • 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

  • Formal training or certification on Architecture concepts and expert applied experience.
  • Five years of hands-on practical experience delivering system design, application development, testing, and operational stability
  • Six years of expertise in SQL and Python
  • Demonstrable experience with Finance and/ or HR master and transactional data
  • Ability to present and effectively communicate to Senior Leaders and Executives - must be able to synthesize technical recommendations, roadmaps, and dependencies into concise messages for leadership
  • 8 years cloud native experience, with Snowflake and Databricks
  • 8 years ELT experience, ideally with Informatica CDI and DBT
  • Experience with modern technology stacks, agile methodologies, and cloud computing
  • Experience of working with geographically dispersed development teams
  • Snowflake Data Engineers are required to have the following qualifications:
  • Minimum of 10 years of experience designing and implementing a full-scale data warehouse solution based on Snowflake.
  • A minimum of 10 years experience in developing production-ready data ingestion and processing pipelines using Java, Spark, Python.
  • Experience with complex data warehouse solutions on Teradata, Oracle, or DB2 platforms with 8 years of hands-on experience
  • Expertise and excellent proficiency with Snowflake internals and integration of Snowflake with other technologies for data processing and reporting.
  • A highly effective communicator, both orally and in writing
  • Problem-solving and architecting skills in cases of unclear requirements.
  • A minimum of 8 years of experience architecting large-scale data solutions, performing architectural assessments, examining architectural alternatives, and choosing the best solution in collaboration with both IT and business stakeholders.
  • Extensive experience with DBT, Informatica, and building data ingestion pipelines.
  • Expertise with Amazon Web Services, Microsoft Azure and Google Cloud.
    • Nice to have skills
  • 2 years experience with SAP Financials or SAP BW
  • 5 years experience with Power BI
  • 8 years experience with Informatica CDI
  • Experience with Databricks and Snowflake
  • Knowledge of machine learning and/ or artificial intelligence

    Janus Henderson Investors Finance Systems Data Architect and Engineer in London, United Kingdom
    • 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!,
  • Experience leading a product as a Product Owner or Product Manager
    • Potential for growth
  • Mentoring
  • Leadership development programs
  • Regular training
  • Career development services
  • Continuing education courses
    • You will be expected to understand the regulatory obligations of the firm, and abide by the regulated entity requirements and JHI policies applicable for your role. At Janus Henderson Investors we're committed to an inclusive and supportive environment. We believe diversity improves results and we welcome applications from all backgrounds. Don't worry if you don't think you tick every box, we still want to hear from you! We understand everyone has different commitments and while we can't accommodate every flexible working request we're happy to be asked about work flexibility and our hybrid working environment. If you need any reasonable accommodations during our recruitment process, please get in touch and let us know at recruiter@janushenderson.com. 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). All applicants must be willing to comply with the provisions of Janus Henderson 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 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.

Relevant jobs