Vacancy for Data Engineer

Back to Search results

Location Birmingham
Contract Type Permanent - Employee
Working Hours per Week 40 hours
Remuneration £50,000 - £70,000 + Excellent benefits
Job Reference GR/10370

The Data Engineer will join our growing team of analytics experts.

The role will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams.

An experienced data pipeline builder and data modeler who enjoys optimizing data systems and building them from the ground up.

The role will support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.


Responsibilities will include:

Design and implement cloud based, enterprise level, Data Warehousing architecture that supports ‘Big data’, ETL processing and BI reporting 

Design and build the infrastructure required (ETL Framework) for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AZURE ‘big data’ technologies such as data pipelines, data factory and data bricks.

Design and implement multi-dimensional schemas within the data warehouse, using  schemas to support Analytics and BI reporting

Produce Data Architecture High Level Design and Detailed Design Documents to communicate your design with the Data Architect, the Data Team, and other stakeholders.

Work with the Data Architect to ensure standards are maintained for Master Data Management, Data Governance and GDPR

Working with the Information Security team keep our data secure across national boundaries through single OCS data platform in Azure.

Explore ways to enhance data quality and reliability.

Analyse and organize large, complex data sets that meet functional / non-functional business requirements.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Build analytics tools to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

Review data tools for analytics and data insight team members that assist them in building and optimizing our product into an innovative industry leader.

Work with data and analytics experts to strive for greater functionality in our data systems.


Experience required:


Must have a good standard of education to degree level OR demonstrate equivalent skills and ability

Working experience/Personal attributes

Advanced SQL knowledge and experience working with relational databases, as well as working familiarity with a variety of databases using structured as well as unstructured data sets.

Experience building and optimizing ‘big data’ data pipelines, architectures and data sets.

Proficient in applying data modelling approaches; normalization, star schemas, dimensional modelling, slowly changing dimensions.

Comprehensive knowledge of data query concepts; joins, grouping, pivots

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement

Strong analytic skills related to working with unstructured datasets.

Build processes supporting data transformation, data structures, metadata, dependency and workload management.

A successful history of manipulating, processing and extracting value from large disconnected datasets.

Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.

Strong project management and organizational skills.

Experience supporting and working with cross-functional teams in a dynamic environment

Experience in data modelling, data warehouse design, ETL frameworks

Advanced  SQL

Technical knowledge and experience of managing and maintaining data platform environments.

Experience of Microsoft Data Factory and Azure Data warehouse cloud services desirable.

Experience with Azure Data Bricks Streamer

Exposure to cloud data migrations highly advantageous

Exposure to one or more data visualisation platforms / BI reporting

Development experience in languages such as Python, R, Java, C++ advantageous

Experience of NoSql/Non-relational databases advantageous

Ability to think strategically and evaluate options in the short, medium and long term.

Ability to cope in a technically complex and fast-changing environment, and to respond calmly and rationally to changing aspirations in a deadline-driven situation.

Strong planning and organising skills including the ability to manage several work streams simultaneously.

Excellent communication skills with a capacity to present, discuss and explain issues coherently and logically both in writing and verbally.

Good influencing and persuasion skills with the ability to enthuse and inspire multidisciplinary teams and build successful relationships at all levels.

Clear decision-making ability with the facility to judge complex situations and assess when to escalate issues.

Ability to balance conflicting and changing demands through prioritisation and a pragmatic approach.

Good team player, self-motivated and able to work on own initiative.

Why join OCS Group UK Ltd?

From providing a first-class shopping experience at major retail and leisure establishments, to maintaining critical factory facilities for well-known industrial organisations, to supporting the patient journey at large hospitals, we provide the essential services that keep businesses and societies running day in and day out.

At OCS Group, we take a partnership approach. That means we start by listening carefully to each customer to understand their requirements, then tailor our services to meet their specific needs. We deliver more than 70 internationally accredited facilities management services – ranging from cleaning, security and catering to waste management – as standalone, bundled or fully integrated solutions.

OCS prides itself as a company that has family values.

We take CARE of you; We act SAFELY and responsibly; We are TRUSTWORTHY; We work as EXPERTS.

What will you get in return?

  • An enhanced pension scheme (above auto enrolment rates) - to save for the future
  • Life Assurance – to protect your family should the worst happen
  • 25 days holiday, plus 8 bank holidays on top
  • Option to purchase additional annual leave
  • Private Medical Insurance – to protect you
  • Access to 100s of high street discounts
  • Financial Wellbeing support - Access to low interest loans
  • Recognition scheme ‘OCS Stars’- monetary rewards given to top performers
  • Training and Development- apprenticeships, e-learning, English as a Second Language and our award nominated ‘Impact’ Programme
  • Long Service Awards
  • Cycle to work scheme- discounted bicycles
  • Access to our Employee Assistance Programme- 24-7 Health & Wellbeing Support
  • Successful candidates for this role, who meet the eligibility criteria, may have the opportunity to undertake a formal work-based training course under our commitment to personal and professional development through the Government’s apprenticeship scheme