Relomote
SR

Senior Data Platform Architect

S R International IncData & Analytics
Hiring from
United States
Work type
Remote
Posted

623,006 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description
Job Title: DBA 4 – Senior Data Platform Architect & Governance Specialist
Job Code: OH 815210
Client: State of Ohio
Location: Franklin County, Ohio
Duration: Through 06/30/2027
Work Arrangement: 100% Remote – Ohio Candidates Only
Interview Process: Remote Interviews
Travel: Required as needed for meetings
Closing Date: 11/12/2026 at 3:00 PM

Position Overview

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

The selected candidate will lead the development of automated ELT pipelines, implement Snowflake-based data engineering solutions, and establish scalable Medallion Architecture (Bronze, Silver, Gold) data platforms.

This role also focuses on advanced data modeling, data migration, enterprise data governance, metadata management, data lineage, and data quality using platforms such as Snowflake and Alation.

The candidate will collaborate with IT architecture teams, business stakeholders, and technical teams to establish enterprise data standards, optimize data platforms, and support modern business intelligence initiatives.

Required 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.

Key Responsibilities

1. ELT Pipeline Engineering & Automation

  • Design, develop, and maintain automated ELT pipelines using SQL, Python, and modern cloud data technologies.

  • Implement incremental data processing across Medallion Architecture layers.

  • Optimize SQL queries, compute resources, and cluster performance.

  • Develop robust solutions to migrate legacy databases and files into automated Lakehouse pipelines.

2. Data Modeling & Cloud Data Architecture

  • Design and implement scalable, secure Medallion Data Architecture across cloud environments.

  • Establish standards for data ingestion, schemas, and file formats such as Iceberg and Parquet.

  • Design logical and physical data models, including fact tables, dimensions, and business entity schemas.

  • Build data models that support structured and semi-structured data, including JSON and API payloads.

  • Develop semantic layers to support self-service business intelligence and reporting.

3. Data Governance & Metadata Management

  • Manage and maintain the Alation Data Catalog.

  • Ensure tables, schemas, and views across Bronze, Silver, and Gold layers are indexed, classified, and tagged.

  • Establish and monitor end-to-end data lineage from source applications to reporting assets.

  • Implement data validation, testing, and quality frameworks.

  • Support enterprise data stewardship and governance standards.

4. Data Migration & Business Intelligence

  • Design and implement data migration and modernization solutions.

  • Establish standards for secure data exchange between systems.

  • Design and implement data warehouses and data marts.

  • Develop enterprise reporting, management dashboards, scorecards, and analytical applications.

  • Replicate and transform data to support business intelligence requirements.

  • Define data warehouse and BI architecture standards.

5. Documentation & Mentoring

  • Develop technical documentation covering pipelines, architecture, data modeling, and migration processes.

  • Establish enterprise technical standards and best practices.

  • Mentor peers and junior technical staff through formal instruction and documentation.

  • Collaborate with business stakeholders and technical teams on architecture and engineering initiatives.

Highly Desired Skills

  • Experience with Snowflake cloud-native architecture, including:

    • Snowflake Warehouses

    • Snowpark

    • Streams and Tasks

    • Secure Data Sharing

  • Familiarity with data modeling tools such as ER/Studio.

  • Experience with modern data modeling methodologies.

  • Experience defining enterprise data architecture standards and best practices.

  • Experience leading cross-functional data architecture and engineering initiatives.

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

Nice-to-Have Skills

  • Experience with dbt.

  • Experience with enterprise data cataloging, metadata management, and data lineage tools such as Alation.

  • Strong work ethic, punctuality, and time-management skills.

This is a remote position.




About SR International INC.

SR International has been a leading name among the IT consulting companies with offices in US and India. For past 16 years, our industry experience and domain knowledge have enabled us to provide innovative solutions to our customers.

Who We Are

We Are Leading IT Based Solution Providers

Today, the world of business information represents the realization of our collective efforts toward improving the future. Held only by the limits of our imagination, the business world is accelerating at an ever-increasing pace. Imagine a better way of doing business, of implementing the perfect software, of refining practice or business integration. All it takes are benchmark standards in service, support, and technical know-how, which have been our bread and butter.

Our Vision.
Established in 2002, SR International Inc is one of the fastest growing and reputed provider of Information Technology Services and Solutions in the USA. Since our inception, we have been a trusted IT partner for our clients. We take pride in our highly skilled IT Resources and unique engagement model. We have been consistently delivering on our promises as a high-performance team. Our expertise in Cloud Computing, Mobility, Web Technologies, ERP and CRM are second to none. Our industry-leading flagship product iMathSmart is re-defining math learning experience for school students.

Career At SR International

At SR International, we treat our consultants like family. Our business and our reputation have been built and maintained by quality resources working onboard, so it’s important for us to maintain the quality resource pool.


Similar jobs

Apply for this job100% free