Job Description

We are looking for an experienced Data Engineer / BI Developer who is proficient in Microsoft SQL and the Microsoft BI technology stack to join our Technical Consulting team. This is an opportunity for an Intermediate - Senior developer, who will be responsible for developing, deploying, and maintaining BI solutions.Our projects include developing custom software, maintaining and supporting software systems, and developing systems integration. Our local and international clients come from various industries, including financial and insurance, supply chain, retail, and media.Main Responsibilities will include:The responsibilities will include, but are not limited to, the following key deliverables:

• Work independently and as part of a team in an Agile environment using the Microsoft stack of technologies.
• Delivery of enhancements and features as requested by the Product Owner.
• Ad-hoc fixes to existing functionality.
• Develop and execute database queries and conduct analysis.
• Translating business requirements into technical ones.
• Report curation and data modelling.
• Participation in data warehouse design.
• Design, develop, and maintain ETL processes.
• Ensure data quality and integrity across the data warehouse and BI solutions.
• Optimize and tune ETL processes for efficiency and performance.
• Monitor and troubleshoot ETL jobs to ensure timely data load and accuracy.
• Creating technical documentation.

Qualifications and Experience required

• You have completed a relevant 3-4 year diploma or degree (Honours or postgraduate degree preferred), or relevant work experience.
• You have 5-8 years hands-on Data Engineering / BI development experience
• You are proficient in Microsoft SQL and the Microsoft BI technology stack (SSIS, SSAS, SSRS, Power BI).
• You have experience with data warehouse design and data modelling.
• You have a strong understanding of ETL processes and best practices.
• You can develop, optimize, and troubleshoot ETL jobs.
• You are familiar with Agile methodologies and practices.

Advantageous:

• You have experience with Relational Databases, Microsoft SQL & Microsoft SSIS
• You have an in-depth understanding of database management systems, OLAP and ETL frameworks
• You can develop and test extraction, transformation, and load (ETL) processes
• You are familiar with Exception and Error handling contingencies and data hospitalisation procedures
• You have experience working with business analysts to identify and understand source data systems
• Exposure to financial services industry preferable
• You have experience with Data mining
• Experience with cloud technologies (AWS, Azure, Google Cloud)

Personal Attributes

• Excellent analytical and problem-solving skills.
• Strong communication skills and the ability to work effectively in a team-oriented environment.
• Ability to translate business requirements into technical specifications.
• Comprehensive thought and error handling solutions
• Ability to pick up new technologies easily
• Attention to detail
• People management skills
• Strong development skills
• Delivery focused and responsive to change
• Able to work in projects (multi-task) environment

Our benefits

• 20 Leave days per year
• Mentoring and career growth opportunities
• Work remotely from anywhere in South Africa (role and client dependent)
• Study leave to write examinations
• Competitive salary
• Contributory pension scheme with life assurance of 5 x annual salary
• Employee referral scheme
• Saratoga reward and recognition programme

Who we are
Saratoga is a company filled with like-minded individuals who deliver quality solution delivery services and are motivated to make a positive impact in the world through technology. We partner with our global client base to deliver innovative business and technology solutions to market fast, cost-effectively and ethically.As a values-driven organisation, our values of People Matter, Mutual Respect and Personal Excellence guide us in how we work with our clients, business partners and each other.We offer our people a well-rounded work experience. From training, career development and tech talks to help our staff develop their skills and knowledge. To virtual and in-person socials to give our teams the opportunities to connect, and reward and recognition programmes to celebrate the awesome work and achievements of our people.At Saratoga, we prioritize flexibility in our work arrangements, embracing both remote and hybrid models to cater to our staff's preferences. However, as a consulting firm, there are instances when on-site presence at the client's location becomes essential for project success and client collaboration.We strive to provide innovative solutions and inspire each other to be the best we can be. If you're looking to join an organisation where people really do matter, take a look at our open roles:Employment Equity requirement
Employment Equity candidates and people with disabilities are encouraged to apply. Saratoga is an equal opportunities employer. We believe that employing a diverse workforce is central to our success. We welcome applications from all members of society irrespective of age, sex, disability, sexual orientation, race, religion or belief. The relevant laws and principles associated with Employment Equity and Black Economic Empowerment will be considered when appointing potential candidates.POPI
Saratoga is POPIA (Protection of Personal Information Act, 2013) compliant, and all personal information is protected according to legislation. By applying for any of our available vacancies, you give Saratoga consent to process your Personal Information for Recruitment Purposes, according to the POPI ACT, 2013. If you have any concerns regarding your Personal Information and our compliance towards the legislation, you are welcome to request our Privacy Policy, or follow this link to view it:

Saratoga Software