Microsoft SQL BI & Informatica Data Engineer

 

Recruiter:

PBT Group

Job Ref:

PBT1653212871

Date posted:

Friday, September 17, 2021

Location:

Johannesburg, South Africa

Salary:

Market Related


SUMMARY:
PBT Group has an opportunity for a Data Engineer with insurance background and knowledge preferred.

POSITION INFO:

PBT Group has an opportunity for a Data Engineer with insurance background and knowledge preferred.

 

The Data Engineer would be responsible to improve profitability by supporting the IT Strategy through the automation of data acquisition and provisioning, the development of Analytics and Business Information, to support the Business in their decision making. Responsible for the Data Ingestion, Transformation, ETL, Data Modelling, Data Architecture and Storage management.

 

Duties:

  • Provide month-end production rotational support to ensure data is consumed and ingested to ensure reports are generated within agreed SLA’s with business. Resolve production incidents and conduct root cause analysis for improvement.          
  • ETL development into staging and data warehouse environments. Develop new data extracts and modify ETL processes as required to improve reporting datasets.
  • Develop and maintain data sets, ETL processes and reports related in order to support operations and decision making related to commercial and personal insurance, provide direct support to end-users.
  • Collaborate with business users and application developers to provide required data. Estimate the time and resource requirements of ETL development work. Validate data and test routines developed & provision of ongoing maintenance and support of assigned ETL applications
  • Analyze the systems environment to understand how the business systems enable these business processes and how the related data is captured and stored.Analyze the structures in which the data is stored to understand what data can be extracted and how it would be done in an efficient manner.
  • Analyze the existing reporting environment to understand what reporting is available and how this can be utilized or amended to inform the specific Business decisions involved.
  • Test all developments for data accuracy, performance and system impact & engage relevant Business users, train them on report usage and guide them in doing user testing.
  • Schedule data extracts and report runs as required to deliver the required information to users at the necessary frequency. Ensure that scheduled procedures are handed over for monitoring and support by the appropriate resources. Update report specifications to reflect the as-built situation.
  • Update technical documentation on data extracts and report functionality to facilitate future understanding to the extent required for ongoing support. Respond to user queries, error logging and further enhancement requests to ensure reports are used and serve their intended purpose.
  • Provide OLAP support and end-user training on the various cubes used for reporting downstream
  • Data Modelling - emphasizes on what data is needed and how it should be organized instead of what operations need to be performed on the data. Data Model is like architect''''''''s building plan which helps to build a conceptual model and set the relationship between data items. This data capability is required in preparation of the Data Platform implementation, and will also align with the approach taken by Group Data to implement ERWIN as a tool of choice for Data Modelling
  • Data Architecture – ensures that we have composed of models, policies, rules or standards that govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations. This data capability is also aligned with the direction that Group Data is taking

 

Experience:

  • 5+ years’ experience of delivering Business Intelligence projects using Microsoft & Informatica tools, Visualization Tools (SSRS, Power BI). Insurance background and knowledge preferred.
  • Ability to produce solutions using Microsoft SQL Integration Services, MS SQL Analysis Services, MS SQL Reporting Services, MS PowerBI, QlikView, Informatica (Power-center & PWX CDC)
  • Knowledge of & Scaled Agile Framework (SAFe) practices will be advantageous
  • Knowledge of Cloud services (Azure & AWS) will be advantageous

 

Qualifications/ Certification:

  • Matric,
  • BSc Computer Science, Data Informatics, Information Technology
  • Cloud certification – advantageous


 

NB! This job is now closed. You can apply for other jobs by uploading your CV.



 

 

 

Similar jobs you might be interested in:

Business Development Manager
Location: Midrand
Salary:
Our client is seeking an experienced and dynamic Business Development Manager to join their Gauteng team. This is a pivotal role for a strategic thinker with a proven track record in driving revenue growth through innovative sales strategies.
Today


Data & Analytics Engineer
Location: Johannesburg
Salary: R800000 Annually
Senior data & Analytics engineermicrosoft Fabric / Azure data Factory Expert📍 Johannesburg (Office Based)🕓 Permanent Position💡 Ideal Candidate ProfileAre you a data engineering specialist with a strong cloud-first mindset?You understand end-to-end data flow — from extraction to analytics — and know how to make it scalable, reliable, and intelligent?Are you passion...
1 day ago


Senior AI Developer - Insurance
Location: Johannesburg
Salary: 1100000 Annually
Are you a seasoned microsoft Developer with a passion for AI and automation? We're seeking a dynamic Senior AI Developer to lead the design and deployment of cutting-edge AI solutions that transform business operations and empower internal users through intelligent assistants.This is a high-impact role for a strategic thinker who thrives on innovation, technical leadership, and delivering measurab...
1 day ago


Data Scientist
Location: Pretoria
Salary: Market Related
Are you passionate about turning complex data into powerful business insights? Join an innovative organisation that’s leveraging data science and machine learning to drive smarter, faster, and more strategic decisions.
2 days ago


Data and Analytics Engineer
Location: Johannesburg
Salary:
Are you an experienced data and Analytics engineer passionate about transforming data into actionable insights? Our client is looking for a skilled professional to join their team.
3 days ago


Business Intelligence Developer
Location: Johannesburg
Salary: 600000 Annually
Are you a dynamic and innovative bi Developer with a passion for data-driven solutions?
4 days ago


Innovations Technologist
Location: Johannesburg
Salary: 420 000 Annually
Ready to build cool stuff that actually makes a difference? Join a fast-moving team where your Power Platform skills will automate real-world problems, connect systems, and wow users. If you're into smart tech, fast prototyping, and seeing your work in action - this is your dream role.
7 days ago


BI Analyst / BI Developer
Location: Johannesburg
Salary:
7 days ago


Business Solutions Developer – Power Platform & Integrations
Location: Johannesburg
Salary:
Are you passionate about streamlining operations and building smart, scalable internal tools? Join a dynamic logistics and tech-driven environment where innovation meets impact.
8 days ago


Systems Administrator (ERP & Microsoft)
Location: Johannesburg
Salary: 700 Annually
If servers, ERP, and microsoft 365 are your playground, we want you on our team!
13 days ago


Create a free job alert for Microsoft SQL BI & Informatica Data Engineer in Johannesburg

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions