BI Developer / Data Warehouse engineer

Recruiter
Talent International
Location
Birmingham
Posted
12 Oct 2018
Closes
18 Oct 2018
Contract Type
Full Time
Data Warehouse Developer Data Warehouse / DWH / BI / Business Intelligence / SQL / ETL / Data Mining / Data Models / Data Lake / Power BI Location: Birmingham Salary: Up to £45,000 + 15% Bonus, and other fantastic Benefits Data Warehouse / DWH / BI / Business Intelligence / SQL / ETL / Data Mining / Data Models / Data Lake / Power BI Would you like to work for an award-winning organisation, that really stands out from the crowd by their unique and innovative way of working, that also creates the best working environment for their employees? If so, please carry on reading. Due to continued expansion, and new Greenfield projects my client based in Birmingham are Seeking a motivated, Data Warehouse Developer to join their fantastic Data team. Responsibilities To design data modeling/analysis services used to mine enterprise system/applications for knowledge and information that enhance business processes. This individual is also responsible for building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation. Strategy & Planning Create data mining architectures, coding standards, statistical reporting, and data analysis methodologies. Devise, develop, and deploy required data queries in response to business user needs. In conjunction with data owners and department managers, develop data models and protocols for mining databases. Work with Data Architect in the development of data management policies and procedures Acquisition & Deployment Develop and maintain Extract Load and Transform (ELT) processes Create and maintain orchestration jobs to load data into the Clients data lake Build and maintain Data models (Dims and facts) Operational Management Work with business teams to develop and build an end to end suite of ELTs to populate the data lake. Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data mining applications with existing systems. Provide and apply quality assurance best practices for data mining/analysis services across the organization. Develop, implement, and maintain change control and testing processes for modifications to data models. Work with Data Architect to create company data dictionary, data definitions for new database file/table development and/or changes to existing ones. Develop routines for end users to facilitate best practices use of data mining tools. Collaborate with database administrators to ensure effective protection and integrity of data assets. Monitor data mining system details within the database, including stored procedures and execution time, and implement efficiency improvements. Respond to and resolve data mining performance issues. Manage and/or provide guidance to junior members of the team. Requirements 5 - 7yrs experience BI and Data Warehouse Amazon Cloud (must) Redshift Database (must) Postgres SQL (must) MySQL (must) Matillion ELT (desirable) Pentaho ELT (desirable) Microsoft Power BI (desirable) Python (desirable) If you feel you have the relevant skills to be considered for this Data Warehouse Developer opportunity and would like to know further information, please forward an up to date version of your CV and I will contact you back within 48 hours to discuss this role in more detail. Data Warehouse / DWH / BI / Business Intelligence / SQL / ETL / Data Mining / Data Models / Data Lake / Power BI Data Warehouse / DWH / BI / Business Intelligence / SQL / ETL / Data Mining / Data Models / Data Lake / Power BI Data Warehouse / DWH / BI / Business Intelligence / SQL / ETL / Data Mining / Data Models / Data Lake / Power BI