Data Architect/Modeller

Standard Life

Greater London

On-site

GBP 48,000 - 80,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Standard Life is seeking a Data Architect/Modeller to join the IT Transformation team within Retirement Solutions and Asset Management. You will deliver the technology strategy for Asset Management through a major transformation and support a mature function with a strong governance framework.

You will design data platforms, data models and semantic structures, collaborating with multiple disciplines to deliver scalable, compliant data solutions using AWS Snowflake and modern analytics tools.

Qualifications

  • Experience in Financial Services, and specifically within Asset Management
  • Excellent working knowledge of standard data modelling tools (e.g. Erwin)
  • Experience with datasets relating to investment, asset data, including derivatives
  • Good stakeholder management and engagement skills
  • Knowledge of Agile methodologies and tooling to support agile delivery of projects (e.g. Jira/Confluence)
  • Understanding of Data Warehouse and/or Data Lake and/or Data Lakehouse
  • Experience with multiple data storage types and technologies in data warehouse and data lake solutions and how to model data for efficient usage of them. Examples include relational DBMS (Postgress, Oracle ), Columnar DBs (E.g. Amazon Redshift, Snowflake), cloud object storage (E.g. Amazon S3)
  • Understanding of ETL/ELT solutions tooling
  • Understanding of analytics and reporting tools (Power BI, Tableau, Quicksight) & APIs
  • Demonstrable expertise in data modelling in large IT estates and integration of Data Governance tooling
  • Experience with Agile, CI/CD, DevOps, Test Automation
  • Excellent communication, influencing and facilitation skills
  • Assertiveness in dealing with people at all levels
  • Issue management and pragmatic direction
  • Resilience and adaptability

Responsibilities

  • Designing, building and reverse engineering data models and metadata systems
  • Help delivery teams interpret business needs into scalable data models
  • Provide oversight to architects and engineers on data models and solutions
  • Support agile delivery with clear data model communications
  • Balance master data management and reporting data marts needs
  • Design data platforms using AWS S3/lambda and Snowflake
  • Create semantic models in Snowflake for AI or Power BI use cases
  • Engage stakeholders and lead multidisciplinary discussions
  • Ensure data models align with end-user needs and governance policies
  • Participate in architectural governance and data dictionaries management

Skills

Data modelling
Stakeholder management
Agile delivery
Communication
Problem solving
Cross-functional teams

Education

Degree in Computer Science/Engineering
Professional body membership (desirable)

Tools

Erwin
Jira
Confluence
AWS
Snowflake
Power BI
Tableau
Quicksight
Python
R
Amazon Redshift

Job description

Job Description

Job Type: 12 month FTC

Closing Date: 25th November

Location: London or Edinburgh

Salary and benefits: Up to £80,000 dependant on experience, discretionary bonus, private medical cover, 38 days annual leave, up to 12% employer pension contribution, 12x salary life assurance, career breaks, income protection, 3x volunteering days and much more!

Flexible working: All roles are open to part-time, job-share and other types of flexibility. We will discuss what is important to you and balancing this with business requirements during the recruitment process. You can read more about flexible working here.

Who are we?

We’re Standard Life, a retirement specialist focused entirely on retirement savings and income. We champion the belief that everyone’s journey to and through retirement can be better, and for more than 200 years, we’ve been helping our customers plan and prepare for their financial futures.

Life today is increasingly complicated, uncertain and unpredictable. People move through different careers, face unexpected moments and navigate important choices. We offer our colleagues flexibility, trust and benefits that work for whatever life brings. In return we expect curiosity, connection, accountability and high standards. We make room for what matters - so you can bring your best, every day.

The Role

We have an incredible opportunity to join us here at Standard Life as a Data Architect/Modeller in our IT Transformation team within the Retirement Solutions and Asset Management function.

Accountable for the delivery of Asset Management's technology strategy through a significant period of transformation and enabling a suitable support model for a mature Asset Management function which is core to the success of the wider Standard Life Group.

Key responsibilities

  • Designing, building and reverse engineering data models and metadata systems
  • Help delivery teams to interpret business needs and transpose these into scalable data models
  • Provide oversight and advice to other architects and engineers within RS&AM who are undertaking the design and build of data models and technology solutions
  • Support engineering teams by communicating your data models in order for efficient delivery within an agile framework
  • Understanding and communication of different types of data models for different purposes to support the delivery of data solutions ranging from master data management systems to reporting data marts
  • Knowledge of how best to design data platforms to the strengths of market leading technologies such as AWS S3/lambda and Snowflake
  • Design data platforms which cater for different business areas, drawing links between problems to reach common solutions.
  • Design of semantic models in Snowflake for AI use cases or for use in Power BI solutions
  • Effective communication with a variety of stakeholders, supporting and hosting discussions within a multidisciplinary team, with potentially difficult dynamics.
  • Demonstrate awareness that data needs to be aligned to the needs of the end user, and production of logical and physical models which align to specific end user needs.
  • Undertaking data profiling and source system analysis, and present clear insights to colleagues to support the end use of the data.
  • Support for and understanding of what data governance is required and where, and taking an active role for the assurance of data solutions with recommendations to ensure compliance.
  • Active participation in architectural governance forums and working groups and ability to support multiple projects simultaneously through design authorities
  • Supporting the creation and on-going management of data dictionaries (business/technical)
  • Providing input and enforcement of the information standards policy. Highlighting deficiencies and improving upon where required
  • Promoting the availability of data from corporate systems over manual curation. Record and catalogue where manual tasks exist and opportunities to automate are available
  • Collaborating with delivery teams, Data Architects and Data Governance to effectively prioritise your activities

