3 days ago
Remote, United States or Rochester, NY, USAMid Level
Base Salary
$90k - $140k/yr
Responsibilities
- Convert Informatica pipelines to Matillion and Snowflake using shared migration patterns.
- Build reusable jobs, templates, validation utilities, and other components to accelerate pipeline conversion.
- Design, optimize, and support Snowflake pipelines and downstream objects for performance and reliability.
- Build and support ingestion pipelines from Azure SQL Server, files, APIs, and MongoDB.
- Profile source data, compare migrated outputs with legacy results using SQL and Python, and resolve discrepancies.
- Coordinate migration sequencing, testing standards, and sign-off criteria with technical leads and client subject-matter experts.
- Document migration logic, assumptions, test evidence, and go-live readiness.
- Communicate progress and risks while supporting project milestones.
- Use AI-assisted tools responsibly to improve productivity, automate routine work, and enhance solution delivery.
Requirements
- BS degree in Computer Science, Data Science, Engineering, or a related field preferred, or an equivalent combination of education and experience.
- At least 3 years of hands-on experience with advanced SQL and Python for data processing and pipeline support.
- At least 2 years of experience designing, building, and supporting ETL/ELT pipelines.
- At least 2 years of Snowflake experience, including dynamic tables, views, performance tuning, and schema design.
- Experience with data ingestion and replication tools, including connector setup, authentication, and integrations across diverse sources.
- Informatica or Matillion experience is preferred.
- Ability to profile complex source data, verify pipeline outputs, and independently resolve data issues.
- Ability to work independently, communicate clearly, and seek help when blocked.
- Ability to use AI while maintaining accountability, professional judgment, and protection of 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.
