Snowflake & Informatica Data Engineer

Remote • Posted 6 hours ago • Updated 6 hours ago
Contract Corp To Corp
Contract W2
Contract Independent
12 Months
No Travel Required
Remote
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Snowflake
  • Informatica
  • ETL
  • Data Engineer
  • Azure DevOps

Summary

Position Title: Senior Snowflake & Informatica Data Engineer

Location: Denver, CO (Must currently reside within the State of Colorado—within 100 miles / Denver Metro strongly preferred—for the duration of the engagement)

Work Arrangement: Remote

Interview Process: Either Webcam or In-Person Interview

< data-path-to-node="12" dir="ltr">Role Summary

Seeking a Senior Data Engineer to design, build, and maintain automated ETL/ELT data pipelines using Snowflake and Informatica for a Statewide Longitudinal Data System (SLDS). Joining under a shared delivery model, this role executes structured knowledge transfer from an implementation partner, leads new agency data ingestions, enforces multi-tier data quality and privacy rules, and transitions into full production ownership of the analytics data foundation.

< data-path-to-node="14" dir="ltr">Key Responsibilities
  • Data Ingestion & ETL/ELT Pipelines: Design, build, test, and deploy automated Informatica workflows and Snowflake SQL transformation pipelines to ingest and harmonize partner agency feeds into a common longitudinal data model.

  • Record Linkage & Analytics Layer: Execute internal identity-matching logic to link student and workforce records across agencies, maintain analytics-layer tables/views, and optimize Snowflake compute and query performance.

  • Data Quality & Privacy Governance: Implement L1 (structural), L2 (completeness/deduplication), and L3 (referential integrity) validation rules, layout-change detection, and cell-suppression standards compliant with FERPA, COPPA, and state statutes.

  • Production Operations & DevOps: Transition from shadowing/co-running to full operational ownership of scheduled feed runs, while managing code reviews, Azure Test Plans, and CI/CD releases in Azure DevOps.

< data-path-to-node="16" dir="ltr">Required Skills & Qualifications
  • Snowflake ETL/ELT: Minimum 5 years of demonstrated experience building, orchestrating, and optimizing complex ETL/ELT pipelines and transformation logic natively within Snowflake.

  • Informatica CDGC: Minimum 1 year of hands-on experience using Informatica Cloud Data Governance and Catalog (CDGC) for metadata management, data profiling, cataloging, and automated quality validation.

  • Infrastructure as Code (IaC): Minimum 1 year of experience utilizing Terraform to provision, configure, and maintain cloud infrastructure.

  • DevOps & Version Control: Demonstrated proficiency implementing automated build, test, and release pipelines in Azure DevOps, paired with expert Git version control skills (branching strategies, PRs, code reviews).

< data-path-to-node="18" dir="ltr">Preferred Qualifications
  • Prior experience working with public-sector, longitudinal education, or workforce data systems.

  • Experience with deterministic/probabilistic record linkage and entity resolution across disparate public datasets.

  • Familiarity with federal/state privacy regulations (FERPA, COPPA, cell suppression) and authoring structured test cases in Azure Test Plans.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91138038
  • Position Id: 12565-13875-1795095067
  • Posted 6 hours ago

Company Info

About Stellar Professionals LLC

Stellar Professionals LLC stands out in the industry, offering a distinctive fusion of over 15 years of seasoned Staffing professionals and a vibrant community of over 150,000 LinkedIn followers. Our AGILE Staffing services are tailored to assist businesses in finding the ideal talent for their projects. In contrast, our Client Acquisition Services are focused on securing more public/private sector projects. Our disruptive approach to staffing and business consulting, encapsulated in our motto 'Agility and Excellence,' truly sets us apart. Contact us today to explore how we can transform your business. Stellar Professionals has a proven track record of success, offering comprehensive capabilities and profound industry knowledge to help you tackle your organization's most intricate issues.

Since our establishment, we have consistently broadened our client base, with a burgeoning roster of returning and new clients each year. This steady expansion is a testament to the value and caliber of our services, instilling unwavering confidence in our potential clients. ​ Many remarkable people want to do something significant but different. With over 15 years of experience in the Talent Acquisition and Staffing industry, we found that Staffing agencies spend a lot of money on Business Development and recruitment activities with low ROI. Therefore, we at Stellar Professionals LLC develop an innovative, cost-effective solution to help you build great Business partnerships and increase revenue.

Stellar Professionals LLC is currently accepting resumes for a variety of positions. Please review the database of positions that we are seeking to fill and contact us for additional information about any specific opportunity.

About_Company_OneAbout_Company_Two
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.