Snowflake data engineer - RRC

ShiftCode Analytics, Inc. is seeking a Software Engineer – Level 2 to provide data engineering services for the Railroad Commission of Texas. The role focuses on implementing data governance solutions, building scalable data systems, and ensuring high-quality data across the organization.

Responsibilities:

• 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

Requirements:

• 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+ 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 Knowledge of local, state, and federal laws and regulations (PII) relevant to data governance
• 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