Data Engineer – Snowflake

Air InfoSec

. Participate in detailed sessions with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns .

Posted 10/27/2026contractRemote • Texas • United StatesSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing ETL/ELT pipelines using Snowflake, along with strong capabilities in data modeling, schema design, and data quality validation. Proficient in translating business requirements into technical specifications and developing self-service analytics solutions.

Highest-signal resume keywords

Snowflake ExpertiseETL/ELT Pipeline DevelopmentData Quality ValidationSQL ProficiencyData Integration Tools Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLETLELTData ModelingData TransformationData Quality ValidationData AnalysisDatabase Schema DevelopmentPerformance TuningData Conversion

Soft Skills

Interpersonal SkillsConflict ResolutionNegotiationEffective CommunicationAdaptability

Tools & Technologies

SnowflakePower BIInformaticaMatillionAzure Data Factory

Industry Keywords

Enterprise Information ManagementRelational Database Management SystemsMetadata ManagementOil and Gas IndustryRailroad Commission of Texas Experience

Tech Stack

Tools & technologies

AzureETLInformaticaMatillionSnowflakeSQL

About the role

Key responsibilities & impact

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 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
Develop new database schemas that meet business and technical 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 obtain approval of system and programming documentation
Support creation of Power BI datasets, semantic models, and dashboards using Snowflake as the primary data source
Troubleshoot data issues across the pipeline from Lonestar or Open Systems extract through Snowflake load to Power BI visualization
Document technical processes, data flows, and system dependencies
Participate in code reviews, testing cycles, and production support activities
Provide technical advice, assistance, and recommendations on report development

Requirements

What you’ll need

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
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 is preferred
Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field is preferred
Candidates must be authorized to work in the U.S.
May be required to work outside normal business hours, including weekends, evenings, and holidays

Benefits

Comp & perks

Remote work from home
Monday through Friday, 8:00 AM to 5:00 PM schedule
Excludes State holidays