The role is primarily project based delivering artefacts defined by Data Architecture Team and Programmes and Projects for new systems, or building new/improved data flows for reporting and analysis in existing systems. This will entail working alongside Data Architects, Business Analysts and Business SMEs. Some assignments however will require independent work.
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
Data development process
Integrates and separates data feeds in order to map, produce, transform and test new data products.PractitionerDesigns, builds and tests data products that are complex or large scale. Builds teams to complete data integration services.
Has a demonstrable understanding of how to process, consolidate and expose and link data from various systems Practitioner Delivers solutions in accordance with agreed Data Architecture Framework.
Understands Meta data, reference data, transactional data and master dataAppropriately presents and differentiates Meta data, reference data, transactional data and master data.WorkingAble to identify and process meta data, reference data, transactional data and master data from the systems landscape using tools like MultiVue, Microsoft Master Data Services
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 inDatabase technologiesOracle, SQL Server, PostGresSQL
ETL toolsMicrosoft SQL Server Integrated Services (SSIS), Informatica Power Centre, Pentaho Data Integration, programming language SQL/T-SQL scripts, procedures and functions
One of the reporting toolsMicrosoft Power BI, QlikView / Qlik Sense, Pentaho Reporting
Master / Reference Data Management ToolsMultiVue, Microsoft Master Data Services
Cloud EnvironmentAmazon Web Services (AWS), Microsoft Azure
People Source Consulting Ltd is acting as an Employment Business in relation to this vacancy.
People Source specialise in technology recruitment across niche markets including Information Technology, Digital TV, Digital Marketing, Project and Programme Management, SAP, Digital and Consumer Electronics, Air Traffic Management, Management Consultancy, Business Intelligence, Manufacturing, Telecoms, Public Sector, Healthcare, Finance and Oil & Gas