Our Client is looking to appoint a Business Intelligence (BI) & Data Warehouse (DWH) Specialist.
This BI & DWH Specialist will be responsible for the design, development, implementation, management and support of enterprise BI reporting, Data Warehouse and Extract, Transform, Load (ETL) processes and environments.
Working with cross-functional teams, you will be required to gather, document, and approve business requirements for data analysis and reporting projects, as well as use BI and database tools to develop reporting solutions to meet business needs.
You will design, develop and implement ETL processes to transform structured, unstructured and disparate source data into the target data store(s) / data warehouse(s) / data mart(s).
Qualification & Experience Requirements
BA/BS in Computer Science or related field or equivalent
5+ years’ experience implementing enterprise-scale reporting systems
Extensive use of SQL and RDBMS systems (DB2, Oracle, SQL Server)
Extensive experience with data warehouse implementations
Business analysis to gather required BI/DWH system requirements
Translate business requirements into specifications that will be used to drive data store/ data warehouse/ data mart design and configuration
Use ETL tools to load data store(s)/ data warehouse(s)/ data mart(s).
Transition developed BI systems to the Operations & Support teamsProvide support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users
Ensure proper configuration management and change controls are implemented for your sphere of influence
Provide technical assistance and cross training to other team members
Design and implement technology best practices, guidelines and repeatable processes
– This key accountabilitie’s list is not exhaustive. Undertaking of additional responsibilities consistent with the purpose of your employment may be required –
Competencies and Attributes
Working with users in a requirements analysis role
Strong knowledge of logical and physical data modeling concepts
Proficiency with BI and DWH toolsets
Demonstrated ability with ETL tools.
Performance tuning experience
Excellent interpersonal ( verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams
Requires strong analytical, conceptual and problem-solving abilities
Programming / scripting experience and knowledge of software development life cycle
Ability to manage multiple priorities, and assess and adjust quickly to changing priorities
Must be able to perform duties with moderate to low supervision
Please provide a covering letter and a word formatted CV in your application.