Data Engineer

Ancient Nutrition; United States; Remote; USD 80,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Unlimited Paid Time Off

Access to Ancient Nutrition products

Job summary

A leading health and nutrition company is seeking a Data Engineer to build data pipelines and support analytics across various departments. This remote role requires 2+ years of experience, SQL proficiency, and skills in data visualization tools like Tableau. The company values teamwork, flexibility, and a proactive approach. Benefits include health insurance, unlimited paid time off, and product discounts. Candidates are encouraged to submit a compelling cover letter to showcase their fit for the position.

Qualifications

• 2+ years of Data Engineer experience or similar field.
• Proficient in SQL with relational database architecture experience.
• Ability to present technical concepts to a non-technical audience.

Responsibilities

• Partner with business leaders to document data needs.
• Build ETL solutions and maintain data integrations.
• Design new data models and optimize PostgreSQL performance.

Skills

SQL

Data Visualization (Tableau recommended)

ETL Tools

Critical Thinking

Problem-Solving

Tools

PostgreSQL

Tableau

Job description

Ancient Nutrition is rooted in our founders’ own personal health journeys and a desire to make history’s most powerful superfoods accessible to everyone. But what started as a mission to create high-quality supplements – ones informed by ancient wisdom, backed by modern science and that the world had never seen before – has grown into a steadfast commitment to transform the way we grow our food.

Because growing the world’s most nutrient-dense superfoods requires the healthiest soil possible and conventional farming is harming both the planet and its people. That’s why we’re on a much larger mission to restore our farmlands and heal our planet through organic regenerative farming practices that give back to the Earth – not just take from it– leaving it better than we found it for future generations to thrive.

Overview

This is an exciting opportunity for a Data Engineer who is passionate about data in all areas of the business. Reporting directly into the Data Engineering Manager, the ideal candidate will have experience building data pipelines, designing data models, and creating reports in a CPG environment. This role provides the opportunity to work with stakeholders across the company (Finance, Retail Sales, Ecommerce, and Customer Service) to translate their ideas into meaningful datasets and visualizations. This person will play a critical role in building our data warehouse, expanding our analytics capability and, as a result, driving our overall performance as a business.

What You’ll Be Doing

• Partner with key leaders across the business to document and understand their data and analytics needs
• Build new ETL solutions and maintain existing integrations for loading data from various platforms into our PostgreSQL database
• Design new data models in our existing data warehouse for specific reporting requests
• Optimize the performance of the PostgreSQL database by implementing efficient data structures
• Design pipelines to automate manual business processes across all areas of the business including Finance, Retail Sales, Ecommerce, and Customer Service
• Build and publish Tableau data sources that serve as a central source of truth for the entire company
• Create new Tableau reports and make updates to existing reports for stakeholders across the business
• Work alongside the BI Strategy team to ensure data and reporting accuracy in Tableau reporting and ad-hoc analyses
• Build and maintain a monitoring and alert process for the Direct Response Television (DRTV) order API

Experience Required

• 2+ years of experience as a Data Engineer (or similar field)
• Must be proficient in SQL and have experience with relational database architecture
• Must have developer skills in data visualization tools such as Tableau (recommended) or Looker
• Knowledge of ETL tools and data integration
• Experience analyzing ERP Financial and eCommerce data in a CPG environment
• Ability to present technical concepts/analyses to a non-technical audience
• Ability to extract, analyze and model relevant data from various data sources
• Strong critical thinking and problem-solving skills

Core Attributes

• You are intellectually curious and are constantly challenging our own best practices (“There’s always a better way” mentality).
• You work well in a team environment.
• You roll up your sleeves and dig in.
• You are flexible. You understand that in a fast-growing company things can change last minute.
• You are a proactive self-starter who is eager to play a key role in growing a brand.
• You are organized and detailed.
• You have a can-do attitude and are an avid team player.

Core Values

• Run to win the race – do everything with excellence
• Committed to constant growth – refine and improve self and work daily
• Take ownership – take initiative
• Be a purpose driven leader/team player – be reliable and responsible
• Fight for one another and others – play as a team and works well with others

Benefits + Culture

Work is about what you do, not where you do it. Ancient Nutrition has many team members located near Nashville, TN but we are a fully remote company and can hire from across the US. Ancient Nutrition is a laid back, but fast-paced place to be. We work hard because we love what we’re building. No one breathes down your neck. We hire great people who don't need to be micromanaged.

We offer health insurance benefits, basic life insurance and access to affordable vision, dental and disability insurance. Unlimited Paid Time Off is a given for salary employees and a generous amount of paid time off accrual for hourly employees, both paid maternity and paternity leave are offered.

We are passionate about living healthy lives and offer free Ancient Nutrition products.

If you feel this role is meant for you, write us a killer cover letter telling us why you are the best fit, and why you want to work with us! We really do read them!