Data Modeller

  • Sector: ConSol UK Software Development
  • Contact: Christian Dy
  • Contact Email: christian.dy@consolpartners.com
  • Start Date: ASAP
  • Client: ConSol Partners
  • Location: London
  • Salary: £55000 - £60000.00 per annum
  • Expiry Date: 22 August 2022
  • Job Ref: BBBH400684_1660576438
Data Modeller
You will join a small team of fellow data design professionals working collaboratively within the larger Business Intelligence and Analytics department to enable and drive the adoption of data-driven decision-making across the organisation.
You will have extensive experience of data modelling at all phases from context, through conceptual models to logical models and will be a skilled user of an advanced modelling tool such as erwin Data Modeler, ER/Studio or Sparx Enterprise Architect.
Your primary focus will be on delivering logical models for star schemas underlying the delivery of actionable operational, tactical,and strategic insights through Power BI dashboards drawing on a data lake pooling information from a range of business systems.
You will support these models with artefacts such as business glossary and data dictionary entries.
Our clients business systems are continually evolving and expanding to meet the changing challenges of the Housing industry and the team has an active role in directing data structure changes and evaluating and validating the suitability of proposed solutions.
These activities call for individuals to have the ability to complement their relation and dimensional data modelling capabilities with excellent communication and stakeholder management skills and with an inherent desire to probe behind measures of performance to expose the determining factors that drive it.
Main responsibilities:
- Working with business to understand the factors influencing delivery performance and efficiency
- Creating conceptual, logical, and dimensional models and the supporting intellectual property
- Supporting Information Analysts in exposing actionable insights
- Supporting Data Assurance Analysts with business rules and metadata
- Promoting data literacy and utilisation across the organisation
- Working with industry partner organisations on standards and other collaborative initiatives
Desirable Skills:
- Extensive experience of tools such as erwin Data Modeller or ER/Studio (Essential)
- Knowledge and understanding of advanced dimensional and relational modelling best practices
- Good understanding of broader data governance and management frameworks and practice
- Experience in SQL databases and database querying languages preferred
- Excellent communication skills, both written and verbal
- Appreciation of the fundamental business value of data and information
- The ability to present data concepts in business terms
- Business analysis skills and experience
- Stakeholder management skills and experience