BI and Data Developer

Information Technology Birmingham, United Kingdom Birmingham, United Kingdom


Description

Position at Connect Distribution Services Limited

Here at CDSL, our aim is to be the first choice for home appliance after sales service, spare parts and accessories.

With over fifty years of experience, we are the largest independent home appliance and spare parts distribution organisation within the UK working with a number of household brands including Whirlpool, Hotpoint, Hoover and Bosch to name a few!

We have an exciting opportunity for a BI and Data Developer to join our IT Department. To support the Head of Infrastructure, maintaining and developing our BI and Database systems - SQL Server and Dynamics AX. Designing deploying and maintaining the data and reporting systems, ensuring the timely delivery of data into the BI Analyst as well as continuous tuning and improvement.  

The role will involve:

  • Monitoring and maintaining existing BI dashboards and extracts
  • Monitoring and maintaining SQL/MySQL database servers and performance
  • Develop new Oracle BI and MS SSRS reports in response to demand from the business
  • Help in the development of Dynamics AX Data Warehouse
  • Advise and plan for platform specific upgrades to support business requirements
  • Providing technical leadership into the development and operation across all BI and Data services
  • Taking responsibility for the delivery of BI/Data into a significant business stream
  • Working with tools to design, develop, unit test, implement and maintain BI solutions
  • Writing and tuning SQL queries that combine data of multiple formats across multiple databases/servers
  • Ensure delivery of data to the BI Analyst team
  • Contributing to a Data/BI strategy for the business that is forward thinking and cloud focused
As a BI and Data Developer it is important you have:
  • Certified in MS SSRS/SSIS/SSAS and certified in SQL Server 2014 databases (or greater)
  • 3 years + experience in supporting both Microsoft SSRS/SSIS/SSAS reporting systems
  • 3 years + experience in supporting/developing Microsoft SQL server (2014 minimum) databases
  • Deep understanding of SSRS (SQL 2014)
  • Experience in SSIS and ELT programs
  • Creating SQL objects tables, views,stored procedures
  • Well versed in DML statements PowerBI, SSRS/SSAS and PowerQuery
  • ERD Diagrams, Business Model Mappings
  • Troubleshooting ETL/ELT Processes
  • Excellent communication
  • Thrives under pressure
  • Excellent problem solving skills
  • Ability to communicate up and down effectively to both technical and non-technical staff
  • Persistent, assertive and supportive
We would be really excited if you have:
  • DBA Certification, PowerBI Certification
  • Microsoft Dynamics AX reporting
  • Worked on Enterprise Data Warehouse
  • Migration Project
  • PowerBI reporting experience
  • Expose to Microsoft Dynamics AX Oracle Data Warehouse
  • Configuring OBIEE and Oracle repositories
  • Extracting data from large CRM/ERP systems
  • Modelling Datasets
  • Data Warehouse Kimbal methodologies
  • OBIEE
  • Provide direction on future technologies 
What we offer:
  • Free on-site parking
  • 31 days annual leave (including bank holidays)
  • Pension scheme
  • Access to over 250 discounts including high street and online shopping, travel, technology, entertainment, food and drink and many more via Perkbox
  • Staff discounts on all products