Data Engineer (Finance & Analytics)

3 months ago

Cape Town, South AfricaMid Level

Responsibilities

Design, build, and maintain data pipelines and applications using Microsoft Azure and Microsoft Fabric.
Develop and optimize SQL data models for financial reporting and analysis.
Build and maintain Power BI dashboards, reports, and reporting solutions.
Own end-to-end data workflows from ingestion through transformation and reporting.
Ensure data accuracy and integrity through validation, reconciliation, and issue investigation.
Collaborate with finance, operations, and IT teams to translate business needs into scalable data solutions.
Improve data processes, automation, system performance, SQL query performance, and report performance.
Support security, governance, and compliance for financial data.
Transform raw data into reliable reporting models and communicate technical concepts to non-technical stakeholders.

Bachelor’s degree in computer science, computer engineering, information systems, or a related field.
At least 3 years of experience in data engineering, analytics engineering, or software engineering with financial order information.
Experience with Microsoft Azure and hands-on experience with Microsoft Fabric, including Lakehouse, Data Warehouse, and Data Factory.
Experience with Power Query, DAX, SQL, large complex datasets, and Power BI data models and reports.
Familiarity with Git and/or Azure DevOps for version control.
Knowledge of Python for data processing and automation is preferred.
Experience integrating data through APIs or external data sources.
Understanding of data warehousing, dimensional modeling, ETL/ELT pipelines, and data validation processes.
Experience working with financial or operational data is a strong plus.
DP-700 certification is preferred.
Ability to work across mixed time zones and collaborate with Pacific Standard Time teams.
Strong analytical, problem-solving, communication, stakeholder management, organizational, and time management skills.

1,001-5,000 employees