Senior Data Warehouse Architect & BI Insights

Momentum; Centurion; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

Momentum in Centurion, Gauteng, is seeking a Senior Data Warehouse Developer to design, build, and maintain data warehouse solutions ensuring data integrity and performance. You will extract, transform and load data from multiple sources, model data, and present insights with Power BI and other visualization tools for technical and non-technical audiences.

The role requires 5 years’ DW experience, strong SQL, ETL expertise, familiarity with Kimball and Inmon methods, and the ability to mentor

Qualifications

• 5 years experience as Data Warehouse Developer
• 3-year degree in Mathematics, Economics, Computer Science, Information Management or Statistics
• Introductory Cloud Certification - Desirable
• Strong SQL and with relational and non-relational databases
• Extensive experience with ETL/ELT tools (SSIS, Data Factory, Informatica, Talend)
• Knowledge of Kimball and Inmon data warehousing methodologies
• Data modeling experience (dimensional modeling, snowflake, star schemas)
• Familiarity with cloud platforms (Azure Synapse, AWS Redshift, Google BigQuery) is a plus
• Experience with Power BI/Tableau
• Excellent problem-solving, analytical and communication skills
• Ability to work independently and as part of a team

Responsibilities

• Develop Power BI solutions, working from high level technical requirements in line with business requirements.
• Quality assurance checks on all new Power BI project functionality and business requirements.
• Produce documentation for code written.
• Configure real-time replication of data from source system to the Data Warehouse, using tools like Stelo SQDR
• Partake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting.
• Basic interaction and collaboration with technical stakeholders to identify data sources, find data definitions for master and meta data as well as formulate and implement solutions.
• Promote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles.
• Promote reusability, maintainability, reliability, and scalability in design and development of data solutions.
• Process live and confidential data according to specified guidelines.
• Convert Legacy Excel reports to PowerBI
• Development and design of professional reports and dashboards to support various stakeholders within the company.
• Testing, debugging and reconciliation of data to source data to ensure data integrity.
• Ensure accuracy and integrity of data and its attribution to costs incurred by business.
• Communicate progress, including easily understandable representation of the data.
• Pro-active in suggesting opportunities as well as making analytical observations on any aspect that would be beneficial to business.
• Design, develop, and implement robust and scalable data warehouse solutions.
• Develop, maintain, and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading.
• Collaborate with stakeholders, including business analysts and data scientists, to understand data requirements and translate them into technical specifications.
• Ensure data quality, accuracy, and consistency across all data warehouse components.
• Monitor and optimize data warehouse performance, troubleshooting issues as they arise.
• Implement data governance and security best practices.
• Provide technical guidance and mentorship to junior developers.
• Stay updated with industry trends and emerging technologies in data warehousing and analytics.

Job description

Momentum in Centurion, Gauteng, is seeking a Senior Data Warehouse Developer to design, build, and maintain data warehouse solutions ensuring data integrity and performance. You will extract, transform and load data from multiple sources, model data, and present insights with Power BI and other visualization tools for technical and non-technical audiences.

The role requires 5 years’ DW experience, strong SQL, ETL expertise, familiarity with Kimball and Inmon methods, and the ability to mentor