Remote Senior Data Platform Architect & Governance Lead

S R International Inc; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

State of Ohio is seeking an experienced Senior Data Platform Architect & Governance Specialist (DBA 4) to design, develop, and maintain enterprise data warehouses, data lakes, and Lakehouse solutions.

You will lead automated ELT pipelines, implement Snowflake-based data engineering solutions, and establish scalable Medallion Architecture data platforms while driving data governance, metadata management, and data quality initiatives across the organization.

Qualifications

• 5+ years of hands-on experience designing and implementing enterprise data warehouses, data lakes, or Lakehouse solutions.
• Expert-level SQL skills, including query optimization, performance tuning, and complex analytical dataset development.
• Experience developing automated ELT pipelines using Python, SQL, and modern cloud data platforms.
• Hands-on experience implementing and supporting Snowflake-based data engineering, data warehousing, and analytics solutions.
• Experience designing and managing Medallion Architecture (Bronze, Silver, Gold) data platforms.
• Advanced experience with dimensional data modeling, including fact tables, dimensions, star schemas, and semantic layers.
• Experience integrating structured and semi-structured data, including APIs, JSON, and file-based ingestion.
• Hands-on experience administering enterprise data catalog and governance platforms such as Alation.
• Experience implementing data governance, metadata management, data lineage, and data quality frameworks.
• Experience executing data migration and modernization initiatives.
• Ability to work independently and lead complex, cross-functional data architecture and engineering initiatives.
• Excellent communication and collaboration skills.

Responsibilities

• ELT Pipeline Engineering & Automation: Design, develop, and maintain automated ELT pipelines using SQL, Python, and modern cloud data technologies.
• Data Modeling & Cloud Data Architecture: Design scalable Medallion Data Architecture across cloud environments and establish ingestion standards.
• Data Governance & Metadata Management: Manage the Alation Data Catalog and ensure indexing, tagging, and lineage across layers.
• Data Migration & Business Intelligence: Design data migration solutions and develop enterprise reporting, dashboards, and BI assets.
• Documentation & Mentoring: Create technical docs and mentor peers and junior staff.

Skills

SQL

Python

Snowflake

Alation

ELT

Data Modeling

Medallion Architecture

Cloud Data Platforms

Data Governance

Lead cross-functional teams

Education

Bachelor's degree in Data Analytics, Computer Science, Information Technology, Computer Engineering, or related field

Tools

Snowflake

Alation

dbt

Iceberg

Parquet

Job description

State of Ohio is seeking an experienced Senior Data Platform Architect & Governance Specialist (DBA 4) to design, develop, and maintain enterprise data warehouses, data lakes, and Lakehouse solutions.

You will lead automated ELT pipelines, implement Snowflake-based data engineering solutions, and establish scalable Medallion Architecture data platforms while driving data governance, metadata management, and data quality initiatives across the organization.