Business Intelligence Developer at Sanergy

About the Role

The Business Intelligence (BI) Developer will design and develop actionable reporting systems to aid in business decision making through the development of reporting systems. The BI Developer will design and maintain a robust data warehouse and associated infrastructure to solve organizational information needs.

Duties and Responsibilities

We are looking for a hard-working and organized BI Developer to be responsible for the upkeep and development of warehouse data to support our business decision-making. The BI Developer will build and maintain a data warehouse design to generate actionable reports to aid in business performance monitoring and business decision making.

As a BI developer, you will be working with business users, collecting their requests, and then updating the set of existing BI reports to accommodate business needs. You will be expected to establish company standards and common reporting terminology, and to help align existing and future reporting requests to such standards. You will also be interacting with the Applications Development Team whenever data schemas need redesigning to accommodate new reporting requirements.

Key Responsibilities – Development of Management Information and Reporting

• Work with the Senior Leadership team an Operations Managers, and other colleagues to understand the management information requirements of the Organisation.
• Work with key stakeholders within the Organisation to understand and document the sources of data and map information requirements against available data sources.
• To be a technical expert for all ETL development and reporting development to identify opportunities to enhance the current management information and reporting provision.
• Design and develop changes and additions to the data warehouse and associated databases to map to information requirements.
• Design and develop reports, dashboards, graphs, user interfaces and queries from the data warehouse to meet the management information requirements of all stakeholders.
• Ensure all developments are tested and meet all functional, technical, quality, security and performance requirements. Design and implement data quality and consistency schemes to assure the accuracy and integrity of management information and reporting.
• Ensure that the security and safety of all data and information is maintained in line with the Organisation’s information and security policy. 

• Provide support in the identification and resolution of issues related to management information and reporting. To develop tools and support colleagues in the provision of ad-hoc management information and reporting queries.
• To provide training support and continually assess adoption of the reporting data generated.

Qualifications

• A Bachelor’s or Advanced Degree in Computer Science, Engineering, or related field.
• Background in data warehouse design (e.g. dimensional modeling) and data mining with proven experience as a BI Developer or Data Scientist
• Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI, Tableau, SSRS, SSIS)
• Solid experience with designing, querying and maintaining databases such Postgres, MSSQL and other Relational Databases eg MySQL
• Experience in data warehouse design, ETL and Reports Visualisation.
• Working knowledge of BI technologies and trends.
• Strong problem-solving and analytical skills.
• Strong attention to detail and ability to work in a team. 
• Programming skills in Python, JavaScript, TypeScript preferred
• Experience with data visualization libraries (D3.js, Matplotlib, RGL)
• Testing and debugging experience