Lead Data Engineer

University HUB

. Own the end-to-end architecture, implementation, and evolution of the Snowflake-based data lakehouse across bronze, silver, and gold layers .

Posted 9/17/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Snowflake architecture, data lakehouse implementation, and ELT processes, with a strong focus on data governance and security compliance. Proven ability to lead and mentor a data engineering team while optimizing data workflows and ensuring high-quality data delivery.

Highest-signal resume keywords

Snowflake AdministrationData Lakehouse ImplementationELT Process DevelopmentPython for Data TransformationData Governance Frameworks

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Snowflake SQLDbt CoreSQL ServerData Modeling StandardsData MigrationData TransformationData Workflow AutomationSchema DesignMedallion ArchitectureQuery Performance Optimization

Soft Skills

Strong Communication SkillsStakeholder ManagementTeam LeadershipMentoring

Tools & Technologies

FivetranPrefectPower BIAzure

Industry Keywords

FERPA ComplianceData GovernanceCloud EnvironmentsERP/SaaS Data Platforms

Tech Stack

Tools & technologies

AzureCloudERPMS SQL ServerPythonSQL

About the role

Key responsibilities & impact

Own the end-to-end architecture, implementation, and evolution of the Snowflake-based data lakehouse across bronze, silver, and gold layers
Define and lead the pipeline strategy
Design and build ELT processes ingesting and transforming data from SQL Server, Workday, and cloud-based services using dbt Core
Lead migration away from legacy data logic and infrastructure
Establish and enforce data modeling standards, schema conventions, and medallion architecture best practices
Own Snowflake security, role-based access controls, and data governance in compliance with FERPA and institutional policy
Automate and orchestrate data workflows using Python and Prefect with Azure-based services
Collaborate with data consumers to ensure accurate, timely, and usable data
Monitor and troubleshoot Snowflake environments, optimize query performance, and resolve pipeline issues
Document system architecture, data flows, and technical configurations
Evaluate Snowflake, dbt, and ecosystem tools to improve scalability, automation, and maintainability
Lead, mentor, and grow a high-performing data engineering team
Perform other duties as assigned
Report under the general supervision of the Chief Information Officer (CIO)
Collaborate with software engineers, institutional research, Power BI developers, and the Office of Innovation and Enhancement

Requirements

What you’ll need

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a closely related field
Minimum of 3 years of hands-on experience administering and managing a Snowflake environment, including configuration, optimization, and security
Experience delivering a full data lakehouse end-to-end from the ground up at meaningful scale, including 5+ source systems, enterprise-scale data volumes, architecture decisions, schema design, medallion architecture, data governance framework, and migration from legacy systems
Proficiency with Snowflake environments, data loading, Snowflake SQL, Streams, Tasks, transformation, and security management
Hands-on experience with dbt Core or dbt Cloud, including model development, testing, documentation, and production deployment
Strong experience developing ELT solutions integrating cloud and on-premises data sources
Experience with Fivetran or a comparable managed EL platform is strongly preferred
Solid SQL skills and hands-on experience with Microsoft SQL Server
Experience using Python for data transformation, orchestration, and automation
Experience with a workflow orchestration platform required; Prefect strongly preferred
Familiarity with Workday reporting data or similar ERP/SaaS data platforms preferred
Working knowledge of cloud environments, especially Azure
Experience supporting business intelligence solutions using tools such as Power BI
Understanding of data governance and security frameworks, including FERPA compliance
Strong communication skills and ability to articulate architectural priorities, manage stakeholder expectations, and push back on requests conflicting with platform strategy or engineering best practices
Must be authorized to work for any employer in the United States; employment visa sponsorship is unavailable

Benefits

Comp & perks

Student-focused work environment
Opportunity to contribute to intellectual and spiritual growth, leadership, and service
Opportunity to build and lead a data engineering team
Full-time employment