Seasoned SQL / C# Developer at Novus Holdings Ltd

Who are we looking for:

• We have a fulltime vacancy for a seasoned Microsoft SQL / C# Specialist with at least 10 years’ experience with the implementation of BI Solutions for business problems through the design and development of ETL, databases and reports using SQL Server, SSRS, SSIS as well as C# scripting. Maintenance and expanding mission critical API integrations with external systems will be a key responsibility. The successful candidate will also play a very active role in advanced data analytics and the development of related proactive insights for the business and customers.
• The ideal candidate will be stationed at our office in Montague Gardens (Cape Town).

Key Duties and Responsibilities    

• Maintenance and active monitoring of all active integrations which include, but not limited to POS, EDI, SFTP, REST, SOAP and other API integrations.
• Maintenance and continuous improvements to the ETL processing.
• Assist with requirements gathering, creating technical specification documentation and development of new requirements in MS SQL as well as C# amongst others. This includes implementing advanced insights models for business and customers using advanced analytical techniques.
• Database administration ensuring best-practice maintenance and systems resource utilization.
• Ensure compliance with data governance standards including data integrity, completeness and POPIA compliance.
• Actively assisting in the testing of new of new solutions.
• Technical knowledge sharing to the rest of the team.
• Actively explore AI solutions to create meaningful insights into our data for both internal and external stakeholders.

Educational Requirements    

• At least a Bachelor’s Degree in Computer Science, Information Systems and other related field / equivalent work experience.

Experience Requirements    

• At least 10 years’ IT work experience in programming and/or systems This must include T-SQL, PL/ MS SQL, SSIS, SSRS, PowerBI.
• At least 10 years’ experience in C# for data processing, custom functions and application integrations. Experience with SQL Assembly will be advantageous.
• Knowledgeable in SQL and ETL programming
• At least 8 years’ experience in data warehousing and advanced data analytics.
• Extensive knowledge and experience with technology and application development
• Knowledge of Big Data tools and skills on Cloud platforms like Azure would be advantageous, but not
• Solid knowledge and experience in enterprise architecture with a reasonable understanding of networking, server infrastructure will be advantageous.

Skills and Competencies    

• Requirements gathering
• Advanced Analytical skills
• Advanced Data Analytical skills
• Strong innovative problem solving abilities
• Database administration
• T-SQL, PL/ MS SQL, SSIS, SSRS, PowerBI, C#
• Server infrastructure and design
• High attention to detail
• Team player
• Results oriented, self-motivated and deadline driven
• Excellent Communication skills (including being able to translate between technical and business jargon).