Data Modeller

Role description

Our new Data Modeller will be designing databases to translate customer data into useable format. This can be using conceptual, logical, and physical models, designed to improve outputs and efficiency. Also using a consultancy approach when it comes to customer requirements, research, developing specifications and delivering solutions

We are an innovative data and technology consultancy, proudly awarded the coveted Megabuyte Best Enterprise Software Award, in recognition for our outstanding organic growth in recent years. We work with our customers to solve some of their toughest data challenges, and help them make better, faster, and more informed decisions.

We’re now looking to grow and build a team that are hungry for success. We’re creating a culture that is fun, supportive yet challenging, and we’re looking for talented like-minded people to join us on this journey. We’re also looking for people who are comfortable in challenging the norm so we can get truly diverse thinking when solving problems and not just senior management making decisions – we really believe in empowerment.

The Role

Our delivery portfolio of work is ever-changing, you can expect to work on a variety of projects across customers in the public sector and defence sector (e.g. Environment Agency, Ministry of Defence), to support business development activities, and to contribute to the development of new service offerings.

Key activities:                     

  • Database design/modelling as per customer requirements
  • Work with Solution Architects & Technical Leads to provide designs that are consistent based on existing frameworks and different technology products
  • Stakeholder management – working closely with internal and external stakeholders to ensure consistent & effective communications and throughout project lifecycle
  • Harmonising different data sets in preparation for it to be used by Data Warehouses
  • Providing technical services on projects including through-life system requirements, consultancy, developing specifications, delivering solutions and support

Responsibilities:

  • Data modelling (design, create and maintain conceptual, logical, and physical data models) and work in line with project scope, taking technical direction from Technical Lead and Project Manager
  • Define and govern data modelling standards, design standards, tools and best practices
  • Set standards for document naming, security, lifecycle & retention architecture and make recommendations for standardisation and proper data usage
  • Define metadata standards (and profiles) for datasets, including mapping from existing metadata
  • Define ETL pipelines (FME or similar) to ingest datasets into the models defined
  • Deliver technical consultancy services to clients including designs, solutions, reports, reviews, analysis, and research under the guidance of Senior Consultants & Technical Lead
  • Work in multi-disciplinary teams to resolve business issues and problems in a collaborative fashion
  • Work closely with internal and external stakeholders to ensure consistent & effective communications throughout the project lifecycle
  • Provide consultancy services to customer challenges around their data
  • Analysis of datasets to identify & quantify market trends
  • Mentor more junior team members when needed
  • Assisting with business development and pre-sales activities where needed

Skills and Experience

  • Highly experienced in the design, creation and complex querying of Relational Databases for Microsoft SQL Server, Oracle and PostGresQL. Some experience with My SQL and SQLLite would be advantageous
  • Experience in UML Modelling to support Solution and System Design and Data Modelling. Primarily using Sparx Enterprise Architect, also Erwin and IBM Rational Tools
  • Experience in system design and implementation of systems ranging from secure, accredited and information management systems
  • Experience in information management and exploitation with emphasis on the importance of metadata and controlled language to support effective exploitation
  • Good knowledge of the Microsoft Office Suite of tools, particularly Excel in support of data analysis
  • Languages:
    • Python and “R” in support of complex data analysis of large datasets
    • C++ in software development
    • XML/XLST for information exchange
    • JavaScript to support user interaction
    • Some experience of C# and Java would be advantageous

You will also have:

  • The ability to obtain SC clearance
  • A willingness to travel to various customer sites around the UK and our HQ or satellite offices

Reward:

  • Competitive Base salary reviewed quarterly throughout the year
  • Bonuses, driven by business performance (work as a team, win as a team?!)
  • Promotion in correlation with business growth – you grow as we grow
  • Learning and development support (training days, exam funding, and professional memberships)
  • Enhanced Family Friendly Policies (such as Maternity and Paternity leave)
  • Enhanced Employer Pension Contributions
  • Subsidised Monthly Gym Membership
  • Life Assurance 4 x your annual salary
  • BUPA Private Healthcare scheme
  • Employee Benefits Platform – Perkbox subscription
  • Birthday off (in addition to 25 days holiday)

Recruitment Process: ​

1.     A introductory call with our HR Team (30 mins)

2.     Meet with one of our Principal Consultants – Technical based interview (60 mins)

3.     Final interview with our Chief Technology Officer (30 mins)

Interested in this job opportunity? Email careers@envitia.com for more information