The Role:
We are seeking a Data Warehouse Engineer to join our IT department. This role is responsible for designing, building, and maintaining the organization's cloud data warehouse, with a focus on ingesting, transforming, and modeling data using Fivetran, dbt (data build tool), and Snowflake. The successful candidate will work closely with analytics, engineering, and business stakeholders to ensure reliable, well-documented, and high-quality data pipelines that support reporting and decision-making across the organization. This position will need to sit within the greater Columbus area, for our largest medical kitting sites.
Responsibilities
Your Impact:
Design, build, and maintain automated data ingestion pipelines using Fivetran to extract data from source systems into the Snowflake data warehouse.
Develop, test, and maintain data transformation models using dbt, following modular and version-controlled development practices.
Administer and optimize the Snowflake environment, including performance tuning, warehouse sizing, and cost management.
Write efficient, well-documented SQL for data extraction, transformation, and analysis.
Implement data quality checks, automated testing, and monitoring within dbt and the broader data pipeline.
Maintain clear documentation of data models, pipeline architecture, and data lineage.
Troubleshoot and resolve data pipeline failures, data discrepancies, and performance issues in a timely manner.
Collaborate with business intelligence, analytics, and software engineering teams to understand data requirements and deliver reliable data sets.
Support data governance, security, and access-control practices within the data warehouse environment.
Participate in code reviews and contribute to the team's engineering standards and best practices.
Skills & Qualifications
What You Bring:
Bachelor's degree in Computer Science, Information Systems, Information Technology, Data Engineering, or a related field, or equivalent combination of education and relevant work experience.
Minimum of two (2) years of professional experience writing and optimizing SQL queries.
Minimum of two (2) years of professional experience working with Snowflake or a comparable cloud data warehouse platform.
Experience with Fivetran or a similar ELT/data ingestion tool is required.
Experience with dbt (data build tool) for data transformation and modeling is required.
Working knowledge of data warehousing concepts, including dimensional modeling, ELT/ETL design patterns, and data pipeline orchestration
What We Need:
Experience with a major cloud platform (AWS, Azure, or Google Cloud Platform).
Familiarity with version control systems such as Git and CI/CD practices for data pipelines.
Experience with workflow orchestration tools (e.g., Airflow, dbt Cloud, or similar).
Familiarity with data governance
What You'll Get:
Medical, Dental, Vision after 30 days
HSA and PPO plans available
Company paid Life Insurance, AD&D, and Long Term Disability
401(k) with generous company match after 90 days
Supplemental Voluntary Benefits like Short Term Disability, Critical Illness, Accident, and Hospital Indemnity
Employee Assistance Program
$500 Referral Bonus Available!
