← Back to jobsJob ID col-cmvl8tp5901n8s3ct61z8ia2z

Lewis Energy GroupPosted 30+ days ago

Data Engineer II

Full-time
On-site
2+ years
Competitive
Posted 30+ days ago

Lewis Energy Group is hiring a Data Engineer II to design, build, and maintain its Microsoft Fabric data platform. The role develops and migrates data pipelines, supports Power BI semantic models, and ensures data quality, governance, and reliable delivery while collaborating with business stakeholders.

Posted
30+ Days Ago
Source
internal-lewisenergy.icims.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Design, build, and maintain data pielines in Microsoft Fabric using Data Factory pipelines, Dataflows Gen2, and notebooks to move data from source systems into Lakehouses and Warehouses
  • Develop data transformation and processing logic in Python and Pyspark within Fabric notebooks, including working with Delta tables and handling large or complex datasets
  • Develop and optimize T-SQL code, including stored procedures, views, and transformation logic, to support data processing and reporting needs
  • Apply data modeling best practice, such as medallion architecture and star schema design, to organize data in OneLake for performance and ease of use
  • Monitor pipeline runs, troubleshoot failures, and put alerting and error handling in place so that data is delivered on time and accurately
  • Assess existing on-premises SQL Server databases, SSIS packages, and scheduled jobs to plan their migration to Microsoft Fabric
  • Rebuild or refactor legacy ETL processes as Fabric-native pipelines and PySpark notebooks, improving performance and maintainability
  • Coordinate with the team and stakeholders on migration timelines to minimize disruption to reporting and operations
  • Build and maintain semantic models that serve as the foundation for PowerBI reports, including relationships, measures, ontology, and Direct Lake or Import configurations
  • Partner with report developers and business users to understand reporting requirements and turn them into well-structured datasets
  • Tune data models and queries to improve report performance and refresh reliability
  • Communicate technical concepts, data limitations, and project status clearly to non-technical stakeholders, helping them understand and make effective use of available data
  • Implement data quality checks and validation rules to catch issues before they reach end users
  • Manage workspace organization, access permissions, and security settings in Fabric in line with company data governance standards
  • Use source control (Azure DevOps/Git) and deployment pipelines to manage changes across development, test, and production environments
  • Create and maintain clear documentation of data sources, pipelines, models, dictionaries, and business logic

Qualifications

  • Bachelor's degree from a four-year college or university; minimum two years of related experience and/or training; or an equivalent combination of education and experience
  • Demonstrated ability to design relational and dimensional data models, including fact and dimension tables, keys, relationships, referential integrity, and historical changes
  • Strong T-SQL skills for complex joins, transformations, query tuning, and troubleshooting
  • Hands-on experience building and supporting integrations across databases, APIs, or file-based sources, including scheduling, incremental processing, and recovery
  • Ability to validate data completeness and accuracy, reconcile source and target results, and investigate duplicates and broken relationships
  • Experience using Python or a comparable scripting language for data processing or automation, and version control for maintainable development
  • Ability to translate business requirements into documented models and explain technical decisions clearly; willingness to learn unfamiliar platforms

Preferred

  • Power BI semantic models, Power Query, DAX, or comparable business intelligence tools
  • Microsoft SQL Server, SSIS, SSAS, or comparable database and integration technologies
  • Microsoft Fabric, Azure Data Factory, Azure Data Lake Storage, Azure SQL, Synapse Analytics, Databricks, or Azure DevOps
  • Oil and gas production data, SCADA, telemetry, time-series data, IoT or Streaming data
  • Power BI Semantic Models
  • Azure Data Lake Storage

Required skills

Azure Data FactoryAzure DevOpsData IntegrationData Validation and ReconciliationMicrosoft FabricMicrosoft SQL ServerPower BIPythonSSIST-SQLVersion Control

Full job description

Lewis Energy Group is hiring a Data Engineer II to design, build, and maintain its Microsoft Fabric data platform. The role develops and migrates data pipelines, supports Power BI semantic models, and ensures data quality, governance, and reliable delivery while collaborating with business stakeholders.

Responsibilities

  • Design, build, and maintain data pielines in Microsoft Fabric using Data Factory pipelines, Dataflows Gen2, and notebooks to move data from source systems into Lakehouses and Warehouses
  • Develop data transformation and processing logic in Python and Pyspark within Fabric notebooks, including working with Delta tables and handling large or complex datasets
  • Develop and optimize T-SQL code, including stored procedures, views, and transformation logic, to support data processing and reporting needs
  • Apply data modeling best practice, such as medallion architecture and star schema design, to organize data in OneLake for performance and ease of use
  • Monitor pipeline runs, troubleshoot failures, and put alerting and error handling in place so that data is delivered on time and accurately
  • Assess existing on-premises SQL Server databases, SSIS packages, and scheduled jobs to plan their migration to Microsoft Fabric
  • Rebuild or refactor legacy ETL processes as Fabric-native pipelines and PySpark notebooks, improving performance and maintainability
  • Coordinate with the team and stakeholders on migration timelines to minimize disruption to reporting and operations
  • Build and maintain semantic models that serve as the foundation for PowerBI reports, including relationships, measures, ontology, and Direct Lake or Import configurations
  • Partner with report developers and business users to understand reporting requirements and turn them into well-structured datasets
  • Tune data models and queries to improve report performance and refresh reliability
  • Communicate technical concepts, data limitations, and project status clearly to non-technical stakeholders, helping them understand and make effective use of available data
  • Implement data quality checks and validation rules to catch issues before they reach end users
  • Manage workspace organization, access permissions, and security settings in Fabric in line with company data governance standards
  • Use source control (Azure DevOps/Git) and deployment pipelines to manage changes across development, test, and production environments
  • Create and maintain clear documentation of data sources, pipelines, models, dictionaries, and business logic

