Snowflake Data Engineer

This is a remote position.

The Snowflake Data Engineer will support the Railroad Commission of Texas (RRC). This role works with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns. The engineer will design and implement ETL/ELT pipelines that move data into Snowflake and will translate business requirements into functional and technical specifications for future self-service analytics. The position also covers documenting existing data extracts, validating data quality across Mainframe, Lonestar, Open Systems, and Snowflake environments, and supporting Power BI reporting built on Snowflake. The engineer will provide technical advice, assistance, and recommendations on report development.

• Participate in detailed sessions with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns.
  
• Develop reverse-engineering documentation for existing data extracts to support business reporting and extract needs.
  
• Design and implement ETL/ELT pipelines that move data into Snowflake using approved tools and frameworks.
  
• Translate business requirements into clear functional and technical specifications for future self-service analytics.
  
• Collaborate with data engineers and architects on data modeling, schema design, and transformation logic in Snowflake, including new database schemas that meet requirements.
  
• Validate data quality and reconcile source-to-target results across Mainframe, Lonestar, Open Systems, and Snowflake environments.
  
• Develop data conversion and system implementation plans, and prepare and obtain approval of system and programming documentation.
  
• Support the creation of Power BI datasets, semantic models, and dashboards using Snowflake as the primary data source.
  
• Troubleshoot data issues across the full pipeline, from Lonestar or Open Systems extract to Snowflake load to Power BI visualization.
  
• Document technical processes, data flows, and system dependencies, and participate in code reviews, testing cycles, and production support activities.
  

Requirements

Minimum Qualifications - Candidates must meet all minimum qualifications

• 8 years of hands-on experience with Snowflake, including SQL, data loading, transformations, and performance tuning.
  
• 4 years of experience with ETL/ELT concepts, data pipelines, and data integration patterns.
  
• 5 years of experience analyzing complex data flows and troubleshooting issues across multiple systems.
  
• 4 years of experience with enterprise information management processes and methodologies, relational database management systems, and metadata management.
  
• 2 years of experience working in fast-paced, changing environments, achieving project delivery and deadlines, analyzing complex information, and developing plans to address identified issues.
  
• 2 years of experience applying interpersonal skills, including working with people under pressure, negotiating among multiple parties, resolving conflicts, and maintaining effective working relationships with personnel at various levels.
  

Preferred Qualifications

• Former Railroad Commission of Texas experience or an oil and gas industry background is strongly preferred.
  
• 3 years of experience with Informatica, Matillion, Azure Data Factory, or similar data integration tools.
  
• Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field.
  

Additional Requirements

• Candidates must be authorized to work in the U.S.
  
• The candidate may be required to work outside normal business hours, including weekends, evenings, and holidays, as requested.