SQL Developer - Cape Town
Salary Negotiable
Cape Town,
Western Cape
more than 14 days ago
About us
At PBT Group we pride ourselves on being a Data Specialist organisation. With 20 years of experience in 27 countries over 3 continents, our team of 550 consultants have implemented more than 700 projects.
Our worldwide expertise and regional specific wisdom differentiate us from our competitors. We have adopted a technology-agnostic approach that best enables us to provide our clients across various industries and regions with customisable services and solutions that bring real value to their business. To achieve this continuously, we look to hire specialists and consultants of exceptional caliber across our offices in South Africa (Cape Town, Stellenbosch, Johannesburg), Netherlands (Amsterdam), Ireland (Dublin) and Australia (Melbourne).
We are looking for promising experienced and aspiring SQL Developers
Duties:
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.
Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.
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.
Ensure compliance with established policies, standards, and methodologies.
Required 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.
Required Qualifications / Training:
Course on the ETL / related toolset.
Relevant data warehouse and BI solution training is essential.
B.Sc. or related degree is advantageous.
2+ years SQL programming experience
At PBT Group we pride ourselves on being a Data Specialist organisation. With 20 years of experience in 27 countries over 3 continents, our team of 550 consultants have implemented more than 700 projects.
Our worldwide expertise and regional specific wisdom differentiate us from our competitors. We have adopted a technology-agnostic approach that best enables us to provide our clients across various industries and regions with customisable services and solutions that bring real value to their business. To achieve this continuously, we look to hire specialists and consultants of exceptional caliber across our offices in South Africa (Cape Town, Stellenbosch, Johannesburg), Netherlands (Amsterdam), Ireland (Dublin) and Australia (Melbourne).
We are looking for promising experienced and aspiring SQL Developers
Duties:
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.
Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.
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.
Ensure compliance with established policies, standards, and methodologies.
Required 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.
Required Qualifications / Training:
Course on the ETL / related toolset.
Relevant data warehouse and BI solution training is essential.
B.Sc. or related degree is advantageous.
2+ years SQL programming experience
Recruiter: PBT Group (Pty) Ltd