Business Intelligence Developer

Business Intelligence Developer

Snaphunt | Cape Town, WC, ZA

Posted 16 days ago

Apply Now


The OfferOpportunity to make a positive impactFlexible working optionsGreat work environmentThe JobResponsibilities:Background in data and business analysisBe analytical and an excellent communicatorHave a business acumen and problem-solving aptitudeEnhance client business intelligence systems to help them make better decisionsTranslate business needs to technical specificationsDesign, build and deploy BI solutionsMaintain and support data analytics platformsCreate tools to store data | InnovationConduct unit testing and troubleshootingDevelop and execute database queries and conduct analysesCreate visualizations and reports for requested projectsNew Systems Development & enhancement of existing systems: designs the system per requirements, writes the code, does testing before implementation into the production environment, gets sign off, implement in production environment; Post implementation testing and solving of problems. Provide ongoing operational and technical support of the BI/MI systems, including ETL and database design; Creation of SQL Server Tables, Stored Procedures, Views and Functions; Creation and Maintenance of SSIS packages; Development of SSAS Cubes; Development and Maintenance of SSRS Reports.Fixing of Errors in Systems: Fixing of system bugs.Systems Analysis and Technical Specification: The business identifies a need; Do feasibility studies in conjunction with the business; Do research to establish the impact on other systems; Do requirement analysis and create technical specifications for development.Provide User Support: Deal with user problems reported, even outside normal working hours; Assist with troubleshooting.Personal Development: Adhere to Training and Development Plan; Take ownership for self-development.Innovation: Assist in proposal, POC and final implementation of innovative technical solutions.The ProfileSkills:Relevant Post Graduate degree3 years work experience in a business intelligence role3+ years strong SQL experience (creation of stored procedures, functions, automation of jobs, performance tuning and optimization, RDBMS, error handling and logging, incremental data loading, change tracking etc.)Minimum 3 years SSIS experience (creation of complex ETL (Extract, Transform, Load) processes, error handling, loading data from various data sources (flat files, xml), integration of new data into data warehouse, precedence constraints, parameterized connections, etc.)Minimum 3 years SSAS experience (creation, implementation and maintenance of multi-dimensional cubes, MDX, DAX)3 years SSRS experienceMS Excel advanced level is essential (including Excel macros)Knowledge of and experience with Enterprise Data WarehousesBe able to give accurate technical estimatesDriving new solutions based on business requirementsStrong communication skills, ability to mentor othersThe EmployerOur Client is a unique international technology hub with expertise in Digital, Performance and Innovation through.