Analytics Engineer
Engineering, Remote, Full-time
ABOUT THRIVE MARKET
Thrive Market was founded in 2014 with a mission to make healthy living easy and affordable for everyone. As an online, membership-based market, we deliver the highest quality healthy and sustainable products at member-only prices, while matching every paid membership with a free one for someone in need. Every day, we leverage innovative technology and member-first thinking to help our over 1,000,000+ members find better products, support better brands, and build a better world in the process. We recently reached a significant milestone by becoming a Certified B Corporation, making us the largest grocer to earn this coveted qualification.
Thrive Market’s Data Engineering team is expanding, this time we need to bring on an Analytics Engineer to be responsible for the design, development, and maintenance of data models that power Thrive Market's analytics platforms. As a data professional, your retail domain expertise will be pivotal in driving systems that generate first-party data. Additionally, they are also able to provide data solutions that help solve our challenges and data needs. You will help us execute our Data Engineering & Analytics initiatives and turn them into products that will provide great value to our members. In this role, we are hoping to bring someone in who is equally excited about our mission, learning the tech behind the company, and has the ability to mentor, lead, and share their expertise with other team members.
RESPONSIBILITIES:
- Data Modeling
- Create and sustain an Enterprise Data Model (EDM) that acts as a comprehensive framework for both strategic and tactical planning for the management of the enterprise data warehouse
- Design, implement, and enforce data modeling best practices, standards, and guidelines to ensure consistency across different data sources and projects. This includes applying Thrive Market data naming standards and documenting data model translation decisions
- Applying a forward engineering approach to design and build databases for OLAP models, coupled with a solid grasp of data warehousing design patterns and modeling techniques
- Collaborate with business stakeholders and subject matter experts to identify tangible metrics, and data entities to create data models for self-service data and reporting needs
- Lead data governance activities - metadata management, data lineage, and data dictionary maintenance
- Work closely with data engineers to validate data model designs and provide guidance during the implementation phase
- Design and implement optimized data models to support business requirements while ensuring models are optimized for performance and scalability
- Document data models and data architecture artifacts; develop and maintain a data dictionary and metadata repository
- Create source-to-target mapping documents to enable data engineers to build data pipelinesConduct codebase reviews of data pipelines & reporting datasets to verify data lineage and validate conclusions drawn from data insights
- Data Architecture
- Facilitate joint Architecture Design sessions to determine data rules and hold logical data model and physical data model reviews with Data stakeholders
- Identify strategic opportunities to rationalize data sets and views that from logical hierarchies reduce redundancy and data movement
- Deliver solutions that leverage robust data pipelines and data models to support reporting use cases for the enterprise
- Troubleshoot and resolve data-related issues and failures in the production environment
- Guide, educate, and mentor the Data Architecture Strategy directives, principles, & standards with Data Engineers and Data Analysts by emphasizing methodology, modeling, and governance with the data team to create best practices
- Capture and maintain metadata, creating business rules for the use of data
- Provide direction, guidance, and oversight for data quality controls by performing data profiling and analysis to understand data quality and completeness
- Capture and maintain metadata, creating business rules for the use of data
- Identify opportunities for standardizing data descriptions, integration and archiving, and elimination of unnecessary redundancy.
QUALIFICATIONS:
- Bachelor's degree in Computer Science, Information Systems, or a related field. A master's degree is a plus
- At least 5 years as a Data Engineer, Analytics Engineer, or Data Architect, designing and implementing data models for enterprise-scale applications
- Proficient hands-on experience developing and managing data pipelines with Airflow, working with cloud data warehouses like Snowflake, transforming data using DBT, and building applications and automation using Python
- Expert in writing, optimizing, and troubleshooting advanced SQL queries
- Experience with major cloud platforms (AWS, GCP, Azure) and container technologies like Docker for development, deployment, and orchestration
- Experience with data integration techniques, including ETL/ELT processes, data warehousing, and data lakes
- Strong understanding of Star or Snowflake schema, and related concepts such as datamarts and cubes
- Strong understanding of the analytics development lifecycle from requirements, logical and physical data model design, implementation, testing, deployment, and support
- Knowledge of data governance principles and practices, including data quality management and metadata management
- Excellent analytical thinking and problem-solving skills with the ability to translate complex business needs into actionable data solutions
- Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and present technical concepts to non-technical stakeholders
- Proven ability to thrive in fast-paced dynamic work environments and effectively manage multiple priorities.
BELONG TO A BETTER COMPANY:
- Comprehensive health benefits (medical, dental, vision, life and disability)
- Competitive salary (DOE) + equity
- 401k plan
- Flexible Paid Time Off
- Subsidized ClassPass Membership with access to fitness classes and wellness and beauty experiences
- Ability to work in our beautiful co-working space at WeWork in Playa Vista and other locations
- Dog-Friendly Office
- Free Thrive Market membership with exclusive employee discount
- Coverage for Life Coaching & Therapy Sessions on our holistic mental health and well-being platform
We're a community of more than 1 Million + members who are united by a singular belief: It should be easy to find better products, support better brands, make better choices, and build a better world in the process.
At Thrive Market, we believe in building a diverse, inclusive, and authentic culture. If you are excited about this role along with our mission and values, we encourage you to apply.
Thrive Market is an EOE/Veterans/Disabled/LGBTQ employer
At Thrive Market, our goal is to be a diverse and inclusive workplace that is representative, at all job levels, of the members we serve and the communities we operate in. We’re proud to be an inclusive company and an Equal Opportunity Employer and we prohibit discrimination and harassment of any kind. We believe that diversity and inclusion among our teammates is critical to our success as a company, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. If you’re thinking about joining our team, we expect that you would agree!
If you need assistance or accommodation due to a disability, please email us at eoe@thrivemarket.com and we’ll be happy to assist you.
Ensure your Thrive Market job offer is legitimate and don't fall victim to fraud. Thrive Market never seeks payment from job applicants. Thrive Market recruiters will only reach out to applicants from an @thrivemarket.com email address. For added security, where possible, apply through our company website at www.thrivemarket.com.
© Thrive Market 2023 All rights reserved.
JOB INFORMATION:
- Compensation Description - The base salary range for this position is $150,000 - $190,000/Per Year.
- Compensation may vary outside of this range depending on a number of factors, including a candidate’s qualifications, skills, competencies and experience, and geographic location.
- Total Compensation includes Base Salary, Stock Options, Health & Wellness Benefits, Unlimited PTO, and more!