Senior Analytics Engineer

This is a fully remote position, open to applicants in South Africa.

📋 Description

• Report to the team lead and play a vital role in our transition from a legacy SQL Server data infrastructure to a contemporary cloud data environment that includes Snowflake, dbt, and Tableau.

• Design and construct data pipelines utilizing Snowpark and/or Snowpipe where native connectors are unavailable for Snowflake, catering to various data sources.

• Assist in the design and development of a new multi-dimensional data model within Snowflake.

• Collaborate closely with our Business Intelligence team, overseeing and implementing enhancement requests for the data warehouse to satisfy the reporting needs of stakeholders.

• The ideal candidate will have the chance to hone mentoring abilities as we aim to elevate the team’s skill set to align with that of our US counterparts. Given our collaborative work with team members across different time zones, strong interpersonal skills are essential.

⛳️ Requirements

• Over 5 years of experience in data engineering, preferably with a focus on cloud migration to Snowflake.

• Proficient in SQL, including the use of CTEs and window functions.

• Expertise in Python for constructing pipelines with Snowpark.

• Experience in designing multi-dimensional data models utilizing star schema and Type 2 Slowly Changing Dimensions (SCDs).

• Familiarity with dbt for developing robust ELT processes.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Opportunities for professional development and continuing education.

• Flexible working hours and the possibility for remote work.

• A collaborative and supportive team environment.

• Comprehensive health benefits and retirement plans.