Share this job with your friends, family and co-workers...
THIS JOB ADVERT IS STILL ACTIVE...
BUSINESS INTELLIGENCE DATA INTEGRATION DEVELOPER - 367119
Reference:
367119
Date Posted:
2020-12-10
Job Title:
BUSINESS INTELLIGENCE DATA INTEGRATION DEVELOPER
Industry:
FMCG / Retail / Wholesale
Type:
Permanent
Wage / Salary:
R - Market Related - P/M (Per Month)
Location:
Cape Town, Western Cape
Country:
South Africa
Closing Date:
2021-02-08
Job Description:
Our client, a reputable retail company based in Cape Town is searchig for a skilled Business Intelligence Data Integration Developer who will be responsible for developing scalable and robust data solutions for integratin data from disparate sources into the Data Warehouse and Analytical Platform that will support diverse reporting and analytical capabilities.
Description
Job Specification
Provide technical knowledge of data integration solutions for Business Intelligence projects
Give input into the impact analysis for new BI solutions providing detailed development estimates, the technical feasibility of and risks associated with each solution design/project
Work with other BI team members to analyse and recommend an end to end BI solution that meet business and data requirements
Develop technical designs and data integration procedures
Work closely with the BI Business Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment
Convert physical data integration models and other design specifications to source code
Ensure the data integration procedures delivered are running, conforms to specifications and design guidelines
Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture, data integration standards and best practices
Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling
Maintain and optimise data integration procedures
Adapt data integration processes to accommodate changes in source systems and new Business requirements
Optimize data integration platform to provide optimal performance under increasing data volumes
Participation and contribution in quality assurance walk through of data integration components
Conduct review of other integration developers' development efforts to ensure consistent methodologies are followed and to make recommendations where necessary
Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution
Build and maintain relationships across business and IT
Establish effective and collaborative partnerships within the BI team and other relevant IT teams, particularly BI source system teams
Lead and drive research and development
Remain current with industry trends and thought leadership on Business Intelligence end to end
Ensure quality of data and the data integration solutions developed
Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis
Profile
Minimum Requirements
JOB REQUIREMENTS
Relevant 3 year tertiary or NQF aligned qualification
Up to 5 years' experience in IT, with a minimum of 3 years in a BI Data Integration role
Proven track record of delivery BI technical solutions on large- to medium-size BI projects
Proven application of Data Warehousing and BI best practices
Proven track record of implementing innovative BI solutions leading to clear business benefits
Knowledge of Data Warehousing concepts and Proven Report and Query writing ability
Strong PL/SQL or T-SQL coding skills, and solid understanding of complex ETL packages
Support overnight batch process to ensure SLA's are met
Exposure to Agile and DevOps practice
Competencies in Cloud platforms and Big Data will be an advantage
ADDITIONAL CRITERIA
In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices
In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies)
Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools
Extensive knowledge and experience in maintainability, scalability and performance of BI environments
Able to create re-usable code and apply standards and best practices to that code
Disciplined in applying BI standards but open to suggestion and change
Meticulous and attention-to-detail focus
Self-motivated with a can-do attitude
