Data Engineer

Description:

• The Data Engineer will be responsible for the development, testing, maintenance, configuration and enhancement of all aspects related to the organisation data architectures including the Enterprise Data Warehouse (EDW). The successful incumbent will work closely with the data analysts, data scientists and business pillar teams in order to power insight and avail meaningful data for business use.

Education:

• BCom/BSc Computer Science/Information Systems) BTech (Information Technology) or MSc (Computer Science) desirable but not essential.

Duties/Responsibilities

• Design and develop databases, SQL queries, stored procedures, reports, dashboards and integration solutions for both real time and batch environments.
• Enable and run data migrations and data integrations across different databases and different servers.
• Store, retrieve and manipulate data for analysis.
• Strive to ensure there is proper data governance and quality across all relevant data platforms.
• Promote best practices and design principles for data warehousing techniques and architecture.
• Proactively analyse and evaluate the business’s databases and data Warehouse to identify and recommend improvements and/or optimization.
• Perform Unit Testing and Systems Integration Testing within the provided or recommended test infrastructure and standards.
• Follow all change control processes to implement the agreed solution by ensuring that all changes in the system upgrades, systems configuration changes or application parameter changes have been approved by the Change Approval Board (CAB) and have been tested.
• Troubleshoot data issues and present possible solutions to these issues.
• Provide second and third level support in order to resolve incidents within SLA timelines, conduct root cause analysis to resolve problems, and update all relevant process documentation.
• Manage and maintain the development environment including source control.
• Maintain code in TFS (Team Foundation Server) supporting multiple branches/deployment paths.
• Follow company and departmental policies and procedures as well as coding and documentation

Experience:

• Minimum of 4years' experience in developing and maintaining Microsoft Business Intelligence Suite in an enterprise environment
• Over 5 years’ experience in advanced Microsoft Excel
• Knowledge and experience in data frameworks, practices, methodologies and tooling (e.g. DAMA, Apache, etc.)
• Experience in database and data warehouse design and in building logical and physical data models
• Understanding of Ralph Kimball methodologies
• Understanding of planning a BI Infrastructure and Architecture
• SQL Reporting Services
• SQL Master Data Services
• SQL Data Quality Services
• Microsoft Power BI
• Microsoft Power Pivot/Pivot Tables, View and Query
• Understanding of Mobile BI / Datazen
• Understanding/experience SQL Server 2016
• Creation of Source to Target Mappings
• Dimensional Modelling
• Experience in DAX and MDX

Please visit our website