BI Dba Integration Specialist
18 hours ago
What will you do?
Meta Lake Data Management & Data Quality
As BI DBA Integration Specialist you will source relevant master data sources as required by SGT service lines to land via SQL Service Integration Services into “Meta Lake” DBMS. You will document source data and Data Quality Requirements to be applied to daily DQS runs and report on data quality issues to the service lines and owners of the data sources for remediation.
Support and develop existing ETL projects
Develop and support Meta Lake SSIS ETL Projects and Packages that source data from files, databases, external cloud web services ,and land this data into the Meta Lake DBMS.
Develop and support Billing SSIS ETL Projects and Packages that Extracts data from the Meta Lake and performs various Transformations.
You will therefore also maintain a billing source, mapping sources, and catalogue of services source pertaining to the billing processing. Supply and maintain required billing processing reporting and service line detail and summary reports as required.
Perform Billing Runs
Perform (trial non-prod) mid-month, as well as (actual prod) month-end billing runs, that will supply validated billing data to the SAP Hana S4 financial system for processing of SGT and other customer financial data, via 3 interfaces BIL(sales order), MIS(cost allocation), PPO (cost allocation).
BI DBA Tasks
You will maintain reliability, stability and data integrity of the SQL BI environments and services. Provide support in the administration, backup, integrity and security of the database environment and SQL BI deployments and services and toolsets. Assist with various tasks from software upgrades and custom interfaces, to troubleshooting and monitoring.
You will be on standby every second week and working of overtime might be required in busy times. What will make you successful in this role?
**You will be required to**:
Record or update client BI services and database information for accurate and complete record keeping of all services supplied.
Manage your workload and source code via Atlasian Jira \ Bitbucket and Unicenter Service management task and tickets.
Assist with BI schema and virtual tables administration.
Perform regular processes (e.g. backups, restores, run scripts) in an accurate and timely manner.
Establish appropriate end-user BI database \ SSRS \ SSAS \ PBI access control levels and review reports.
Assist with BI database \ SSRS \ SSAS \ PBI access and performance issues.
Assist with the automation of regular BI database and BI tools support activities.
Should be able to use SQL queries and Scripting, SSIS SSRS SSAS PBI.
Setting business requirements for BI toolsets.
Translating business requirements into technical ones.
Leading BI software development, deployment, and maintenance with best practices and standards processes and documentation.
Report curation and data modelling.
Participation in data warehouse design.
Documenting manually or automated (BiExpress \ DocExpress ) contents in a data warehouse and metadata, as well as for BI toolsets and deployments. Qualifications and Experience
**Qualifications**:
Matric
Diploma or Degree in Computer Science
Experience
At least two years experience in BI SQL scripting
Proven, demonstrable interest in DBMS such as SQL, Sap Hana, Teradata, Cloudera and
Attunity replication.
Proven, demonstrable knowledge of SQL queries and scripting,
Proven, demonstrable interest in technology (servers, storage systems, networks, “no sql” databases etc.)
Proven, demonstrable knowledge of SQL BI offerings such as SSRS, SSIS and SSAS and Power BI
Data warehouse and modelling experience is desirable
Knowledge of IDE’s such as SQL Server Management Studio & Visual Studio or experience is desirable
C# knowledge or experience is desirable Knowledge and Skills IT Data Analysis Database Knowledge Database Security Project Coordination Risk Management Personal Attributes Organisational savvy - Contributing through others Manages complexity - Contributing through others Plans and aligns - Contributing through others Optimises work processes - Contributing through others Being resilient - Contributing dependently Collaborates - Contributing through others Communicates effectively - Contributing through others Customer focus - Contributing through others Interpersonal savvy - Contributing through others Build a successful career with us
We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future - your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its four business clusters - Sanlam Life and Savings, Sanlam Investment Group, Sanlam Emerging Markets, Santam, as well as MiWay and the Group Office - the group provides many opportunities for growth and development. Core Competencies Being resilient - Contributing through others Collaborates - Contributing through oth
-
BI Dba Integration Specialist
18 hours ago
Bellville, South Africa Progressive IT Resourcing Full time**Meta Lake Data Management & Data Quality** As BI DBA Integration Specialist you will source relevant master data sources as required by service lines to land via SQL Service Integration Services into “Meta Lake” DBMS. You will document source data and Data Quality Requirements to be applied to daily DQS runs and report on data quality issues to the...
-
Snr Database Administrator
2 weeks ago
Bellville, South Africa Progressive IT Resourcing Full time**What will you do?** - The DBA will design, install, configure, administer, monitor, and troubleshoot all components of the MSSQL platform including the core database as well as the additional components and functionality. - The DBA will also be responsible for security administration as well as administration tasks related to SDLC. - The DBA will also be...
-
BI Analyst
9 months ago
Bellville, South Africa CA Support Full timePosition Overview: The Business Intelligence Analyst will play a crucial role in enhancing data-driven decision-making processes within the organisation. Your primary responsibility will be to analyse complex datasets and generate valuable insights that will drive operational and strategic initiatives. Working closely with various departments, including...
-
BI Development Manager
7 months ago
Bellville, South Africa Sanlam Full time**PURPOSE OF THE POSITION** - The Purpose of the job is to provide data management and business intelligence services for the Santam Group that spans across all stakeholders with specific reference to the management of the Data use cases and the delivery of Santam’s future data architecture as part of the Business Information renewal journey.**CAREER...
-
BI Technical Delivery Manager
2 weeks ago
Bellville, South Africa Sanlam Full timeWho are we? Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...
-
BI Technical Delivery Manager
1 week ago
Bellville, South Africa Progressive IT Resourcing Full time**Our Client?** Company Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...
-
SQL Db Administrator
5 days ago
Bellville, South Africa Sanlam Full timeWho are we? Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...
-
Specialist: HR Analytics
2 weeks ago
Bellville, South Africa University of the Western Cape Full timeThe University of the Western Cape (UWC) is a vibrant, diverse and dynamic university, rooted in the African continent with an increasing global reach. UWC actively responds in critical and creative ways to the development needs of the country, within an ever-changing and challenging global context._ **The role of the Human Resources Department** is to...
-
Api Integration Specialist Ref: Zr
2 days ago
Bellville, South Africa Progressive IT Resourcing Full time**Permanent, Cape Town** **ROLE RESPONSIBILITIES** - Previous work experience in an Integration and/or API gateway platform - General understanding of good API Management practices - Ensuring stability in the API integration platform through appropriate DevOps practices (documentation, monitoring, performance monitoring, automated deployment, CI/CD...
-
Head: Digital, Data and Bi
7 months ago
Bellville, South Africa Sanlam Full time**Job Overview - The job purpose of a Head of Digital, Data and Business Intelligence is to strategically lead and oversee the organization's digital transformation initiatives. This involves harnessing data-driven insights, implementing advanced analytics, and optimizing business processes to enhance efficiency.- The role encompasses shaping a cohesive...
-
Iwms Specialist
6 months ago
Bellville, South Africa Excellerate Full timePosition title : IWMS Specialist Position reports to : Head of BI & Analytics Business Unit : Operations **Main purpose / objective of the position**: As an IWMS Specialist, you will be required to configure, customize, and integrate methods of Integrated Workplace Management Solutions (IWMS), including Planon (a fully web-based solution that allows...
-
Database Administrator
7 months ago
Bellville, South Africa Hr Legend Full time**DATABASE ADMINISTRATOR - SQL (Bellville, Cape Town)** Market related package with benefits Bellville, Cape Town **REQUIREMENTS**: Minimum: - Grade 12 - Relevant tertiary qualification i.e. Bachelors Degree in a computer discipline or relevant SQL certification - 5 years of experience as a SQL Server DBA or similar role - 5 years of experience with...
-
Application Support It
4 days ago
Bellville, South Africa CX-International Full time**Purpose of the Role** As part of this function working overtime from time to time is necessary in this role. **Role and Responsibilities** - A good IT technical knowledge across multiple areas to enable quick and accurate diagnosis of problems. - Ensure all system changes are undertaken to agreed standards of quality, service, procedures and security. -...
-
Senior Tech Lead
2 weeks ago
Bellville, South Africa Sanlam Full timeWho are we? Sanlam Life and Savings (SLS) is focused on serving our retail and corporate clients in South Africa and further developing our strategic advantages in the South African market. Sanlam Life and Savings consists of three clusters - Sanlam Corporate, Sanlam Retail Mass and Sanlam Retail Affluent. The Sanlam Life and Savings Office provides...
-
Professor/associate Professor in Management
4 days ago
Bellville, South Africa University of the Western Cape Full timeThe University of the Western Cape (UWC) is a vibrant, diverse and dynamic university rooted in the African continent with an increasingly global reach. UWC actively responds in critical and creative ways to the development needs of the country within an ever-changing and challenging global context. The Faculty of Economic and Management Sciences offers a...
-
BI Data Analyst
7 months ago
Bellville, South Africa Sanlam Full time**CAREER OPPORTUNITY** - Santam has a career opportunity for a Data Analyst in the B.I.T.S. environment who will be based in Bellville, Cape Town.**JOB DESCRIPTION** - Guided by the Data Management Lead, this role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop...
-
BI Data Analyst
1 week ago
Bellville, South Africa Santam Full timeCAREER OPPORTUNITY An exciting career opportunity exists for someone to perform a new and critical role within our Business Intelligence department, reporting to the BCM: Information Management. Guided by the BCM and a prioritised backlog, this role will be responsible for assisting in the impact and data dependency analysis between data sources within the...
-
BI Data Management Lead
7 months ago
Bellville, South Africa Sanlam Full time**PURPOSE OF THE JOB** - The Purpose of the job is to provide data management services with specific focus on data sharing, data quality, reference data and metadata management and tooling, for the Santam Group.**CAREER OPPORTUNITY** - As a Data Management Lead your primary responsibility will be to establish, implement, and maintain effective data standard...
-
Talent Acquisition Specialist
2 weeks ago
Bellville, South Africa ICG Medical Full timeTalent Acquisition Specialist (South Africa) An acute understanding of talent supply and demand in your market is critical to ensure ICG Medical’s competitive advantage in the staffing and recruiting and healthcare industry. Our TA Specialists are empowered to implement an integrated local go-to-market approach to meet the demands of the business. This...
-
Portfolio Intelligence Analyst
7 months ago
Bellville, South Africa Sanlam Full time**Who are we?** Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...