Business Intelligence Back End Developer

Support Services Group
Salary depending on experience
14 Oct 2016
23 Oct 2016
Contract Type
Business Intelligence Back End Developer Role: As part of the Business Intelligence Team, to implement packages, develop applications and interfaces focussed on delivering Business Intelligence tools. To assist with data analysis, sourcing sample and test data. To assist in the development of the Data warehouse. Various technologies will be used (MS SQL, SSAS, Redgate, Toad etc?) and most of the solutions developed will be based on a cutting-edge in-house SQL server DWH. Main Duties: Support the design and evolution of the company's Enterprise Data Warehouse (based on MS SQL). Develop user interfaces for master data and system health reporting. Development of required data transport logic. Documenting the business requirements at high level and work with the solutions architect to provide the IT solutions to meet the requirements through design workshops and specific project meetings. Assist Business Intelligence Team Architect and Analysts with the development of data extract queries, OLAP cubes and reports Research and evaluate when needed, possible approaches to fulfil the requirements. Develop applications and/or interfaces when needed and produce the associated documentation to guarantee supportability. Design test plans for the systems built and execute the plan in coordination with the rest of the project team to guarantee integration testing and correct errors found. Participate in the handover of the system to the application support team and the infrastructure team. Follow the standard project management methodology. Design, build and maintain efficient and automated SQL jobs to extract, transform and load key data from disparate sources into the BI Data Warehouse. Continuously and progressively cross-reconcile and cleanse all data within both the Data Warehouse and the source systems so that sources of error and confusion (e.g. duplicate licenses within the CRM system) are systematically eliminated and kept out. The goal is 100% reconciliation between all related data objects. Design & build tables, views, functions, stored procedures and other MS SQL objects within the Enterprise BI Data Warehouse to create a fully-managed set of consumable BI data sources that can feed standard scorecards, reports and self-service analysis tools (e.g. Excel Pivot tables and Cognos Reports). Work with other members of the BI team to build SQL Server Analysis Services (SSAS) OLAP cubes and publish them to business functions for them to report and perform analysis Produce high-quality detailed documentation on the design and operation of all the SQL components of the Data Warehouse. Produce and/or assist with ad-hoc questions and data analyses on demand. Assist analysts within the business functions to use published tables, views and cubes in their own reports by providing ad-hoc training and advice. Proactively identify anomalous, unexpected or significantly noteworthy data, verify its accuracy, and raise it to the attention of executive decision makers for discussion. Review specifications to ensure an unambiguous, consistent, testable and complete set of requirements Provide estimates (planning, workload, feasibility) and evaluate when needed possible approaches to fulfill the requirements Evaluate impact of data changes on existing solutions Follow the standard project management methodology Create proof of concept and prototypes Work against tight deadlines and delivery dates, raise alerts and communicate any change in planning or workload to project manager or line manager regularly Provide support and training for reporting tool and data interpretation, to develop and deliver end user training Write code and stored procedures to produce special reports or populate interfaces between applications Work with 3rd party vendors in the context of production database environments to review technical functionality, suitability, implications and costs of potential implementations (packages, new versions, fixes) Stay up to date with industry new IT developments in the database space and maintain a broad technical understanding of IT infrastructure Special Conditions: May require international business travel. Will be allocated to more than one project at a time Job is not technology specific nor functionally linked to a specific business area within the company Candidate must be willing to provide occasional out-of-hours support for BI systems (e.g. around financial year end). Relevant in-house or external training will be provided as relevant This job was originally posted as

More jobs like this