Senior Data Architect: Lakehouse & ELT Automation

Info Origin Inc; Columbus (OH); On-site; USD 69,000 - 83,000; Full time

Job summary

Info Origin Inc is seeking a Data Architect in Ohio to design and govern scalable ELT pipelines, lakehouse data architecture, and reporting solutions in cloud environments. You will implement standards for data models, schemas, and semantic layers, while guiding data migrations and governance programs.

The role requires deep hands-on experience with SQL, Python, and cloud platforms, plus expertise in Medallion Architecture and modern BI tooling.

Qualifications

• 5+ years of hands-on experience designing and implementing enterprise data warehouse, data lake, or Lakehouse solutions.
• Expert-level SQL skills, including query optimization and development of complex analytical datasets.
• Experience developing automated ELT pipelines using Python, SQL, and modern cloud data platform technologies.

Responsibilities

• ELT Pipeline Engineering & Automation: designs and maintains programmatic ELT pipelines for Medallion stages.
• Advanced Data Modeling & Cloud Data Architecture: designs scalable Medallion Architecture across cloud environments.
• Develop and document standards/best practices for pipelines, architecture, modeling, and migration efforts.
• Data migrations, business process monitoring and security model designs for data exchange.
• Reporting BI: defines data warehouse design and implements warehouses, marts, dashboards, and enterprise reporting.
• Modern Data Governance, Metadata Management & Cataloging: manages Alation catalog, data lineage, and data quality frameworks.
• Mentoring: plans and conducts mentorship activities for peers or junior staff.

Skills

SQL

Python

ETL pipelines

Cloud data platforms

Data warehousing

Dimensional modeling

Data governance

APIs & JSON ingestion

Analytics

Education

Bachelor’s Degree in Data Analytics

Bachelor’s Degree in Computer Science

Tools

Snowflake

dbt

Alation

API ingestion tooling

Job description

Info Origin Inc is seeking a Data Architect in Ohio to design and govern scalable ELT pipelines, lakehouse data architecture, and reporting solutions in cloud environments. You will implement standards for data models, schemas, and semantic layers, while guiding data migrations and governance programs.

The role requires deep hands-on experience with SQL, Python, and cloud platforms, plus expertise in Medallion Architecture and modern BI tooling.