Job Summary
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, OneStream).
- 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.
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.
* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent
* If you have not received any feedback after 2 weeks, please consider you application as unsuccessful.