Contact us
Advertising Salary
£50,000 to £65,000

The opportunity

As an integral part of the multi-function Data Engineering Team provide data architecture, data design, and data modelling direction for Openwork’s data lake, dimensional model, reporting, and information systems.

The benefits:

  • Salary - £50,000 to £65,000
  • Bonus scheme - on target bonus 10%
  • Pension scheme - contribute up to 5% of your salary and Openwork will match you and put in an extra 5%
  • Critical illness cover
  • Income protection - 1x salary
  • Death in service - 4x salary
  • 25 days holiday + bank holidays, with the opportunity to buy up to an additional 10 days
  • A range of other flexible benefits to include private medical insurance, dental insurance and much more.
Key Accountabilities:
  • Act as the Product Owner for the data lakehouse, semantic layers / data marts, and reference data solutions.
  • Lead the Design and Modelling for data for Openwork data solutions.
  • Produce and own the Logical Data Model for Openwork
  • Produce and own the Kimball Symantec model using best practice techniques
  • Define mapping specifications for the data migration from legacy DWH to the new DWH
  • Produce and own the data mapping for the data warehouse reference data solution.
  • Define mapping specifications for incremental data loads from various source systems into the DWH
  • Drive enforcement of Architecture Principles within change, promoting re-use through adoption of the Openwork data model.
  • Provide technical direction for Data and Business Analysts on the Data Transformation rules for mapping specifications
  •  Support development and Test team(s) within the programme

What will you need to succeed?

  • Experience in a commercial environment producing Kimball data models.
  • Experience with Azure Data Technologies (Synapse, Data Lake, Notebooks).
  • Experience working an Agile environment.
  • Experience working as a Product Owner (desirable)
  • Financial Services industry experience (desirable)
  • Graduate in IT or Finance (desirable)
  • Minimum Maths AS-Level
  • Azure data technologies (Synapse, Data Lake, Notebooks).
  • Kimball Methodology
  • Azure DevOps
  • Erwin Data Modeller
  • Openwork sales and recruitment structures (desirable)
  • Knowledge of the product hierarchy (desirable)
Skills and Competencies:
  • Strong SQL querying abilities
  • Data modelling -conceptual, logical, and physical – (eg. eRwin Data Modeller)
  • Data Mapping
  • Ability to explain complex solutions simply
  • High level of Attention to detail
  • Structured and methodical approach
  • Ability to apply judgement to situations requiring balance between time and accuracy
  • Professional manner
  •  Good communication skills

Why us?

We're a dynamic, fast paced, and growing business with huge ambition. This is all made possible by the brilliant people who are part of The Openwork Partnership family. We're investing heavily in our colleagues, continuously striving to give them the platform to develop personally and professionally and reach their full potential.

We’re also very proud of our culture, as one of the Best 100 Large Companies to work for in 2022. The Openwork Partnership values, and respects individuality and we are committed to building an inclusive culture and environment which truly recognises and celebrates our colleague’s individual differences and identities – just like our financial advice, for us, it’s personal. We believe everyone can make a difference and your race, religion, disability, and gender will never be a barrier. At Openwork, we have a strong ethic of care for each other where you can balance a successful career with your commitments and interests outside of work. We believe that you will bring your best self to work if you are trusted to choose when, where and how you do it.

Other jobs like this

    Advertising Salary
    £120,000 - £140,000
    Advertising Salary
    £50,000 to £65,000
    Swindon / Remote
    Advertising Salary
    £18,000 to £27,000