@2022 Methys. All rights reserved
Business Intelligence Developer
Methys group is a unique international technology hub with expertise in Digital, Performance and Innovation through.
We are focused on customer success, driving maximum business performance. Leveraging on partnerships with key technology providers and a rich set of methodologies blending functional and technological excellence
We are looking for an Business Intelligence Developer to join our team based in Cape Town. The successful candidate will slot into our BI team and will have the responsibility for the development, maintenance, integration, data governance and data reporting of Methys client’s business systems and other systems.
Background in data and business analysis
Be analytical and an excellent communicator
Have a business acumen and problem-solving aptitude
Enhance client business intelligence systems to help them make better decisions
Translate business needs to technical specifications
Design, build and deploy BI solutions
Maintain and support data analytics platforms
Create tools to store data | Innovation
Conduct unit testing and troubleshooting
Develop and execute database queries and conduct analyses
Create visualizations and reports for requested projects
New 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.
Relevant Post Graduate degree
3 years work experience in a business intelligence role
3+ 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 experience
MS Excel advanced level is essential (including Excel macros)
Knowledge of and experience with Enterprise Data Warehouses
Be able to give accurate technical estimates
Driving new solutions based on business requirements
Strong communication skills, ability to mentor others
Why Join Us
The Benefit of joining our Methys Team is that you will be working in a vibrating environment, with a multicultural team operating in various countries (France, Tunisia and SA).
Come and be part of this highly energetic, enthusiastic, positive team whose sole focus is on growth, growing personally as individuals, but growing professionally through all the opportunities within the group.
The position is available immediately
Please send your CV to email@example.com