Data Warehouse Engineer

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, an AmLaw 200 firm regularly recognized for our commitment to Innovation, Inclusion, and collaborative culture is seeking a Data Warehouse Engineer to join any of our Atlanta, Chicago, Cincinnati, Cleveland, Columbus, Dayton or Minneapolis offices. We are hiring a Data Warehouse Engineer to own the movement of data from our source systems into Snowflake and to keep our on-premises SQL Server environment healthy. You will help design, build, and operate a scalable analytics data platform that supports key business domains. This role focuses on developing high‑quality data pipelines, a trusted Snowflake data warehouse, and well‑modeled datasets that power analytics and decision‑making across the organization.

This is a hands‑on role for someone who has built a data warehouse from the ground up and is just as comfortable tuning a SQL Server instance, restoring a database, or running a disaster recovery test.

Key Responsibilities

• Design, build, and maintain ingestion pipelines from source databases (SQL Server and other relational systems) into Snowflake, using batch and incremental or change-data-capture patterns.
• Integrate data from third‑party SaaS platforms such as CRM, product analytics, and finance systems.
• Monitor pipeline runs, resolve failures, and set up alerting, logging, and data‑quality checks.
• Document source‑to‑target mappings, refresh schedules, and dependencies.

Data warehouse design and modeling

• Build and maintain a layered warehouse: raw (landing) tables, cleansed and transformed staging layers, and curated presentation layers.
• Write and optimize transformation logic in SQL, including slowly changing dimensions, surrogate keys, and late‑arriving data.
• Design and deliver dimensional data marts and data cubes (star schemas, aggregates, semantic or OLAP models) for finance, operations, and other business groups.
• Partner with report developers and analysts to turn business requirements into well‑defined, tested data products.

Snowflake administration

• Manage warehouses, databases, schemas, and roles in line with least‑privilege access and our naming conventions.
• Tune performance and control cost: warehouse sizing, clustering, query profiling, and resource monitors.
• Support masking policies and other data‑protection controls and promote changes from development to production through a controlled release process.

SQL Server administration

• Manage a small environment of SQL Server instances: installation, patching, configuration, capacity planning, and security.
• Tune performance: indexing, statistics, query plans, wait‑stat analysis, and blocking or deadlock resolution.
• Own backup and recovery: design backup schedules, verify backups, and perform point‑in‑time restores.
• Plan, document, and test disaster recovery, including high availability options such as Always On availability groups, log shipping, or failover clustering.
• Maintain SQL Agent jobs, maintenance plans, and monitoring.

Operations and collaboration

• Keep runbooks, data dictionaries, and architecture diagrams current.
• Produce clear technical documentation, including pipeline designs and data flow diagrams.
• Follow change management and secure development practices and take part in on‑call or after‑hours support for critical loads and outages.
• Partner with analytics and business stakeholders to translate requirements into well‑modeled, reliable datasets.

Required Qualifications

• Bachelor's degree in computer science, information systems, or a related field, or equivalent practical experience.
• Up to 5 years of experience in data engineering or data warehousing, including at least one warehouse built from scratch: raw tables, transformation layers, data marts, and data cubes.
• Strong SQL skills, including complex joins, window functions, CTEs, stored procedures, and performance tuning.
• Hands‑on experience building and supporting data pipelines from source databases into a cloud data warehouse, preferably Snowflake.
• 3+ years administering SQL Server in production: performance tuning, backup and restore, and disaster recovery planning and testing.
• Experience with ETL or ELT tooling and with scheduling or orchestration of data jobs.
• Ability to troubleshoot across systems, communicate clearly with technical and non‑technical users, and document work thoroughly.

Preferred Qualifications

• Snowflake SnowPro Core or Advanced certification, or a Microsoft SQL Server or Azure data certification.
• Experience with legal or professional services data, such as practice management and billing systems like Aderant Expert.
• Experience with SSRS, Power BI, or similar reporting tools, and with building semantic layers for them.
• Experience with dbt, Python, or PowerShell for transformation, automation, and testing.
• Familiarity with Snowflake features such as Streams, Tasks, Snowpipe, dynamic tables, role‑based access control, and Cortex.
• Knowledge of secure coding practices (such as OWASP) and of data governance, masking, and audit requirements for confidential client data.
• Experience with source control and CI/CD for database and pipeline code.

This position requires the employee to work onsite at a specified Thompson Hine office location based on a schedule determined by the Manager for the benefit of the department and firm. Changes to the location and/or schedule must be approved by the Manager and Human Resources. This position is not eligible for remote work absent from the employee’s office working in business continuity mode.

Compensation is determined upon the market in which the position is located, the responsibilities of the position, the experience and skills of the applicant, and other job‑related factors. The estimated salary ranges for these locations are the following: Cleveland position is $106,000 to $119,500; Chicago is $112,000 to $127,000.

Thompson Hine LLP is an Equal Opportunity Employer that offers competitive wages, and a robust benefits package. Benefit offerings include, but are not limited to, medical, dental, and vision insurance as well as Paid Time Off (PTO).