Business Insight Data Engineer

Job Description

We have a vacancy for a Data Engineer to 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.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.The ideal candidate will be an experienced data pipeline builder and data modeler who enjoys optimizing data systems and building them from the ground up. You will be self-directed and comfortable supporting the data needs of multiple teams, systems and products.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.

Qualifications and Experience required:

• 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.
• Experience with 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
• Technical knowledge and experience of managing and maintaining data platform environments.
• Experience with Azure Data Bricks Streamer
• Exposure to one or more data visualisation platforms / BI reporting

What will you get in returnAn enhanced pension scheme (above auto enrolment rates) - to save for the futureLife Assurance - to protect your family should the worst happen25 days holiday, plus 8 bank holidays on topOption to purchase additional annual leavePrivate Medical Insurance - to protect youAccess to 100s of high street discountsFinancial Wellbeing support - Access to low interest loansRecognition scheme OCS Stars- monetary rewards given to top performersTraining and Development- apprenticeships, e-learning, English as a Second Language and our award nominated Impact ProgrammeLong Service AwardsCycle to work scheme- discounted bicyclesAccess to our Employee Assistance Programme- 24-7 Health & Wellbeing SupportSuccessful 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 Governments apprenticeship schemeWhy join OCS Group UK LtdOCS prides itself as a company with strong family values and we are passionate about hiring people who demonstrate the s