Analytics Engineer

At iFIT, we are creating the world's most holistic health and fitness platform. We integrate physical fitness, mental health, nutrition, and active recovery into a seamless, interactive experience. Our proprietary software learns from and adapts to each member, delivering immersive content that guides them on a truly personalized fitness journey. To do this, we need data to be the engine that powers this personalization and our business strategy.

We are not looking for a traditional analytics engineer who just builds pipelines from a backlog. We are looking for a Forward-Deployed Analytics Engineer to act as the full-stack data partner for a key business domain (e.g., Product, Marketing, or Finance).
Your mission is to embed within that team, deeply understand their challenges and opportunities, and build the end-to-end data products that give them a competitive edge. You will be a true owner, moving beyond just transforming data to building the semantic models, BI experiences, and automated insights that drive decisions. Crucially, you will have an AI-first mindset, relentlessly seeking to leverage generative AI, code assistants, and automated tooling to accelerate development, ensure impeccable data quality, and scale our self-service capabilities.
This ambitious pace-setter will join our team as an Analytics Engineer that will act as the bridge between data engineering and data analysis, ensuring that raw data is transformed into clean, reliable, and accessible datasets that fuel business insights. This role is responsible for building and maintaining robust data models, optimizing data pipelines, and enabling analysts and business teams with trusted, well-documented data.

What You'll Achieve
⦁ Become a Strategic Data Partner: Serve as the primary data expert and consultant for your embedded business domain. You won't just take requirements; you will anticipate needs and proactively propose data solutions to strategic business problems.
⦁ Deliver Full-Stack Data Products: Own the entire analytics development lifecycle, from raw data ingestion and modeling in our data warehouse to the final semantic layer and dashboards that our business teams use every day.
⦁ Champion AI-Augmented Development: Radically accelerate your workflow by leveraging generative AI and code assistants (e.g., GitHub Copilot, dbt's Semantic Layer) for code generation, automated documentation, and advanced data quality testing.
⦁ Build a Foundation of Trust: Architect and implement robust, scalable, and highly performant data models using dbt and Snowflake, creating a single source of truth that the entire company can rely on.
⦁ Empower the Enterprise: Drive the adoption of self-service analytics by building intuitive, well-documented datasets and BI tools (Tableau, Sigma, Looker), enabling stakeholders to answer their own questions with confidence and speed.

Core Responsibilities
⦁ Collaborate intimately with product managers, marketers, and other stakeholders to translate ambiguous business questions into concrete data requirements and technical specifications.
⦁ Design, build, and own sophisticated data models on Snowflake using dbt, following software engineering best practices (version control, CI/CD, testing).
⦁ Develop and automate AI-powered data quality checks, anomaly detection, and observability to ensure the highest level of data integrity and trust.
⦁ Optimize our data stack for performance and cost-efficiency, ensuring our queries are fast and our infrastructure is scalable.
⦁ Build and refine our semantic layer in Snowflake Intelligence, dbt, or BI tools, making data intuitive and accessible for non-technical users.
⦁ Act as a force multiplier by mentoring analysts and business users, teaching them how to leverage the data products you build.
⦁ Stay on the bleeding edge of the modern data stack and AI in data, constantly experimenting with and recommending new tools and methodologies to improve our capabilities.

Who You Are
⦁ An Owner: You possess a strong sense of ownership and are driven to see your projects deliver tangible business value from conception to completion.
⦁ A Pragmatic Builder: You have 4+ years of hands-on experience in analytics engineering, data engineering, or a similar role, with a strong portfolio of building data models and pipelines in a cloud environment.
⦁ Fluent in Modern Data Tooling:
⦁ Expert-level SQL and deep experience with data modeling concepts (e.g., star/snowflake schemas, Kimball methodologies).
⦁ Production experience with dbt is a must.
⦁ Hands-on expertise with a cloud data warehouse like Snowflake, BigQuery, or Redshift.
⦁ Proficiency with Git and CI/CD workflows (e.g., GitHub Actions).
⦁ AI Enthusiast & Early Adopter: You have demonstrable experience or a palpable passion for using AI tools in your development workflow. You actively seek ways to automate and amplify your impact with intelligent systems.
⦁ A Gifted Translator: You have exceptional communication skills and can effectively bridge the gap between complex technical concepts and business outcomes for non-technical audiences.
⦁ Business-Obsessed: You are motivated by solving business problems, not just by technology. You are naturally curious and constantly ask "why" to get to the root of the problem.

Preferred Qualifications
⦁ Experience developing in a BI semantic layer (e.g., LookML, Power BI DAX).
⦁ Familiarity with Python for data analysis and orchestration (e.g., Airflow, Dagster).
⦁ Practical experience using LLMs or generative AI tools for code generation, documentation, or data quality.
⦁ Knowledge of data observability and cataloging platforms.

ROLE COMMITMENTS (align these goals with your team and the company’s goals)
⦁ Optimize the enterprise: Deliver single source of truth data to empower fact based decisions
⦁ Deliver high-quality consumer experiences: Enable self serve BI coverage and compelling interfaces to serve our internal stakeholders
⦁ Build the most compelling connected health & fitness platform: Enable fact based decisions across Product Analytics, Customer Analytics, Marketing Analytics, Operational Analytics

ESSENTIAL DUTIES AND RESPONSIBILITIES
⦁ Design, build, and maintain scalable data models and pipelines that support analytics and business intelligence needs.
⦁ Transform raw data into clean, structured, and accessible datasets using modern data transformation tools (e.g., dbt, SQL).
⦁ Partner with data engineers to ensure reliable data infrastructure and with analysts to deliver usable, well-documented datasets.
⦁ Implement and maintain data quality frameworks, monitoring systems, and governance practices.
⦁ Optimize SQL queries and data transformations for performance and cost efficiency.
⦁ Collaborate with business stakeholders to understand data requirements and translate them into technical solutions.
⦁ Document data models, definitions, and transformation logic to ensure transparency and knowledge sharing.
⦁ Stay current with industry trends and best practices in analytics engineering and modern data stack technologies.

Education and Basic Qualifications

⦁ Bachelor’s degree in Computer Science, Data Science, Engineering, Mathematics, or related field (or equivalent work experience).
⦁ 4+ years of experience in analytics engineering, data engineering, or business intelligence.
⦁ Strong proficiency in SQL and experience with data modeling (star/snowflake schemas).
⦁ Hands-on experience with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift)
⦁ Proficiency with data transformation and orchestration tools (e.g., dbt, Airflow, Dagster).
⦁ Experience with version control (Git) and collaborative development workflows.
⦁ Strong problem-solving skills and attention to detail.

