Senior Data Warehouse Developer MMH260203-1 - Centurion
12 hours ago
Job description
Role PurposeWe're looking for a skilled and experienced Senior Data Warehouse Developer to join our team.
In this pivotal role, the Senior Data Warehouse Developer will be instrumental in designing, developing, and maintaining our data warehouse solutions, ensuring data integrity, performance, and accessibility.
The Senior Data Warehouse Developer will also be responsible for gathering, analyzing, and interpreting data from various sources, extracting clear, precise, and actionable insights.
A key part of the role will be to present these insights using easily understandable data representations for both technical and non-technical audiences.
RequirementsProven experience (5 years) as a Data Warehouse Developer or in a similar role.
3-year degree in Mathematics, Economics, Computer Science, Information Management or Statistics
Introductory Cloud Certification - Desirable
Strong proficiency in SQL and experience with various relational and non-relational databases.
Extensive experience with ETL/ELT tools and methodologies (e.g., SSIS, Data Factory, Informatica, Talend, etc.).
Solid understanding of data warehousing concepts, including Kimball and Inmon methodologies.
Experience with data modeling (dimensional modeling, snowflake, star schemas).
Familiarity with cloud data platforms (e.g., Azure Synapse, AWS Redshift, Google BigQuery) is a plus.
Experience with data visualization tools (e.g., Power BI, Tableau) is beneficial.
Excellent problem-solving, analytical, and communication skills.
Ability to work independently and as part of a team.
Advantageous Experience
Experience with big data technologies (e.g., Spark, Hadoop).
Knowledge of scripting languages (e.g., Python, PowerShell).
Experience with version control systems (e.g., Git).
Experience in ETL and visualisation tools (e.g. SQL, Informatica, QlikView, PowerBI etc.)
Duties and Responsibilities
Internal Process
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 for 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.
Client
Provide authoritative expertise and advice to clients and stakeholders.
Continuous interaction with clients and internal stakeholders.
Deliver on service level agreements made with clients and internal and external stakeholders in order to ensure that client expectations are met.
Participate and contribute to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service.People
Develop and maintain productive and collaborative working relationships with peers and stakeholders.
Continuously develop own expertise in terms of professional, industry and legislation knowledge.
Contribute to continuous innovation through the development, sharing and implementation of new ideas.
Take ownership for driving career development.
As an applicant, please verify the legitimacy of this job advert on our company career page
Similar jobs
We're looking for a skilled and experienced Data Warehouse Developer to join our team. · In this pivotal role, the Data Warehouse Developer will be instrumental in designing, developing, and maintaining our data warehouse solutions, · ensuring data integrity, performance, and acc ...
2 weeks ago
We're looking for a skilled and experienced Senior Data Warehouse Developer to join our team. · The Senior Data Warehouse Developer will be instrumental in designing, developing, and maintaining our data warehouse solutions, · ensuring data integrity, performance, and accessibili ...
2 weeks ago
To design and develop websites that meet high standards of visual appeal, usability, · & technical performance. Ensure optimal site functionality... · ...
3 weeks ago
+ Job summary: To design and develop websites that meet high standards of visual appeal, usability, and technical performance. · + Responsibilities:Advise on the design, creation, testing and documentation of new and enhanced applications and systems in accordance with agreed fra ...
3 weeks ago
Investment Development Consultant (Pretoria) MMH251008-1
Only for registered members
The Investment Development Consultant uses innovative engagement and influence techniques to market Momentum Investments to IFAs that have potential to do business with us. · Requirements · Qualifications: · 3-year BCom degree in the following fields: Business Management, Investm ...
1 month ago
This position focuses on software development, with responsibilities including defining test scenarios, developing automated tests, and facilitating code reviews. The role requires collaboration with the team to improve test automation skills and knowledge of software products. · ...
3 days ago
· Senior RF Engineer vacancy in Centurion. Degree or Diploma in Electrical or Electronic Engineering. Must have 1-2 years of working experience in a Senior capacity with design management and Product management experience. · Senior RF Engineer · Centurion · The successful incum ...
1 day ago
· Description · Main Purpose: To sell policies, recruit, develop and train representatives to achieve the set target · To be developed into a Sales Manager when vacancies are available (Key Individual) · - 1 year Programme · Courses · - Full-Time Academic School: 0 – 1 month · - ...
15 hours ago
A specialist international design company in Centurion is recruiting for a Senior Antenna Engineer with BEng Hons (Electronic engineer) or Masters or PhD and a minimum of 8 years relevant working experience. · ...
6 days ago
We are looking for talented IT professionals to join our technical team at IPT. Whether you are starting your journey or are a seasoned industry veteran, we have a place for you in our tiered Systems Engineering structure. · We are hiring across the board for Tier 1, Tier 2, and ...
1 month ago
We are looking for a driven and analytical professional with a strong background in Supply Chain and a passion for Technology, Data, and Process Improvement. · Project Management & Implementation · ...
6 days ago
The ideal candidate is a qualified Preschool and Level 1 to 3 artistic Gymnastics Coach capable of developing, planning, and executing lesson plans. The position requires a passion for gymnastics, a love for teaching, and a commitment to the development of young athletes. · Devel ...
6 days ago
IQVIA is seeking a dynamic and purpose-driven Sales Lead to champion a specialized Dental Portfolio across the Gauteng region. This is a leadership-focused, field-based position ideal for a commercially minded professional who thrives on influencing dental practitioners, driving ...
3 days ago
The Sales Manager is accountable for driving revenue growth through strategic leadership of the sales function. This role requires hands-on management of sales operations team development and client relationships while ensuring strict adherence to company products pricing and pro ...
4 days ago
The Sales Manager is accountable for driving revenue growth through strategic leadership of the sales function. · Grade 12/School Leaving Certificate (essential) · Sales/Marketing qualification (essential) · ...
4 days ago
Hire Resolve's client in the Information Technology industry is urgently seeking a Junior Software Engineer in Centurion. · ...
6 days ago
We are seeking a motivated and talented Finance graduate to join our team in Centurion. The ideal candidate will have a strong academic background in finance or a related field and possess excellent analytical and problem-solving skills. · Assist in financial analysis and reporti ...
6 days ago
This is a full-time hybrid role for a Business Intelligence Development Manager based in Centurion. · Designing, building, and implementing business intelligence solutions. · Leading data-driven projects. · ...
1 month ago
We are recruiting a Junior Test Automation Engineer to support manual and automated testing across the SDLC within an Agile delivery team. · ...
4 weeks ago
The successful incumbent will be responsible for managing and/or supervising other actuarial staff. · Maintain, develop, and implement market leading Short-term Insurance pricing models. · Explore and identify data and rating enhancements to inform pricing models. · ...
3 weeks ago