Snowflake data engineer - RRC

Snowflake data engineer
Title/Level: Software Engineer - Level 2
Client - Railroad Commission of Texas (RRC)
Visa - USC/GC/H4/ H1B
Location Remote
Rate $50 - $53/hr. on C2C

I. DESCRIPTION OF SERVICES
The Railroad Commission of Texas (RRC) requires the services of one (1) Software Engineer, Level 2 with strong expertise in data engineering and data governance, specializing in Informatica Data Governance and Snowflake. The selected candidate will focus on building scalable data solutions, implementing governance frameworks, and ensuring high-quality, trusted data across the organization.
All work products resulting from the project shall be considered "works made for hire" and are the property of the Railroad Commission of Texas. Background checks may be conducted as authorized by Texas law. The RRC will not pay any fees for interviews or discussions during the candidate selection process.
The Software Engineer will be responsible for implementing and maintaining Informatica Data Governance solutions, including metadata management, data quality rules, lineage, and stewardship workflows. The role will require close collaboration with data stewards, analysts, and business teams to define and enforce governance standards.
The candidate will also develop automated data ingestion, transformation, and validation processes, and integrate Snowflake with Informatica and other cloud platforms. Responsibilities include monitoring data quality, performance, and reliability across pipelines, contributing to architectural decisions and documentation of best practices, and resolving data issues to ensure data accuracy, consistency, and security. The position will also provide technical guidance related to data reporting and analytics solutions.

II. ESSENTIAL JOB DUTIES
The Software Engineer will perform duties including, but not limited to:
• Implement and maintain Informatica Data Governance tools such as Axon, Enterprise Data Catalog (EDC), and Informatica Data Quality (IDQ).
• Develop and manage enterprise data cataloging and governance frameworks.
• Design and support scalable and distributed data systems.
• Perform data modeling, metadata management, and data lineage documentation.
• Develop API integrations and automated workflow processes for data systems.
• Design and implement Snowflake-based ELT pipelines, including performance tuning and optimization.
• Integrate Snowflake with Informatica and other cloud-based data platforms.
• Define data transformation rules, metadata definitions, and lineage documentation.
• Monitor and improve data quality, reliability, and governance compliance across enterprise systems.
• Ensure reporting and data extract requirements align with enterprise data governance standards.
• Troubleshoot data and reporting defects and collaborate with technical teams to resolve issues.
• Provide technical recommendations and best practices for data architecture and reporting development.
• Contribute to CI/CD and DevOps processes, including source control and automated deployment.

III. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements
Candidates who do not meet or exceed the minimum stated requirements will be displayed to customers but may not be selected for this opportunity.
Years Required/Preferred Experience
5+ Required Strong experience with Informatica Data Governance tools (Axon, EDC, IDQ)
2+ Required Experience with Informatica Intelligent Cloud Services (IICS)
5+ Required Experience with API integrations and workflow automation
5+ Required Skill with Microsoft Office tools including Word, Excel, PowerPoint, Visio, and SharePoint
3+ Required Understanding of cloud data platforms (Azure, AWS, Databricks, Snowflake, or similar)
3+ Required Expertise in data modeling, metadata management, and data lineage
5+ Required Knowledge of enterprise information management processes, relational database systems, and metadata management
2+ Preferred Knowledge of local, state, and federal laws and regulations (PII) relevant to data governance
2+ Required Experience working in fast-paced environments while meeting project deliverables and deadlines
2+ Required Strong interpersonal skills including conflict resolution, negotiation, and collaboration across teams
2+ Preferred Experience in data modernization initiatives such as legacy system migration to modern platforms
2+ Preferred Graduation from an accredited four-year college or university with coursework in computer science, data processing, business administration, or a related field