Lead Data Engineer: Snowflake, Pipelines & Governance

Empower Retirement; Greenwood Village (CO); On-site; USD 125,000 - 182,000; Full time

Benefits offered by this job

Medical, dental, vision and life保险

401(k) with company match

Tuition reimbursement

Paid time off

Volunteer time

Leave programs

BRGs

Job summary

Empower Retirement seeks a Lead Data Engineer to design, build, and optimize scalable data pipelines and platforms. You will lead complex initiatives, guide Snowflake engineering during our transition from SAS Viya and Redshift, and ensure governance and reliability across teams.

You will mentor engineers, perform code reviews, and collaborate with architects to deliver robust, secure solutions while balancing performance and cost. Proficiency in SQL, Python, and AWS is required.

Qualifications

• Bachelor's degree in Computer Science or related field or equivalent
• 6-8+ years of data engineering experience with enterprise scale platforms.
• Advanced proficiency in SQL, including query optimization and strong hands-on Python.
• Strong experience with AWS and modern data platforms; hands-on Snowflake engineering experience is required.
• Deep understanding of data modeling, ETL/ELT processes, and data warehousing.
• SAS/SAS Viya experience is strongly preferred; willing to learn SAS-based workflows.
• Demonstrated hands-on production support and persistence in resolving issues.
• Experience leading technical initiatives and mentoring engineers.
• Strong problem-solving and communication skills; able to explain complex topics clearly.
• Experience working in Agile environments.
• PySpark experience is preferred.

Responsibilities

• Lead the design and implementation of advanced data pipelines and ingestion frameworks.
• Guide technical execution of complex data initiatives across teams; balance production with modernization.
• Support SAS Viya and SQL-based production workflows; trace failures and improve monitoring.
• Translate business requirements into scalable data solutions with SMEs.
• Ensure data platforms are optimized for performance, scalability and cost.
• Enforce data governance, security and quality standards.
• Mentor engineers, lead code reviews, and document processes.
• Collaborate with architects and stakeholders to align solutions with enterprise direction.
• Drive improvements in automation and platform capabilities.
• Support design decisions for Snowflake transformations and data structures.

Skills

SQL

Python

AWS

Snowflake

SAS Viya

ETL/ELT

Data Modeling

Data Warehousing

PySpark

Education

Bachelor's degree in Computer Science or related field

Tools

SAS Viya

Snowflake

Job description

Empower Retirement seeks a Lead Data Engineer to design, build, and optimize scalable data pipelines and platforms. You will lead complex initiatives, guide Snowflake engineering during our transition from SAS Viya and Redshift, and ensure governance and reliability across teams.

You will mentor engineers, perform code reviews, and collaborate with architects to deliver robust, secure solutions while balancing performance and cost. Proficiency in SQL, Python, and AWS is required.