Job Description

View All Jobs

Data Warehouse Engineer

× Email This Job Your First Name
Your Last Name
Your E-Mail Address
E-Mail Address to Share With
Subject
Message
Prove you're not a robot Send E-Mail Close US-CA-San Luis Obispo

• Apply
• × Employee Referral Tell Us Who You Are First Name
  Last Name
  E-Mail Address
  Please complete all 3 fields. How Do You Want to Share?
  Close

Bloomberg Gender-Equality Index
MINDBODY is one of 230 companies selected for the 2019 Bloomberg Gender-Equality Index (GEI) which distinguishes companies committed to transparency in gender reporting and advancing women’s equality. We believe that when women thrive, companies thrive.

JOB FAMILY SUMMARY:

Mindbody’s Data Science department makes sense of our data world through meaningful and actionable insights, identifying trends, delivering reports, informing product and infrastructure advancements, and promoting a culture of data-driven decision making.

The Data Warehouse Engineering branch of Mindbody’s Data Science department is focused on providing innovative and large-scale data platform solutions in a shared services model to support enterprise data needs of Mindbody. This involves building data pipelines to pull together information from different source systems; integrating, consolidating and cleansing data; and structuring it for use in reporting and analytical applications. This team also architects distributed systems, data stores, and collaborates with data science teams in building right solutions for them. The data provided by the team is used by data science in supporting key functions and initiatives within Product Development, Business Development, Customer Experience/Success, Marketing and Sales at Mindbody.

JOB SUMMARY:

Data Warehouse Engineer II focuses on designing, implementing and supporting new and existing data solutions- data processing, and data sets to support various advanced analytical needs. You will create and support data pipelines to integrate with multiple external sources using APIs, databases, flat files. You will liaise with members of the wider Mindbody Data Science teams to ensure alignment with existing systems and consistency with internal standards and best practice.

MINIMUM QUALIFICATIONS AND REQUIREMENTS:

• Bachelor's degree or higher in a quantitative/technical field (e.g. Computer Science, Statistics, Engineering
• 5+ years of relevant experience in one of the following areas: Data Warehouse, business intelligence or business analytics
• 5+ years of hands-on experience in writing complex, highly-optimized SQL queries across large datasets
• 3+ years of experience in scripting languages like Python etc.
• Experience in data modeling, ETL development, and Data warehousing
• Data Warehousing Experience with Oracle, Redshift, etc.
• Experience with AWS services including S3, Redshift, EMR and RDS
• Experience with Big Data Technologies (Hadoop, Hive, HBase, Pig, Spark, etc.)
• 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

PRINCIPAL DUTIES AND RESPONSIBILITIES:

• 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 Redshift
• 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 Spark.
• 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
• Provide on-call support for after-hours critical batch process issues.
• Participate in strategic & tactical planning discussions, including annual budget processes
• All other duties as assigned

DEPARTMENT OF LABOR NOTICE OF FILING

This notice is being provided as a result of the filing of an application for permanent alien labor certification for the job opportunity below. A person may provide documentary evidence bearing on the application to the U.S. Department of Labor, Employment and Training Administration, Office of Foreign Labor Certification, 200 Constitution Avenue, NW, Room N-5311, Washington, DC 20210.

Mindbody, Inc. seeks a Data Warehouse Engineer (San Luis Obispo, CA) that provides business management software-as-a-service for the wellness industry, design, implement, and support a platform providing access to large datasets. Create unified enterprise data models for analytics and reporting. Design and build robust and scalable data integration (ETL) pipelines using SQL, Python and Spark. As part of Agile development team contribute to architecture, tools, and development process improvements. Work in close collaboration with product management, peer system and software engineering teams to clarify requirements and translate them into robust, scalable, operable solutions that work well within the overall data architecture. Coordinate data models, data dictionaries, and other database documentation across multiple applications. Lead design reviews of data deliverables such as models, data flows, and data quality assessments. Promote data modeling standardization; define and drive adoption of standards. Work with Data Management to establish governance processes around metadata to create an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata. Master’s degree in Computer Science, Information Systems or related. Position located in San Luis Obispo, CA but can work remote anywhere in the US.

Send Resumes to: [email protected] .