ETL Developer (Intermediate) at Discovery Limited

Key Purpose

We are looking for a SQL developer who will be responsible for designing efficient SQL solutions and ensuring their stability, reliability, and performance. You will also work with other developers optimizing SQL statements as necessary, and establishing best practices. You should be a quick thinker, highly organized and able to troubleshoot any number of issues that can come up during the day-to-day operations. The incumbent must be able and willing to work flexible hours, including overtime to assist with the monthly production ETL.

Areas of responsibility may include but not limited to:

• Perform day-to-day operations, includes monitoring and maintenance, problem investigation and resolution.
• Write and analyse existing SQL queries for performance improvements.
• Develop, implement and optimize stored procedures and functions.
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Ensure performance, security, and availability of databases (database optimization and tuning
• Working knowledge of SSIS, how to create and maintain packages.
• Experience running monthly ETL advantageous
• Creation and maintenance of cubes.
• Document code, provide progress reports, and perform code review and peer feedback.
• Review and interpret ongoing business report requirements
• Interface with clients to understand business context and trouble shoot.

Personal Attributes and Skills

• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills
• Sense of ownership and pride in your performance and its impact on company’s success

Education and Experience

• A degree in an IT related field, with an emphasis on programming
• Strong understanding of ETL concepts
• Minimum of 5 years of experience as a SQL Developer or similar role
• Strong proficiency with SQL, SSIS and SSAS (cubes)
• Proficient in standard business software: MS Office

Employment Equity  

The Company’s approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.