Senior Data Platform Architect & Governance (Remote, OH)

UNICON International Inc.; Columbus (OH); Remote; USD 109,000 - 114,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k)

Job summary

UNICON is seeking a senior DBA/Data Platform Architect who will lead the design and governance of enterprise data platforms. You will architect Lakehouse solutions across cloud environments, implement robust ELT pipelines, and mentor teams to ensure scalable, secure data delivery.

The role requires strong SQL, data modeling, and data governance skills, with experience in Snowflake, Alation, and modern BI toolchains. Remote Ohio-based collaboration and enterprise-level impact are expected.

Qualifications

• 5+ years designing and implementing enterprise data warehouse, data lake, or Lakehouse solutions (includes cloud environments).
• Expert SQL skills with query optimization and complex analytics data sets.
• Experience building automated ELT pipelines using Python/SQL and cloud data platforms.
• Hands-on Snowflake data engineering, warehousing, and analytics experience.

Responsibilities

• Design and maintain ELT pipelines and orchestration for incremental data processing across Medallion architecture.
• Optimize queries and clusters for modern cloud data platforms during heavy transformations.
• Migrate legacy data into Lakehouse ingestion pipelines with robust coding.
• Develop and publish standards, best practices, and architecture documentation.
• Lead data governance, metadata management, and Alation-based cataloging efforts.
• Mentor peers and junior staff in data engineering and governance.

Skills

Data warehouse design

SQL performance tuning

ELT pipelines

Snowflake engineering

Dimensional modeling

Data integration (APIs/JSON)

Alation governance

Cross-functional leadership

BI tooling

Communication with execs

Education

Bachelor’s degree in data analytics/CS/IT/Engineering

Tools

Snowflake

Alation

dbt

Job description

UNICON is seeking a senior DBA/Data Platform Architect who will lead the design and governance of enterprise data platforms. You will architect Lakehouse solutions across cloud environments, implement robust ELT pipelines, and mentor teams to ensure scalable, secure data delivery.

The role requires strong SQL, data modeling, and data governance skills, with experience in Snowflake, Alation, and modern BI toolchains. Remote Ohio-based collaboration and enterprise-level impact are expected.