3 days ago
Remote, United StatesStaff+
Base Salary
$125k - $182k/yr
Responsibilities
- Design and implement advanced data pipelines, ingestion frameworks, ETL processes, and scalable data platform solutions.
- Personally develop, test, troubleshoot, and maintain SQL, Python, and ETL code for production and new development workflows.
- Lead complex data engineering initiatives, balancing production commitments with modernization and migration decisions.
- Support and troubleshoot SAS Viya and SQL-based production workflows, including root-cause analysis, corrections, output validation, monitoring, and recovery improvements.
- Translate complex business requirements into scalable solutions, consistent business definitions, reusable datasets, dimensional models, and analytics-ready data structures.
- Optimize Snowflake queries, compute costs, platform performance, scalability, and reliability.
- Enforce data governance, security, quality, testing, release, and engineering standards.
- Mentor engineers, provide technical leadership, lead code reviews, document processes, and build backup ownership across the team.
- Collaborate with architects and stakeholders on enterprise architecture, technical decisions, production issues, and Snowflake transformations.
- Validate migrations through reconciliation, parallel runs, and rollback planning before retiring established workflows.
- Drive improvements in automation, efficiency, and platform capabilities.
Requirements
- Bachelor’s degree in Computer Science or a related field, or an equivalent combination of training and experience.
- At least 6 years of data engineering experience with enterprise-scale platforms; the posting states 6–8+ years.
- Advanced SQL proficiency, including query optimization and complex transformations, along with strong hands-on Python skills.
- Strong AWS and modern data platform experience, with required hands-on Snowflake engineering experience.
- Deep understanding of data modeling, ETL/ELT processes, data warehousing, dimensional modeling, and reusable business-facing datasets.
- SAS or SAS Viya experience is strongly preferred; candidates with relevant SQL, procedural programming, and enterprise ETL experience must be willing and able to learn and support SAS workflows.
- Hands-on production support experience, persistence in resolving issues, and experience making safe changes to complex existing code.
- Experience leading technical initiatives and mentoring engineers.
- Strong problem-solving, communication, collaboration, and ability to explain complex technical matters to technical and nontechnical partners.
- Experience working in Agile environments.
- PySpark experience is preferred, and experience preparing governed data for advanced analytics or machine learning is a plus.
Benefits
- Medical, dental, vision, and life insurance.
- 401(k) retirement plan with company matching contributions up to 6%, potential discretionary contributions, financial advisory services, and a broad investment lineup.
- Tuition reimbursement up to $5,250 per year.
- Generous paid time off upon hire, including paid time off, ten company holidays, and three floating holidays annually.
- 16 hours of paid volunteer time per calendar year.
- Paid parental leave, paid short- and long-term disability, and Family and Medical Leave programs.
- Business Resource Groups supporting inclusion and collaboration.
- Flexible work environment; remote or hybrid employees must provide reliable wired high-speed fiber, cable, or DSL internet and a suitable home workspace, and may be required to work in the office if requirements are not met.
- Business-casual environment, including the option to wear jeans.
