Database Administrator 4

NOVALINK SOLUTIONS LLC

. Design and maintain programmatic, automated ELT pipelines using SQL, Python, and modern cloud data tools .

Posted 11/9/2026full-timeColumbus • Ohio • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing enterprise data solutions, including data warehouses and Lakehouse architectures, with a strong focus on SQL, Python, and cloud data platforms. Proficient in data governance, metadata management, and dimensional data modeling to support business intelligence and analytics.

Highest-signal resume keywords

Expert-Level SQL SkillsAutomated ELT Pipeline DevelopmentSnowflake Data Engineering ExperienceDimensional Data ModelingData Governance and Metadata Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonData Warehouse DesignLakehouse SolutionsDimensional Data ModelingData MigrationData Quality FrameworksData LineageAutomated ELT PipelinesData Architecture Documentation

Soft Skills

Excellent Communication SkillsCollaboration with StakeholdersMentorship and Leadership

Tools & Technologies

SnowflakeAlationDbtER StudioAgile Methodologies

Industry Keywords

Medallion ArchitectureData GovernanceMetadata ManagementBusiness IntelligenceData Catalog

Tech Stack

Tools & technologies

CloudPythonSnowflakeSQL

About the role

Key responsibilities & impact

Design and maintain programmatic, automated ELT pipelines using SQL, Python, and modern cloud data tools
Process data incrementally through Bronze, Silver, and Gold Medallion stages
Conduct query and cluster tuning for modern cloud data platforms
Write code to migrate legacy databases and files into automated Lakehouse ingestion pipelines
Design and implement scalable, secure Medallion Data Architecture across cloud environments
Establish standards, schemas, and file formats such as Iceberg and Parquet
Design physical and logical Gold-layer data structures, including dimensions, facts, and business entity schemas
Build resilient models for semi-structured data such as JSON and API payloads
Design semantic layers supporting self-service business intelligence
Document pipelines, architecture, modeling, and migration efforts
Define data exchange standards and data security models between systems
Implement data warehouses, data marts, business intelligence tools, user interfaces, enterprise reporting, dashboards, scorecards, and analytic applications
Replicate and transform data for business intelligence
Manage and curate the Alation Data Catalog
Index, classify, and tag 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
Design programmatic data validation and testing protocols between Bronze and Silver layers
Plan and conduct formal mentorship activities for peers and lower-level staff

Requirements

What you’ll need

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 data 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
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 initiatives
Excellent communication skills and ability to collaborate with technical teams, business stakeholders, and executive leadership
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
Strong work ethic and time-and-attendance punctuality
Experience with dbt
Candidates must be in Ohio
Bachelor’s degree in Data Analytics, Computer Science, Information Technology, Computer Engineering, or a closely related field is highly desired, not required

Benefits

Comp & perks

Contract employment
Hybrid work arrangement
Mentorship opportunities
Opportunity to work with modern cloud data platforms and enterprise data architecture