Senior BI Developer

Claire's ,
Birmingham, West Midlands
More Details

Overview

Job Description

Purpose of Role The Senior BI Developer will play a key role in the design and development of the organisation's new Data Warehouse ensuring that the business has access to all the data it needs to gain insight into business activities to drive operational and strategic decision making. Main Responsibilities * Detailed design of data warehousing solutions working closely with end users and system owners as required * Develop, test and deployment of high performing and stable BI solutions in line with approved, defined requirements within the required timescales and adhering to the agreed standards and procedures ensuring that quality products are produced * Design, develop and deploy data load processes for the big data platform and data marts using Hadoop, Hive and other data integration tools * Monitor the quality of data within the warehouse pro-actively seeking to identify issues and put in place suitable solutions before they impact the business * Ensure the quality of MI & BI products through the adherence of Change and Quality Management processes that include version control, documentation, peer review, and testing with documented plans, scenarios, scripts, and acceptance criteria along with evidencing and authorisation of results * Establish and ensure the continued use of standards and procedures for solution development and documentation * Carry out detailed testing and document the tests to an auditable level. Quality-assure the completed work for user acceptance, training and implementation Education and/or Certifications * A degree in a quantitative discipline such as mathematics, physics, computer science or engineering Essential Criteria : * Significant experience designing, developing and managing data warehousing solutions * Significant experience in dimensional modelling experience following Kimball Methodology * Demonstrable experience in the extraction, transformation and load of data into data warehouse solutions using SSIS or other similar tools * Development of big data solutions using Hadoop & Hive * Manipulation and analysis of large data sets (Billion plus records) to create business reports * Experience of troubleshooting data issues and identifying appropriate solutions Knowledge: * Conceptual understanding of data modelling, database design and query optimisation. * Understanding of cloud infrastructure & databases (Azure, AWS, Goolge) * Knowledge of Big Data technologies and data processing techniques Skills / Abilities: * Azure HDInsight / Hortonworks / Hadoop * Development of user defined functions using Java / Scala * Proficient in Python * Highly proficient in T-SQL / HiveQL * Great communication skills, both verbal and written * Excellent attention to detail

People also viewed