Application Developer

Hybrid in Denver, CO, US • Posted 2 hours ago • Updated 2 hours ago
Contract Independent
Contract Corp To Corp
12 Months
No Travel Required
Hybrid
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • ADA
  • Acceptance Testing
  • Continuous Delivery
  • Analytics
  • Auditing
  • Cloud Computing
  • Data Extraction
  • Data Governance
  • Document Engineering
  • IaaS
  • Extract, Transform, Load
  • Incident Management
  • IDS
  • Git
  • IT Architecture
  • Physical Layer
  • Public Sector
  • Reporting
  • SQL
  • Scripting
  • Telecommuting
  • Terraform
  • Use Cases
  • Version Control
  • Performance Tuning
  • Privacy
  • ProVision
  • Mapping
  • Knowledge Transfer
  • Manual Testing
  • Meta-data Management
  • Failover
  • Informatica
  • Test Cases
  • Test Plans
  • Testing
  • Network Layer

Summary

Job Titles:Application Developer
Location: Denver, CO (Remote Role)
Note: Work Arrangement: Remote / Telecommuting (Candidate must reside within the State of Colorado; strong preference for local / Denver Metro candidates
Job Description: 
  • The Data Engineer is responsible for realizing the vision of the Data Architect through the technical implementation of data pipelines using Snowflake and Informatica. Data Engineers are technical coding experts focused on moving data from line-of-business, transactional, or partner agency source systems into analytical data platforms, building transformations, managing data cleansing and quality, and presenting structured data for consumption by analysts and scientists.
  • In the context of the Statewide Longitudinal Data System (SLDS / COdata) an OIT Data Engineer is expected to join the project team in January 2027 under a shared delivery model with a 3rd party implementor.  The OIT Data Engineer will participate in a structured knowledge-transfer progression (shadowing, co-running, and checking), leading specific new source ingestions, and progressively will take over production operations and upkeep of the SLDS data foundation and analytics layer. 

Scope of Responsibilities

  • Data Ingestion & Pipeline Engineering: Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake to ingest data from partner state agencies and third parties into the SLDS common data model. 

  • Transformation & Analytics Layer Support: Implement transformation logic to convert raw agency feeds into harmonized, linked longitudinal records and analytics layer data models, adhering to core naming and modeling standards established with the Data Architect.

  • Record Linkage & Identity Matching: Execute the SLDS internal matching logic to link newly ingested agency records to master longitudinal student and workforce profiles, handling match exceptions and cross-agency reconciliations.

  • Production Pipeline Operations & Incident Response: Maintain operational ownership of scheduled feed runs, monitoring job execution, resolving run failures, reloading late or corrected files, reconciling row counts, and rebuilding downstream objects.

  • Data Quality & Governance Compliance: Implement L1 (structural/format), L2 (completeness/de-duplication), and L3 (referential integrity/logic) validation checks, layout-change detection, and audit trails; enforce data privacy, suppression rules, and compliance standards (FERPA, COPPA, ADA, and state statutes).

  • Performance Optimization & Platform Stewardship: Optimize query execution, warehouse compute, and pipeline performance for cost and latency; identify and tune heavily used models and performance hot spots in Snowflake.

  • Quality Assurance, Code Review & Promotion: Adhere to the unified release process across Development, Test, UAT, and Production environments using Azure DevOps and Azure Test Plans; author and execute test cases, conduct peer code reviews, and maintain release change logs.

 

Technical Code & Pipeline Artifacts

  1. Production ETL/ELT Pipelines: Fully developed, scheduled Informatica workflows and Snowflake SQL/transformation pipelines for CDHE Courses and existing operational feeds.

  2. Cleansing & Validation Modules: Automated L1, L2, and L3 quality-check rules and Informatica layout-change detection routines in the RAW layer.

  3. Identity Matching & Linkage Routines: Documented internal matching scripts linking new partner agency student/workforce records into longitudinal IDs.

  4. Analytics Layer Transformation Objects: Production views, tables, and metric models in Snowflake aligned with longitudinal reporting use cases .

  5. De-Identified Data Extraction Scripts: Data extraction scripts that generate de-identified, suppressed outcome files for participating IHEs per specification.

Documentation & Engineering Specifications

  1. ETL Pipeline Design Documents: Technical architecture and transformation specifications detailing source-to-target logic, schemas, and dependencies.

  2. Mapping & Transformation Specifications: Contribution to enterprise data mapping documents aligning source fields to the SLDS common data model.

  3. Lineage Documentation & Dependency Maps: As-built data lineage records and dependency diagrams detailing object-level upstream and downstream flows.

  4. Operational Runbooks & Incident Procedures: Standard operating procedures for running feed cycles, handling late or malformed files, performing failover, and reconciling row counts.

Governance, Testing & Operational Reporting

  1. Azure Test Plans & Execution Records: Fully documented test plans, test suites, manual test run results, and defect logs for all pipeline modifications prior to production promotion .

  2. Release Change Logs: Detailed audit entries for all OIT-led production releases, detailing changes, rationales, linked Azure DevOps work items, test results, and deployment timestamps].

  3. Feed Operation Run Logs & Match Summaries: Run completion records, reconciliation totals, exception logs, and data-quality summaries produced for agency loads.

 

Required Qualifications & Technical Experience

  • Snowflake ETL/ELT: Minimum 5 years of demonstrated experience building, orchestrating, and optimizing complex ETL/ELT data pipelines and transformation logic natively within the Snowflake platform.

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

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

  • CI/CD & DevOps: Demonstrated proficiency implementing automated build, test, and release deployment pipelines using Azure DevOps.

  • Version Control: Expert proficiency with Git / version control workflows (branching strategies, pull requests, automated merge checks, code reviews).

  • Location Constraint: Must currently reside within the State of Colorado for the duration of the engagement.

  •  

Preferred Skills & Experience

  • Prior experience working with public sector, longitudinal education, and workforce data systems (e.g., CDE, CDHE, CDLE, CDEC, National Student Clearinghouse).

  • Experience with record linkage, entity resolution, and deterministic/probabilistic identity matching across disparate public records 

  • Familiarity with federal and state student/workforce privacy regulations, including FERPA, COPPA, and cell suppression standards

  • Experience authoring and executing structured test plans in Azure Test Plans 

  • Position Type: 6-Month Contract (with possibility of extension based on project performance and state funding)

  • Work Arrangement: Remote / Telecommuting (Candidate must reside within the State of Colorado; strong preference for local / Denver Metro  candidates)

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: 10115907
  • Position Id: 9147311
  • Posted 2 hours ago

Company Info

About Tri-Force Consulting Services Inc

Since 2000, Tri-Force Consulting Services has been an MBE/SDB certified IT consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.

About_Company_One
Contact the job poster
KD

Kashyap Dave

Recruiter @ Tri-Force Consulting Services Inc

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