Preferred Qualifications

⦁ Familiarity with Python or other scripting languages for data manipulation.
⦁ Experience with BI tools such as Tableau, Sigma, Looker, or Power BI.
⦁ Knowledge of data governance, cataloging, and lineage tracking tools.
⦁ Exposure to DevOps/MLOps practices and CI/CD pipelines.

Key Competencies
⦁ Analytical mindset with a passion for clean, reliable data.
⦁ Strong communication skills to collaborate across technical and non-technical teams.
⦁ Ability to translate business needs into scalable technical solutions.
⦁ Continuous learner with an interest in modern data technologies and practices.

COMPENSATION AND BENEFITS
At iFIT, we strive to give our employees a well-rounded work/life balance and a positive team culture by offering:
⦁ The opportunity to work remotely-from wherever you are, or the ability to work in beautiful Cache Valley with access to an exceptional outdoor lifestyle, a university campus nearby, and the chance to test the fitness products we create.
⦁ Free mental health resources for employees and dependents
⦁ Career growth and guidance
⦁ Discounts on iFIT Products
⦁ FREE iFIT Membership
⦁ Employee discounts through ADP-LifeMart
⦁ Full benefits package (Medical, HSA, FSA, Dental, Vision and Life insurance)
⦁ Paid maternity and paid paternity leave
⦁ 401(k) with company match.
⦁ A PTO policy that ensures you can find a happy work-to-life balance.
⦁ Access to cutting-edge technology and hardware for work and fitness.
⦁ Collaborative workspace and environment.

Compensation may vary based on the job level, your geographic work location, position incentive plan and exemption status.

Although we can hire in the states listed below, not all positions are available in all locations. List of states we can hire in: AK, AL, AR, AZ, CA, CO, CT, FL, GA, ID, IL, IN, KS, KY, LA, MA, MD, MI, MN, MO, MS, NC, NH, NJ, NV, NY, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VA, WA, WI, WY.
DISCLAIMER
Your employment at iFIT is "at-will". You and the company each have the right to terminate the employment relationship at any time for any cause or for no cause at all. Nothing but an express written contract signed by you and a Vice President of this Company can modify this "employment at will" arrangement.

"We do not discriminate in employment opportunities or practices on the basis of race, color, religion, sex, national origin, age, ancestry, mental or physical disability, sexual orientation, gender identity, medical condition, genetic information, marital status, veteran status or any other characteristic protected by law."