Data Engineer

Maas Energy Works, Inc.; Redding (CA); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Three weeks vacation

Paid sick time

Holiday pay

Flexible holidays

ICHRA Health Insurance Reimbursement

Dental & Vision Insurance

Life Insurance

Clinic Membership for employees

401(k) with company matching

Profit sharing

Job summary

Maas Energy Works, Inc. seeks a Data Engineer to own the operational backbone of the data platform, including SQL Server on Azure and the Fabric data warehouse that feeds reporting and internal apps.

The data is high-frequency time-series from 100+ projects, so reliability, completeness, and monitoring matter as much as building new things. This hands-on role sits on a small team actively modernizing its platform.

Qualifications

• 3+ years of professional experience with SQL Server and T-SQL, including set-based query design, stored procedures, execution-plan tuning, and indexing.
• Hands-on database administration in production: backup and recovery, SQL Agent, maintenance jobs, logins and role-based security, and capacity monitoring.
• Experience building and operating production ETL/ELT pipelines (Azure Data Factory, Synapse pipelines, Fabric Data Factory, or SSIS), including incremental loads, failure handling, and reruns.
• Working knowledge of dimensional modeling: facts, dimensions, grain, and slowly changing dimensions.
• Hands-on Microsoft Fabric experience: Warehouse and Lakehouse, Data Factory pipelines, Dataflow Gen2, notebooks, and capacity monitoring.
• Familiarity with Azure fundamentals: resource organization, networking basics, managed identities, and Key Vault.
• Experience implementing data quality checks, monitoring, or alerting production data.
• Proficiency with Git.
• A track record of learning new tools and platforms independently and applying them to real work.
• Python, and C# programming languages
• Spark framework

Responsibilities

• Administer the SQL Server environment in Azure: backups and restore testing, SQL Agent jobs, index and statistics maintenance, security and access, storage growth, and performance tuning.
• Monitor continuous data ingestion from 100+ projects and resolve gaps, delays, duplicates, and out-of-range values before they reach downstream reporting.
• Build, maintain, and troubleshoot pipelines that move data from staging and external REST APIs into the Fabric data warehouse.
• Maintain and extend the warehouse's dimensional models, data quality rules, and load performance.
• Build alerting for pipeline failures, data freshness, and completeness, and own the response when they fire.
• Contribute to the migration of remaining workloads from Azure Synapse to Microsoft Fabric.
• Support analysts and application developers who consume warehouse data through Power BI semantic models and internal applications.
• Write and maintain runbooks and technical documentation, and work in Git with code review and CI/CD deployment.

Skills

SQL Server

T-SQL

ETL/ELT pipelines

Dimensional modeling

Microsoft Fabric

Azure Data Factory

Synapse

Fabric Data Factory

SSIS

Git

Python

C#

Spark

Tools

Azure Data Factory

Synapse

Fabric Data Factory

SSIS

Power BI

Job description

Position Title: Data Engineer

Department: Information Technology

Reports to: Data Team Manager

Compensation: $100,000 - $130,000

Hours: Full-time, Monday - Friday, 8:30am - 5:00pm, with flexibility as business and project needs require.

Benefits

• Three weeks of paid vacation
• Paid sick time
• Eight and a half paid holidays per year
• Two paid flexible holidays per year
• ICHRA Health Insurance Reimbursement
• 100% Employer Paid Dental and Vision Insurance
• 100% Employer Paid Life Insurance
• 100% Employer Paid Medical Clinic Membership or Cash Equivalent for employees and dependents
• Other benefits accrue over the first 3-24 months, including additional paid vacation, 401(k) with company matching, and quarterly profit share.

Place of Work: Corporate Headquarters - 1730 South Street, Redding CA, 96001

Company Overview

Maas Energy Works is the leading developer and operator of agricultural waste-to-energy systems in the United States. The Company designs, develops, constructs, and operates biogas renewable energy generation systems, primarily on dairy farms. Our projects include anaerobic digesters, biogas-powered electric generation, and renewable natural gas upgrading.

Position Description

We are hiring a Data Engineer to own the operational backbone of our data platform: SQL Servers, the pipelines that move data out of it, and the Microsoft Fabric data warehouse that feeds reporting, regulatory work, and internal applications. The data is high-frequency time-series and operational data from more than 100 projects, so reliability, completeness, and monitoring matter as much as building new things.

This is a hands-on role on a small team that is actively modernizing its platform. We want someone who learns new tools on their own initiative, takes ownership of production systems, and wants to grow with the platform.

Essential Responsibilities

• Administer the SQL Server environment in Azure: backups and restore testing, SQL Agent jobs, index and statistics maintenance, security and access, storage growth, and performance tuning.
• Monitor continuous data ingestion from 100+ projects and resolve gaps, delays, duplicates, and out-of-range values before they reach downstream reporting.
• Build, maintain, and troubleshoot pipelines that move data from staging and external REST APIs into the Fabric data warehouse.
• Maintain and extend the warehouse's dimensional models, data quality rules, and load performance.
• Build alerting for pipeline failures, data freshness, and completeness, and own the response when they fire.
• Contribute to the migration of remaining workloads from Azure Synapse to Microsoft Fabric.
• Support analysts and application developers who consume warehouse data through Power BI semantic models and internal applications.
• Write and maintain runbooks and technical documentation, and work in Git with code review and CI/CD deployment.

Required Qualifications

• 3+ years of professional experience with SQL Server and T-SQL, including set-based query design, stored procedures, execution-plan tuning, and indexing.
• Hands-on database administration in production: backup and recovery, SQL Agent, maintenance jobs, logins and role-based security, and capacity monitoring.
• Experience building and operating production ETL/ELT pipelines (Azure Data Factory, Synapse pipelines, Fabric Data Factory, or SSIS), including incremental loads, failure handling, and reruns.
• Working knowledge of dimensional modeling: facts, dimensions, grain, and slowly changing dimensions.
• Hands-on Microsoft Fabric experience: Warehouse and Lakehouse, Data Factory pipelines, Dataflow Gen2, notebooks, and capacity monitoring.
• Familiarity with Azure fundamentals: resource organization, networking basics, managed identities, and Key Vault.
• Experience implementing data quality checks, monitoring, or alerting production data.
• Proficiency with Git.
• A track record of learning new tools and platforms independently and applying them to real work.
• Python, and C# programming languages
• Spark framework

Preferred Qualifications

• Experience with Power BI semantic models
• Experience with high-volume time-series, IoT, or industrial operations data.
• Microsoft certification DP-600 (Fabric Analytics Engineer) or DP-700 (Fabric Data Engineer).

Other Duties

Please note this job description is not designed to cover or contain a comprehensive list of activities, duties, or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Physical Demand Requirements

Work Environment - Office Staff

This role operates primarily in a professional office environment and uses computers, cloud platforms, databases, development tools, and communication systems. Limited travel to company offices or project locations may be required.

Physical Demands - Office Staff

This is largely a sedentary role requiring extended computer work, regular communication, and the ability to manage multiple technical priorities. The position may occasionally require travel in vehicles or airplanes and access to company operating locations.