Search by job, company or skills

  • Posted 16 hours ago
  • Be among the first 10 applicants
Early Applicant

Job Description

  • Design and optimise dimensional models for reporting and analytics, including mini dimensional models in SQL
  • Migrate data transformation steps from PowerBI to data bricks and roll out DBT for scalable workflows.
  • Rebuild and maintain core datasets to ensure accuracy and performance across systems.
  • Producing Conceptual, Logical and Physical Data Models and related artefacts to specified standards
  • Producing Entity Relationship Diagrams and specifying and documenting the
  • relationships between entities, specifying and documenting the data attributes for each entity
  • Agreeing entity and attribute definitions with the respective stakeholders
  • Simultaneously being part of several project teams in order to allow multiple projects to proceed at pace concurrently
  • Contributing to data modelling framework design discussions regarding items such as
  • the design and use of Reference Data
  • Investigating and providing estimates for data modelling work and, reporting progress to-date
  • Working with Business SME and Technical staff to identify the data sources to be used
  • to meet the business requirements
  • Data mapping: The identification, specification and documentation of data mappings
  • and the associated transformations in order to move data from the source systems,
  • through the data warehouse layers where appropriate and, to present the data to authorised end users
  • The clarification and documentation of business rules and data transformations with
  • technical colleagues and business users
  • Working with Database Administrators (DBA's) and information service designers to
  • ensure the physical implementation meets the functional and non-functional requirements

More Info

Job Type:
Industry:
Employment Type:

About Company

Job ID: 135898481