MI Developer

TN United Kingdom; Manchester; On-site; GBP 40,000 - 70,000; Full time

Job summary

An established industry player is seeking a skilled Data Management Specialist to enhance operational performance through effective data governance and management. In this pivotal role, you will collaborate with senior leadership to develop and maintain a robust data warehouse, ensuring high-quality data processing and compliance with regulatory standards. Your expertise in SAS, data modelling, and ETL processes will be crucial as you mentor junior team members and drive continuous improvement initiatives. Join a dynamic team where your analytical skills will directly impact strategic business decisions and foster a culture of data excellence.

Qualifications

• Experience in a Data Warehouse or Business Intelligence role.
• Proficient in coding with SAS and SAS macros.

Responsibilities

• Support the Head of MI Development in building and improving the MISL data warehouse.
• Model and transform data from new sources to support brand growth.

Skills

SAS

Data Warehousing

ETL Concepts

Data Modelling

Excel

Data Quality Management

Problem Solving

Data Analysis

Education

Bachelor's Degree in Data Science or related field

Tools

SAS Viya

SAS DI Studio

SAS Visual Analytics

SQL Server

Apache Airflow

MS DevOps

Job description

Role Purpose:

Working with the Head of MI Development to deliver high-quality data management across Markerstudy. Responsible for providing meaningful management information data to support improved financial and operational performance, managing technical solutions, and BAU support.

Act as a mentor to junior team members, utilizing advanced system knowledge to develop the team, and ensure adherence to FSA, TCF, GDPR regulations, including mandatory e-learning.

Responsibilities:

1. Support the Head of MI Development in building, maintaining, and improving the MISL data warehouse.
2. Model and transform data from new sources to support the growth of the Markerstudy brand, using data modelling techniques to normalise and integrate data sources for business benefit.
3. Proactively develop ideas and relationships to support departmental data initiatives and inform strategic business decisions.
4. Assist with migration to SAS Viya and leverage new technologies to enhance ETL processes.
5. Review and improve data processing methods for efficiency and performance.
6. Advocate for data governance activities, policies, and procedures.
7. Drive continuous improvement in data quality standards.
8. Resolve data issues by identifying root causes and implementing sustainable solutions.
9. Prioritize data risks and report accordingly.
10. Ensure daily data processing is completed on time with no failures.
11. Possess previous experience in a DW or BI role.
12. Have essential experience coding in SAS and SAS macros, SAS DI Studio, and Enterprise Guide.
13. Be experienced in data modelling, ETL concepts, data warehousing, and data quality management.
14. Possess advanced Excel skills.
15. Demonstrate proactive problem-solving, detailed data analysis, and presentation skills.
16. Communicate technical information clearly to non-technical stakeholders.
17. Operate effectively in a fast-changing environment, tackling issues proactively.
18. Be confident in judgment and decision-making, viewing challenges as opportunities for growth.
19. Have experience with SAS Viya, SAS Visual Analytics, SQL Server, Apache Airflow, and MS DevOps for workflows and CI/CD pipelines.