Lovevery is a fast-growing digitally native brand co-founded by successful serial entrepreneurs and based in Boise, Idaho. Our customers are parents, and our mission is to help them feel confident they are giving their children meaningful development experiences in the critical early years of life. Taking a science-based approach, Lovevery products have won awards from Red Dot, Parents’ Choice, and NAPPA. TIME Magazine named The Play Kits subscription offering as one of the Best Inventions of 2018.


About the role

This role will act as a bridge between analysts, engineers, product managers, business stakeholders, and more to ensure that the business is supplied with clean, actionable data. This can range from reporting on department or business level KPI’s to translating complex analytics models into automated exploration templates for business users to better understand how they can be effective in their roles.


About you

  • Results Oriented: focused on delivering content that drives action, not just dashboards for the sake of dashboards.
  • Organized Communicator: able to gather, interpret, and document business requirements and translate them into engineering roadmap items.
  • Scalable Mindset: excited about helping to create a world-class data platform that scales easily and prioritizes the end user.
  • Full Pipeline Perspective: eager to develop a deep understanding of what factors drive business success, what metrics need to be surfaced to support those factors, and how to derive those metrics from raw data.


Responsibilities

  • Collaborate on building end-to-end reporting solutions, from identifying and connecting raw data sources to delivering actionable insights through visual storytelling.
  • Transform raw data to a globally consolidated, intelligent design scheme on Databricks Delta using DBT
    • Use platform best practices for fast, efficient queries.
    • Test for transformation accuracy, anomalies, and relational integrity at every step in the pipeline.
    • Create transformations that favor readability and cleanliness over abstraction or consolidation.
    • Create clear, insightful, automated visualizations and reports that provide visibility into business performance, issues, and opportunities.
    • Tackle multiple domains of data transformation and reporting, including revenue recognition, email metrics, website and mobile app analysis, customer retention, marketing efficiency, and more.
    • Translate complex ad-hoc analytical models into templated transformations that users can access and explore easily.
    • Proactively gather business data requirements and translate them into engineering and analytic initiatives.
    • Support power users throughout the business in owning their data and learning how to surface reporting using the tools you build.
    • Establish and promote a single source of truth for business term definitions and calculations through documentation and proactive stakeholder communication.
    • Implement extensive monitoring, testing, and alerting in a data and reporting platform to ensure accuracy and freshness.


    Qualifications

    • Experience building out production datasets and a proven ability to implement key industry data warehousing techniques on a new technology such as Delta Lakehouse or other cloud-based platform. (3-5+ years)
    • Advanced understanding of automating data transformations using SQL or PySpark, preferably with a tool like DBT. (3+ years)
      • Experience with configuration and macro writing within DBT for code consolidation.
      • Mastery of one or more Business Intelligence platforms, such as Looker, Tableau, or PowerBI. (3+ years)
      • History of building testing and alerting into reporting systems that proactively identifies issues and opportunities.
      • Strong communication skills regarding highly technical concepts with stakeholders at multiple levels of business, including:
        • Presenting analytical insights to department heads and executives.
        • Teaching business users how to explore and ‘own’ their data in Looker.
        • Familiar with reporting requirements of organizations in the e-commerce space, specifically related to customer retention, marketing optimization, and website/mobile app tracking.
        • Comfortable with shared code version control systems like Git.


        Our Benefits Include

        • Competitive salary, benefits and stock option package
        • 3 weeks PTO in year 1 +14 paid holidays
        • Generous parental leave
        • Any equipment you need to get the job done
        • Free/discounted Lovevery products
        • Remote working option available anywhere in the US

        Salary Range Information

        Based on market data and other factors, the salary range for this position is $101,000 to $165,000. However, a salary higher or lower than this range may be appropriate for a candidate whose qualifications differ meaningfully from those listed in the job description.

        Lovevery is proud to be an equal opportunity employer that values diversity in all forms. All employment decisions at Lovevery are based on business needs, job requirements, and individual qualifications, without regard to race, religion, national origin, sexual orientation, gender identity, HIV status, marital status, or any other status protected by the laws or regulations in the locations where we operate.