Snowflake DW Engineer - Data Pipelines & SQL

Thompson Hine LLP; Cincinnati (OH); On-site; USD 110,000 - 130,000; Full time

Job summary

Thompson Hine LLP seeks a Data Warehouse Engineer to own data movement from source systems into Snowflake and maintain the on‑premises SQL Server environment. The role designs, builds, and operates a scalable analytics platform supporting key business domains.

This hands‑on position focuses on pipelines, a trusted Snowflake warehouse, and well‑modeled datasets for analytics across the organization, including Snowflake and SQL Server administration in a constrained on‑site environment.

Qualifications

• Bachelor's degree in computer science, information systems, or related field, or equivalent practical experience.
• Up to 5 years of data engineering or data warehousing experience, including at least one warehouse built from scratch.
• Strong SQL skills with complex joins, window functions, CTEs, and performance tuning.
• Hands-on experience building data pipelines into a cloud data warehouse, preferably Snowflake.
• 3+ years administering SQL Server in production: performance tuning, backup/restore, DR planning and testing.
• Experience with ETL/ELT tooling and job orchestration.

Responsibilities

• Design, build, and maintain ingestion pipelines from source databases into Snowflake.
• Integrate data from third-party SaaS platforms such as CRM and finance systems.
• Monitor pipeline runs, resolve failures, and set up data quality checks.
• Document source-to-target mappings, refresh schedules, and dependencies.
• Build and maintain a layered warehouse: raw, staging, and presentation layers.
• Write and optimize transformation logic in SQL with SCDs and late-arriving data.
• Design and deliver dimensional data marts and data cubes for multiple business groups.
• Partner with report developers to translate requirements into data products.

Skills

SQL development

ETL/ELT

Data warehousing

Data modeling

Communication

Education

Bachelor's degree in CS or related field

Tools

Snowflake

SQL Server

SSRS/Power BI

dbt

Job description

Thompson Hine LLP seeks a Data Warehouse Engineer to own data movement from source systems into Snowflake and maintain the on‑premises SQL Server environment. The role designs, builds, and operates a scalable analytics platform supporting key business domains.

This hands‑on position focuses on pipelines, a trusted Snowflake warehouse, and well‑modeled datasets for analytics across the organization, including Snowflake and SQL Server administration in a constrained on‑site environment.