The Financial Intelligence Centre (FIC) exists to apply measures outlined in the Financial Intelligence Centre Act, 2001 (Act 38 of 2001), which are intended to make the financial system intolerant to abuse. The FIC does this by working towards fulfilling its mandate of assisting in identifying the proceeds of crime, combating money laundering, the financing...
Read more about this company
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
Gmail
Yahoomail