Job Description
About the Role
PBT Group, leaders in Business Intelligence, is seeking a highly skilled Microsoft SQL Data Engineer / ETL Developer to join their team in Cape Town City Centre. The successful candidate will be responsible for designing and developing end-to-end data acquisition processes, ensuring compliance with established policies, standards, and methodologies.
Key Responsibilities
- Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems.
- Conduct planning, analysis and design activities in conjunction with other development specialists.
- Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.
- Participate in estimation of tasks and assist in the development of project plans.
- Code or makes modifications to programs of high complexity, according to specifications.
- Conduct medium to high complexity evaluations for product releases, stand-alone products, etc.
- Conduct walkthroughs and quality review of deliverables.
- Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes.
- Participate in the formulation of standards to support the data acquisition development process.
- Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.
Requirements
- Strong MS SQL Data Engineering experience
- Solid SSIS (SQL Server Integration Services) experience
- Solid SSRS (SQL Server Reporting Services) experience
- Ability to analyse and define requirements
- Database design skills
- Intimate knowledge of source systems as well as a basic understanding of dimensional models
- Conventional database- and data warehouse modeling skills, in order to understand the data warehouse data models
- A sound knowledge of the programming language used to write the data staging programs or ETL tool
- A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool
- A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs.
Qualifications
- Course on the ETL / related toolset
- Relevant data warehouse and BI solution training is essential
- B.Sc. or related degree is advantageous
- 2 years programming experience
Salary & Benefits
No salary information is available for this position.
How to Apply
Click the green “Go Apply” button below to apply directly online with the employer.
About IT / Computing / Software Jobs in Cape Town Region
The IT and computing industry in the Cape Town region is generally thriving, with a strong demand for skilled professionals in fields such as software development, data analytics, and cybersecurity. Typically, these roles are found across various sectors, including technology, finance, healthcare, and education. As a result, career opportunities in this field are often diverse and abundant.
In terms of salary ranges, it’s common to find IT and computing professionals earning between R400 000 to R1 200 000 per annum, depending on factors such as experience, company size, and industry sector. However, please note that these figures are broad estimates and may vary significantly based on individual circumstances. For instance, senior roles or those in larger companies tend to command higher salaries, while entry-level positions may be lower.
Common skills required for IT and computing roles include proficiency in programming languages such as Java, Python, or C++, experience with software development methodologies like Agile or Scrum, knowledge of data structures and algorithms, and familiarity with cloud computing platforms. Additionally, many employers also value skills such as data analysis, problem-solving, and communication.
The technology industry is a significant sector that employs IT professionals in Cape Town, followed by the financial services and manufacturing sectors. Other industries that commonly require these roles include education, healthcare, and government.
For those looking to advance their careers in IT and computing, there are various opportunities for professional development. Typically, this involves obtaining relevant certifications, such as CompTIA or Cisco, and staying up-to-date with industry trends through online courses or workshops. Many employers also provide training and mentorship programs to support employee growth. With experience and continuous learning, it’s possible to move into senior roles or specialise in a particular area of expertise.
This information provides general career guidance. Actual salaries and requirements vary by employer.
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
[quick_job_alert]
[jobseeker_tips]
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
[sa_latest_jobs count=”6″ columns=”2″]
Browse Employers
Job Alerts