Lead Data Engineer - Remote, Snowflake & AWS Expert

Empower; Greenwood Village (CO); Presencial; USD 125.000 - 182.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical, dental, vision insurance

401(k) with company match

Tuition reimbursement

Generous PTO and holidays

Volunteer time off

Descripción de la vacante

Empower is seeking a Lead Data Engineer to shape and deliver scalable data pipelines and platforms. You will own design, implementation, and governance of complex data solutions, mentor engineers, and collaborate with enterprise teams to evolve the Snowflake/AWS data landscape.

You will balance production duties with modernization, ensuring reliable, well-documented code and robust monitoring in a fast-paced, collaborative environment. Strong SQL, Python, and communication skills are essential.

Formación

• Bachelor’s degree in Computer Science or related field, or equivalent combination of training and experience.
• 6–8+ years of data engineering experience with enterprise scale platforms.
• Advanced proficiency in SQL, including query optimization and complex transformations, and strong hands-on Python skills.
• 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. Experience with dimensional modeling and reusable datasets.
• SAS/SAS Viya experience is strongly preferred. Candidates with strong SQL, procedural programming, and enterprise ETL experience must be willing and able to learn SAS-based workflows.
• Demonstrated hands-on production support, persistence in resolving issues, and experience making safe changes to unfamiliar or complex existing code.
• Experience leading technical initiatives and mentoring engineers.
• Strong problem-solving and communication skills. Ability to explain complex technical matters clearly, listen to business users, and collaborate across teams.
• Experience working in Agile environments.
• PySpark experience is preferred and a plus.

Responsabilidades

• Lead the design and implementation of advanced data pipelines and ingestion frameworks. Personally develop, test, and maintain the underlying SQL, Python, and ETL code.
• Guide technical execution of complex data initiatives across teams. Balance current production commitments with incremental modernization; assess migrations or redesigns.
• Support and troubleshoot SAS Viya and SQL-based production workflows. Trace failures and data discrepancies to root cause, implement safe corrections, validate outputs, and improve monitoring.
• Translate business requirements into scalable data solutions with SMEs to clarify definitions and reconcile outputs.
• Ensure data platforms are optimized for performance, scalability, and reliability, including Snowflake compute costs.
• Enforce data governance, security, and quality standards.
• Mentor engineers and provide technical leadership, document processes, and build backup ownership.
• Lead code reviews and ensure adherence to engineering standards using VCS, automated testing, and CI/CD.
• Collaborate with architects and stakeholders to align solutions with enterprise direction and communicate decisions clearly.
• Drive improvements in automation, efficiency, and platform capabilities.
• Support Snowflake transformations and shared analytics-ready data structures.
• Validate migrations through reconciliation, parallel runs, and rollback planning before retiring workflows.

Conocimientos

SQL

Python

Data modeling

ETL/ELT

Communication

Educación

Bachelor’s degree in Computer Science or related field

Herramientas

SAS Viya

Amazon Redshift

Snowflake

CI/CD

Descripción del empleo

Empower is seeking a Lead Data Engineer to shape and deliver scalable data pipelines and platforms. You will own design, implementation, and governance of complex data solutions, mentor engineers, and collaborate with enterprise teams to evolve the Snowflake/AWS data landscape.

You will balance production duties with modernization, ensuring reliable, well-documented code and robust monitoring in a fast-paced, collaborative environment. Strong SQL, Python, and communication skills are essential.