Senior Data Engineer
Job Description
Robotics Technologies is hiring a Senior Data Engineer in Denver, CO (onsite) to build and operate enterprise data pipelines that power analytics. In this role, you will design automated ETL/ELT workflows using Snowflake and Informatica, strengthen data quality and governance practices, and use infrastructure automation to support reliable production operations.
What you will do
- Design, develop, test, and deploy automated ETL/ELT pipelines using Snowflake and Informatica.
- Create data ingestion workflows that integrate multiple source systems into centralized analytical platforms.
- Write complex SQL transformations, build data cleansing routines, and establish data validation processes.
- Implement data quality checks for completeness, accuracy, duplicate detection, and referential integrity.
- Support data modeling, transformation logic, and analytics-layer development.
- Handle data reconciliation, troubleshoot pipeline failures, and manage production data operations.
- Optimize Snowflake queries, warehouse utilization, and overall pipeline performance.
- Apply metadata management practices including data profiling, cataloging, and governance.
- Use Terraform for infrastructure provisioning and configuration.
What you bring
- Experience with Snowflake ETL/ELT development, data pipelines, and transformations.
- Experience with Informatica Cloud Data Governance and Catalog (CDGC).
- Experience using Terraform for Infrastructure as Code (IaC).
- Strong proficiency in Snowflake SQL, data transformations, and pipeline optimization.
- Experience implementing CI/CD pipelines using Azure DevOps.
- Strong knowledge of Git, branching strategies, pull requests, and version control workflows.
- Experience implementing data quality validation, data cleansing, and metadata management.
- Strong troubleshooting, analytical, and problem-solving skills.
Helpful experience (preferred)
- Experience working with government or public-sector data systems.
- Knowledge of education, student, and workforce data platforms.
- Experience with record linkage, entity resolution, and identity matching.
- Familiarity with FERPA, COPPA, data privacy, and data suppression requirements.
- Experience with Azure Test Plans and structured test execution.
- Experience supporting Tableau reporting and analytical data models.
Salary: USD 78 - 78 per hourly. Location: Denver, CO (onsite).