Data Engineer

About WeconnectU

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

1. Data Engineering & Centralised Data Platform

· 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.

4. Project & Consultant Delivery

· 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.