Database Administrator 4 - hybrid Columbus, OH

Novalink Solutions LLC•Columbus, OH

2d•Hybrid

About The Position

The Database Administrator 4 designs, builds, and supports enterprise data platforms and business intelligence solutions, including automated ELT pipelines, cloud data architecture, data modeling, governance, cataloging, and data migration. The role works with IT Architecture staff to develop a scalable and secure Medallion Data Architecture across cloud environments, and establishes standards for ingestion, processing, schemas, and file formats. It also creates documentation and technical standards and mentors peers or lower-level staff. The position supports reporting and analytics by defining data warehouse and business intelligence designs, implementing warehouses, marts, tools, interfaces, reports, dashboards, scorecards, and analytic applications, and transforming or replicating data for business intelligence. The role manages Alation catalog metadata and lineage, and develops data validation and quality protocols. Candidates are required to be in Ohio. The position is described as hybrid in Columbus, Ohio.

Requirements

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 development of complex analytical datasets.
Experience developing automated ELT pipelines using Python, SQL, and modern cloud data platform technologies.
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 and associated processing standards.
Advanced experience with dimensional data modeling, including fact tables, dimensions, star schemas, and semantic layer design.
Experience integrating structured and semi-structured data sources, including APIs, JSON, and file-based ingestion frameworks.
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.
Excellent communication skills and ability to collaborate with technical teams, business stakeholders, and executive leadership.
Candidates must be in Ohio.

Nice To Haves

Experience with Snowflake cloud-native architecture, including Snowflake Warehouses, Snowpark, Streams, Tasks, and secure data sharing.
Familiarity with data modeling tools such as ER Studio and modern modeling methodologies.
Experience working in Agile, iterative, or rapidly evolving solution environments.
Experience with enterprise data cataloging, metadata management, and data lineage tools such as Alation.
Experience with dbt.
Strong work ethic and punctuality in time and attendance.
Bachelor’s degree in Data Analytics, Computer Science, Information Technology, Computer Engineering, or a closely related field is highly desired.
Ability to define technical standards, best practices, and architecture documentation for enterprise data platforms is highly desired.
Ability to work independently and lead complex, cross-functional data architecture and engineering initiatives is highly desired.

Responsibilities

Design and maintain automated ELT pipelines that process data incrementally through Medallion stages.
Tune queries and clusters on modern cloud data platforms to optimize compute usage during data transformations and processing.
Develop code to migrate legacy databases and files into automated Lakehouse ingestion pipelines.
Collaborate with IT Architecture staff to design and implement scalable, secure Medallion Data Architecture across cloud environments.
Establish standards, schemas, and file formats for ingestion and data lake processing.
Design physical and logical Gold-layer data structures, including dimensions, facts, and business entity schemas.
Build resilient data models for structured and semi-structured data, with version control for data contracts.
Translate business reporting requirements into user-friendly semantic layers for self-service business intelligence.
Document pipelines, architecture, modeling, and migration efforts.
Design standards for data exchange between systems, including data security models.
Understand business intelligence data needs and define data warehouse and business intelligence designs.
Implement data warehouses, data marts, business intelligence tools and user interfaces, enterprise reporting, dashboards, scorecards, and analytic applications.
Replicate and transform data for business intelligence.
Manage and curate the Alation Data Catalog, indexing, classifying, and tagging tables, schemas, and views across Bronze, Silver, and Gold layers.
Map and monitor end-to-end data lineage from source applications to Gold-layer reporting assets in Alation.
Design programmatic data validation and testing protocols between the Bronze and Silver layers.
Plan and conduct formal mentorship activities for peers and/or lower-level staff through verbal instruction or technical documentation.
Lead complex, cross-functional data architecture and engineering initiatives.