Description
Data Analyst
We are IT Recruitment Specialists partnered with a prestigious Global Consultancy who require a Data Analyst for one of their Public sector Clients based in Crewe.
IR35 Status: N/A up until , from the role will be Inside
Location- Remote for now, once restrictions lifted will be Crewe
Job Spec-
Key Technical Skills: Gefeg, SparX
Requirements
Agile Scrum
4+ years' experience
Mapping bespoke schemas to product payloads
Master Data management/analysis
Code List management/analysis
Data flow diagrams
Primary Purpose
This will entail working alongside Data Architects, Business Analysts and Business SMEs.
Mapping bespoke schemas to product payloads
Master Data management/analysis
Code List management/analysis
Data flow diagrams
Key responsibilities
New Systems work will include:
Analysis to produce a detailed understanding of the current system landscape
Develop in depth understanding of proposed system landscape
Prepare data flows for current and proposed systems
Document Source-to-Target data attribute mappings including transformation rules
Transform/Consolidate data from various source systems using ETL tools and SQL
Ad Hoc tasks will include:
Create a single view of master data (the Golden record)
Produce data profiles, data dictionaries and data quality reports
Addressing data quality issues
Essential competencies
1-Communicating between the technical and the non-technical team(s)
2-Data analysis and profiling
3-Data development process
4-Data integration
5-Understands Meta data, reference data, transactional data and master data
Additional Information
Typically successful candidates will exhibit the following skills, experience and knowledge
Technical
Expert in developing solutions using at least one tool from each of the following group:
1.Database technologies - Oracle, SQL server, PostGresSQL
2.ETL tools - Microsoft SQL Server Integrated Services (SSIS), Informatica Power Centre, Pentaho Data Integration, programming language SQL/T-SQL scripts, procedures and functions.
3.Reporting tools - To develop dashboards Power BI, QlikView/Qlik Sense, Pentaho Reporting
4.Master/Reference Data Management tools - MultiVue, Microsoft Master Data Services
5.Cloud Environments - Amazon Web Services(AWS), Microsoft Azure
Proficient in:
.Database technologies-Oracle, SQL Server, PostGresSQL
.ETL tools-Microsoft SQL Server Integrated Services (SSIS), Informatica Power Centre, Pentaho Data Integration, programming language SQL/T-SQL scripts, procedures and functions
.One of the reporting tools-Microsoft Power BI, QlikView/Qlik Sense, Pentaho Reporting
.Master/Reference Data Management Tools-MultiVue, Microsoft Master Data Services
.Cloud Environment-Amazon Web Services (AWS), Microsoft Azure