Senior Bi Developer

Cape Town, Western Cape, South Africa

Job Description


Kick-start your career in the online gaming world and experience the very latest in technology and innovation.

The Department:

Passionate about providing the business with ERP and Cube Reporting solutions, the Finance team strives to provide a platform allowing people to work smart and not hard.

We continuously look to innovate, automate, enhance and simplify processes which in turn allows users of the systems faster and more accurate results as close to real time as possible.

Purpose of the Role:

A role exists for a Senior BI Developer in an online organization with a good history and strong Reporting Team.

This role requires a motivated, energetic, inquisitive and highly numerate person who has a solid technical base but also possesses an appreciation for numbers and understands the value that can be derived from interrogating them.

Duties include, but not limited to:

Integration of ERP data into company databases and TM1 cubes so that it can also be used by Finance business users for reporting and publishing financial results.

Designing new database structures or enhancing existing ones to cater for optimal process flow and optimal user querying.

Optimizing data ingestion for TM1 and analyzing ERP data required for TM1.

Automate ERP data extracts for required SOX controls.

Integration of data into relevant workflow processes, with the specific aim of continuously improvement and data optimisation

Conceptualizing, defining and delivering new reports for ERP and TM1 as well as improving existing ones

Analysis of data from various sources in order to ensure that the business acts proactively on the information at its disposal

Continually searching for new and useful ways to obtain, integrate and analyse data that is relevant to financial reporting.

Debugging, monitoring and troubleshooting current solutions

Work with Project Managers and Product Owners in developing and executing project plans or development tasks within assigned schedule and timeline.

Guide and mentor junior resources when needed

Education of report end-users so as to ensure a maximum spread of expertise around the finance department

This job description is not intended to be an exhaustive list of responsibilities. The job holder may be required to complete any other reasonable duties in order to achieve business objectives.

Essential Criteria:

Experience and understanding of table structures in Dynamics Nav and Business Central

Experience or knowledge of IBM Planning Analytics

At least 5 years work experience in a Business Intelligence or SQL Developer role will be considered.

5+ 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/cdc. 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.)

Ability to build reports in Excel and reporting tools such as Power BI

Minimum of 1 yearsxe2x80x99 experience in front end visualisation tools such as Power BI/ Qlikview /Tableau/ Cognos (creation, implementation and maintenance of analytical dashboards and visualisations)

Advanced skills in MS Excel

Be able to give accurate technical estimates

Driving new solutions based on business requirements

Strong communication skills, ability to mentor others

At least 1 yearsxe2x80x99 experience within DigiTech

Demonstrates consistent behaviour aligned to the Combiined F and Organizational Culture

Desirable Criteria:

Software dev background

Experience integrating with API solutions

Knowledge of event-driven programming

Service broker queue

1 year of project management experience

Undergraduate degree (or substantial progress towards one) with majors in IS / math / stats / engineering or similar.

1 yearsxe2x80x99 experience with OLAP reporting tools and cube technologies, such as SSAS/Cognos TM1 (creation, implementation and maintenance of multi-dimensional cubes, MDX, DAX)

Person Specifications:

Stress Tolerance

Numbers

Problem Solving

Innovation

Time Management

Interpersonal Skills

Adaptability / Flexibility

Teamwork

*Please note we will apply relevance to our Talent Management and Talent Development Programme as part of our recruitment process.

*Shortlisted candidates may need to complete an assessment.

This position requires trust and honesty it has access to customers financial details - therefore a credit and criminal record check will be conducted. The qualifications identified herein are an inherent job requirement; therefore, a qualification verification check will be done. By applying for this role, and supplying the necessary details, you hereby grant us permission to apply for these checks. This will be done in a confidential manner, and solely for the purposes of verification.

Should you not hear from us within 2 weeks, please deem your application as unsuccessful.

The perfect place to work, play and grow!

DigiOutsource

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1257270
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Cape Town, Western Cape, South Africa
  • Education
    Not mentioned