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
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.
