Data Architect: Own the Unified Data Platform

The HC Companies, Inc.

Middlefield Township (OH)

On-site

USD 110,000 - 150,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The HC Companies, Inc. is seeking a Data Architect in Middlefield, OH to own and shape the data foundation. You will collect, clean, and unify data across systems, then design scalable models and pipelines. Your work will inform leadership dashboards and enterprise reporting, moving away from Excel toward centralized data platforms.

You’ll collaborate with IT leadership, Finance, Sales, and Operations, building a Lakehouse/warehouse vision and delivering practical data solutions for the business.

Qualifications

  • 4–8 years in data analysis, data engineering, or data architecture.
  • Strong SQL skills (complex queries, transformations, performance tuning), ideally on SQL Server.
  • Hands-on Power BI experience, including data modeling and DAX.
  • Advanced Excel skills, including ODBC-based reporting.
  • A knack for learning complex data structures quickly, and the curiosity to ask, “Why does the data look like this?”
  • Clear communication with both technical and non-technical people.

Responsibilities

  • Extract, analyze, and validate data from SQL Server databases, CMS apps, SalesPad, and Dynamics GP.
  • Design and implement a unified data model across business systems.
  • Build and optimize data pipelines using SQL and modern data tools.
  • Create dashboards and reports for Sales, Operations, Finance, and leadership.
  • Replace manual, Excel-based reporting with automated, scalable solutions.
  • Champion data quality, governance, and consistency.
  • Turn business questions into technical solutions and suggest improvements to data strategy.

Skills

Data analysis
Data engineering
Data architecture
SQL
Power BI
Excel
Analytical thinking
Communication

Tools

SQL Server
Microsoft Fabric
Azure Data Factory
Synapse
Dynamics GP
SalesPad

Job description

The HC Companies, Inc. is seeking a Data Architect in Middlefield, OH to own and shape the data foundation. You will collect, clean, and unify data across systems, then design scalable models and pipelines. Your work will inform leadership dashboards and enterprise reporting, moving away from Excel toward centralized data platforms.

You’ll collaborate with IT leadership, Finance, Sales, and Operations, building a Lakehouse/warehouse vision and delivering practical data solutions for the business.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Architect
Data Architect

The HC Companies, Inc. • Middlefield Township (OH)

On-site
USD 110,000 - 150,000
Senior Data Architect: Lakehouse & ELT Automation
Senior Data Architect: Lakehouse & ELT Automation

Info Origin Inc • Columbus (OH)

On-site
USD 69,000 - 83,000
Remote Lead, Enterprise Data Modeling & Architecture
Remote Lead, Enterprise Data Modeling & Architecture

Leith of Wendell • United States

Remote
USD 150,000 - 190,000
Data Architect
Data Architect

Next Zen AI Strategix • Jersey City (NJ)

On-site
USD 140,000 - 200,000
Hybrid Enterprise Data Architect - Strategy & Analytics
Hybrid Enterprise Data Architect - Strategy & Analytics

Park Place Technologies • Oklahoma

Hybrid
USD 140,000 - 190,000
Senior Data Architect: Lead Data Pipelines & Lakehouse
Senior Data Architect: Lead Data Pipelines & Lakehouse

CI&T • United States

Remote
USD 140,000 - 190,000
Health insurance
Dental insurance
Meal allowance
+2
Data Architect — Modern Platforms, Governance & Analytics
Data Architect — Modern Platforms, Governance & Analytics

CoStrategix • Blue Ash (OH)

On-site
USD 120,000 - 150,000
Comprehensive medical, dental, and vision insurance
401(k) retirement plan
Flexible hybrid workplace
Senior Data Architect – Cloud Data Platform & Lakehouse
Senior Data Architect – Cloud Data Platform & Lakehouse

UsefulBI Corporation • United States

Hybrid
USD 120,000 - 180,000
Remote Data Architect - Cloud Data Lakehouse
Remote Data Architect - Cloud Data Lakehouse

Empower • Greenwood Village (CO)

On-site
USD 138,000 - 200,000
Health insurance
401(k) matching
Tuition reimbursement
+3
Senior Lakehouse Data Platform Architect
Senior Lakehouse Data Platform Architect

Workday, Inc. (old) • Pleasanton (CA)

On-site
USD 223,000 - 334,000