Job Information
Work Experience: 4-5 years
Industry: Insurance
City: Johannesburg
State/Province: Gauteng
Country: South Africa
Zip/Postal Code: 2000
Job Description
The Data Engineer will be responsible for transforming data into actionable insight using the Microsoft SQL tech stack of Business Intelligence products.
This will be a collaborative role that will be responsible for delivering the full stack in the BI solution from the business requirements gathering, solutions architecture, data models to the semantic models and the reports themselves.
Should be able to design and develop end to end BI Solutions.
Be able to do gap and impact analysis on the requirement.
Accept coaching and mentoring from fellow developers/architects.
Complete documentation of BI requirements and development according to Hollard standards.
Provide support to business on existing projects.
Assist business users in acquiring access to reports/databases.
Responsible for the design and implementation of effective cross-functional business intelligence systems and processes.
Translate business and technical requirements into efficient sustainable BI solutions.
This will be a dynamic role where you will be an integral member of a small team building an end-to-end business intelligence solution.
This person should be very analytical with an even mix of business acumen and technical capability.
The Data Engineer will be responsible for working with analysts, managers, and executives to understand business needs and working with source owners and BI teams to understand the data sources.
Participate in analysis and design sessions.
Communicate progress with business users and project teams.
Elicit requirements for ad-hoc data requests, extract data from the various sources using SQL, and deliver request via various reporting tools.
Update and maintain ETL scripts written in SQL, which extract data from source systems and load the data warehouse.
Redesign and improvement of existing solutions.
Analyse business requirements and translate them into technical and system requirements to best satisfy these requirements.
Write and maintain technical documentation.
Develop end to end BI solutions.
Adhere BI SDLC and development methodologies.
Unit test their own development.
Requirements
The successful candidate must have:
Tertiary qualifications with majors in at least one of the following: Computer Science, Information Systems
+5 years' experience working on Microsoft BI platform.
Familiar with Agile / Waterfall development methodology
Exposure to Visual Studio and C#/VB.Net coding
SQL Server 2016+ highly recommended
Experience with relational databases
Exposure to database administration function
Exposure / Experience designing and implementing dimensional modelling and data warehouses.
Good database design skills (required)
Extensive skills on ETL packages
Experience in using and writing complex MDX and DAX statements.
MS PowerBI stack highly recommended (Power Pivot, Power View and Power Query experience)
MDS "Master Data Service" development, maintenance, and deployment
SQL Server Jobs, Stored Procs, Views, Functions, Indexes, Table Value Functions, etc.
SQL performance tuning and enhancements
Knowledge to produce fully automated solutions with minimal human intervention required
Benefits
Willingness to take ownership and accountability
Building and maintain relationships
Have a collaborative mindset
Have a strategic mindset when designing solutions that enable standardization and efficiency
Contribute to the success of the team; co-operate with other employees to improve personal and team performance
Team player & ability to work closely with others
Be able to function independently should that be required
Problem solver / solution provider
Passionate about BI and data integration
Committed, self-driven & highly motivated individual
Adaptable; be able to handle change effectively
Good communication skills
Able to work by themselves and in a team
Experience working in an agile manner
Ability and willingness to work standby and / or weekends (if required)
#J-18808-Ljbffr
