Lead Data Engineer

Posted 13hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Lead Data Engineer building University of the Cumberlands’ Snowflake lakehouse and analytics infrastructure. Leading architecture, pipelines, governance, and the data engineering team.

Responsibilities:

  • 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:

  • 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:

  • 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