Solution Engineer (Data & Bi)

Copious Software; Gauteng; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A technology services company in Gauteng is seeking a BI Solutions Architect responsible for data analysis, data modelling, and designing BI solutions. Ideal candidates will have experience with Microsoft BI stack and Oracle, strong SQL skills, and the ability to communicate effectively. Join us to work on innovative projects that truly make an impact.

Benefits

Better income structure

Team get-togethers

Workation trips

Up-skilling and re-skilling

Qualifications

• Strong experience in gathering requirements for reporting solutions and data analytics.
• Ability to mentor junior team members.
• Excellent oral and written communication skills.

Responsibilities

• Interact with business analysts and end users to establish information needs.
• Conduct data analysis and data profiling on various source systems.
• Design and document logical and physical data models using dimension modelling techniques.
• Review data models with functional and technical teams.
• Lead the creation and enhancement of BI standards and processes.

Skills

Data analysis

SQL query writing

BI front-end tools (Power BI, Excel)

Logical and physical data modelling

ETL design

Master Data Management (MDM)

Strong analytical skills

Education

Relevant degree or certification in Data Science or related field

Tools

Microsoft BI stack

Oracle

SSIS

SSAS

SSRS

Job description

Overview

Ready to embark on this thrilling journey?

Apply now and let's revolutionize the economic and technology landscape together!

About Copious

We’re Copious.

At Copious, we believe in People, Knowledge and Solutions.

We believe that when you bring those three things together, you can create something truly valuable.

That’s why we bring together engaged talents to provide high-value technology services that help our consultants and clients succeed.

Copious is a Talent & Technology services company dedicated to helping businesses grow.

We are present in South Africa, India, Singapore & soon in UAE.

Why Work with Us

Better income structure for more take-home.

Team get-togethers & workation trips.

Work on the latest Tech Stacks with a choice from many clients.

Up-skilling & re-skilling.

A dedicated account manager is assigned who works closely with your engagement.

About Clients

Imagine working with industry-leading customers changing the game and disrupting the landscape in sectors like Banking, Finance, Insurance, and Retail.

At Copious, we bring together the brightest minds to collaborate on groundbreaking projects that shape the future.

Responsibilities

Interact with business analysts and end users to establish information needs.

Conduct data analysis and data profiling on various source systems.

Design and document logical and physical data models using dimension modelling techniques.

Review data models with functional and technical teams.

Interact with software developers, business analysts, quality management and end users to communicate BI designs and solutions.

Establish, maintain, and ensure compliance with data modelling and data integration standards.

Lead the creation, enhancement and implementation of newer BI standards and processes.

Data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs.

Conceptualize and design solutions.

Mentor junior team members.

Excellent oral and written communication skills.

Technical Skills

The BI Solutions Architect should understand and have expertise in the various technologies needed to implement BI solutions.

The BI Solutions Architect must have experience with the Microsoft BI stack and Oracle.

Solid experience in gathering requirements for reporting solutions and data analytics.

Solid experience in writing functional and technical specifications, process flows and source-to-target mappings.

Experience working with BI front-end tools to develop prototype solutions (Power BI, Excel).

Strong SQL query writing ability (across database environments).

Strong experience in logical and physical data modelling using a variety of techniques including Kimball.

Strong database fundamentals and data modelling knowledge (normalization and de-normalization).

Experience in ETL design and a good understanding of ETL solution architectures.

Good understanding of ODS, data warehouse, data mart, cube, and database technologies.

Strong analytical and problem-solving skills.

Navigating ambiguity and complexity.

Strong understanding of Master Data management (MDM), Metadata Management and Data Governance (DG).

Microsoft data technology skills (SSIS, SSAS, SSRS).

Other Duties Include

Establish domain-specific standards, near / mid-term strategy, and roadmaps.

Assist the BI Unit in creating the vision for future state technologies and architecture.

Participate in research and development efforts (proofs of concept, prototypes) as subject matter experts when introducing new technologies.

Provide technical expertise to assist in level of effort estimates (LOE), technical resource planning and work breakdown structures for proposed and current work to support Project Management.

Participate in various phases of the SDLC to perform QA / architectural review functions and to ensure adherence to Architecture technology standards and project-specific solutions architecture (e.g., design reviews).