Microsoft BI Data Engineer (SSIS, SSAS, Power BI)

Recruiter:

PBT Group

Job Ref:

1483144838

Date posted:

Friday, August 5, 2022

Location:

Johannesburg, South Africa

JOB SUMMARY:
-

JOB DESCRIPTION:

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS.

REQUIRED SKILLS:

- Microsoft BI: Strong SQL, SSIS, SSAS, SSRS

- Strong modular system design skills.

- Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them.

- System analysis and design skills are necessary to design and document the data extractions and transformations.

- Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs.

- Good organisation, planning and basic management skills.

- Good interpersonal and communication skills.

- Decision making and problem solving skills.

REQUIRED QUALIFICATIONS / TRAINING:

- Relevant data warehouse and BI solution training is essential.

- B.Sc. or related degree is advantageous.

- 5+ years programming experience.

DUTIES:

Duties: Back-end

- Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.

- Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.

- Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information.

- Perform root cause analysis, performance monitoring and application related issues.

- Review IT work products from the team members for completeness and quality.

- Accurately translate business requirement to technical documentation and test case or results.

- Analyse and map data from source systems to target operational data stores and data marts.

- Maintain and provide application support in production.

- Code or folder migration from one environment to another as part of release management.

- Participation in all aspects of quality assurance.

- Active participation in systems integration and user acceptance testing.

Duties: Front-End

- Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools.

- Develop the semantic layer, metadata, reports and report definitions.

- Develop graphs and portal interfaces.

- Load and maintain the metadata for the data access tool.

- Troubleshoot BI tools, systems and software; performance-tune these applications as necessary.

- Produce complex, efficient, error-free reporting solutions and related documentation.

- BI front end development on data structures, cubes, reporting, dashboards, etc.

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Strategic Sourcing Manager
Location: Johannesburg
Salary:
A leading organisation within the manufacturing and mining sector is seeking a highly strategic and commercially astute Strategic Sourcing Manager to drive procurement excellence and supplier performance across critical raw material categories. This is a senior-level opportunity for a strong negotiator and analytical thinker who thrives in high-value sourcing environments and is passionate about d...
1 day ago

FIELD SERVICES TEAM LEADER (OPERATIONS MANAGER)
Location: Johannesburg
Salary: R1.2 – R1.4 MILLION PKG (+ COMPANY CREDIT CARD & VEHICLE WHEN TRAVELLING)
OEM EQUIPMENT & SERVICES (MINING SECTOR)
1 day ago

Data Scientist
Location: Johannesburg
Salary: Monthly
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for a data Scientist to join our client in the insurance environment based in Sandton on a permanent basis.
3 days ago

Data Scientist (Insurance)
Location: Johannesburg
Salary:
3 days ago

IT Audit Supervisor
Location: Johannesburg
Salary: 900000 Annually
Exciting IT Audit Supervisor opportunity in Gauteng
5 days ago

Junior BI Developer
Location: Johannesburg
Salary:
Launch your career in Business Intelligence by working handsâon with SQL, reporting platforms, and modern microsoft data technologies in a supportive, growthâfocused environment.
5 days ago

Microsoft Dynamics 365 Developer
Location: Johannesburg
Salary: 500000 Monthly
New job opportunity for a Microft Dynamics 365 Developer with experience in power Platform solutions and supporting junior team members - power Apps and power Automate essential skills Dynamics 365 & power Platform DeveloperAre you a Dynamics 365 Developer who thrives in building smart, scalable power Platform solutions? Join a business where your technical expertise directly improves cus...
5 days ago

Complex Developer
Location: Centurion
Salary:
Gijima Staffing Solutions is recruiting on behalf of a client for a 1-year contract for a Complex Developer (Senior / Specialist Level).Experience Required: ±15 Years
5 days ago

Data Analyst
Location: Johannesburg
Salary:
Role Summary:We are looking for an experienced and technically versatile data Analyst who excels in data interpretation, business insight generation, and technical development. This role requires a deep understanding of data architecture, system design, and AI concepts, combined with the ability to translate complex data into actionable business intelligence. The ideal candidate is self-driven, hi...
5 days ago

Reporting Consultant
Location: Johannesburg
Salary:
Are you a reporting-focused finance professional with strong FP&A and financial modelling capabilities and a passion for implementing systems that enhance reporting accuracy and insight? This opportunity is ideal for a CIMA-qualified professional who thrives on turning complex financial data into clear, strategic insights while building robust reporting and modelling frameworks.
6 days ago

Microsoft BI Data Engineer (SSIS, SSAS, Power BI)

Similar jobs you might be interested in:

Create a free job alert for Microsoft BI Data Engineer (SSIS, SSAS, Power BI) in Johannesburg