33 Etl Development jobs in South Africa
Data and Transformation Architect.COE COE.Information Technology (Business Services)(J30001)
Posted 5 days ago
Job Viewed
Job Description
Join to apply for the Data and Transformation Architect.COE COE.Information Technology (Business Services)(J30001) role at Airports Company South Africa
Data and Transformation Architect.COE COE.Information Technology (Business Services)(J30001)Join to apply for the Data and Transformation Architect.COE COE.Information Technology (Business Services)(J30001) role at Airports Company South Africa
Responsibilities
The successful candidate will be reporting to the Senior Manager Enterprise architecture and will be responsible for but not limited to the following:
- Design compelling technology solutions in alignment with the business’ strategic objective and requirements.
- Define, integrate, and upgrade a comprehensive architecture to support applications, platforms, and databases.
- Ensure solutions are designed as per business requirements and as per enterprise IT standards; with minimum and agreed variance from functional and technical specifications.
- Translating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses.
- Defining the data architecture framework, standards and principles, including modelling, metadata, security, reference data.
- To provide modelling, design, development, preparation, implementation and optimization of data.
- Document security requirements and controls for protecting information, systems, and technology assets.
- Provide technical / professional support to internal and external stakeholders to ensure achievement of functional and organisational objectives.
- Build, support and maintain healthy, diverse internal and external relationships (government, authorities and agencies) to ensure achievement of organisational goals. Implement remedial actions where required.
- Adhere to and ensure adherence to statutory regulations, organisational standards, policies and procedures. Report non-compliance and implement corrective actions to ensure compliance.
- Plan, schedule, supervise and coach subordinate activities within processes or services to achieve efficiency and quality goals.
- Assure stable employee relations by managing conflict and creating a positive working environment.
Key Performance Outputs
Responsibilities
The successful candidate will be reporting to the Senior Manager Enterprise architecture and will be responsible for but not limited to the following:
- Design compelling technology solutions in alignment with the business’ strategic objective and requirements.
- Define, integrate, and upgrade a comprehensive architecture to support applications, platforms, and databases.
- Ensure solutions are designed as per business requirements and as per enterprise IT standards; with minimum and agreed variance from functional and technical specifications.
- Translating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses.
- Defining the data architecture framework, standards and principles, including modelling, metadata, security, reference data.
- To provide modelling, design, development, preparation, implementation and optimization of data.
- Document security requirements and controls for protecting information, systems, and technology assets.
- Provide technical / professional support to internal and external stakeholders to ensure achievement of functional and organisational objectives.
- Build, support and maintain healthy, diverse internal and external relationships (government, authorities and agencies) to ensure achievement of organisational goals. Implement remedial actions where required.
- Adhere to and ensure adherence to statutory regulations, organisational standards, policies and procedures. Report non-compliance and implement corrective actions to ensure compliance.
- Plan, schedule, supervise and coach subordinate activities within processes or services to achieve efficiency and quality goals.
- Assure stable employee relations by managing conflict and creating a positive working environment.
The following skills and experience or the equivalent of such, will be required:
- Matric - Essential
- Bachelor's Degree – Information Technology - Essential
- Certificate – Recognized architecture framework (e.g. Zachman, TOGAF) - Advantageous
- 3 years Operational Experience – Data and Transformation architect
- MS Office - Advanced
- Attention to detail
- Communication
- Problem Solving
- Decision Making
- Planning and Organising
- Analytical Thinking
- Risk Management etc.
Kindly apply online for this opportunity following the Oracle link below
Career Portal (sharepoint.com) by the Ref: ID:
Shortlisted candidates will be required to provide proof of their qualifications, NQF level and credits and must be eligible for Top Security Clearance within 3 months of appointment.
Positions will be filled in line with Airports Company South Africa values and Employment Equity Policy and Plan.
Should you not hear from Airports Company South Africa within 30 days, please consider your application unsuccessful.Seniority level
- Seniority level Mid-Senior level
- Employment type Full-time
- Job function Engineering and Information Technology
- Industries Aviation and Aerospace Component Manufacturing
Referrals increase your chances of interviewing at Airports Company South Africa by 2x
Sign in to set job alerts for “Data Architect” roles.Bryanston, Gauteng, South Africa 1 month ago
Centurion, Gauteng, South Africa 6 days ago
Specialist: Data Architect 2 year contractJohannesburg, Gauteng, South Africa 1 month ago
Senior Data Business Analyst MMH250603-15Centurion, Gauteng, South Africa 20 hours ago
Centurion, Gauteng, South Africa 5 days ago
Johannesburg, Gauteng, South Africa 1 month ago
Solution Architect – Government & Public Services – Senior ManagerCity of Johannesburg, Gauteng, South Africa 1 day ago
City of Johannesburg, Gauteng, South Africa 1 day ago
Johannesburg Metropolitan Area 1 month ago
Principal Systems Design / Architecture EngineerJohannesburg, Gauteng, South Africa 1 day ago
Integration Specialist/Architect Job SpecificationCenturion, Gauteng, South Africa 16 hours ago
Johannesburg Metropolitan Area 5 hours ago
Johannesburg, Gauteng, South Africa 1 month ago
Application Architect - SAP HANA Master Data GovernanceSandton, Gauteng, South Africa 2 months ago
Johannesburg, Gauteng, South Africa 6 days ago
Centurion, Gauteng, South Africa 6 days ago
Banking Business Analyst - Digital/AI/DataCity of Johannesburg, Gauteng, South Africa 4 days ago
Salesforce Technical Lead - Senior ManagerMidrand, Gauteng, South Africa 1 month ago
Johannesburg, Gauteng, South Africa 6 days ago
Johannesburg, Gauteng, South Africa 1 week ago
Customer Engineer III, Data and AI, Google CloudJohannesburg, Gauteng, South Africa 1 week ago
Johannesburg, Gauteng, South Africa 7 hours ago
Data Engineer I - QuantumBlack, AI by McKinseyJohannesburg, Gauteng, South Africa 1 week ago
Johannesburg Metropolitan Area 2 days ago
Johannesburg, Gauteng, South Africa 4 days ago
Johannesburg Metropolitan Area 4 days ago
Centurion, Gauteng, South Africa 6 days ago
Centurion, Gauteng, South Africa 20 hours ago
Johannesburg, Gauteng, South Africa 1 week ago
Centurion, Gauteng, South Africa 20 hours ago
Centurion, Gauteng, South Africa 20 hours ago
Johannesburg, Gauteng, South Africa 1 week ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-LjbffrManager - Business Transformation (Data Strategy/Data Governance)
Posted 5 days ago
Job Viewed
Job Description
From the beginning, our goal was to establish an advisory firm that stands apart from the rest – one that is grounded in our Core Values and dedicated to creating a positive experience not just for our clients, but for our people too. We firmly believe in the strength of collaboration, enthusiasm, generosity, and perseverance as the driving forces behind our success. With advisory solutions spanning accounting and risk, technology-enabled transformation, and transactions, we partner with our clients to solve today’s challenges and deliver present and future value.
Our commitment to our people has earned us numerous awards including Inc5000's Fastest Growing Companies and Glassdoor's Best Places to Work. Explore what our employees have to say about our unique culture by clicking here .
By joining our rapidly growing Business Transformation team you will serve as a trusted partner to our clients. You’ll bring your first-hand experience, unique perspectives, and functional knowledge to deliver tailored, strategic solutions. These not only address today's challenges but also lay the groundwork for future success. With support from experienced leaders and a dedicated coach, you will join a collaborative community that encourages contributions beyond the scope of client delivery.
What You'll Do:- Working with high-performing teams to analyze, evaluate and enhance our clients businesses, including processes, governance, data and technologies
- Lead our clients and teams on their data journey which includes collaborating on their strategic vision for data, crafting a pragmatic roadmap of initiatives, and aiding our clients in the implementation of these initiatives, aligned to business objectives
- Ability to drive data governance framework design and facilitate policies and procedures development in line to meet the strategic and regulatory objectives of our clients related to data governance, data management, data quality, data risk management, and data privacy and security
- Collaborate seamlessly with key senior stakeholders, including business, IT teams and data owners to identify data needs
- Conduct interviews with clients to perform current state/future state gap analysis and identify the root causes of client’s challenges
- Drive data culture and data adoption programs for clients who struggle with firmwide understanding of data ROI
- Establish KPIs related to data quality and data risk, controls, and remediation plans
- Develop roadmaps to developing data assets and data commercialization
- Drive program/project management activities including status reporting or maintain RAID logs, and able to conduct scrum meetings for defect / development management
- Support CrossCountry leadership team on internal projects, including but not limited to the following: sales/marketing initiatives, recruiting, and organizational development
- 7+ years of relevant experience and track recording delivering transformation programs into CDO, CTO, COO, CFO, and/or CRO organizations
- Strong strategic planning skills with past experience working with C-Suites executives to build out Organizational Level Strategic Roadmaps
- Up-to-date on latest industry trends in industry trends and best practices in data strategy and governance
- Knowledge of industries, including investment banking, broker-dealers, custody, fund administration and investment management
- Proven leadership roles with strong communication and presentation skills
- Professionalism and discretion in interacting with executives and clients
- Proficiency in one or more of the following: Collibra, OvalEdge, Atlan, Talend, SAP Master, BigID, OneTrust
- Experience in tools such as Tableau, PowerBI, Alteryx, Snowflake
- Bachelor’s degree in Business, Economics, Engineering, Information Systems, Mathematics, Data Analytics, or similar discipline
#LI-MH1
#LI-Remote
Benefits Summary
The CrossCountry total rewards package includes comprehensive healthcare options, including medical, dental, and vision coverage; flexible spending accounts; and a 401(k) with company matching. Additionally, employees can take advantage of generous parental and maternity leave policies, technology stipends, and wellness reimbursement programs, all designed to support both professional growth and personal well-being. For detailed information about benefits at CrossCountry, please visit our dedicated benefits site: .
Equal Employment Opportunity (EEO)
CrossCountry provides equal employment opportunities (EEO) to all employeesand applicants for employment and believes that respect and fair treatment are critical to creating a productive and inclusive workplace.
As an equal opportunity employer, CrossCountry is fully committed to comply with all federal, state, and local laws and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability, pregnancy, genetics, sexual orientation, veteran status, gender identity or expression or any other protected characteristic. The company also complies with pay transparency and labor laws applicable to all terms and conditions of employment.
#J-18808-LjbffrManager - business transformation (data strategy/data governance)
Posted today
Job Viewed
Job Description
Manager - business transformation (data strategy/data governance)
Posted today
Job Viewed
Job Description
Data Scientist (Pipeline)
Posted 13 days ago
Job Viewed
Job Description
A Data Scientist will often work as part of a multidisciplinary team, using data and analytics to inform and achieve organisational goals, exploring existing and new data using a range of statistical tools and techniques.
Job DescriptionData Scientist
Job Purpose:
You will provide high-level strategic and tactical insights to identify, prioritize, and drive improvement initiatives. Delivering innovative solutions for the business by surfacing underlying opportunities, highlighting factual data & information, and narrating ‘the story’ around those opportunities. Also, providing expert consultancy to Capita’s clients on the design and implementation of complex projects & programmes.
The aim of this role is to aid our clients in providing a world-class customer service and experience, unlocking problems and providing supportive solutions. This is achieved by supporting Capita’s internal operations around key performance indicators (Customer Satisfaction, Right First Time, AHT, etc.) and the clients' internal business processes with tangible and actionable insights and recommendations. The vision is for Capita to be acknowledged (through awards, client loyalty, winning new business, and reputation) as Contact Centre industry experts in customer experience.
Key Responsibilities:
- Deliver innovative and industry-leading insights, along with improvement recommendations for Capita and our clients.
- Conduct insight reviews through the application of advanced analytics, using internal and external data sources.
- Use sophisticated predictive modeling to understand what changes need to be made to realize improvement.
- Consider impacts from operational and client change requests when understanding benefit realization.
- Understand commercial aspects to ensure recommendations support the business plan.
- Lead the insight direction to support and align with the operational strategy.
- Provide expert views on customer satisfaction and loyalty methodologies such as Net Promoter Score.
- Collaborate with shared services MI teams to integrate disparate data sets, supporting automation and efficiency.
- Support delivery of improvements through root cause analysis and performance review over time.
- Articulate options and recommendations to stakeholders, highlighting benefits and challenges, and adapting approaches as needed.
- Stay updated with industry trends, recommending emerging technologies and new measurement approaches.
- Understand planning models to ensure benefit realization.
- Assist senior management in formulating MI & insight for decision-making and budgeting.
- Lead and support projects by analyzing data and converting it into actionable insights.
- Work with BI teams and other operational stakeholders to deliver robust services.
- Support senior management with change controls and contractual obligations.
- Mentor Analysts in teams where a managerial role is absent.
Professional Know-how:
Grade 12 / Matric
Knowledge & Experience:
- At least 2 years’ experience applying data science, preferably in a contact centre environment.
- Competent in insight, MI, analytical and statistical theories and methods.
- Strong understanding of statistical analytics, correlation, regression, cluster analysis, standard deviation, etc.
- Knowledge of MI/BI & contact centre software such as Business Objects, Power BI, Aspect WFM, Avaya Telephony, MS Office.
- Proficiency with programming tools like Power BI, Azure, Fabric, Snowflake, Python, SQL, R.
- Excellent Excel skills, including VBA, formulas, and PivotTables.
- Strong presentation skills and ability to communicate complex results clearly.
- Experience in data collation, reporting, and presentation.
- Data manipulation skills beyond Excel, including SQL.
- Knowledge of customer satisfaction/loyalty measurement techniques.
- Strong analytical skills and interest in data analysis and insight.
- Experience with evidence-based decision-making and statistical software.
- Experience with speech & text analytics applications.
- Efficient, accurate working approach and independent initiative.
- Understanding of financial and commercial considerations.
About us
Capita is an award-winning contact centre service provider with global delivery centers trusted by leading brands to transform customer experience. We aim to help you achieve your future goals, whether gaining customer service experience or growing your skills. Our services span multiple sectors and locations, working to create better outcomes for all.
Our offices feature a 6-star green rating, with amenities including a gym, clinic, creche, restaurants, pharmacy, hairdresser, and spa.
What’s in it for you?
- Competitive salary, medical aid, provident fund, and other benefits.
- Annual performance incentives.
- Participation in global networks and community programs.
- Extra leave days and international exposure opportunities.
- Development and growth prospects.
We value our employees and promote Capita’s core values: Customer First, Fearless Innovation, Achieve Together, Everyone is Valued.
Next steps:
Apply now with your CV. Your application will be reviewed, and successful candidates will be invited for an interview. Shortlisted candidates may undergo assessments. We adhere to employment equity principles and encourage diverse applications.
#J-18808-LjbffrData Scientist (Pipeline)
Posted today
Job Viewed
Job Description
A Data Scientist will often work as part of a multidisciplinary team, using data and analytics to inform and achieve organisational goals, exploring existing and new data using a range of statistical tools and techniques.
Job DescriptionData Scientist
Job Purpose:
You will provide high-level strategic and tactical insights to identify, prioritize, and drive improvement initiatives. Delivering innovative solutions for the business by surfacing underlying opportunities, highlighting factual data & information, and narrating ‘the story’ around those opportunities. Also, providing expert consultancy to Capita’s clients on the design and implementation of complex projects & programmes.
The aim of this role is to aid our clients in providing a world-class customer service and experience, unlocking problems and providing supportive solutions. This is achieved by supporting Capita’s internal operations around key performance indicators (Customer Satisfaction, Right First Time, AHT, etc.) and the clients' internal business processes with tangible and actionable insights and recommendations. The vision is for Capita to be acknowledged (through awards, client loyalty, winning new business, and reputation) as Contact Centre industry experts in customer experience.
Key Responsibilities:
- Deliver innovative and industry-leading insights, along with improvement recommendations for Capita and our clients.
- Conduct insight reviews through the application of advanced analytics, using internal and external data sources.
- Use sophisticated predictive modeling to understand what changes need to be made to realize improvement.
- Consider impacts from operational and client change requests when understanding benefit realization.
- Understand commercial aspects to ensure recommendations support the business plan.
- Lead the insight direction to support and align with the operational strategy.
- Provide expert views on customer satisfaction and loyalty methodologies such as Net Promoter Score.
- Collaborate with shared services MI teams to integrate disparate data sets, supporting automation and efficiency.
- Support delivery of improvements through root cause analysis and performance review over time.
- Articulate options and recommendations to stakeholders, highlighting benefits and challenges, and adapting approaches as needed.
- Stay updated with industry trends, recommending emerging technologies and new measurement approaches.
- Understand planning models to ensure benefit realization.
- Assist senior management in formulating MI & insight for decision-making and budgeting.
- Lead and support projects by analyzing data and converting it into actionable insights.
- Work with BI teams and other operational stakeholders to deliver robust services.
- Support senior management with change controls and contractual obligations.
- Mentor Analysts in teams where a managerial role is absent.
Professional Know-how:
Grade 12 / Matric
Knowledge & Experience:
- At least 2 years’ experience applying data science, preferably in a contact centre environment.
- Competent in insight, MI, analytical and statistical theories and methods.
- Strong understanding of statistical analytics, correlation, regression, cluster analysis, standard deviation, etc.
- Knowledge of MI/BI & contact centre software such as Business Objects, Power BI, Aspect WFM, Avaya Telephony, MS Office.
- Proficiency with programming tools like Power BI, Azure, Fabric, Snowflake, Python, SQL, R.
- Excellent Excel skills, including VBA, formulas, and PivotTables.
- Strong presentation skills and ability to communicate complex results clearly.
- Experience in data collation, reporting, and presentation.
- Data manipulation skills beyond Excel, including SQL.
- Knowledge of customer satisfaction/loyalty measurement techniques.
- Strong analytical skills and interest in data analysis and insight.
- Experience with evidence-based decision-making and statistical software.
- Experience with speech & text analytics applications.
- Efficient, accurate working approach and independent initiative.
- Understanding of financial and commercial considerations.
About us
Capita is an award-winning contact centre service provider with global delivery centers trusted by leading brands to transform customer experience. We aim to help you achieve your future goals, whether gaining customer service experience or growing your skills. Our services span multiple sectors and locations, working to create better outcomes for all.
Our offices feature a 6-star green rating, with amenities including a gym, clinic, creche, restaurants, pharmacy, hairdresser, and spa.
What’s in it for you?
- Competitive salary, medical aid, provident fund, and other benefits.
- Annual performance incentives.
- Participation in global networks and community programs.
- Extra leave days and international exposure opportunities.
- Development and growth prospects.
We value our employees and promote Capita’s core values: Customer First, Fearless Innovation, Achieve Together, Everyone is Valued.
Next steps:
Apply now with your CV. Your application will be reviewed, and successful candidates will be invited for an interview. Shortlisted candidates may undergo assessments. We adhere to employment equity principles and encourage diverse applications.
#J-18808-LjbffrData scientist (pipeline)
Posted today
Job Viewed
Job Description
Be The First To Know
About the latest Etl development Jobs in South Africa !
Data scientist (pipeline)
Posted today
Job Viewed
Job Description
Data Warehousing Specialist | Centurion
Posted 13 days ago
Job Viewed
Job Description
Join a leading Financial Services firm in their quest for excellence! Are you a skilled Data Warehousing Specialist seeking an exciting opportunity to make a significant impact? Our client, a prominent player in the financial industry, is actively seeking a talented professional like yourself to join their dynamic team. You will need to establish and lead a world-class data analytics/warehouse capability for the company to enable future needs for advanced analytics and AI.
Maintain and support:
- Existing MIS databases.
- Existing reports and dashboards.
- Existing data warehouses.
Develop, test, deploy, maintain and support: new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.
Remain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry.
Outputs:
Internal Process:
- Collaborate with Project Managers and Business Leaders to deliver quality, effective management information, data warehouse and business intelligence applications, in line with the agreed development process and business needs.
- Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
- Conduct research and evaluate potential technical solutions to identified business problems.
- Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
- Design and code new database and analytics functionality using code that is readable, maintainable and reusable.
- Conduct Unit Testing of own code and resolve all issues/queries timeously.
- Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.
- Deliver solutions into the applicable production environment once testing has been completed.
- Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.
- Maintain existing databases and applications according to change requests approved by business as and when needed.
- Diagnose root causes of issues through problem-solving and recommend potential solutions.
- Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.
- Log issues found in existing systems as internal change controls and ensure successful resolution of issues.
Responsibilities:
Develop, implement and document Business Intelligence Solutions:
- Contribute to the overall data warehouse architecture and database designs.
- Maintain and oversee the administration and maintenance of the data warehouse.
- Develop and maintain Business Intelligence and reporting technologies and processes.
- Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications.
- Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications.
- Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions.
- Ensure the continued maintenance and enhancement to existing business intelligence solutions.
- Within user specifications extract, transform and load (ELT) data using the relevant tools.
- Verify and quality assure of data provided.
- Provide support to business intelligence users on data-related issues.
Future development and planning:
- Conduct research and undergo training where appropriate, in order to remain abreast of data enablement trends and understand their application in the short-term insurance industry.
- Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture and applications in the company short-term insurance business, in alignment with the company’s standards and the South African financial services regulatory framework.
Self-management and Teamwork:
- Provide authoritative expertise and advice to colleagues.
- Develop and maintain productive and collaborative working relationships with peers and team members.
- Deliver on Service Level Agreements made with colleagues.
- Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialisation.
- Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
- Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
- Take ownership for driving career development.
Finance:
- Manage financial and other company resources under your control with due respect.
Competencies:
- Business Acumen.
- Client / Stakeholder Commitment.
- Drive for Results.
- Leads Change and Innovation.
- Motivating and Inspiring Team.
- Collaboration.
- Impact and Influence.
- Self-Awareness and Insight.
- Diversity and Inclusiveness.
- Growing Talent.
Skills:
- Communication – articulating information and challenging ideas.
- Analysing and interpreting data.
- Problem-solving.
- Planning and organising – time and task management.
Experience and Qualifications:
- Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) – Essential.
- Dimensional modelling and/or relevant Microsoft certification – Advantageous.
- On-the-job training/qualifications:
- Microsoft Sql Server.
- Oracle.
- Power BI.
- Advanced MS Excel.
- Starquest.
Some experience in predictive analytic platforms will be advantageous. These include:
- Python.
- Scala.
- Spark.
- AWS Sagemaker.
Some experience in Azure / AWS platform services will be advantageous. These include:
- Azure SQL elastic instance.
- Data factory.
- PowerBI.
- AWS RDS.
Experience:
- Methodologies.
- The candidate must have ability to elicit data requirements from stakeholders.
- The candidate must have clear documentation skills.
Principles:
- The candidate must be familiar with design patterns in the data development industry.
- The candidate must have a solid understanding of Metadata constructs.
- The candidate must have clear understanding of EDW.
- Knowledge of Domain driven design would be an advantage.
- The candidate must be familiar with the concept of Data Marts.
- The candidate must be familiar with abstraction techniques.
Modelling:
- The candidate must have proven data modelling techniques (3 years).
- The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years).
- Knowledge of Immon data warehouse modelling techniques would add an advantage.
- The candidate must have data normalization skills most especially the 2nd Normal form.
Data Transportation:
- The candidate must have solid experience of ETL systems.
- The candidate must have solid experience of sourcing, staging and loading.
- The candidate must be familiar with parallel loading principles.
- The candidate must be familiar with source to target mapping.
Development Software:
- The candidate must have advanced knowledge of T-SQL (4 years) and the following concepts.
- Dynamic T-SQL.
- Multi-threading.
- Performance optimisation and tuning.
- The candidate must have practical experience of SQL Server Database Engine (4 years).
- The candidate must have practical experience of MS SSIS ETL software (4 years).
- The candidate must have practical experience of MS SSAS OLAP software (4 years).
- The candidate must have practical experience of MS Visual Studio Data Tools (4 years).
- Knowledge of Database Administration would add an advantage.
- Expert knowledge in configuration of database hardware resources.
Repository type:
- The candidate must be able to source data from different repositories.
- The candidate must be fully acquainted with Microsoft SQL Server repository.
- Knowledge of Data Lake would be an advantage.
- Knowledge of Oracle would be an advantage.
- Knowledge of Hadoop is not essential but will also be an advantage.
Data Warehousing Specialist | Centurion
Posted today
Job Viewed
Job Description
Join a leading Financial Services firm in their quest for excellence! Are you a skilled Data Warehousing Specialist seeking an exciting opportunity to make a significant impact? Our client, a prominent player in the financial industry, is actively seeking a talented professional like yourself to join their dynamic team. You will need to establish and lead a world-class data analytics/warehouse capability for the company to enable future needs for advanced analytics and AI.
Maintain and support:
- Existing MIS databases.
- Existing reports and dashboards.
- Existing data warehouses.
Develop, test, deploy, maintain and support: new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.
Remain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry.
Outputs:
Internal Process:
- Collaborate with Project Managers and Business Leaders to deliver quality, effective management information, data warehouse and business intelligence applications, in line with the agreed development process and business needs.
- Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
- Conduct research and evaluate potential technical solutions to identified business problems.
- Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
- Design and code new database and analytics functionality using code that is readable, maintainable and reusable.
- Conduct Unit Testing of own code and resolve all issues/queries timeously.
- Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.
- Deliver solutions into the applicable production environment once testing has been completed.
- Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.
- Maintain existing databases and applications according to change requests approved by business as and when needed.
- Diagnose root causes of issues through problem-solving and recommend potential solutions.
- Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.
- Log issues found in existing systems as internal change controls and ensure successful resolution of issues.
Responsibilities:
Develop, implement and document Business Intelligence Solutions:
- Contribute to the overall data warehouse architecture and database designs.
- Maintain and oversee the administration and maintenance of the data warehouse.
- Develop and maintain Business Intelligence and reporting technologies and processes.
- Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications.
- Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications.
- Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions.
- Ensure the continued maintenance and enhancement to existing business intelligence solutions.
- Within user specifications extract, transform and load (ELT) data using the relevant tools.
- Verify and quality assure of data provided.
- Provide support to business intelligence users on data-related issues.
Future development and planning:
- Conduct research and undergo training where appropriate, in order to remain abreast of data enablement trends and understand their application in the short-term insurance industry.
- Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture and applications in the company short-term insurance business, in alignment with the company’s standards and the South African financial services regulatory framework.
Self-management and Teamwork:
- Provide authoritative expertise and advice to colleagues.
- Develop and maintain productive and collaborative working relationships with peers and team members.
- Deliver on Service Level Agreements made with colleagues.
- Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialisation.
- Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
- Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
- Take ownership for driving career development.
Finance:
- Manage financial and other company resources under your control with due respect.
Competencies:
- Business Acumen.
- Client / Stakeholder Commitment.
- Drive for Results.
- Leads Change and Innovation.
- Motivating and Inspiring Team.
- Collaboration.
- Impact and Influence.
- Self-Awareness and Insight.
- Diversity and Inclusiveness.
- Growing Talent.
Skills:
- Communication – articulating information and challenging ideas.
- Analysing and interpreting data.
- Problem-solving.
- Planning and organising – time and task management.
Experience and Qualifications:
- Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) – Essential.
- Dimensional modelling and/or relevant Microsoft certification – Advantageous.
- On-the-job training/qualifications:
- Microsoft Sql Server.
- Oracle.
- Power BI.
- Advanced MS Excel.
- Starquest.
Some experience in predictive analytic platforms will be advantageous. These include:
- Python.
- Scala.
- Spark.
- AWS Sagemaker.
Some experience in Azure / AWS platform services will be advantageous. These include:
- Azure SQL elastic instance.
- Data factory.
- PowerBI.
- AWS RDS.
Experience:
- Methodologies.
- The candidate must have ability to elicit data requirements from stakeholders.
- The candidate must have clear documentation skills.
Principles:
- The candidate must be familiar with design patterns in the data development industry.
- The candidate must have a solid understanding of Metadata constructs.
- The candidate must have clear understanding of EDW.
- Knowledge of Domain driven design would be an advantage.
- The candidate must be familiar with the concept of Data Marts.
- The candidate must be familiar with abstraction techniques.
Modelling:
- The candidate must have proven data modelling techniques (3 years).
- The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years).
- Knowledge of Immon data warehouse modelling techniques would add an advantage.
- The candidate must have data normalization skills most especially the 2nd Normal form.
Data Transportation:
- The candidate must have solid experience of ETL systems.
- The candidate must have solid experience of sourcing, staging and loading.
- The candidate must be familiar with parallel loading principles.
- The candidate must be familiar with source to target mapping.
Development Software:
- The candidate must have advanced knowledge of T-SQL (4 years) and the following concepts.
- Dynamic T-SQL.
- Multi-threading.
- Performance optimisation and tuning.
- The candidate must have practical experience of SQL Server Database Engine (4 years).
- The candidate must have practical experience of MS SSIS ETL software (4 years).
- The candidate must have practical experience of MS SSAS OLAP software (4 years).
- The candidate must have practical experience of MS Visual Studio Data Tools (4 years).
- Knowledge of Database Administration would add an advantage.
- Expert knowledge in configuration of database hardware resources.
Repository type:
- The candidate must be able to source data from different repositories.
- The candidate must be fully acquainted with Microsoft SQL Server repository.
- Knowledge of Data Lake would be an advantage.
- Knowledge of Oracle would be an advantage.
- Knowledge of Hadoop is not essential but will also be an advantage.