22 Data Warehouse jobs in South Africa
Data Warehouse Analyst
Centurion, Gauteng
Keo-Kutlwi Group (Pty)Ltd
Posted 3 days ago
Job Viewed
Job Description
Job summary: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
Job Requirements: br>• Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity. < r>• ontribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability. < r>• D velop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse. < r>• C nduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions. < r>• D sign, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively. < r>• M nitor the performance of BI solutions and identify areas for improvement. < r>• C eate and maintain documentation for data sources, ETL processes, reports, and dashboards. < r>• E fectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences. < r>• S ay up-to-date with the latest BI trends, tools, and techniques. < r>• M ntor junior analysts and provide guidance on best practices. < r>
Educational Requirements:
• B chelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience. < r>
Experience Required:
• 5 8 years of experience in Data Warehouse analysis. < r>• 5 years’ experience in data modelling in a Data Warehouse.
Skills, knowledge and abilities:
• Str ng understanding of data warehousing concepts, ETL processes, and data modeling techniques. < r>• P oficiency in SQL and experience working with relational databases. < r>• E perience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker). < r>• S rong analytical and problem-solving skills. < r>• E cellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences. < r>• A ility to work independently and as part of a team. < r>• E perience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus. < r>• E perience with scripting languages (e.g., Python, R) is a plus. < r>• K owledge of statistical methods and techniques is a plus
Job Requirements: br>• Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity. < r>• ontribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability. < r>• D velop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse. < r>• C nduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions. < r>• D sign, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively. < r>• M nitor the performance of BI solutions and identify areas for improvement. < r>• C eate and maintain documentation for data sources, ETL processes, reports, and dashboards. < r>• E fectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences. < r>• S ay up-to-date with the latest BI trends, tools, and techniques. < r>• M ntor junior analysts and provide guidance on best practices. < r>
Educational Requirements:
• B chelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience. < r>
Experience Required:
• 5 8 years of experience in Data Warehouse analysis. < r>• 5 years’ experience in data modelling in a Data Warehouse.
Skills, knowledge and abilities:
• Str ng understanding of data warehousing concepts, ETL processes, and data modeling techniques. < r>• P oficiency in SQL and experience working with relational databases. < r>• E perience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker). < r>• S rong analytical and problem-solving skills. < r>• E cellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences. < r>• A ility to work independently and as part of a team. < r>• E perience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus. < r>• E perience with scripting languages (e.g., Python, R) is a plus. < r>• K owledge of statistical methods and techniques is a plus
This advertiser has chosen not to accept applicants from your region.
0
Data Warehouse Analyst
Centurion, Gauteng
Penny The Recruiter
Posted 14 days ago
Job Viewed
Job Description
What you will be doing:
Please note that if you do not hear from us within 3 weeks, consider your application unsuccessful.
- Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
- Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
- Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
- ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
- Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
- Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
- Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.
- Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
- Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
- Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.
- Mentorship: Mentor junior analysts and provide guidance on best practices.
- Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
- 5 - 8 years of experience in Data Warehouse analysis.
- 5 years experience in data modelling in a Data Warehouse.
- Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
- Proficiency in SQL and experience working with relational databases.
- Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).
- Strong analytical and problem-solving skills.
- Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
- Ability to work independently and as part of a team.
- Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.
- Experience with scripting languages (e.g., Python, R) is a plus.
- Knowledge of statistical methods and techniques is a plus.
Please note that if you do not hear from us within 3 weeks, consider your application unsuccessful.
This advertiser has chosen not to accept applicants from your region.
1
Data warehouse analyst
Centurion, Gauteng
Psybergate
Posted today
Job Viewed
Job Description
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for a Data Warehouse Analyst to join our financial services client based in Centurion.What You Will Be Doing Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements. Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity. Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability. ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse. Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions. Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively. Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement. Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards. Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences. Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques. Mentorship: Mentor junior analysts and provide guidance on best practices. What We Are Looking ForBachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience. 5 - 8 years of experience in Data Warehouse analysis. 5 years' experience in data modelling in a Data Warehouse. Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques. Proficiency in SQL and experience working with relational databases. Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker). Strong analytical and problem-solving skills. Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences. Ability to work independently and as part of a team. Experience with cloud-based data warehousing solutions (e.g., Snowflake, Big Query, Redshift) is a plus. Experience with scripting languages (e.g., Python, R) is a plus. Knowledge of statistical methods and techniques is a plus. Please note that if you do not hear from us within 3 weeks, consider your application unsuccessful.Desired SkillsETL SQL Power BI data analysis #J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.
2
Data Warehouse Engineer
2001 Johannesburg, Gauteng
Parvana
Posted 43 days ago
Job Viewed
Job Description
About our client: Our client offers financial service solutions helping their clients achieve their dreams. With an emphasis on culture fit, they boast a dedicated team of over 600 employees, many with over a decade of tenure. They have built their culture on a feeling of togetherness, trust and respect and are always looking to support employees' continuous learning. Using Agile, they provide diverse services with a focus on research, innovation and improvement.What you will be doing: Design, develop, and modify database structures, relationships, data flows, and data interfaces within the data warehouse.Analyse, create and modify data structures to adapt to business needs and add enhanced functionality.Develop and modify ETL processes to load data from various sources into the data warehouse.Use programming languages, software development methods, and best practices to develop new data warehouse structures and reports and modify existing ones.Unit test and debug code.Participate in requirements gathering, analysis, technical design, testing, documentation and project planning.Consult with clients to gather information about needs, objectives, and requirements.Identify and propose technical solutions to client requests and system problems.Follow department standards and create written documentation and diagrams as required.Thorough understanding of data warehouse architecture, data structures, and fundamental design principles.Ability to work independently with general supervision, which may include providing guidance and support to entry-level professionals or support staff.Contribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.Responsible for software development, production support, and providing expertise in Data Warehouse and Reporting Applications.What our client is looking for: A relevant tertiary degree would be ideal (Computer Science, IT, Data Science, Information Systems, etc.)Strong interest in analytical / dimensional modelling, and data analytics tools. Insurance knowledge is a plus.In-depth knowledge of business intelligence tools including data warehousing, and ETL (Extraction, Transformation, and Load). Yellowfin knowledge is beneficial.Knowledge and understanding of the software development life cycle.Knowledge and experience in relational databases, SQL, PostgreSQL.Experience in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms.Analytical and troubleshooting skills for complex technical issues and tasks.Ability to present and explain complex technical topics, problems, and alternative solutions to others.Experience estimating solution development and delivering solutions within those estimations.Knowledge of Insurance Systems.Experience with or knowledge of most of the following software, languages and tools, or similar products would be preferred: SQL Server DBMS, T-SQL (ANSI), PostgreSQL, Python.Job ID: J106874For a more comprehensive list of opportunities that we have on offer, do visit our website -
This advertiser has chosen not to accept applicants from your region.
3
Senior Data Warehouse Developer
Bellville, Western Cape
Momentum Group Limited
Posted 13 days ago
Job Viewed
Job Description
Join to apply for the Senior Data Warehouse Developer role at Momentum Group Limited .
Get AI-powered advice on this job and more exclusive features.
Metropolitan is one of the oldest financial services brands in South Africa, with a 125-year legacy of serving communities through affordable financial solutions that promote growth and security. Operating in South Africa and seven other African countries, Metropolitan offers products like funeral insurance, health, savings, hospital cash-back cover, retirement solutions, and life insurance.
Role Purpose
Are you passionate about data architecture and analytics? We seek a Data Warehouse Developer to design and develop dimensional data models, data marts, and enterprise data models using MS SQL. You will shape our data infrastructure, ensuring efficient data storage, retrieval, and processing across analytical platforms using various tools.
Requirements
- Matric
- Degree in Information Technology, Data Science, Computer Science, or relevant equivalent qualification
- 5+ years of experience in Business Intelligence development, specifically in data warehouse environments
Duties & Responsibilities
Internal Process
- Design, develop, and maintain efficient dimensional data models and data marts.
- Architect enterprise data models to support analytical and business intelligence needs.
- Implement and maintain ETL processes for data integration.
- Collaborate with cross-functional teams to gather data requirements and ensure high-quality data solutions.
- Optimize query performance for high availability and responsiveness.
- Ensure data integrity, security, and consistency across systems.
- Mentor junior developers and promote best practices.
- Improve data warehouse architecture to meet evolving business needs.
Client
- Provide expertise and advice to clients and stakeholders.
- Build and maintain relationships with internal and external stakeholders.
- Deliver on service level agreements.
- Make recommendations to enhance client service.
- Contribute to a culture of rewarding relationships and feedback.
People
- Develop collaborative relationships with peers and stakeholders.
- Participate in change initiatives.
- Continuously develop professional expertise.
- Innovate through new ideas.
- Drive personal career development.
Finance
- Identify opportunities for cost efficiency and operational improvements.
- Contribute to risk identification and communicate recommendations.
Competencies
- Examining Information
- Interpreting Data
- Developing Expertise
- Providing Insights
- Articulating Information
- Meeting Timescales
- Attention to detail
- Producing Output
- Mid-Senior level
- Full-time
- Information Technology
This advertiser has chosen not to accept applicants from your region.
4
Data Warehouse Business Analyst
Cape Town, Western Cape
Status Staffing
Posted 19 days ago
Job Viewed
Job Description
Data Warehouse Business Analyst
Reference: PC001563-RC-2
Our client based in Durbanville is looking for a Data Warehouse Business Analyst with proven experience as a business analyst in data warehousing projects to join their team.
EMPLOYMENT TYPE: Permanent
SECTOR: Admin
BASIC SALARY: R45 000
START DATE: A.S.A.P / Immediate
- 3+ Years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment
- Microsoft Office (Word, Excel, PowerPoint)
- Bachelor's degree in Computer Science, Information Technology, Business, or a related field
- Proven experience as a business analyst in data warehousing projects.
- Strong understanding of data modelling concepts and techniques
- Collaborate with business stakeholders to gather and document detailed requirements for data warehouse projects
- Understand and analyse business processes to identify data-related needs and opportunities for improvement
- Work closely with end-users to define data requirements, ensuring they align with business goals
- Assist in the design and development of data models that support business requirements
- Collaborate with data architects and data engineers to create logical and physical data models for the data warehouse
- Ensure data models adhere to best practices and align with organizational standards
- Conduct data profiling and analysis on source systems to understand data quality, integrity, and relationships
- Identify and document data anomalies, discrepancies, and patterns that may impact the effectiveness of the data warehouse
- Create and maintain comprehensive documentation for data warehouse requirements, data models, and processes
- Facilitate communication between business users and technical teams, translating business requirements into technical specifications
- Collaborate with data engineers, ETL developers, and other stakeholders to ensure the successful implementation of data warehouse solutions
- Participate in the testing and validation of data warehouse solutions to ensure they meet business requirements and adhere to data quality standards
- Identify and address issues related to data accuracy, completeness, and timeliness
- Provide training and support to end-users on accessing and utilizing data warehouse solutions
- Assist in the development of user documentation and training materials
- Stay informed about industry best practices, emerging technologies, and trends related to data warehousing
- Proactively identify opportunities for process improvement and optimization of data warehouse solutions
- Mon – Fri: 08:00 – 17:00
Should you meet all the requirements, apply on our website at today. Should you not hear back from us within 10 working days, please consider your application as unsuccessful. We will retain your credentials for future similar roles.
Package & RemunerationR45 000
#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.
5
Data Warehouse Business Analyst
Cape Town, Western Cape
Intellistaff
Posted 19 days ago
Job Viewed
Job Description
Reference: JHB003043-SS-2
Our client in the finance/investment space is urgently looking to employ an experienced Data Warehouse Business Analyst at their organization.
Duties & ResponsibilitiesLocation: De Bron, Bellville
Job Description: To play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding business requirements, analysing data sources, and collaborating with stakeholders to ensure the effective design, development, and maintenance of data warehouses. To serve as a liaison between business users and technical teams to ensure that data warehouse solutions align with organizational objectives.
- Degree in Computer Science, Information Technology, or related field
- 5+ years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment
- Proven experience as a business analyst in data warehousing projects.
- Strong understanding of data modelling concepts and techniques.
- Proficiency in SQL and knowledge of database systems will be advantageous.
- Excellent communication and interpersonal skills.
- Analytical mindset with a keen attention to detail.
- Familiarity with business intelligence tools and reporting concepts.
- Collaborate with business stakeholders to gather and document detailed requirements for data warehouse projects.
- Understand and analyse business processes to identify data-related needs and opportunities for improvement.
- Assist in the design and development of data models that support business requirements.
- Collaborate with data architects and data engineers to create logical and physical data models for the data warehouse.
- Create and maintain comprehensive documentation for data warehouse requirements, data models, and processes.
- Ensure documentation is kept up-to-date and readily available for reference by both technical and non-technical stakeholders.
- Facilitate communication between business users and technical teams, translating business requirements into technical specifications.
- Collaborate with data engineers, ETL developers, and other stakeholders to ensure the successful implementation of data warehouse solutions.
- Participate in the testing and validation of data warehouse solutions to ensure they meet business requirements and adhere to data quality standards.
- Identify and address issues related to data accuracy, completeness, and timeliness.
- Provide training and support to end-users on accessing and utilizing data warehouse solutions.
- Assist in the development of user documentation and training materials.
- Stay informed about industry best practices, emerging technologies, and trends related to data warehousing.
- Proactively identify opportunities for process improvement and optimization of data warehouse solutions.
MR - Monthly
#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.
Be The First To Know
About the latest Data warehouse Jobs in South Africa !
6
Junior Data Warehouse Developer
Centurion, Gauteng
Keo-Kutlwi Group (Pty)Ltd
Posted 3 days ago
Job Viewed
Job Description
• Gather, analyse and interpret data from various sources, extract insights in a clear, precise and actionable manner, using easily understandable representations of data for both technical and non-technical audiences.
• evelop Power BI solutions, working from high level technical requirements in line with business requirements. br>• Q ality assurance checks on all new Power BI project functionality and business requirements. < r>• C nfigure realtime replication of data from source system to the Data Warehouse, using tools like Stelo SQDR < r>• P rtake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting < r>• B sic 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. < r>• P omote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles. < r>• P omote reusability, maintainability, reliability, and scalability in design and development of data solutions. < r>• P ocess live and confidential data according to specified guidelines. < r>• C nvert Legacy Excel reports to PowerBI < r>• D velopment and design of professional reports and dashboards to support various stakeholders within the company. < r>• T sting, debugging and reconciliation of data to source data to ensure data integrity. < r>• E sure accuracy and integrity of data and its attribution to costs incurred by business. < r>• C mmunicate progress, including easily understandable representation of the data. < r>• P o-active in suggesting for opportunities as well as making analytical observations on any aspect that would be beneficial to business. < r>
Experience required:
• 1 3 years' experience as a Junior Data Warehouse/MIS Developer or related field (essential) < r>• E perience in ETL and visualisation tools (e.g. SQL, Informatica, QlikView, PowerBI etc.) < r>• E try level Data Replication experience, e.g. Stelo SQDR, Qlik Replicate, etc. < r>• I termediate SQL Server 2022, Intermediate SSIS < r>• I termediate SQL Developer/ Data Warehouse skills with MS T-SQL < r>
Education required:
• D gree in Mathematics, Economics, Computer Science, Information Management or Statistics < r>• I troductory Cloud Certification - Desirable
• evelop Power BI solutions, working from high level technical requirements in line with business requirements. br>• Q ality assurance checks on all new Power BI project functionality and business requirements. < r>• C nfigure realtime replication of data from source system to the Data Warehouse, using tools like Stelo SQDR < r>• P rtake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting < r>• B sic 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. < r>• P omote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles. < r>• P omote reusability, maintainability, reliability, and scalability in design and development of data solutions. < r>• P ocess live and confidential data according to specified guidelines. < r>• C nvert Legacy Excel reports to PowerBI < r>• D velopment and design of professional reports and dashboards to support various stakeholders within the company. < r>• T sting, debugging and reconciliation of data to source data to ensure data integrity. < r>• E sure accuracy and integrity of data and its attribution to costs incurred by business. < r>• C mmunicate progress, including easily understandable representation of the data. < r>• P o-active in suggesting for opportunities as well as making analytical observations on any aspect that would be beneficial to business. < r>
Experience required:
• 1 3 years' experience as a Junior Data Warehouse/MIS Developer or related field (essential) < r>• E perience in ETL and visualisation tools (e.g. SQL, Informatica, QlikView, PowerBI etc.) < r>• E try level Data Replication experience, e.g. Stelo SQDR, Qlik Replicate, etc. < r>• I termediate SQL Server 2022, Intermediate SSIS < r>• I termediate SQL Developer/ Data Warehouse skills with MS T-SQL < r>
Education required:
• D gree in Mathematics, Economics, Computer Science, Information Management or Statistics < r>• I troductory Cloud Certification - Desirable
This advertiser has chosen not to accept applicants from your region.
7
Senior Data Warehouse Developer
Centurion, Gauteng
Keo-Kutlwi Group (Pty)Ltd
Posted 3 days ago
Job Viewed
Job Description
• Develop Power BI solutions, working from high level technical requirements in line with business requirements.
• uality assurance checks on all new Power BI project functionality and business requirements. br>• P oduce documentation for code written. < r>• C nfigure real-time replication of data from source system to the Data Warehouse, using tools like Stelo SQDR < r>• P rtake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting. < r>• B sic 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. < r>• P omote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles. < r>• P omote reusability, maintainability, reliability, and scalability in design and development of data solutions. < r>• P ocess live and confidential data according to specified guidelines. < r>• C nvert Legacy Excel reports to PowerBI < r>• D velopment and design of professional reports and dashboards to support various stakeholders within the company. < r>• T sting, debugging and reconciliation of data to source data to ensure data integrity. < r>• E sure accuracy and integrity of data and its attribution to costs incurred by business. < r>• C mmunicate progress, including easily understandable representation of the data. < r>• P o-active in suggesting for opportunities as well as making analytical observations on any aspect that would be beneficial to business. < r>• D sign, develop, and implement robust and scalable data warehouse solutions. < r>• D velop, maintain, and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading. < r>• C llaborate with stakeholders, including business analysts and data scientists, to understand data requirements and translate them into technical specifications. < r>• E sure data quality, accuracy, and consistency across all data warehouse components. < r>• M nitor and optimize data warehouse performance, troubleshooting issues as they arise. < r>• I plement data governance and security best practices. < r>• P ovide technical guidance and mentorship to junior developers. < r>• S ay updated with industry trends and emerging technologies in data warehousing and analytics. < r>
Experience Required:
• P oven experience (5+ years) as a Data Warehouse Developer or in a similar role. < r>• 3 year degree in Mathematics, Economics, Computer Science, Information Management or Statistics < r>• I troductory Cloud Certification - Desirable < r>• S rong proficiency in SQL and experience with various relational and non-relational databases. < r>• E tensive experience with ETL/ELT tools and methodologies (e.g., SSIS, Data Factory, Informatica, Talend, < r> etc.).
• S lid understanding of data warehousing concepts, including Kimball and Inmon methodologies. < r>• E perience with data modeling (dimensional modeling, snowflake, star schemas). < r>• F miliarity with cloud data platforms (e.g., Azure Synapse, AWS Redshift, Google BigQuery) is a plus. < r>• E perience with data visualization tools (e.g., Power BI, Tableau) is beneficial. < r>
Skills, knowledge and abilities:
• E cellent problem-solving, analytical, and communication skills. < r>• A ility to work independently and as part of a team.
• uality assurance checks on all new Power BI project functionality and business requirements. br>• P oduce documentation for code written. < r>• C nfigure real-time replication of data from source system to the Data Warehouse, using tools like Stelo SQDR < r>• P rtake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting. < r>• B sic 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. < r>• P omote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles. < r>• P omote reusability, maintainability, reliability, and scalability in design and development of data solutions. < r>• P ocess live and confidential data according to specified guidelines. < r>• C nvert Legacy Excel reports to PowerBI < r>• D velopment and design of professional reports and dashboards to support various stakeholders within the company. < r>• T sting, debugging and reconciliation of data to source data to ensure data integrity. < r>• E sure accuracy and integrity of data and its attribution to costs incurred by business. < r>• C mmunicate progress, including easily understandable representation of the data. < r>• P o-active in suggesting for opportunities as well as making analytical observations on any aspect that would be beneficial to business. < r>• D sign, develop, and implement robust and scalable data warehouse solutions. < r>• D velop, maintain, and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading. < r>• C llaborate with stakeholders, including business analysts and data scientists, to understand data requirements and translate them into technical specifications. < r>• E sure data quality, accuracy, and consistency across all data warehouse components. < r>• M nitor and optimize data warehouse performance, troubleshooting issues as they arise. < r>• I plement data governance and security best practices. < r>• P ovide technical guidance and mentorship to junior developers. < r>• S ay updated with industry trends and emerging technologies in data warehousing and analytics. < r>
Experience Required:
• P oven experience (5+ years) as a Data Warehouse Developer or in a similar role. < r>• 3 year degree in Mathematics, Economics, Computer Science, Information Management or Statistics < r>• I troductory Cloud Certification - Desirable < r>• S rong proficiency in SQL and experience with various relational and non-relational databases. < r>• E tensive experience with ETL/ELT tools and methodologies (e.g., SSIS, Data Factory, Informatica, Talend, < r> etc.).
• S lid understanding of data warehousing concepts, including Kimball and Inmon methodologies. < r>• E perience with data modeling (dimensional modeling, snowflake, star schemas). < r>• F miliarity with cloud data platforms (e.g., Azure Synapse, AWS Redshift, Google BigQuery) is a plus. < r>• E perience with data visualization tools (e.g., Power BI, Tableau) is beneficial. < r>
Skills, knowledge and abilities:
• E cellent problem-solving, analytical, and communication skills. < r>• A ility to work independently and as part of a team.
This advertiser has chosen not to accept applicants from your region.
8
Data warehouse business analyst
Cape Town, Western Cape
Intellistaff
Posted today
Job Viewed
Job Description
Reference: JHB003043-SS-2 Our client in the finance/investment space is urgently looking to employ an experienced Data Warehouse Business Analyst at their organization. Duties & Responsibilities Location: De Bron, BellvilleJob Description: To play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding business requirements, analysing data sources, and collaborating with stakeholders to ensure the effective design, development, and maintenance of data warehouses. To serve as a liaison between business users and technical teams to ensure that data warehouse solutions align with organizational objectives. Requirements and Skills Degree in Computer Science, Information Technology, or related field 5+ years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment Proven experience as a business analyst in data warehousing projects. Strong understanding of data modelling concepts and techniques. Proficiency in SQL and knowledge of database systems will be advantageous. Excellent communication and interpersonal skills. Analytical mindset with a keen attention to detail. Familiarity with business intelligence tools and reporting concepts. Responsibilities Requirement Analysis Collaborate with business stakeholders to gather and document detailed requirements for data warehouse projects. Understand and analyse business processes to identify data-related needs and opportunities for improvement. Data Modelling Assist in the design and development of data models that support business requirements. Collaborate with data architects and data engineers to create logical and physical data models for the data warehouse. Data Profiling and Analysis Create and maintain comprehensive documentation for data warehouse requirements, data models, and processes. Ensure documentation is kept up-to-date and readily available for reference by both technical and non-technical stakeholders. Communication and Collaboration Facilitate communication between business users and technical teams, translating business requirements into technical specifications. Collaborate with data engineers, ETL developers, and other stakeholders to ensure the successful implementation of data warehouse solutions. Quality Assurance Participate in the testing and validation of data warehouse solutions to ensure they meet business requirements and adhere to data quality standards. Identify and address issues related to data accuracy, completeness, and timeliness. Training and Support Provide training and support to end-users on accessing and utilizing data warehouse solutions. Assist in the development of user documentation and training materials. Continuous Improvement Stay informed about industry best practices, emerging technologies, and trends related to data warehousing. Proactively identify opportunities for process improvement and optimization of data warehouse solutions. Package & Remuneration MR - Monthly #J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.
9