Data Engineer (SQL experience essential)

Mimecast

  • Johannesburg, Gauteng
  • Permanent
  • Full-time
  • 2 months ago
Analytics EngineerWe’re your dream business intelligence team!The Business Intelligence & Analytics team at Mimecast is an exciting blend of business, data, and technology. Using a high-powered technology stack that includes Tableau, dbt, Cloud & On-prem Data Warehouse and business applications, the team answers business questions, designs and develops enterprise-wide reporting, visualization and analytic tools to turn data into actionable insight. In turn, we enable our stakeholders to make smarter, data-driven decisions. You will be part of a fast-paced, team-centric environment committed to delivering strategic, management and operational insight.What you’ll do
  • 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
What you'll bring
  • 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
What we BringWe are Mimecasters. And we are alive with purpose.We do what we need to protect the world of business from getting important (and potentially compromising) data stolen. We never leave anyone behind. We deliver quickly – and outstandingly. We’re big on honesty because it makes us better. We’re empowered by our mission. And if cybercriminals have a good day, we work twice as hard to make the rest of their days a nightmare. That’s The Mimecast Way.DEI StatementCybersecurity is a community effort. That’s why we’re committed to building an inclusive, diverse community that celebrates and welcomes everyone – unless they’re a cybercriminal, of course.We’re proud to be an Equal Opportunity and Affirmative Action Employer, and we’d encourage you to join us whatever your background. We particularly welcome applicants from traditionally underrepresented groups.We consider everyone equally: your race, age, religion, sexual orientation, gender identity, ability, marital status, nationality, or any other protected characteristic won’t affect your application.Due to certain obligations to our customers, an offer of employment will be subject to your successful completion of applicable background checks, conducted in accordance with local law.

Mimecast