SD Engineer (Data & BI)

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

Job summary

A technology services company is seeking a BI Solutions Architect based in Sandton, Gauteng. The role involves interacting with various stakeholders to gather requirements, conduct data analysis, and design data models. Candidates should have strong SQL skills and experience with relevant technologies including Microsoft BI stack and Oracle. Responsibilities also include mentoring team members and participating in quality assurance processes of the SDLC. This position offers an opportunity to lead BI standards and contribute to innovative technological solutions.

Qualifications

• Understanding of technologies needed to implement BI solutions.
• Experience with Microsoft BI stack and Oracle.
• Strong database fundamentals and knowledge of data modelling.

Responsibilities

• Interact with analysts and users to establish information needs.
• Conduct data analysis and profiling on source systems.
• Design and document logical and physical data models.

Skills

SQL query writing

Business Intelligence tools (Power BI, Excel)

Data modelling techniques (Kimball)

ETL design

Data governance

Analytical skills

Project Management support

Tools

Microsoft BI stack

Oracle

SSIS

SSAS

SSRS

Job description

Copious is a Talent & Technology services company dedicated to helping businesses grow. Since 2014, we’ve partnered with talents and clients to create Career and Business solutions for the People in the business and technology ecosystem.

We offer API Test Automation, Salesforce Services, Business Intelligence & Analytics, SAP Services and Talent Solutions Services and are present in South Africa, India, Singapore & soon in UAE.

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. (i.e., design reviews).