Analytics Engineer

Aeroflow Health is made up of creative and talented associates who are transforming the home medical equipment industry. Our patient‑centric business model is founded on innovation through technology and cutting‑edge delivery platforms. We have grown to be a leader in the home medical equipment segment of the healthcare industry, are among the fastest‑growing healthcare companies in the country and recognized on Inc.

5000’s list of fastest‑growing companies in the U.S.

Within Aeroflow, the Data Operations team is comprised of a small but mighty team of data professionals. Our engineers work alongside our business stakeholders, product owners, technical leads, and QA specialists to help facilitate quality data products for our internal customers.

For this role, you will be joining our Data Operations team. This team is a group of passionate data practitioners and innovators dedicated to building cutting‑edge solutions using the latest in ELT technologies, including Airbyte, DBT, Snowflake and Sigma. You will play a pivotal role in designing, developing, and deploying models in our Data Warehouse. You will collaborate with cross‑functional teams to bring innovative ideas to life, leveraging your expertise in ELT and Data Warehouses to maximize the value of Aeroflow’s data.

Key objectives for this position include partnering with our internal stakeholders to create high value data products to drive growth, efficiency, and opportunity.

• Data Modeling:
  Design, develop, and maintain a robust and scalable data model within the Snowflake data warehouse, ensuring data accuracy, consistency, and performance.
• Data Pipelines:
  Build and optimize data pipelines using Airbyte to efficiently extract, transform, and load data into the Snowflake data warehouse.
• dbt Development:
  Create, manage, and optimize dbt models to transform raw data into actionable insights.
• Semantic Layer:
  Develop a comprehensive semantic layer to provide a unified view of the data for business users and analysts.
• Data Quality:
  Implement data quality checks and monitoring to ensure data integrity and reliability.
• Collaboration:
  
  Work closely with data analysts, SQL engineers, and business stakeholders to understand data requirements and deliver solutions.
• Employee has an individual responsibility for knowledge of and compliance with laws, regulations, and policies.
• Compliance is a condition of employment and is considered an element of job performance.
• Maintain HIPAA/patient confidentiality.
• Regular and reliable attendance as assigned by your schedule.
• Other job duties assigned.

• Data Engineering:
  Strong proficiency in data engineering concepts, including data modeling, ELT processes, and data warehousing.
• SQL:
  Expert‑level SQL skills for data manipulation and analysis.
• dbt:
  In‑depth knowledge of dbt for building and managing data transformations.
• Airbyte:
  Experience with Airbyte or Fivetran for data ingestion and pipeline management.
• Cloud Platforms:
  Familiarity with cloud platforms (e.g., AWS, GCP, Azure) and cloud data warehousing.
• Data Quality:
  Understanding of data quality concepts and tools.
• Problem Solving:
  Ability to analyze complex data challenges and develop effective solutions.

• Bachelor's degree in Computer Science, Statistics, or a related field.
• 3+ years of experience in data engineering or a related role.
• Proven experience with data modeling and ETL processes.
• Strong SQL skills and proficiency in Python or other scripting languages.
• Experience with data warehousing platforms (Snowflake preferred).
• Knowledge of data quality best practices.
• ETC.

We are seeking a highly analytical and detail‑oriented individual with a passion for data. The ideal candidate will have a strong foundation in data engineering and a proven ability to build efficient and reliable data pipelines. We value a collaborative and problem‑solving mindset, as well as a strong desire to drive data‑driven decision making.

Competitive Pay, Health Plans with FSA or HSA options, Dental, and Vision Insurance, Optional Life Insurance, 401K with Company Match, 12 weeks of…