About Us

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.

Responsibilities

• 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.

Profile

• 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. 

Availability:

The position is available immediately

Please send your CV to career@methys.com