Lead Engineer Data
Empower, Nationwide Remote
The role
The Lead Data Engineer provides hands-on technical leadership in the design, development, and optimization of scalable data pipelines, ingestion frameworks, and data platforms. This role leads complex initiatives, ensures alignment with architectural standards, and drives delivery of high-quality, secure, reliable and properly governed data solutions and data platforms aligned with enterprise standards. Operating with significant independence, the Lead Data Engineer guides technical decision-making, mentors engineers, and ensures consistent implementation of best practices across teams.
Serves as an escalation point for complex data engineering challenges.
The team currently uses SAS Viya and Amazon Redshift for data processing, automation, and reporting and is transitioning toward Snowflake. This role combines direct coding, troubleshooting, and support of existing workflows with participation in Snowflake engineering and design alongside enterprise engineering teams. Production ownership and new development remain core responsibilities as the future environment evolves.
What you will do
- 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 which processes to retain, migrate, redesign, or retire.
- Support and troubleshoot SAS Viya and SQL-based production workflows. Trace job failures and data discrepancies to root cause, implement safe corrections, validate outputs, and improve monitoring and recovery.
- Translate highly complex business requirements into scalable data solutions. Work with subject-matter experts to clarify business definitions and reconcile outputs into consistent, reusable datasets.
- Ensure data platforms are optimized for performance, scalability, and reliability. Consider Snowflake query performance and compute cost.
- Enforce data governance, security, and quality standards.
- Mentor engineers and provide technical leadership on projects. Share knowledge, document processes, and build backup ownership across the team.
- Lead code reviews and ensure adherence to engineering standards. Use version control, automated testing, and CI/CD practices to support safe releases.
- Collaborate with architects and stakeholders to align solutions with enterprise direction. Communicate technical decisions and production issues clearly to technical and nontechnical partners in a matrixed environment.
- Drive improvements in automation, efficiency, and platform capabilities.