Your new company
Your new role
To design and lead the implementation of and manage data flows and data management systems which will connect operational systems and collect, validate and present data for use in business insights and BI processes
What you'll need to succeed
- Assist in the ongoing systems migrations (ETL & testing).
- Knowledge of cloud data platform providers (AWS, GCP, Snowflake, Azure)
- Experience of designing and developing Data Warehouse, Marts, Sets.
- Experience of identifying and mitigating issues and risks associated with their development work
- Experience of data modelling and a thorough understanding of logical modelling concepts
- Experience with databases and analytics, including relational databases (e.g. SQL Server), Data Warehousing and business analytics tools
- Experience working with database, storage, collection and aggregation models, delta loading and external data (social media, websites, ONS Councils)
- Experience working with some or all the following: - SharePoint, SSRS, Power BI and deep knowledge of the underlying technology in order to develop data integration layers and associated systems to provide repositories of information
- Experience of working in an agile cross-functional delivery squad working with product owners, solution analysts, solution architects and test analysts is essential
- Experienced in designing, coordinating and implementing pilots, prototypes or proof of concepts
- Experienced working with statistical data visualisation tools and techniques is essential.
- Experience in the selection and implementation of technologies and partners to deliver resilient, scalable and futureproof data solutions
- Experience data profiling and systems analysis experience
- Extensive experience of using recognised standards and tools to design, code, test, correct and document complex programs and scripts from agreed specifications
- Experience of designing data models based on the HACT standard
- Solid understanding of data visualisation tools (Power BI)
- Broad understanding of BI information exploitation methods including ad-hoc queries, data mining techniques, data visualisation, real-time intelligence and data exploration.
- Identification and resolution of problems in databases, data processes, data products and services
- Analysis and reporting of test activities and results
Familiarity with industry recognised data modelling standards and their application.
- Understanding of Data Warehouse (DW) strategies, architecture and structure utilising SSIS, Schemas, Kimball Methodology
- Deep technical capability in designing, building and testing complex and large-scale data products
- Fully conversant with advanced concepts and principles of data modelling
- Capable of designing and producing complex and consistent data models across multiple subject areas
- Proficiency in writing advanced SQL queries, Stored Procedures, and expertise in Cloud ADF, Rest API data ingestion
- Good stakeholder management capability, engagement and communication skills.
- Able to effectively translate and accurately communicate across technical and non-technical teams
What you'll get in return
- Access to We Care contact a doctor
- Eye care vouchers
- Pension Scheme
- Healthcare cash plans
- Kitchen and Shower Facilities
- Free Flu vaccine
- Free parking
- Electric car scheme
- Annual leave 25 days increasing with each years service
- 3 days off between Christmas and New Year- office shut down
- Discounted gym membership
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 on 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