Required Skills & Experience
- 3+ years of experience with strong, hands-on Snowflake experience with the ability to contribute immediately without significant platform ramp-up.
- Proven experience performing legacy system/data warehouse to Snowflake migrations, including lift-and-shift or similar cloud migration initiatives.
- Advanced SQL skills for querying, analyzing, transforming, and validating data.
- Hands-on experience with Python for data engineering, automation, or data-processing activities.
- Experience with data validation, reconciliation, and data-quality analysis during migrations.
- Ability to analyze migrated data, identify gaps, and clearly communicate findings through practical reporting.
- Demonstrated ability to work independently and proactively with limited supervision.
- Strong problem-solving skills with a track record of identifying blockers, finding the appropriate stakeholders/resources, and driving issues through resolution.
- Strong stakeholder communication skills, particularly around status updates, dependencies, risks, and next steps.
Nice to Have Skills & Experience
- Experience with Snowflake Cortex AI or other Snowflake-native AI capabilities.
- Experience supporting data mart or data warehouse environments.
- Experience creating business-facing reports or analyses using Excel or similar tools.
- Previous experience within the pharmaceutical, life sciences, or scientific-data environment.
Job Description
Insight Global is seeking a Snowflake Data Engineer to support a large pharmaceutical client. This individual will be responsible for migrating data from legacy systems into Snowflake, validating and organizing migrated data, identifying data gaps, and translating findings into practical reporting and insights.
The ideal candidate will have strong hands-on experience with Snowflake, SQL, Python, and legacy-to-cloud data migrations. This role requires someone who can operate independently in a complex enterprise environment, proactively identify and resolve blockers, coordinate with technical and business stakeholders, and drive work forward without requiring significant day-to-day direction.
Responsibilities:
- Design and execute the migration of data from legacy/source systems into Snowflake.
- Develop and maintain data pipelines and processes using Snowflake, SQL, and Python.
- Analyze migrated datasets to understand data structure, completeness, quality, and usability.
- Perform data validation, reconciliation, and quality checks to identify gaps or inconsistencies between source and target systems.
- Troubleshoot migration issues and proactively drive technical and operational blockers through resolution.
- Work with business and technical stakeholders to understand data requirements and determine the appropriate resources or teams needed when dependencies arise.
- Provide clear and consistent communication around project status, risks, roadblocks, and next steps.
- Organize and transform data into straightforward reports and analyses that enable stakeholders to understand key findings.
- Support and coordinate additional migration activities as the environment continues to evolve.
- Independently manage multiple workstreams and priorities in an environment where requirements may not always be fully defined.
- Proactively identify alternative solutions when an initial technical approach is unsuccessful.