Job Description
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.
How to Apply
Click the green “Go Apply” button below to apply directly online with the employer.
About Other Finance/Accounting Jobs in Western Cape
In the Western Cape, the finance and accounting profession is a thriving industry with a strong demand for skilled professionals. Typically, the job market trends indicate a steady growth in the need for finance and accounting expertise across various sectors. This is often driven by the increasing importance of financial management, regulatory compliance, and data-driven decision-making in businesses.
When it comes to salaries, it’s common to see broad ranges varying depending on factors like experience, company size, and industry sector. Generally, entry-level positions can expect salaries ranging from R250 000 to R400 000 per annum, while senior roles may command salaries between R600 000 and R1 200 000 or more, depending on the individual’s qualifications and level of expertise.
Common skills required for finance and accounting roles in Western Cape include proficiency in financial software such as QuickBooks, Xero, or SAP; strong analytical and problem-solving skills; excellent communication and interpersonal skills; attention to detail and organisational abilities; knowledge of tax laws and regulations; and experience with budgeting and forecasting tools. Typically, a degree in commerce, accounting, or a related field is also essential.
Industry sectors commonly employing finance and accounting professionals include the financial services sector, technology industry, manufacturing sector, and corporate organisations. These roles often involve providing financial guidance, managing budgets, preparing financial reports, and ensuring compliance with regulatory requirements.
For those looking to advance their careers in finance and accounting, career development opportunities abound. Typically, experienced professionals can move into senior management positions or pursue specialisations like forensic accounting, audit, or financial planning. Others may choose to transition into related fields like business consulting, investment banking, or entrepreneurial ventures. With continuous learning and professional development, finance and accounting professionals in Western Cape can enjoy a rewarding and challenging career with opportunities for growth and advancement.
This information provides general career guidance. Actual salaries and requirements vary by employer.
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Learn the common software and tools used in your industry - stay current with technology.
How to Apply
Click “GO APPLY NOW” to visit the company’s application page.
Follow their instructions carefully.
JVR Jobs connects you with employers – we don’t process applications directly.
Latest Job Opportunities
Brooklyn: Medical Sales Rep posted by Fountain Circle Medical Suppliers
Fountain Circle Medical Suppliers is a home care provider, specializing in sleep apnoea. Sales Rep Work. Visiting Docter rooms. Meeting…
View JobCape Town Region: Vehicle Sales Executive posted by Stiles Recruit
We are seeking an enthusiastic and motivated Car Sales Representative to join our dynamic sales team. The ideal candidate will…
View JobJohannesburg: Junior Bookkeeper posted by Hire Resolve
A leading IT Services and Solutions company is looking for an experienced Junior Bookkeeper to join their team in Johannesburg…
View JobLimpopo: Sales Agent posted by Golden Acquisition Promotions
JOB TITLE: Sales Agent COMPANY OVERVIEW: Golden Acquisiotion Promotions is a leading sales and marketing company based in Thohoyandou. Our…
View JobEastern Cape: Quality Systems Specialist posted by Hire Resolve
A leading food manufacturing company is looking for an experienced Quality Systems Specialist with strong experience in Quality Assurance, Food…
View JobRichards Bay: Junior Administrator posted by Hire Resolve
An established occupational health and safety training institute is seeking a motivated Junior Office Administrator to join their team in…
View Job
Browse Employers
Job Alerts