Sr Snowflake Data Engineer

Job Title: Sr Snowflake Data Engineer

Location: Columbia, MD


Type: Contract to Hire 

Compensation: $70/HR 

Contractor Work Model: Hybrid, (few meetings per month)

 

ALTA IT seeking an experienced Senior Data Engineer to join our health insurance client. This role is a key contributor in designing, developing, and optimizing cloud-based data solutions using Snowflake.

You’ll leverage advanced Snowflake capabilities, build modern data pipelines, and enable scalable analytics and reporting to support enterprise operations. The ideal candidate demonstrates deep Snowflake and SQL expertise, hands-on experience with Snowpark (Python), and a strong foundation in data architecture, governance, and automation.

Key Responsibilities

• Develop and optimize data pipelines and transformations in Snowflake using SQL and Snowpark (Python).

• Build and manage Streams, Tasks, and Materialized Views for real-time and batch data operations.

• Implement CI/CD pipelines and automate deployments (e.g., Jenkins).

• Collaborate with architects and analysts to design scalable data models and enforce data governance standards.

• Monitor and optimize pipeline performance, reliability, and cost.

• Integrate Snowflake with tools like dbt and Kafka for orchestration and streaming.

Required Skills

• 5 years in data engineering; 3 years hands-on with Snowflake Data Cloud.

• Strong SQL and Python/Snowpark skills.

• Experience with data modeling, DevOps/CI-CD, and data governance (Collibra, Alation, or Purview).

• Proven ability to troubleshoot, optimize, and deliver scalable solutions.

Preferred

• Experience with dbt, Kafka, or data quality tools (Great Expectations, Monte Carlo).

• Snowflake certification (SnowPro Core or Advanced).

• Background in regulated industries such as healthcare or insurance.

Soft Skills

• Strong analytical and communication abilities.

• Collaborative, proactive, and adaptable in fast-paced environments.

• Commitment to quality, automation, and continuous improvement.
  
  

System One, and its subsidiaries including Joulé, ALTA IT Services, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.



System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.



#M2





#DI-AJ1



Ref: #850-Rockville (ALTA IT)