Mid-Level Data Engineer - Jay-Bee Oil & Gas

About Jay-Bee Oil & Gas

Jay-Bee Oil & Gas is a family-owned business operating in West Virginia since 1982, with a reputation as a group of hard-working, honest people dedicated to being good neighbors as we explore and produce oil and gas resources. With nearly 40 years of experience in the Appalachian Basin, we've produced more than 500 wells and uniquely understand the complexities of drilling in this region. As a full-service company, we perform the majority of activities associated with drilling and producing oil and gas wells and getting them to market, including independent exploration and production of unconventional natural gas resources from tight sands and fractured shales.

Position Overview

We're seeking a Mid-Level Data Engineer to join our growing team and lead the implementation of our data infrastructure modernization. This is a unique opportunity to work directly with executive leadership and build foundational data systems that will drive strategic decision-making across the organization. As our sole data engineer, you'll have significant autonomy and the opportunity to shape our entire data architecture from the ground up.

Location: West Virginia (Remote work available)
Experience Level: Mid-Level (3-5 years)

Key Responsibilities

Core Data Infrastructure

• Snowflake Implementation: Design, configure, and deploy Snowflake as our primary data warehouse platform
• Data Pipeline Development: Build robust ETL/ELT pipelines to ingest data from various operational systems, APIs, and third-party sources
• Data Integration: Establish connections to production databases, SCADA systems, regulatory databases, and sensor platforms
• Data Quality & Governance: Implement automated testing, validation, and monitoring for all data workflows

Technical Deliverables

• Data Warehouse Architecture: Design optimized schemas and data models for oil and gas production analytics
• API Integration: Develop and maintain data connectors for various third-party systems and APIs
• Business Intelligence Support: Create data foundations to support Power BI, Spotfire, and other BI tools
• Geospatial Data Management: Handle well locations, lease boundaries, and surface facility data for spatial analysis
• Automation: Build self-healing, monitored data pipelines with proper error handling and alerting

Collaboration & Growth

• Work closely with our Business Analyst and leadership team to understand data requirements
• Participate in strategic planning sessions with CEO visibility
• Document processes and create knowledge base for future team expansion
• Mentor future hires as the data team grows

Required Qualifications

Technical Skills:

• 3-5 years of data engineering experience
• Strong proficiency in Snowflake (data warehousing, optimization, security)
• Advanced SQL skills and database design principles
• Experience with Python for data processing and automation
• Knowledge of ETL/ELT frameworks (dbt, Airflow, or similar)
• Familiarity with cloud platforms (AWS, Azure, or GCP)
• Understanding of API integration and data connectors