Preferred

  • Power BI semantic models, Power Query, DAX, or comparable business intelligence tools
  • Microsoft SQL Server, SSIS, SSAS, or comparable database and integration technologies
  • Microsoft Fabric, Azure Data Factory, Azure Data Lake Storage, Azure SQL, Synapse Analytics, Databricks, or Azure DevOps
  • Oil and gas production data, SCADA, telemetry, time-series data, IoT or Streaming data
  • Power BI Semantic Models
  • Power Query
  • DAX
  • Business Intelligence Tools
  • Microsoft SQL Server
  • SSIS
  • SSAS
  • Database Technologies
  • Data Integration Technologies
  • Microsoft Fabric
  • Azure Data Factory
  • Azure Data Lake Storage
  • Azure SQL
  • Synapse Analytics
  • Databricks
  • Azure DevOps
  • Gas Production Data
  • SCADA
  • Telemetry
  • Time-Series Data
  • IoT Data
  • Streaming Data

Benefits

  • Insurance: Medical/Dental/Vision/Basic Life and AD&D/and other benefit options to meet your personal needs
  • 401K with immediate matching contribution
  • Annual Discretionary Bonus
  • Generous Paid Time Off and Paid Holidays
  • Employee Assistance Program (EAP) – Free, confidential support for you and your dependents
  • Wellness & Company Events throughout the year

Company

  • Vertically integrated natural gas exploration and production company
  • San Antonio, Texas, USA
  • https://www.lewisenergy.com/
  • Founded in 1983
  • 1001-5000 employees

Qualifications

  • Bachelor's degree from a four-year college or university; minimum two years of related experience and/or training; or an equivalent combination of education and experience
  • Demonstrated ability to design relational and dimensional data models, including fact and dimension tables, keys, relationships, referential integrity, and historical changes
  • Strong T-SQL skills for complex joins, transformations, query tuning, and troubleshooting
  • Hands-on experience building and supporting integrations across databases, APIs, or file-based sources, including scheduling, incremental processing, and recovery
  • Ability to validate data completeness and accuracy, reconcile source and target results, and investigate duplicates and broken relationships
  • Experience using Python or a comparable scripting language for data processing or automation, and version control for maintainable development
  • Ability to translate business requirements into documented models and explain technical decisions clearly; willingness to learn unfamiliar platforms
  • Power BI semantic models, Power Query, DAX, or comparable business intelligence tools
  • Microsoft SQL Server, SSIS, SSAS, or comparable database and integration technologies
  • Microsoft Fabric, Azure Data Factory, Azure Data Lake Storage, Azure SQL, Synapse Analytics, Databricks, or Azure DevOps
  • Oil and gas production data, SCADA, telemetry, time-series data, IoT or Streaming data

Required skills

  • Azure Data Factory, Azure DevOps, Data Integration, Data Validation and Reconciliation, Microsoft Fabric, Microsoft SQL Server, Power BI, Python, Relational and Dimensional Data Modeling, SSIS, T-SQL, Version Control

Experience

  • 2+ years

Job details

Employment type

Full-time

Seniority level

2+ years

Date posted

Oct 21, 2026

Work mode

On-site

Job source

internal-lewisenergy.icims.com

Company

Lewis Energy Group

Information Technology & AI

Vertically integrated natural gas exploration and production company

  • San Antonio, Texas, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 1983
  • lewisenergy.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in San Antonio

R1 RCM

Today

New

Software Engineer - Data Platform (R37)

Full-timeOn-siteAustin, TX$120K – $150K/yr

R1 RCM’s R37 AI innovation lab builds technology to transform healthcare, including the Phare OS platform.

Why similarSame rolePythonAustin

The Voleon Group

Today

New

Software Engineer, Data Infrastructure

Full-timeRemoteUnited States$235K – $300K/yr

The Voleon Group is a technology company applying AI and machine learning to finance. The Software Engineer on its Data Infrastructure team builds and scales data infrastructure and tooling, collaborates with teams to improve their use of data, and helps…

Why similarSame rolePythonRemote

Axtria - Ingenious Insights

Today

New

Data Engineer II – Databricks

Full-timeOn-siteChapel Hill, NCCompetitive

Axtria is seeking a Data Engineer II to build and optimize scalable data pipelines for pharmaceutical marketing and customer engagement initiatives.

Why similarSame rolePython

Get new Data Engineer jobs in San Antonio by email

Create job alert

Data Engineer II

Lewis Energy Group · Competitive

Apply on company site