What we're looking for

Essential

  • Experience of Financial Services, and specifically within Asset Management
  • Excellent working knowledge of standard data modelling tools (e.g. Erwin)
  • Experience with datasets relating to investment, asset data, including derivatives
  • Good stakeholder management and engagement skills
  • Knowledge of Agile methodologies and tooling to support agile delivery of projects (e.g. Jira/Confluence)
  • Understanding of Data Warehouse and/or Data Lake and/or Data Lakehouse
  • Experience with multiple data storage types and technologies in data warehouse and data lake solutions and how to model data for efficient usage of them. Examples include relational DBMS (e.g. Postgress, Oracle ), Columnar DBs (E.g. Amazon Redshift, Snowflake), cloud object storage (E.g. Amazon S3)
  • Understanding of architecture and design concepts for ETL/ELT solutions utilising a range of tooling
  • Understanding of architecture and design concepts for data exploitation solutions and technologies includes Analytics (E.g. R & Python), Reporting (E.g. Quicksight, Tableau, Qlik, Power BI) & APIs
  • Demonstrable expertise in the areas of data modelling in large complex IT estates, implementation of multiple data architectures and integration of Data Management/Governance tooling
  • Experience in modern ways of working (examples include Agile, CI/CD, DevOps, Test Automation)
  • Excellent communication, influencing and facilitation skills, in particular for problem solving and troubleshooting activities
  • Assertiveness in dealing with people at all levels within and outside of the delivery organisation
  • Issue management, prioritisation and ability to provide pragmatic direction which is consistent with clients' longer-term strategy
  • Able to demonstrate resilience, flexibility and adapt to changing schedules and priorities

Desirable

  • Membership of a professional body
  • Degree in Computer Science, Technology or Engineering

Personal Attributes

  • Customer focused with an attitude to deliver excellent customer outcomes through technical expertise
  • Problem solving, analytics and resolution skills
  • Strong verbal and written communication skills
  • Demonstrated ability to communicate effectively across teams
  • Ability to operate in cross-functional and multidisciplinary teams
  • Ability to learn new technologies. Continuously strives to learn and make time for self-development.

We want to hire the whole version of you.

We are committed to ensuring that everyone feels accepted and welcome applicants from all backgrounds. If your experience looks different from what we’ve advertised and you believe that you can bring value to the role, we’d love to hear from you.

If you require any adjustments to the recruitment process, please let us know so we can help you to be at your best.

Find out more about working at Standard Life

  • Guide for Candidates: standardlifeplc.pagetiger.com/guideforcandidates
  • Find or get answers from our colleagues: www.standardlifeplc.com/careers/talk-to-us
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Fa Enor Saasfaprod1 • City of Edinburgh

Hybrid
GBP 35,000 - 45,000
Data Governance Practice Lead
Data Governance Practice Lead

Standard Life • Greater London

Hybrid
GBP 72,000 - 88,000
Private medical cover
38 days annual leave
Employer pension 12%
+4
Data Architect
Data Architect

Affinity Water • Hatfield

On-site
GBP 70,000 - 110,000
Annual leave 26-30 days (increasing)
Bonus scheme
Wellbeing centre
+4
RS&AM Reporting Analyst
RS&AM Reporting Analyst

Fa Enor Saasfaprod1 • City of Edinburgh

Hybrid
GBP 36,000 - 44,000
private medical cover
38 days annual leave
excellent pension
+5
Data Engineer
Data Engineer

Standard Life plc • Birmingham

Hybrid
GBP 35,000 - 45,000
Bonus
Private medical cover
38 days annual leave
+5
Data Engineer
Data Engineer

Standard Life plc • City of Edinburgh

Hybrid
GBP 35,000 - 45,000
Bonus
Private medical cover
38 days annual leave
+5
Senior Information Architect-London
Senior Information Architect-London

Northern Trust Corporation • Greater London

On-site
GBP 90,000 - 130,000
Senior Information Architect-London
Senior Information Architect-London

Northern Trust Corp • Greater London

On-site
GBP 90,000 - 130,000
Data Modeler
Data Modeler

Experis (Austria) • Greater London

On-site
GBP 60,000 - 80,000
Comprehensive healthcare
Pension
Life assurance
+2
Technology Solutions Lead - B2B
Technology Solutions Lead - B2B

Standard Life plc • Greater London

Hybrid
GBP 75,000 - 85,000
Private medical cover
38 days annual leave
Excellent pension
+4