Senior Data Engineer / Data Architect

Cape Town, WC, ZA, South Africa

Job Description

Join our Technical Consulting team as a

Senior Data Engineer / Data Architect.

You will lead and design enterprise-scale data warehouses leveraging the Microsoft Data Platform, SQL Server, Kimball methodology, and star schema modelling. The focus of this role is on designing and developing robust data solutions, data warehousing, and ETL pipelines in line with industry standard software engineering practices, supporting our clients' strategic business objectives

What You'll Be Doing



Lead the design and implementation of enterprise data warehouses using industry standard best practices (Kimball, star schema, and related dimensional modeling approaches). Architect and optimize ETL pipelines and integrations using SQL Server and other Microsoft Data Platform tools. Translate business requirements into scalable technical solutions with strong data modelling and integration. Collaborate closely with business stakeholders and technical teams. Develop and maintain data models, architectural documentation, and technical artifacts. Optimize and troubleshoot data warehouse performance and ETL pipelines. Mentor and support other team members, driving technical and architectural best practices.

Qualifications & Experience:



7+ years' experience

as a Data Engineer, with at least

2 years in a senior or data architecture capacity.

Demonstrated experience in enterprise

data warehouse design, ETL pipeline development, and dimensional modelling.

Expert-level skills in

Microsoft SQL Server

(development, performance tuning

), star schemas, and Microsoft Data Platform tools

(e.g., SSIS, ADF, Power BI). Strong knowledge of the

Kimball methodology and dimensional modelling

. Proven ability to work with industry standard software engineering practices such as requirements analysis, solution design, construction, testing, implementation, and validation. Experience in translating business requirements into technical designs and specifications. Experience in the full data solution lifecycle: requirements gathering, prototyping, modelling, construction, testing, implementation, and ongoing support.

Leadership capabilities at a technical level

: guiding teams, evaluating existing architectures, and introducing improvements aligned to industry best practices. Understanding of

data quality

, security, and end-to-end documentation standards. Ability to provide traceability and impact analysis for major data projects

Advantageous

:

Experience with cloud data platforms (Azure, AWS, Google Cloud). Background in data governance, metadata management, and data quality frameworks. Experience working in Agile environments.

Key Attributes:



Excellent communicator Able to interact with clients at a systems analysis level You have a knack for picking up new technologies Love to find easier ways of doing things, and a good problem solver Passionate about technology Proven people management skills Delivery focused Able to work in projects (multi-task) environment Responsive to change

Why Join Us?



Be part of a team that values collaboration, innovation, and excellence. Contribute to meaningful projects that support operational transformation and business agility. Work in a fast-moving environment that encourages feedback, ownership, and autonomy. Develop professionally in an environment that champions growth and learning. Enjoy the flexibility and responsiveness of a dynamic workplace.

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 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 are looking to join an organisation where people really do matter, take a look at our open roles: www.saratoga.co.za/careers/

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: https://saratogasoftware.com/privacy-policy/

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD1541538
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Cape Town, WC, ZA, South Africa
  • Education
    Not mentioned