Perelel Job Title: Senior Data Analyst Location: Remote Reports To: Sr Director of Strategic Analytics Contact: careers@perelelhealth.com with [Sr. Data & Full Name] in subject About Us Perelel is the first OBGYN-founded vitamin brand on a mission to transform women's reproductive health. As a high-growth, women-led company, we deliver stage-specific vitamins and supplements backed by medical expertise for every phase of a woman's lifecycle. Join our growing team dedicated to filling critical gaps in women's healthcare while building a community that empowers through evidence-based solutions. Role Summary We're looking for a seasoned analytics professional who excels at transforming raw data into reliable, actionable insights. You'll be responsible for building and maintaining our data transformation layer using modern tools like dbt, while also delivering high-impact analysis across customer behavior, product performance, and business operations. This role combines hands-on technical data work with strategic analytics leadership. Key Responsibilities Data Transformation & Modeling • Design and implement data transformation pipelines using dbt to create clean, reliable datasets for analysis • Build and maintain dimensional data models that support consistent reporting across the organization • Develop automated data quality tests and validation frameworks to ensure data integrity • Create reusable data marts and analytics tables that serve multiple business functions • Optimize SQL queries and transformation logic for performance and maintainability • Establish data lineage documentation and governance practices ETL Development & Maintenance • Build and manage ETL processes that integrate data from e-commerce platforms, marketing tools, and operational systems • Design efficient data extraction workflows from APIs, databases, and third-party services • Implement incremental loading strategies and change data capture processes • Monitor and troubleshoot data pipeline failures, ensuring reliable data delivery • Collaborate with engineering teams to improve source system data quality and structure Analytics & Reporting • Develop comprehensive dashboards and reporting solutions that track key business metrics • Conduct deep-dive analyses on customer segmentation, product performance, and operational efficiency • Lead A/B test design and statistical analysis to measure marketing and product initiatives • Create executive-level reports and presentations that communicate findings to leadership • Build self-service analytics capabilities that empower non-technical teams Required Qualifications • Bachelor's degree in Data Science, Statistics, Mathematics, Economics, Business Analytics, or related field • 3-5 years of experience in data analysis, business intelligence, or analytics roles • Advanced proficiency with dbt for data transformation and modeling • Strong experience building ETL pipelines using tools like Airflow, Fivetran, Stitch, or custom solutions • Expert-level SQL skills with experience in data warehouses (Snowflake, BigQuery, Redshift) • Proficiency in Python or R for statistical analysis and data manipulation • Experience with business intelligence tools (Tableau, Looker, Power BI, or Mode) • Strong understanding of dimensional modeling and data warehouse design principles • Proven track record of delivering analytics that drive business decisions Preferred Qualifications • Experience with cloud data platforms and modern data stack technologies • Knowledge of statistical methods, experimental design, and A/B testing frameworks • Previous experience in CPG, e-commerce, or direct-to-consumer industries • Familiarity with customer analytics and marketing attribution models • Experience with version control (Git) and collaborative development practices • Understanding of data governance, privacy regulations, and compliance requirements • Experience leading analytics projects and mentoring junior team members Technical Environment • Data warehouse: Snowflake • Transformation: DBT • BI Tools: Looker • Languages: SQL, Python • Cloud: AWS • Version control: Github What We Offer • Competitive salary with unlimited PTO • Comprehensive health, dental, and vision insurance • Flexible work arrangements with remote-friendly culture • Professional development budget for courses, conferences, and certifications • Access to our full product line and wellness benefits • Ownership of critical data infrastructure with high visibility across the organization • Fast-track career growth as the company scales