Data Engineer II - Microsoft Fabric

About the role

Lewis Energy Group, a vertically integrated exploration and production company and leading natural gas producer in South Texas, is hiring a Data Engineer II in San Antonio. The engineer designs, builds and maintains the company's data platform on Microsoft Fabric, works with business users and stakeholders, and is based onsite at the San Antonio office.

Key responsibilities

• Design, build and maintain data pipelines in Microsoft Fabric using Data Factory, Dataflows Gen2 and PySpark notebooks, moving data into Lakehouses and Warehouses
• Develop transformation logic in Python and PySpark, including Delta tables and large datasets
• Write and optimize T-SQL, including stored procedures, views and transformation logic
• Apply data modeling best practices such as medallion architecture and star schema in OneLake
• Monitor pipelines, troubleshoot failures and set up alerting and error handling
• Migrate on-premises SQL Server databases, SSIS packages and scheduled jobs to Fabric, rebuilding legacy ETL as Fabric-native pipelines and notebooks
• Build and maintain semantic models for Power BI, tune models and queries, and communicate data limitations to non-technical stakeholders
• Implement data quality checks, manage workspace access and security, use Azure DevOps/Git for source control and deployment pipelines, and document sources, pipelines, models and business logic

Required profile

• Bachelor's degree from a four-year college or university, or equivalent combination of education and experience
• Minimum two years of related experience and/or training
• Full-time onsite work in San Antonio
• Ability to translate business requirements into documented models and explain technical decisions clearly

Required skills

• Relational and dimensional data modeling, including fact and dimension tables, keys, relationships and referential integrity
• Strong T-SQL for joins, transformations, query tuning and troubleshooting
• Integration across databases, APIs or file-based sources, including scheduling, incremental processing and recovery
• Data validation, reconciliation and investigation of duplicates and broken relationships
• Python or a comparable scripting language and version control
• Preferred: Power BI, DAX, Power Query, SQL Server, SSIS, SSAS, Azure Data Factory, Azure SQL, Synapse, Databricks, Azure DevOps, and oil and gas data such as SCADA, telemetry or streaming data

What we offer

• Medical, dental, vision, basic life and AD&D insurance and other benefit options
• 401K with immediate matching contribution
• Annual discretionary bonus
• Paid time off and paid holidays
• Employee Assistance Program and wellness events