A dynamic Asset Management company seeks a dynamic Data Warehouse and BI Analyst who will be responsible for engaging with and supporting the full end-to-end data development process including business requirements analysis, source data analysis, modelling, ETL solution design and development and testing.

Duties:

• Elicit and document business data and reporting requirements.
• Provide input into data warehouse solution design and data modelling activities.
• Source system and existing warehouse data analysis, as an input into the data requirements and target design.
• Development of data proofs of concept.
• Validation of data models, business rules and business outputs.
• Documentation of requirements, analysis findings and business glossaries.
• Documentation of ETL specifications, such as source to target mappings, business rule and data validation requirements, ETL functional and non-functional requirements.
• Testing and data quality assurance processes.
• Project management engagement including planning, estimates and ongoing feedback.
• Bringing critical insights and suggestions for continual improvement into process and solution design.

Requirements:

• Graduate student in Information Systems, Accounting or Investment Management fields.
• A minimum of five years’ working experience with data warehouse and business intelligence-related architecture.
• At least three years’ working experience with data in a financial services environment.
• Experience of different data modelling paradigms for data warehousing.
• Experience with industry reference models will be beneficial.
• Strong hands-on SQL experience for the purposes of interrogating data.
• Experience with BI reporting tools such as static reporting, analytics and visualisation tools.

Knowledge andexperienceon the following systems:

• SQL for the purposes of analyzing and interrogating data is essential.
• MS Office Suite, particularly advanced experience of MS Excel.
• Data modelling and architecture tools such as IBM IDA/Erwin/EA Sparx.
• Knowledge of Portfolio and Trade Management Systems, i.e. InvestOne, Decalog and Bloomberg AIM.
• Knowledge of Retail Investment Client Accounting Systems, such as Oracle Flexcube.

While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.

When applying for jobs, ensure that you have the minimum job requirements. Only SA citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please email a Word copy of your CV to

moc.nifatad@nyrat

and mention the reference numbers of the jobs. We have a list of jobs on http://www.datafin.com. DataFin IT Recruitment – Cape Town Jobs.

Posted on 22 Feb 08:49