Data Engineer

Who we are

We’re a passionate engineering, platform, and operations team, developing and supporting ground-breaking products. Together, we’ll build for the future, creating more opportunities for wellness businesses around the world to help their customers lead full, healthy lives. We push ourselves and our company to always strive for this higher purpose, recognizing the power in working together toward the same goal. We believe in building a diverse company where everyone feels safe bringing their authentic selves to work. And we believe that the secret to success is our people.  Join the team, and let’s see what we can accomplish together!  

Your role

The Data Engineer focuses on designing, implementing, and supporting new and existing data solutions, data processing, and data sets to support various advanced analytical needs. This role creates and supports data pipelines to integrate with multiple external sources using APIs, databases, and flat files. This role also works cross functionally to ensure alignment with existing systems and consistency with internal standards and best practice.   

You'll likely spend time working on

• Design, implement, and support a platform providing access to large datasets 

• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources 

• Implement data structures using best practices in data modeling, ETL/ELT processes, and SQL, and Snowflake. 

• Model data and metadata for ad hoc and pre-built reporting 

• Interface with business customers, gathering requirements and delivering complete reporting solutions 

• Build robust and scalable data integration (ETL) pipelines using SQL, Python and Data Bricks. 

• Build and deliver high quality datasets to support business analyst and customer reporting needs. 

• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers 

• Participate in strategic & tactical planning discussions, including annual budget processes 

• All other duties as assigned 

About the right team member

  As a Data Engineer, you’ll be a part of a team working to build secure, easy to use systems for the Mindbody ecosystem. You collaborate well with your team to learn, share, and grow. You’ll pursue continuous improvement to help Mindbody achieve its mission: Powering the world’s fitness and wellness businesses and connecting them with more consumers, more effectively, than anyone else.

You'll thrive in this role with experience in

• Entry-level experience in one of the following areas: data warehouse, business intelligence or business analytics 

• Hands-on experience in writing complex, highly optimized SQL queries across large datasets 
• Solid experience in scripting languages like Python
• Experience in data modeling, ETL development, and Data warehousing

• Experience in working and delivering end-to-end projects independently 

• Strong attention to detail, analytical mindset, and highly organized 

• Desire to work in a fast paced, potentially ambiguous, start-up-like atmosphere 

• Strong technical aptitude and demonstrated ability to quickly evaluate and learn new technologies 

• Strong interpersonal skills, with the ability to work independently and within a team environment 

Technologies you'll be working with

• Scripting languages like Python

• Experience in data modeling, ETL development, and Data warehousing 

• Data Warehousing Experience with Oracle, Redshift, etc. Secondary Skills: DBT, Databricks, Looker, Tableau (or any other BI tools) 

• Intermediate Experience with AWS services.