Description
Data Analyst
Whitehall Resources are currently looking for a Data Analyst.
Key Requirements:
- 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.
- Create a single view of master data (the Golden record).
- Produce data profiles, data dictionaries and data quality reports.
- Addressing data quality issues.
- 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 Skills:
- Agile Scrum
- Communicating between the technical and the non-technical team(s).
- Data analysis and profiling.
- Data development process.
- Data integration.
- Understands Meta data, reference data, transactional data and master data.
- 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.
- Reporting tools - To develop dashboards Power BI, QlikView/Qlik Sense, Pentaho Reporting.
- Master/Reference Data Management tools - MultiVue, Microsoft Master Data Services.
- Cloud Environments - Amazon Web Services(AWS), Microsoft Azure.
- Gefeg, SparX.
This role will be Inside of IR35 from April 2021.
All of our opportunities require that applicants are eligible to work in the specified country/location, unless otherwise stated in the job description.