Search Jobs | Dice.com

1 results (1 new)

Group by company

Senior Data Platform Architect & Governance Specialist (Snowflake, Lakehouse, Alation)

USG, Inc.

Hybrid in Columbus, Ohio • Today

Easy Apply

Contract, Third Party

Depends on Experience

Job Details

Skills

data platform architect
ELT
Medallion
Alation Data Catalog

Summary

Senior Data Platform Architect & Governance Specialist (Snowflake, Lakehouse, Alation)

Location: Remote (Franklin County, OH). Candidates must be located in Ohio.
Interview: Teams
Travel: Occasional, for meetings as needed

About the Role
We’re looking for a senior data platform architect (DBA 4) to design and run a modern cloud Lakehouse built on a Medallion (Bronze, Silver, Gold) architecture. You’ll build automated ELT pipelines, design the data models behind self-service BI, and own data governance and cataloging in Alation. You’ll also mentor peers and junior staff.

What You’ll Do

Design and maintain automated ELT pipelines (SQL, Python, and cloud data tools) that move data incrementally through the Medallion layers
Tune queries and compute for heavy transformation workloads on modern cloud data platforms
Migrate legacy databases and files into automated Lakehouse ingestion pipelines
Set standards, schemas, and file formats (Iceberg, Parquet) for ingestion and data lake processing
Design dimensional models (facts, dimensions, star schemas) and semantic layers that support self-service BI
Build data models that handle semi-structured data (JSON, API payloads) alongside structured data, with version-controlled data contracts
Curate the Alation Data Catalog and map end-to-end data lineage from source systems to Gold-layer reports
Design data validation and quality frameworks at the Bronze-to-Silver boundary
Implement data warehouses, data marts, dashboards, and enterprise reporting
Document pipelines, architecture, and standards, and mentor team members

Required Qualifications

5+ years designing and implementing enterprise data warehouse, data lake, or Lakehouse solutions
Expert-level SQL, including query optimization, performance tuning, and complex analytical datasets
Automated ELT pipeline development using Python, SQL, and modern cloud data platforms
Hands-on Snowflake experience across data engineering, warehousing, and analytics
Medallion Architecture (Bronze, Silver, Gold) design and management
Advanced dimensional modeling and semantic layer design
Experience integrating structured and semi-structured sources: APIs, JSON, and file-based ingestion
Hands-on administration of enterprise data catalog and governance platforms such as Alation
Experience with data governance, metadata management, lineage, and data quality frameworks
Data migration and modernization experience
Ability to define technical standards and architecture documentation, and to lead complex, cross-functional initiatives
Excellent communication skills with technical teams, business stakeholders, and executives

Preferred Qualifications

Snowflake cloud-native features: Warehouses, Snowpark, Streams, Tasks, and secure data sharing
Data modeling tools such as ER Studio and modern modeling methodologies
Agile or iterative delivery experience
dbt experience
Bachelor’s degree in Data Analytics, Computer Science, IT, Computer Engineering, or a related field

eye

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10204540
Position Id: 87545-2308-1794001190
Posted 6 hours ago

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Lead ETL Developer

Columbus, Ohio

•

Today

Job Title: Lead ETL Developer Location: Onsite - 4days in a week (onsite (Columbus, OH or Atlanta, GA or Akron, OH or Detroit, MI or Chicago, IL or Charlotte, NC or Dallas, TX or Minneapolis, MN). AWS, Snowflake, and Python-based frameworks Key Responsibilities Technical Leadership & Delivery Lead the design, development, and maintenance of ETL/ELT pipelines in the EDW ecosystem Ensure alignment to enterprise data architecture, standards, and best practices Drive solution design from requiremen

Easy Apply

Full-time, Part-time, Third Party, Contract

Snowflake Engineer (Python / Snowpark)

Columbus, Ohio

•

Today

If you're passionate about being part of a dynamic organization that enables a Fortune 100 company with nearly $70 billion in annual sales to drive innovation and adopt new technologies that deliver business results, then Nationwide's Technology team could be the place for you! At Nationwide , "on your side" goes beyond just words. Our customers are at the center of everything we do and we're looking for associates who are passionate about delivering extraordinary care. Work Arrangement: This r

Full-time

USD 118,000.00 - 222,000.00 per year

Snowflake Engineer (Python / Snowpark)

Columbus, Ohio

•

Yesterday

Full-time

USD 118,000.00 - 222,000.00 per year

Consultant, Data Engineer

Columbus, Ohio

•

Yesterday

Full-time

USD 118,000.00 - 222,000.00 per year

Job Details

Skills

data platform architect
ELT
Medallion
Alation Data Catalog

Summary

Senior Data Platform Architect & Governance Specialist (Snowflake, Lakehouse, Alation)

Location: Remote (Franklin County, OH). Candidates must be located in Ohio.
Interview: Teams
Travel: Occasional, for meetings as needed

What You’ll Do

Design and maintain automated ELT pipelines (SQL, Python, and cloud data tools) that move data incrementally through the Medallion layers
Tune queries and compute for heavy transformation workloads on modern cloud data platforms
Migrate legacy databases and files into automated Lakehouse ingestion pipelines
Set standards, schemas, and file formats (Iceberg, Parquet) for ingestion and data lake processing
Design dimensional models (facts, dimensions, star schemas) and semantic layers that support self-service BI
Build data models that handle semi-structured data (JSON, API payloads) alongside structured data, with version-controlled data contracts
Curate the Alation Data Catalog and map end-to-end data lineage from source systems to Gold-layer reports
Design data validation and quality frameworks at the Bronze-to-Silver boundary
Implement data warehouses, data marts, dashboards, and enterprise reporting
Document pipelines, architecture, and standards, and mentor team members

Required Qualifications

5+ years designing and implementing enterprise data warehouse, data lake, or Lakehouse solutions
Expert-level SQL, including query optimization, performance tuning, and complex analytical datasets
Automated ELT pipeline development using Python, SQL, and modern cloud data platforms
Hands-on Snowflake experience across data engineering, warehousing, and analytics
Medallion Architecture (Bronze, Silver, Gold) design and management
Advanced dimensional modeling and semantic layer design
Experience integrating structured and semi-structured sources: APIs, JSON, and file-based ingestion
Hands-on administration of enterprise data catalog and governance platforms such as Alation
Experience with data governance, metadata management, lineage, and data quality frameworks
Data migration and modernization experience
Ability to define technical standards and architecture documentation, and to lead complex, cross-functional initiatives
Excellent communication skills with technical teams, business stakeholders, and executives

Preferred Qualifications

Snowflake cloud-native features: Warehouses, Snowpark, Streams, Tasks, and secure data sharing
Data modeling tools such as ER Studio and modern modeling methodologies
Agile or iterative delivery experience
dbt experience
Bachelor’s degree in Data Analytics, Computer Science, IT, Computer Engineering, or a related field

eye

Dice Id: 10204540
Position Id: 87545-2308-1794001190
Posted 6 hours ago

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Lead ETL Developer

Columbus, Ohio

•

Today

Easy Apply

Full-time, Part-time, Third Party, Contract

Snowflake Engineer (Python / Snowpark)

Columbus, Ohio

•

Today

Full-time

USD 118,000.00 - 222,000.00 per year

Snowflake Engineer (Python / Snowpark)

Columbus, Ohio

•

Yesterday

Full-time

USD 118,000.00 - 222,000.00 per year

Consultant, Data Engineer

Columbus, Ohio

•

Yesterday

Full-time

USD 118,000.00 - 222,000.00 per year