Data Warehouse Engineer I

Mindbody, Inc San Luis Obispo , CA 93403

Posted 2 months ago

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 Engineering (DE) 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 the right solutions for them. The data provided by the DE team is used by data science team in supporting key functions and initiatives within Product Development, Business Development, Customer Experience/Success, Marketing and Sales at MindBody.

Data Warehouse Engineer I focuses on integrating, consolidating, and cleansing data from multiple source systems including the data from companies acquired by MindBody. This position works closely with their manager to prioritize tasks that are important in supporting our product and business units.

MINIMUM QUALIFICATIONS AND REQUIREMENTS:

  • Bachelor's degree or equivalent experience

  • 1-year (preferably 2-3 years) experience building/operating systems for data extraction, ingestion, and processing of large data sets

  • Basic proficiency in MS SQL, SSIS (or any other ETL tool), R, Python, Amazon RedShift, MS Azure

  • Industry experience as a Data Engineer or related specialty (e.g., Software Engineer, Business Intelligence Engineer, Data Scientist, Business Analyst

  • Hands-on experience with SQL query language, data warehouse, RDBMS and common BI tools and techniques

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

  • A 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:

  • Develop new ETL processes to fulfill the data needs of data science and other departments

  • Utilize expertise in data modeling, ETL architecture, and report design for department initiatives

  • Produce detailed documentation including data flow diagrams, logical diagrams, and physical diagrams as needed

  • Ensure the data collection pipeline and data analysis infrastructure meet the needs of the business

  • Acquire strong knowledge of data structures, analysis, replication and distributed/ relational data & database mapping

  • Provide insights and analyses around product and customer data

  • Assist with SQL code review process for purposes of learning, asking new questions and finding errors

  • Assist with development of new scripts, KPIs and dashboards

  • Consult with management to understand current and future business goals and strategies, and ensure that high-visibility reporting and analysis is aligned

  • All other duties as assigned

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Data Warehouse Engineer

Mindbody, Inc

Posted 3 months ago

VIEW JOBS 2/7/2019 12:00:00 AM 2019-05-08T00:00 The Senior Data Engineer focuses on designing, implementing and supporting new and existing data solutions- data processing, and data sets to support various advanced analytical needs. You will be designing, building and supporting data pipelines consuming data from multiple different source systems and transforming it into valuable and insightful information. You will have the opportunity to contribute to end-to-end platform design for our cloud architecture and work multi-functionally with operations, data science and the business segments to build batch and real-time data solutions. The role will be part of a team supporting our Corporate, Sales, Marketing, and Consumer business lines. MINIMUM QUALIFICATIONS AND REQUIREMENTS: * 7+ years of relevant experience in one of the following areas: Data engineering, business intelligence or business analytics * 5-7 years of supporting a large data platform and data pipelining * 5+ years of experience in scripting languages like Python etc. * 5+ years of experience with AWS services including S3, Redshift, EMR and RDS * 5+ years of experience with Big Data Technologies (Hadoop, Hive, HBase, Pig, Spark, etc.) * Expertise in database design and architectural principles and methodologies * Experienced in Physical data modeling * Experienced in Logical data modeling * Technical expertise should include data models, database design and data mining PRINCIPAL DUTIES AND RESPONSIBILITIES: * 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 * Leads design reviews of data deliverables such as models, data flows, and data quality assessments * Promotes data modeling standardization, defines and drives adoption of the standards * Work with Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata Mindbody, Inc San Luis Obispo CA

Data Warehouse Engineer I

Mindbody, Inc