3 days ago
Remote, United States or Rochester, NY, USAStaff+
Base Salary
$105k - $155k/yr
Responsibilities
- Own the client-approved end-to-end design for migrating Informatica pipelines to Maia (Matillion) and Snowflake.
- Define repeatable processes and reusable patterns for discovering, classifying, converting, testing, and promoting pipelines.
- Design connector and authentication patterns for Azure SQL Server, files, APIs, and MongoDB.
- Set testing and sign-off standards, review pipeline quality and documentation, and resolve deficiencies.
- Apply AI-assisted conversion with guardrails, review, and verification practices.
- Partner with clients and internal stakeholders on priorities, sequencing, risks, trade-offs, and cutover readiness.
- Lead day-to-day delivery against May and June fiscal year-end milestones.
- Coach and develop data engineers, potentially including direct reports, and evaluate tools and practices.
Requirements
- A BS degree in Computer Science, Data Science, Engineering, or a related field is preferred, or an equivalent combination of education and experience.
- At least 5 years of hands-on data engineering experience designing, building, and supporting enterprise ETL/ELT pipelines.
- At least 3 years of Snowflake experience with dynamic tables, views, performance tuning, schema design, advanced SQL, and Python.
- Experience leading the technical design of a large-scale pipeline migration or platform conversion with reusable source-to-target mapping standards.
- Informatica expertise and hands-on Matillion or comparable cloud-native integration-platform experience; Informatica-to-Matillion migration experience is highly desirable.
- Experience using AI to accelerate pipeline conversion at scale and establish review and verification practices.
- Strong testing, validation, data-quality troubleshooting, technical leadership, mentoring, client communication, and decision-making skills.
- Experience leading and mentoring Agile engineering teams and using AI ethically, securely, and compliantly while protecting confidential information.
Benefits
- Fully remote work environment with occasional in-person participation for meetings, events, or collaboration; employees near Rochester, NY may be asked to work from the office more frequently.
- Flexible time off.
- Medical, dental, and vision insurance.
- 401(k) with company match.
- Company-paid life and disability insurance.
- Professional development opportunities.
