Data Engineer - Data Modelling

Data Engineer - Data ModellingSector: Automotive / Financial Services
Programme: NextGen DevOps
Rate: £470 per day
Location: UK Remote
IR35 status: Inside IR35

Your new company

You'll be supporting a major transformation programme within a complex automotive and financial services environment.The programme will deliver both Operations and Development services and support several significant transformation initiatives, including mainframe modernisation, integration of financial services platforms with SaaS products, and transformation of the wider data landscape.

Your new role

As a Data Engineer / Data Modelling Specialist, you'll work closely with business and technical stakeholders to understand existing processes and data requirements and translate these into effective enterprise data solutions.A key focus will be designing and maintaining conceptual, logical and physical data models, alongside database schemas and data structures that support scalable, reliable enterprise solutions.You'll also contribute to data integration, legacy modernisation and database optimisation while working alongside architecture, engineering and development teams across the wider transformation programme.

Key responsibilities

• Work with business and technical stakeholders to understand business processes and data requirements.
• Translate business requirements into enterprise data solutions and database designs.
• Design and maintain conceptual, logical and physical data models.
• Design and develop enterprise database schemas and data structures.
• Build and maintain enterprise data solutions and integrations.
• Optimise databases and data solutions for performance, scalability and reliability.
• Support the transformation and modernisation of legacy data environments.
• Contribute to data integration between enterprise applications, SaaS platforms and other systems.
• Maintain appropriate standards across data quality, governance and performance.
• Work alongside architecture, engineering and development teams across the wider programme.

What you'll need to succeedEssential skills and experience
You'll need strong commercial experience across:

• Enterprise data modelling and database design
• Conceptual, logical and physical data modelling
• Database schema design and development
• Understanding complex business processes and translating requirements into data models and technical solutions
• SQL
• Relational database technologies, such as:
  • PostgreSQL
  • DB2
  • SQL Server
  • Oracle
• Building and maintaining enterprise data solutions
• Data integration and transformation
• Database performance and optimisation
• Data quality and governance
• Working directly with business stakeholders to gather and translate data requirements

Desirable skills and experienceAdditional experience across the following would be advantageous:
AWS and cloud data

• AWS Aurora PostgreSQL
• AWS Database Migration Service (DMS)
• Snowflake
• Azure
• Google Cloud Platform (GCP)

Data integration and engineering

• Informatica
• Talend
• Apache Airflow
• Python for data processing and automation
• Data warehouse design and optimisation

APIs and event-driven architecture

• REST APIs
• GraphQL
• Apache Kafka
• Event-driven architectures

DevOps / infrastructure

• Terraform
• Docker
• Kubernetes

Experience working within regulated or complex enterprise environments, including Financial Services, Government, Healthcare or Logistics, would also be beneficial.Experience supporting legacy modernisation or large-scale data transformation programmes would be particularly relevant.

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk