​

Similar Jobs

Senior Data Platform Architect & Governance Specialist
Contract Corp-To-Corp
Job Alerts:
NoYes
Save
Posted on:11/09/2026
24
Applied:1
Similar Jobs
Depends on experience
Alation,APIs,Cloud Data Platforms,Data Engineering,Data Governance,Data Lake,Data Migration,Data Warehouse,ELT Pipeline,JSON,Lakehouse Solutions,Medallion Architecture,Metadata Management,Python,SNowflake,SQL
Work type: On site
Work authorization: US local resources,Work authorization required,Work authorization sponsored,Work authorization in field of study
Veteran Service: Yes
Number of hirings: 1
Job Details
Senior Data Platform Architect & Governance Specialist (Snowflake, Lakehouse, Alation)
Locations:Franklin County, OH - Candidates must be located in Ohio
Duration: Contract

Job Description:
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

Mandatory Skills:
Skill
Required / Desired
Amount
of Experience
5+ years of hands-on experience designing and implementing enterprise data warehouse, data lake, or Lakehouse solutions
Required



Expert-level SQL skills, including query optimization, performance tuning, and development of complex analytical datasets
Required


Experience developing automated ELT pipelines using Python, SQL, and modern cloud data platform technologies
Required



Hands-on experience implementing and supporting Snowflake-based data engineering, data warehousing, and analytics solutions
Required


Experience designing and managing Medallion Architecture (Bronze, Silver, Gold) data platforms and associated data processing standards
Required



Advanced experience with dimensional data modeling, including fact tables, dimensions, star schemas, and semantic layer design
Required


Experience integrating structured and semi-structured data sources, including APIs, JSON, and file-based ingestion frameworks
Required



Hands-on experience administering enterprise data catalog and governance platforms such as Alation
Required


Experience implementing data governance, metadata management, data lineage, and data quality frameworks
Required



Experience executing data migration and modernization initiatives
Required


Ability to define technical standards, best practices, and architecture documentation for enterprise data platforms
Highly desired



Ability to work independently and lead complex, cross-functional data architecture and engineering initiative
Highly desired


Experience with Snowflake cloud-native architecture, including Snowflake Warehouses, Snowpark, Streams, Tasks, and secure data sharing
Highly desired



Familiarity with data modeling (i.e. ER Studio) and modern modeling methodologies
Highly desired


Experience with enterprise data cataloging, metadata management, and data lineage tools (e.g., Alation)
Nice to have



Experience with dbt
Nice to have


Bachelor’s Degree in Data Analytics, Computer Science, Information Technology, Computer Engineering, or a closely related field
Highly desired

Interview type: Telephonic
Experience years required: 5