Data Engineer

JOB SUMMARY

The incumbent will be responsible extracting, cleaning, preparing, modelling, and moving data from heterogeneous data sources to Group Strategic and Corporate Planning’s (GSCP) data warehouse. He/She will also be responsible for enhancing the efficiency of the analytics workflow that delivers insights and metrics used in strategy development, monitoring and execution.

KEY DUTIES AND RESPONSIBILITIES

• Elicits and documents data requirements and business rules from discussions with business stakeholders, analysts and data scientists
• Works closely with business stakeholders, data scientists/analytics professionals to develop data capture forms, data models and solutions that help with addressing strategic business problems
• Adapts best practice in the design of data models/schemas which enable reusable datasets
• Maintains and optimizes the data models and pipelines in support of the analytics workflow
• Configures and enhances the design of the data warehouse
• Creates data quality profiles for source data that is loaded into the data warehouse and escalates data quality issues to data governance personnel
• Documents and maintains data dictionaries, data quality profiles, data models and data pipelines
• Implements and integrates data pipelines from multiple data sources
• Performs data transformations to clean and prepare data for reporting and analytics
• Takes responsibility for Security Access and Role Permission of GSCP's Analytics Infrastructure inclusive of its reports and dashboards
• Researches and provides insights into best practices regarding analytics workflows and data stacks
• Provides recommendations for database/server infrastructure and supporting technologies
• Provides support in conducting workshops and data literacy sessions
• Collaborates with Data Scientists and Analytics Lead to perform advanced analytics and develop data products
• Engages in marketing of the Group’s products and services
• Responds to customers’ requests, enquiries, incoming and outgoing calls, in a courteous and timely manner consistent with operating standards and escalation to the Supervisor/Manager where necessary
• Completes special projects and other delegated activities as assigned by the Supervisor/Manager

QUALIFICATIONS AND EXPERIENCE

• Candidates must possess a Bachelor’s Degree in Computer Science, Information Systems, Information Technology, Mathematics or an equivalent qualification in other Quantitative/ Analytical fields from an accredited institution
• Candidates must also possess a minimum of two (2) years' experience, of which one (1) year must be in the financial sector working with SQL, ETL solutions and Data Modelling software
• Experience using Microsoft BI Suite (SQL Server, SSIS, SSAS, SSRS)
• Certifications in Data Engineering, Business Analytics, Data Science, Project Management, or related fields will be considered an asset
• Scientific curiosity and continuous self-learning with the ability to innovate while still conforming to established best practice
• Strong oral and written communication, presentation, teamwork and time management skills
• Strong analytical, critical, conflict resolution and conceptual thinking skills
• Ability to solve complex technical problems and troubleshoot data technology issues
• Working knowledge of the following:
• Contemporary programming and scripting languages
• Analyzing data using tools such as Python, R, or SAS
• Designing and building Dashboards in Excel, Power BI, or Tableau