Data Engineer at Investec

Description

• Investec is looking for a Data Engineer with 8+ years of experience to join the Private Bank Tech Data team in Sandton. The successful candidate will have strong experience designing BI solutions using Microsoft stack preferably within Investment banking or Financial services experience as well as experience supporting the transformation of data platforms from on-premise environments to the cloud.
• Designing and building end to end BI solutions, that will extract data from multiple systems, transforming and loading into multiple reporting data warehouses
• Working with end users and analysts on requirements and translate them into technical specification, provides estimation to the management
• Supporting existing BI Platform, reverse engineer and improve processes
• Following and contributing to departmental development process in terms of standards, methodologies, testing, version control and documentation, mentor junior members, drive and implement industry best practices, evaluate, and introduce new tools, design, and improve existing ETL framework, data validation framework
• Assist in the migration to an off-prem Cloud Solution (Specifically Microsoft Azure)

Azure Cloud Data Engineer Competencies

• Deliver to all stages of the data engineering process
• Data ingestion, transformation, data modelling and data warehousing, and building self-service data products.
• Experience in Azure, in particular Data Factory, MS Fabric and Databricks
• Good understanding of Data Lakes, in particular Azure Data Lake Gen2
• Demonstrated proficiency in stream analytics and real time data processing frameworks
• Deep hands on experience building and operating cloud based data platforms and pipelines at scale

Experience, skill and capability

• Excellent data analysis and exploration using T-SQL, and strong SQL programming (stored procedures, functions).
• Knowledge of data warehouse modelling methodologies
• Experience of loading data from different sources – xml, csv, excel, web services, different databases, MQ messages etc.
• Extensive experience of using SSIS, script tasks, custom plugins
• Significant experience designing solutions following Kimball methodology and good knowledge of data modelling concepts
• Knowledge of data modeling principles, best practices, and knowledge of relational and dimensional modeling
• Performing data proofing, analysis, and validation to ensure the quality of data.
• Post release support of deployed BI solutions
• Experience of building reports using SSRS, PowerPivot, integration with SharePoint, building corporate reporting portals, Data Products, KPIs, dashboards, self-service BI

General

• Experience of working in a team following agile development practices, using team development tools, working on the same objects
• Wide knowledge of other tools, vendors, solutions available on the market and applicable to BI space, upcoming releases of new software packages, etc.

Personal attributes and other requirements

• Ownership
• Self-starter culture and Agile mindset
• Delivery focused and Excellent attention to detail
• Ability to work on projects and with a variety of stakeholders
• Inquisitive nature and willingness to solve problems