Data Engineer — Modern Data Platform & Pipelines

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

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.