Job Title: DBA 4 - Senior Data Platform & Governance Specialist
Direct client:
Work Arrangement: Columbus, OH - Remote
Candidate Location: Ohio candidates only
Travel: Required occasionally for meetings, as needed
Education: Bachelor's degree preferred
Job Summary
We are seeking an experienced Senior Data Platform Architect & Governance Specialist to design, develop, and support enterprise-scale data warehouse, data lake, and Lakehouse solutions.
The ideal candidate will have strong hands-on experience with Snowflake, SQL, Python, automated ELT pipelines, Medallion Architecture (Bronze, Silver, Gold), dimensional data modeling, and enterprise data governance platforms such as Alation.
This role will play a key part in modernizing enterprise data platforms, implementing scalable data architectures, improving data quality, and enabling reliable business intelligence and analytics.
Key Responsibilities
Design, develop, and maintain automated ELT pipelines using SQL, Python, and modern cloud data technologies.
Implement and manage enterprise Lakehouse solutions using Medallion Architecture (Bronze, Silver, Gold).
Perform SQL query optimization, performance tuning, and cloud compute optimization.
Execute data migration and modernization initiatives from legacy databases and file systems.
Design and implement scalable Snowflake-based data engineering and analytics solutions.
Develop dimensional data models, including fact tables, dimensions, star schemas, and semantic layers.
Integrate structured and semi-structured data sources, including APIs, JSON, and file-based ingestion.
Establish data standards, schemas, data contracts, and enterprise architecture documentation.
Administer and maintain enterprise data catalogs using Alation.
Implement data governance, metadata management, data lineage, and data quality frameworks.
Develop data warehouses, data marts, enterprise reports, dashboards, and management scorecards.
Collaborate with IT architecture teams, business stakeholders, and technical teams.
Mentor junior team members and establish data engineering best practices.
Mandatory Technical Skills
5+ years of experience designing and implementing enterprise data warehouses, data lakes, or Lakehouse solutions.
Expert-level SQL skills, including complex queries, optimization, and performance tuning.
Hands-on experience developing automated ELT pipelines using Python and SQL.
Strong hands-on experience with Snowflake-based data engineering, warehousing, and analytics.
Experience implementing Medallion Architecture (Bronze, Silver, Gold).
Advanced dimensional data modeling, including fact tables, dimensions, star schemas, and semantic layers.
Experience integrating structured and semi-structured data, APIs, JSON, and file-based ingestion.
Hands-on experience with enterprise data catalog and governance platforms such as Alation.
Experience with metadata management, data lineage, data quality, and data governance.
Experience with enterprise data migration and modernization initiatives.
Strong documentation, communication, collaboration, and technical leadership skills.
Desired Skills
Snowflake cloud-native architecture, including Snowflake Warehouses, Snowpark, Streams, Tasks, and secure data sharing.
Experience with data modeling tools such as ER/Studio.
Experience with Agile and iterative development environments.
Experience defining enterprise data architecture standards and best practices.
Nice to Have
Experience with dbt.
Strong work ethic and excellent time management.
Education
Bachelor's degree in Data Analytics, Computer Science, Information Technology, Computer Engineering, or a closely related field is preferred.
Important Candidate Requirement
Only candidates currently located in Ohio will be considered.
Interested candidates who meet the mandatory technical requirements are encouraged to apply.
Please share your updated resume along with your current location, availability, and relevant experience with Snowflake, Python, SQL, Medallion Architecture, and Alation.