Developer – Data Warehousing (CPT/JHB)
IT – Software Development
Cape Town – Western Cape ~ Johannesburg – Gauteng
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.