Junior Snowflake Data Engineer

Think Consulting; Columbia (MD); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

Remote work

Job summary

Think Consulting seeks a Snowflake Data Engineer to support a government data modernization effort, migrating legacy CMS/healthcare data to a Snowflake ecosystem. You will design data structures, implement RBAC and governance, and optimize SQL for large datasets.

Role is 100% remote, EST-aligned, with USC/Green Card required and ability to obtain Public Trust clearance. 2+ years of Snowflake experience and strong data architecture knowledge are expected.

Qualifications

• Core and/or Advanced Snowflake Certification.
• 2+ years hands-on Snowflake experience.
• Strong SQL development and query optimization.
• Experience with large-scale databases, data repositories, and data integration.
• Knowledge of Snowflake security, including role-based access controls, permissions, and governance.
• Strong understanding of data modeling, database concepts, and data architecture principles.
• Experience performing data analysis and working directly with complex datasets.
• Excellent communication and collaboration skills.

Responsibilities

• Support the modernization of CMS claims and healthcare data platforms from legacy/mainframe systems to Snowflake.
• Perform data analysis, data validation, and data quality assessments across large datasets.
• Develop, optimize, and maintain complex SQL queries and data transformations.
• Design and implement Snowflake data structures, roles, permissions, and access controls.
• Collaborate with stakeholders to understand data requirements and business rules.
• Assist with data repository design and overall Snowflake architecture best practices.
• Support data migration, integration, and performance optimization efforts.
• Work closely with technical and business teams to establish a scalable cloud data environment.
• Participate in defining future-state data engineering and data architecture strategies.

Skills

Snowflake certification

SQL development

Data modeling

Data governance

RBAC security

Data architecture

Data analysis

Communication

Education

Snowflake Certification

Tools

Snowflake

SQL

Job description

100% Remote - must work EST.
Requires USC or Green Card
Must be able to obtain and maintain a Public Trust Clearance

Think is seeking a Snowflake Data Engineer to support a large-scale data modernization initiative for a government client. This role will help transform and modernize legacy claims and healthcare data platforms, migrating data from mainframe environments into a modern Snowflake data ecosystem.

Responsibilities

• Support the modernization of CMS claims and healthcare data platforms from legacy/mainframe systems to Snowflake.
• Perform data analysis, data validation, and data quality assessments across large datasets.
• Develop, optimize, and maintain complex SQL queries and data transformations.
• Design and implement Snowflake data structures, roles, permissions, and access controls.
• Collaborate with stakeholders to understand data requirements and business rules.
• Assist with data repository design and overall Snowflake architecture best practices.
• Support data migration, integration, and performance optimization efforts.
• Work closely with technical and business teams to establish a scalable cloud data environment.
• Participate in defining future-state data engineering and data architecture strategies.

Required Qualifications

• Core and/or Advanced Snowflake Certification
• 2+ years of hands-on experience working within Snowflake environments.
• Strong SQL development and query optimization experience.
• Experience working with large-scale databases, data repositories, and data integration initiatives.
• Knowledge of Snowflake security, including role-based access controls, permissions, and governance.
• Strong understanding of data modeling, database concepts, and data architecture principles.
• Experience performing data analysis and working directly with complex datasets.
• Excellent communication and collaboration skills.

Preferred Qualifications

• Previous experience supporting CMS, HHS, or other federal healthcare agencies.
• Experience working with healthcare, claims, Medicare, Medicaid, or related healthcare datasets.
• Experience supporting cloud-based data modernization initiatives.
• Background functioning in both Data Engineer and Data Architect capacities.
• Experience migrating data from legacy or mainframe environments to modern cloud platforms.

Equal Opportunity Employer, including disability and protected veteran status