Analyst Developer

Analyst Developer job vacancy in Cape Town.

The Analyst Developer will act as the critical link between business requirements and technical implementation, ensuring analytics-ready, high-quality data is delivered within the Operational Data Store (ODS).

This role focuses on translating business and financial reporting needs into structured, scalable data models that support reporting and decision-making platforms.

Key Responsibilities:

• Translate business and financial reporting requirements into detailed functional specifications aligned to the ODS.
• Collaborate with business stakeholders to define data domains, KPIs, metrics, and data consumption requirements (Power BI, One Stream).
• Design, develop, and maintain dbt models across the silver and gold layers, ensuring alignment with business logic.
• Conduct data profiling, data lineage analysis, and impact assessments to support data integrity and traceability.
• Create semantic views and curated datasets to enable self-service analytics and reporting.
• Support data democratization initiatives through clear documentation and stakeholder enablement.
• Validate and ensure that delivered data structures meet both operational and reporting requirements.

Requirements:

Core Skills & Experience

• Strong SQL skills with practical experience in analytics-oriented data modelling.
• Hands-on experience with dbt and Snowflake.
• Solid understanding of financial data structures and reporting processes.
• Experience in data analysis and requirements elicitation.
• Exposure to BI / reporting tools, particularly Power BI.
• Strong stakeholder engagement and communication skills.

Ideal Candidate Profile:

• Comfortable working at the intersection of business and data engineering.
• Able to interpret and structure complex reporting requirements.
• Detail-oriented with a strong focus on data accuracy and usability.
• Confident engaging both technical teams and business users.