Senior BI Developer Analyst - Cape Town Verfied

Salary Negotiable Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 12-11-2019 7:43:08 AM
07-01-2020 7:43:08 AM
Senior BI Developer Analyst
Location: Western Cape, Southern Suburbs

Our client is an innovative digital financial service provider who specializes in fast, flexible loans and funeral cover policies. Their aim is to become a favorite financial service provider for their customers by offering products that are affordable, transparent and easy to access
The ideal candidate for this role will be responsible to support, enhance and optimise the current data warehouse environment by extracting, transforming and loading data from various sources using TSQL & SSIS and will develop and enhance reporting and analytical capabilities/solutions, using SSRS, Power-BI and SSAS, delivering projects that support the business’ requirements in an agile manner.
Here's what you can expect to be doing in the role:
• Interpret and understand business data and information requirements as per technical specifications
• Deliver data and information to the business in line with business priorities, according to quality standards, within the agreed time constraints and according to departmental coding practice & standards as well as user expectations
• Be involved in the process of populating new data within the Data Warehouse
• Understand and offer support to the current production environment and relevant processes
• Support the BI Team in maintaining the production environment, ensuring delivery of current information to the business on time, effectively collected, correctly transformed, audited, accurately published
• Ensure efficient and effective resolution of production issues
• Monitor the environment to proactively engage in prevention activities and to maintain an environment that is easy to understand and troubleshoot
• Recurring standby to support and resolve operational issues encountered in the day to day operations of the data warehouse production environment
• Provide support service to users on data and information to satisfy user needs
Requirements - a little about who you are:
• Relevant 3 year IT degree / diploma
• A minimum of 5 years’ data warehousing experience with a working understanding of dimensional modelling
• At least 5 years’ experience in ETL processes using SSIS
• Intermediate to Advanced skill level in using MS-SQL/T-SQL
• Intermediate to Advanced skill level in developing reports using SSRS
• Experience in building and maintaining Tabular Cubes (DAX) using SSAS will be an added advantage
• Exposure to Self-Service BI using Power-BI will be an added advantage
• Exposure in using TFS or SVN will be an added advantage
• Exposure in working within an agile project environment will be an added advantage
Benefits:
• Flexible benefits to structure your own package
• Creative agile work environment
• Flexible working hours
• Café and lounge area
• Staff restaurant with a variety of healthy meal options

Should you receive no response within 2 weeks, please consider your application unsuccessful.