SQL Data Engineer

Pbt Group; Cape Town; On-site; ZAR 300,000 - 600,000; Full time

Job summary

An established industry player in Business Intelligence is seeking a skilled Microsoft SQL Data Engineer to join their dynamic team. This role involves planning and analyzing complex business requirements, conducting evaluations, and ensuring compliance with established standards. You will design and develop end-to-end data acquisition processes, leveraging your expertise in ETL tools and SQL. If you have a passion for data engineering and a keen eye for detail, this opportunity offers a chance to make a significant impact in a collaborative environment focused on innovation and excellence.

Qualifications

• 2+ years programming experience in data engineering or business intelligence.
• Solid experience with SSIS and SSRS is essential for this role.

Responsibilities

• Plan and analyze business requirements to implement technology solutions.
• Design and develop complex data acquisition processes using ETL tools.

Skills

SSIS (SQL Server Integration Services)

SSRS (SQL Server Reporting Services)

Analytical Skills

Database Modeling

ETL Processes

SQL

Attention to Detail

Education

Course on ETL/related toolset

Relevant data warehouse and BI solution training

B.Sc. or related degree

Tools

ETL Tools

Job description

PBT Group, leaders in Business Intelligence, has a vacancy for a Microsoft SQL Data Engineer.

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 make 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:

• Solid SSIS (SQL Server Integration Services) experience.
• Solid SSRS (SQL Server Reporting Services) experience.
• Ability to analyse and define requirements.
• 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.
• Pride of work, thoroughness and attention to detail.

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 programming experience.