DBA4 - JFS - Database Administrator

Stealth Entry; Columbus (OH); Remote; USD 140,000 - 190,000; Full time

Job summary

Stealth Entry Cybersecurity Solutions is hiring a Senior Data Platform Architect & Governance Specialist (DBA 4) for the State of Ohio. This senior role will design, build, and govern a Snowflake-based Lakehouse with Medallion architecture and automated ELT pipelines.

You will manage data catalogs, metadata, and data quality, while mentoring staff and documenting architecture. Remote work from Ohio with occasional travel for meetings; 1-year contract with potential extension.

Qualifications

• 7+ years in data architecture and design, with data modeling experience.
• Senior DBA/architect with Snowflake and lakehouse experience.
• Experience with data governance, lineage, and metadata management.

Responsibilities

• Design, build, and govern a Snowflake-based Lakehouse for the State of Ohio.
• Create automated ELT pipelines and migrate legacy data into the platform.
• Model dimensional schemas and semantic layers for self-service BI.
• Manage the Alation Data Catalog for metadata, lineage, and data quality.
• Mentor staff, write architecture docs, and support app teams with DBA tasks.

Skills

Advanced SQL

Snowflake

Data Lakehouse

ETL/ELT pipelines

Data governance

Alation

dbt

Education

Bachelor’s degree in Computer Science or related field

Tools

Snowflake

Alation

dbt

Python

ETL Tools

Job description

Senior Data Platform Architect & Governance Specialist (DBA 4)

Company: Stealth Entry Cybersecurity Solutions Client: State of Ohio Location: Remote (Franklin County). Candidates must live in Ohio. Travel for meetings as needed. Engagement: 1-year contract with the possibility of an extension Eligibility: U.S. Citizens and Green Card holders only. Interviews: Conducted remotely

About Stealth Entry

Stealth Entry Cybersecurity Solutions is a Service-Disabled Veteran-Owned Small Business and Ohio Minority Business Enterprise headquartered in Westerville, Ohio. We provide skilled IT and cybersecurity professionals to federal, state, and commercial clients.

About the Role

Stealth Entry is hiring a Senior Data Platform Architect & Governance Specialist (Database Administrator 4) for our client, the State of Ohio. In this senior role, you will design, build, and govern a modern Snowflake-based Lakehouse that uses a Medallion Architecture (Bronze, Silver, Gold).

You will build automated ELT pipelines and move legacy databases into the new platform. You will design dimensional models and semantic layers for self-service business intelligence. You will also manage the Alation Data Catalog for metadata, lineage, and data quality. You will set standards, write architecture documentation, mentor other staff, and support the application team with database administration, tuning, backup and recovery, and data warehousing operations.

What You’ll Do

ELT Pipeline Engineering and Automation

• Design and maintain automated ELT pipelines (SQL, Python, or modern cloud data tools) that process data incrementally through the Medallion stages
• Tune queries and clusters on modern cloud data platforms so compute is used efficiently during heavy transformations
• Write reliable code to migrate legacy databases and files into automated Lakehouse ingestion pipelines

Data Modeling and Cloud Data Architecture

• Work with IT Architecture staff to design and implement a scalable, secure Medallion Data Architecture across cloud environments
• Set standards, schemas, and file formats (such as Iceberg and Parquet) for ingestion and data lake processing
• Design efficient physical and logical data structures in the Gold layer, including dimensions, facts, and business entity schemas
• Build data models that handle semi-structured data (JSON, API payloads) alongside structured data, with version control of data contracts
• Turn complex business reporting requirements into user-friendly semantic layers for self-service BI

Data Governance, Metadata, and Cataloging

• Manage and curate the Alation Data Catalog so all tables, schemas, and views across the Bronze, Silver, and Gold layers are indexed, classified, and tagged
• Map and monitor end-to-end data lineage in Alation, from source applications to Gold-layer reporting assets
• Design automated data validation and testing between the Bronze and Silver layers to enforce enterprise data stewardship

Business Intelligence and Reporting

• Define data warehouse and BI design based on business data needs
• Implement data warehouses, data marts, BI tools, enterprise reporting, management dashboards, scorecards, and analytic applications
• Replicate and transform data for business intelligence
• Design standards for exchanging data between systems, including data security models

Database Administration and Operations

• Maintain the central data repository and data dictionaries, including standards, backup, and recovery
• Monitor database performance and space requirements, and perform and supervise performance tuning
• Schedule and monitor end-of-day data warehousing jobs
• Write shell scripts for backup, restore, and monitoring tasks
• Handle database design, installations, and conversions, and manage access security, database integrity, and physical storage design
• Take part in Database Management System selection and help coordinate software releases

Standards, Documentation, and Mentoring

• Document pipelines, architecture, data models, and migration efforts
• Plan and lead formal mentoring for peers and junior staff
• Give clear status updates to the Project Team Lead, track issues, risks, and action items, and report time spent on all work
• Work with little direct supervision, estimate and schedule your own work, and help improve processes

What You Bring

• 7+ years of relevant experience in data dictionary analysis and design and data model analysis and design
• 5+ years of hands-on experience designing and implementing enterprise data warehouse, data lake, or Lakehouse solutions
• Expert-level SQL, including query optimization, performance tuning, and building complex analytical datasets
• Experience building automated ELT pipelines with Python, SQL, and modern cloud data platform technologies
• Hands-on experience implementing and supporting Snowflake data engineering, data warehousing, and analytics solutions
• Experience designing and managing Medallion Architecture (Bronze, Silver, Gold) data platforms and their processing standards
• Advanced dimensional modeling experience, including fact tables, dimensions, star schemas, and semantic layer design
• Experience integrating structured and semi-structured sources, 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 delivering data migration and modernization projects
• Ability to define technical standards, best practices, and architecture documentation for enterprise data platforms
• Ability to work independently and lead complex, cross-functional data architecture and engineering projects
• Excellent communication skills with technical teams, business stakeholders, and executive leadership

Education

• Bachelor’s degree in Data Analytics, Computer Science, Information Technology, Computer Engineering, or a closely related field (preferred)

Preferred

• Snowflake cloud-native architecture experience, including Warehouses, Snowpark, Streams, Tasks, and secure data sharing
• Familiarity with data modeling tools such as ER Studio and modern modeling methods
• Experience with dbt
• Experience working in Agile or fast-changing environments
• Strong work ethic and reliable time and attendance