DBA4 - JFS - Database Administrator

STEALTH ENTRY•Columbus, OH

1d•$47 - $52•Remote

About The Position

Stealth Entry Cybersecurity Solutions is hiring a Senior Data Platform Architect & Governance Specialist (Database Administrator 4) for its client, the State of Ohio. The role will design, build, and govern a Snowflake-based Lakehouse using a Medallion Architecture (Bronze, Silver, Gold). It includes building automated ELT pipelines, migrating legacy databases, designing dimensional models and semantic layers for self-service business intelligence, and managing the Alation Data Catalog for metadata, lineage, and data quality. The position also establishes platform standards and architecture documentation, mentors other staff, and supports the application team with database administration, performance tuning, backup and recovery, and data warehousing operations. The role is remote in Franklin County, but candidates must live in Ohio and travel for meetings as needed. The engagement is a one-year contract with the possibility of extension. Interviews are conducted remotely. Applicants must be U.S. citizens or Green Card holders.

Requirements

At least 7 years of relevant experience in data dictionary analysis and design and data model analysis and design.
At least 5 years of hands-on experience designing and implementing enterprise data warehouse, data lake, or Lakehouse solutions.
Expert-level SQL skills, 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 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.
Candidates must live in Ohio.
Applicants must be U.S. citizens or Green Card holders.

Nice To Haves

Bachelor’s degree in Data Analytics, Computer Science, Information Technology, Computer Engineering, or a closely related field is 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.

Responsibilities

Design and maintain automated ELT pipelines that process data incrementally through Bronze, Silver, and Gold Medallion stages.
Tune queries and clusters on cloud data platforms to use compute efficiently during heavy transformations.
Write reliable code to migrate legacy databases and files into automated Lakehouse ingestion pipelines.
Work with IT Architecture staff to design and implement a scalable, secure Medallion Data Architecture across cloud environments.
Set standards, schemas, and file formats, including 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 for structured and semi-structured data, including JSON and API payloads, with version control of data contracts.
Translate complex business reporting requirements into user-friendly semantic layers for self-service BI.
Manage and curate the Alation Data Catalog, indexing, classifying, and tagging tables, schemas, and views across platform layers.
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 Bronze and Silver layers to support enterprise data stewardship.
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.
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.
Participate in Database Management System selection and help coordinate software releases.
Document pipelines, architecture, data models, and migration efforts.
Plan and lead formal mentoring for peers and junior staff.
Provide status updates to the Project Team Lead, track issues, risks, and action items, and report time spent on work.
Work with little direct supervision, estimate and schedule work, and help improve processes.