Business Intelligence Support Developer

Summary

Join Datacom as a Support Developer and contribute to the development, deployment, and maintenance of data warehousing and ETL artefacts. You will provide operational support, monitor and tune queries, address data integrity issues, and contribute to data model design. Responsibilities include debugging database solutions, developing ETL processes, and researching best practices. You will maintain and support the enterprise data/reporting platform, assist users, and adhere to data warehouse design principles. The role requires strong analytical skills, SQL expertise, and experience with SQL Server Integration Services (SSIS). Datacom offers a dynamic work environment with perks such as remote working, flexible hours, and professional development opportunities.

Requirements

• Strong analytical skills and experience of writing complex SQL queries
• Strong working knowledge of SQL Server RDBMS including SQL Server Integration Services (SSIS)
• Business Requirements Analysis and Documentation
• Demonstrates strong verbal and numerical skills (complex calculations, data analysis and reconciliation, numerical and verbal logical reasoning)
• Ability to develop strong relationships with key contacts
• Change Management
• Strong problem-solving skills
• Strong attention to detail
• Time management & ability to work under pressure
• Minimum 1 year experience working in a BI, Analytics, Reporting, Database management role
• Strong Database systems experience
• Strong ETL experience
• Awareness of Business Intelligence and analytical concepts, data visualisation techniques

Responsibilities

• Develop, deploy, and maintain data warehousing artefacts, ETL artefacts, and provide operational support on these artefacts in a BAU environment
• Support BAU BI Solutions by monitoring and tuning queries and data loads, addressing issues regarding data Integrity, monitoring performance and communicating functional and technical issues
• Debug, monitor, optimise and troubleshoot database solutions
• Contribute to the design and development of data models, developing and performing ETL processes to meet business requirements
• Research and deliver best practices methodologies
• Maintain and support the enterprise data/reporting platform so that it can provide reliable, timely, performant and accurate information to business users
• Provide assistance and support to all Datacom users with respect to the data/reporting platform, including internal users who are using and manipulating data
• Adhere to data warehouse design and quality best practices in accordance with established principles and design philosophy within Group Data
• Design and development of efficient queries, stored procedure and functions for reporting
• Define and clarify requirements, propose and develop appropriate solutions, and provide feedback to the reporting team and internal customers
• Monitor and evaluating key performance indicators, forecasting and trends
• Take reasonable care that their actions (or inactions) do not harm the Health and Safety of self or others. Reports all incidents, hazards or unsafe work practices as per Datacom policy
• Establish and maintain automation processes with a large range of internal and external data sources
• Create and maintain required documentation
• Serve as the subject matter expert for Microsoft SQL Server related tools
• Ensure that issues encountered in production environments are resolved in a timely manner
• Perform performance tuning / query optimisation
• Conduct regular maintenance and improvements to queries and databases
• Adapt quickly and effectively to changes in departmental or strategic priorities by responding to requests for additional ad hoc requests
• Perform data reconciliation/verification of reporting requirements

Preferred Qualifications

Working knowledge of any other business intelligence/data visualisation tools e.g. Tableau, Microsoft Power BI, Qlik, SAS Visual analytics

Benefits

• Remote working
• Flexi-hours
• Professional development courses