Datafin are currently seeking candidates for their open Developer – Data Warehousing (CPT/JHB) position in Cape Town, Western Cape through Go Job Search. Are you an experienced candidate looking to take up a Developer – Data Warehousing (CPT/JHB) role such as with an industry leading company like Datafin?
ENVIRONMENT: HELP develop and enhance the cloud data capability model of an innovative Investment Firm to house its DWH as they seek your coding talents as a Developer who must have extensive experience in relational and dimensional database structure and design and reporting. You will also develop integration solutions using T-SQL and other vendor integration tools, ETL Development and maintain existing SSRS report definitions to present the data. The ideal candidate must possess a Degree/Diploma in Information Science or related technical discipline, have 5-8 years’ SQL experience – stored procedures, UDF’s, T-SQL, performance tuning and optimization, RDBMS, error handling and logging, etc. and proficiency with SSIS, SSRS, Power BI and knowledge of financial concepts and terms.DUTIES: Work as part of a larger IT team using the Scrum methodology.Interact with business users, Business Analysts and other Developers to understand user requirements.Develop integration solutions using T-SQL and other vendor integration tools.ETL Development to load Data Warehouse.Maintain existing SSRS report definitions to present the data.Support existing integration and reporting solutions in the production environment by analysing problems reported by users and track down their cause through debugging techniques and discussion with other team members.Testing and deployment of new development.REQUIREMENTS: Qualifications –Degree or Diploma in Information Science or related technical discipline.Experience/Skills –5-8 Years SQL experience (stored procedures, UDF’s, T-SQL, performance tuning and optimization, RDBMS, error handling and logging, etc.) is essential.Experience with data integration, validation and reconciliation (SSIS or similar).Expert knowledge of reporting technologies (SSRS, Power BI or similar).Working experience with relational and dimensional database structures.Working experience with design and development of data marts and data warehouses.Interacting with business users to understand requirements and producing solutions.Knowledge of financial concepts and terms and interested in attending courses to improve business knowledge. Advantageous –Experience creating and maintaining cubes (SSAS).AWS Cloud implementation.Jira and GitLab.Exposure to PostgreSQL.Financial Services industry experience.ATTRIBUTES:Attention to detail and quality.Problem solving.Willingness to take initiative and responsibility.Able to meet deadlines and deal with pressure.Can work effectively as part of a diverse team and cross-train with team members.Strong analytical skills.Good communication.
Apply now and a member of the team at Datafin will get in touch with you to discuss your career options further.