Business Intelligence Data Integration Developer

Job SpecificationProvide technical knowledge of data integration solutions for Business Intelligence projectsGive input into the impact analysis for new BI solutions providing detailed development estimates, the technical feasibility of and risks associated with each solution design/projectWork with other BI team members to analyse and recommend an end to end BI solution that meet business and data requirementsDevelop technical designs and data integration proceduresWork closely with the BI Business Analysts and Business Users to translate functional specifications into technical designs for implementation and deploymentConvert physical data integration models and other design specifications to source codeEnsure the data integration procedures delivered are running, conforms to specifications and design guidelinesDesign, 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 practicesDesign, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handlingMaintain and optimise data integration proceduresAdapt data integration processes to accommodate changes in source systems and new Business requirementsOptimize data integration platform to provide optimal performance under increasing data volumesParticipation and contribution in quality assurance walk through of data integration componentsConduct review of other integration developers'' development efforts to ensure consistent methodologies are followed and to make recommendations where necessaryDocument solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solutionBuild and maintain relationships across business and ITEstablish effective and collaborative partnerships within the BI team and other relevant IT teams, particularly BI source system teamsLead and drive research and developmentRemain current with industry trends and thought leadership on Business Intelligence end to endEnsure quality of data and the data integration solutions developedImplement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis