Data Developer(SQL, SSRS, SSIS, PowerBI) at Datacentrix

Role summary:

• We are seeking a highly skilled Database Developer who can design, develop, and maintain data management systems. The ideal candidate should have experience in Microsoft SQL and ETL processes. The candidate should also have a deep understanding of data modelling, schema design, performance tuning, and database administration.

Key outputs:

• Design and develop database solutions using Microsoft SQL Server including schema design, query optimization, and stored procedures.
• Write efficient SQL queries and code to extract, transform and load (ETL) large datasets from various sources into relational databases.
• Design and maintain ETL processes and workflows including scheduling, monitoring, and error handling.
• Proficient in data modelling, schema design, and database administration.
• Experience working with large datasets and high transaction volume databases.
• Strong communication and collaboration skills with cross-functional teams.
• Configure and administer Microsoft SQL Server environments and monitor database performance to ensure optimal performance.
• Collaborate with cross-functional teams to identify and implement database solutions that meet business requirements.
• Troubleshoot and resolve database issues including ensuring data quality, accuracy, and consistency.
• Ensure the security, integrity, and availability of databases and data management systems.
• Excellent problem-solving skills and attention to detail.

Qualifications:

• An undergraduate qualification (Bachelor's degree or equivalent) in the relevant IM discipline and/or Technical competencies and certification with relevant years of experience in a similar role.

Experience:

5+ Years’ experience relating to:

• Time and Attendance experience
• Experience with ETL processes and tools such as SSIS.
• Strong SQL skills including experience writing complex queries and optimizing database performance.
• IOT

Behaviours:

• This role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes

Closing Date: 12 May 2023