Data Engineer (SQL experience essential)
Mimecast
- Johannesburg, Gauteng
- Permanent
- Full-time
- Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models
- Build trust in all interactions in data development
- Be the primary point of contact for major sections of enterprise data models
- Design, develop, and extend dbt code to build upon enterprise data models
- Maintain the clear documentation for consumers of data sources
- Implement data ops principles in everything you do
- Craft code that meets our internal standards for style, maintainability, and best practices for a high-scale database environment. Maintain and advocate for these standards through code review.
- Approve data model changes for specific database and data model schemas
- Provide data modeling expertise to all teams through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake
- Be a result driven and optimistic problem solver
- Comfort working in a highly agile, intensely iterative environment
- Self-motivated and self-managing, with task organizational skills
- Great communication: Regularly achieve consensus amongst technical and business teams
- Demonstrated capacity to clearly and concisely communicate complex business activities, technical requirements, and recommendations
- Demonstrated experience with one or more of the following business subject areas: marketing, finance, sales, product, customer success, customer support, or engineering
- Highly proficient in SQL. You can interpret and optimize queries, for performance, written by other analysts and engineers
- Experience in data transformations and modeling using dbt
- Experience in the data space as an analyst, engineer, or equivalent
- Experience designing, implementing, operating, and extending enterprise dimensional models
- Experience working with a large-scale data warehouse, preferably in a cloud environment
- Experience building reports and dashboards in a data visualization tool
- Experience maintaining a project workstream to identify tasks, milestones, and deliverables