Data Specialist,Institutional Domains,Client Servicing Domain at Allan Gray Proprietary Limited

Job Description
The Allan Gray Institutional development team is currently around 65 members, covering a range of skills and responsibilities including Domain Owners, Development Manager, Architect, Business Analysts, Developers (.NET and SQL) and IT Operations. This team is responsible for the systems that support Allan Gray’s asset management function. There is plenty of opportunity to learn about the asset management industry and technology.

Our ideal candidate is very detail oriented, self-driven, and curious. Using their combination of strong technical skills and appreciation for data usage in business processing and analytics, the data specialist will contribute in building robust solutions in line with our overall data architecture.

Responsibilities

• 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.
• Collaborate with Tech Lead to implement the move of workload (new and existing) to Cloud platform
• Develop integration solutions using SQL and/or data movement tools for:
  • Intra-system data distribution
  • Loads into the data warehouse
• Design and create Power BI dashboards to present the data.
• Optimising ETL loads to improve performance.
• Testing and deployment of new development.

Requirements

• 5-8 years’ experience working with relational database systems is essential
• ETL development on any tool (SSIS/AWS Glue/Azure Data Factory/Markit EDM) essential
• Working experience with SSRS/Power BI is desirable
• Working knowledge Cube technology (eg. SSAS) would be an advantage
• Experience or exposure to dimensional modelling/ data warehouse design methodologies (Ralph Kimball) is essential
• Working with AWS deployment is desirable
• Experience or exposure to data streaming technologies (Kafka/Kinesis) would be an advantage

Skills / Competencies

• Attention to detail and quality.
• Problem solving
• Willingness to take initiative and responsibility.
• Ability to meet deadlines and deal with pressure.
• Ability to work effectively as part of a diverse team and cross-train with team members.
• Strong analytical skills.
• Good communication

Education

• Analytical degree or diploma is essential
• Knowledge of financial concepts and terms and interested in attending courses to improve business knowledge.
• Financial Services industry experience would be an advantage.