Data Engineer

Weconnectu; Wes-Kaap; On-site; ZAR 900,000 - 1,350,000; Full time

Job summary

WeconnectU is seeking a Data Engineer to design, build and maintain the data foundation connecting product, CRM, finance, and operations to trusted reporting and analytics. The role blends hands‑on data engineering, data modelling, and disciplined delivery across multiple departments.

You may use Snowflake or a comparable cloud platform, with a focus on scalable schemas, data quality, and end‑to‑end data contracts. Collaboration with Technology, Product, Finance and commercial teams is essential.

Qualifications

• 4-6 years of practical data engineering or analytics engineering experience.
• Hands-on experience with Snowflake or similar cloud data warehouse/lakehouse.
• Strong SQL with automation, testing and production support.
• Experience designing ETL/ELT pipelines, APIs and scheduled workflows.
• Relational and dimensional data modelling, including CRM data models.
• Knowledge of Git, data governance, security and POPIA principles.

Responsibilities

• Build and maintain ETL/ELT pipelines from multiple data sources into a central data platform.
• Develop integrations using SQL, APIs, Python and cloud services.
• Design scalable schemas and data models for shared company and CRM data.
• Implement incremental loads, testing, logging, retries, alerting and monitoring.
• Write secure, version-controlled code and manage performance, access and cost.
• Map data flows across end-to-end processes and define sources of truth.
• Translate business requirements into data contracts, tasks and test cases.
• Create automated checks for data quality, completeness and reconciliation.
• Maintain CRM and customer-data solutions for Sales, Marketing, Customer Success and Operations.
• Run discovery with departments to model data needs into pipelines and outputs.
• Maintain data lineage and documentation.

Skills

SQL

Python

APIs

Cloud services

Data modelling

Git

BI tools

Data quality

Education

Bachelor’s degree or equivalent

Diploma or degree in a relevant field

Tools

Snowflake

dbt

AWS

SQL tooling

Job description

WeconnectU is an intelligent property management software business. Reliable connected data helps us understand customers, improve products, run operations and make sound commercial decisions.

Purpose of the Role

The Data Engineer will design, build and maintain the data foundation that connects WeconnectU's products, CRM, finance systems and operational tools to trusted reporting and analytics. The role combines hands-on data engineering, strong relational and CRM data-model design, a practical understanding of business operations and disciplined project delivery. The successful candidate may use Snowflake or a comparable cloud data platform, depending on WeconnectU's final architecture decision.

You will work across Technology, Product, Finance, Sales, Marketing, Customer Success, Operations and People. Where consultants build parts of the foundation, you will act as WeconnectU's internal delivery owner and ensure the solution is tested, documented, maintainable and properly handed over.

Key Responsibilities

• Build and maintain reliable ETL / ELT pipelines from product databases, finance systems, CRM and other operational sources into the centralised data platform.
• Develop integrations using SQL, APIs, Python and appropriate cloud services.
• Design scalable schemas and data models for shared company, user, CRM, product-usage, finance and operational data, using a cloud data warehouse, lakehouse or equivalent platform.
• Implement incremental loads, testing, logging, retries, alerting and monitoring so failures are visible and recoverable.
• Write readable, secure, version-controlled code and manage platform performance, access, scalability and cost responsibly.

2. Operational Data Flows & Quality

• Map how data moves through end-to-end business processes, from capture and hand-offs to operational action, finance and reporting.
• Define sources of truth, owners, identifiers, business rules, dependencies and reconciliation points for critical data.
• Translate business requirements into data contracts, technical tasks, test cases and measurable acceptance criteria.
• Create automated checks for completeness, validity, uniqueness, consistency, freshness and reconciliation.
• Establish visible exception-handling and issue-ownership processes, and work with teams to fix root causes upstream.
• Design and improve structured CRM and customer-data solutions that support Sales, Marketing, Customer Success, Training, Onboarding and Operations.
• Run focused discovery with departments to understand how data is captured, used and reported, then turn those needs into practical models, pipelines and self-service outputs.
• Maintain clear definitions and lineage for important entities, fields, metrics and calculation logic.

3. Analytics & Reporting Enablement

• Prepare trusted datasets and reusable data marts for executive, departmental and product reporting.
• Develop or support dashboards and recurring reports with clear, governed definitions.
• Reduce duplicated and manual reporting while helping teams interpret data and its limitations correctly.
• Turn the data roadmap into a practical backlog with milestones, owners, dependencies, risks and decisions.
• Coordinate internal contributors and external consultants around agreed priorities and business outcomes.
• Define technical scope, interfaces, deliverables and acceptance criteria before build work starts.
• Review designs, code, data models and pipeline outputs; coordinate testing and resolve gaps before sign-off.
• Track progress, costs and risks, and require reusable code, deployment instructions, runbooks, documentation and knowledge transfer.

5. Cross-Functional Partnership & Continuity

• Build trusted relationships across departments and act as an approachable first point of contact for data issues.
• Explain technical trade-offs plainly, facilitate focused working sessions and challenge weak assumptions constructively.
• Prioritise requests using business value, urgency, effort and risk.
• Maintain architecture, model, pipeline and operating documentation so solutions are supportable without key-person or consultant dependency.

Key Performance Areas / KPIs

• Reliability and freshness of priority pipelines and datasets against agreed service levels.
• Coverage of priority source systems and improvement in data quality.
• Delivery of milestones within scope, timeline and budget, with risks raised early.
• Quality and acceptance of consultant deliverables, documentation and knowledge transfer.
• Reduction in manual or conflicting reporting and increased use of trusted data.

Requirements

• 4-6 years of practical experience in data engineering, analytics engineering, BI engineering or a closely related role.
• Required: hands-on production experience with Snowflake, a comparable cloud data warehouse or lakehouse platform, including data loading, schema design, SQL transformations, role-based access, monitoring and performance or cost optimisation. Snowflake experience is advantageous, but the ability to design the right solution is more important than prior use of one named platform.
• Very strong SQL skills, with practical experience in automation, integration, testing and production support.
• Experience designing, building and supporting ETL / ELT pipelines, API integrations, scheduled workflows and incremental data loads.
• Strong relational and dimensional data-modelling skills, including CRM data models, shared customer or company records, cross-system identity matching and history tracking.
• Experience mapping operational processes, understanding departmental reporting needs and delivering data solutions across multiple departments.
• Strong project coordination skills covering requirements, plans, dependencies, risks, testing and delivery follow-through; experience managing consultants is strongly preferred.
• Working knowledge of Git, BI tools, data quality, governance, security, privacy and POPIA principles, with the judgement to balance delivery speed with maintainability.
• Clear written and verbal communication, plus a relevant degree, diploma or equivalent practical experience.
• Experience with AWS data services, dbt or other orchestration tools, multi-product SaaS, property management, finance operations or CRM data would be advantageous.