Database Developer At Financial Intelligence Centre

Financial Intelligence Centre; Pretoria; On-site; ZAR 300,000 - 400,000; Full time

Job summary

A prominent entity in the financial sector is seeking a skilled database developer to enhance and maintain their database solutions. The role requires strong proficiency in Microsoft SQL Server and Power BI, along with a solid background in database management and development. Candidates should have a degree in computer science and at least three years of relevant experience, with a focus on data quality and architectural input.

Qualifications

• Minimum three years' experience in developing database solutions.
• Proficiency in Microsoft SQL Server and Power BI.
• Understanding of XML, JSON, and Windows Server platforms.

Responsibilities

• Develop, maintain and test database solutions.
• Compile and review technical design specifications.
• Develop reports and dashboards, and provide input to data architecture.

Skills

Database development

Transact SQL

Microsoft SQL Server 2012+

PowerBI

XML

JSON

Data quality management

Data profiling

Education

Degree in computer science

Microsoft Certified Solutions Associate

Job description

The job purpose is to develop, maintain and test database solutions in line with FIC business requirements.

• Analyse- and interpret of business requirements documents
• Compile and review of technical design specification
• Develop and maintain of database views, functions, user defined types, stored procedures amongst others in line with FIC business requirements
• Develop reports and dashboards
• Provide input to data architecture input
• Develop advanced ETL code
• Develop database code or scripts for testing of the data solution
• Compile and review systems analysis, impact analysis of database solutions
• Code reviews of database solutions
• Maintain of applications and system documentation
• Maintain and support of application solutions in operations
• Analyse and Resolve root-cause production problems and data issues,
• Define and adhere to database development standards and processes
• Data quality, data profiling, metadata management and master data management
  
  

Education, Skills And Experience

• A Degree in computer science or equivalent
• At least three (3) years' experience in developing database solutions on Microsoft SQL server platform
• Proficiency and experience in Microsoft SQL Server version 2012 and above as well as windows server version 2012 and above platforms
• Microsoft Certified Solutions Associates
• MCSA: SQL 2016 BI Development or Certification in Microsoft Certified Solutions Associates
• MCSA: SQL 2016 BI Reporting or Microsoft Certified Solutions Associates
• MCSA: SQL 2016 Database Development
• Solid understanding of Microsoft Windows Server platform version 2012 and above
• Minimum three (3) years' experience in writing Transact SQL code
• Proficiency in XML, XSD and JSON
• Minimum three (3) years' experience in developing on PowerBI platform