Location
75 Iron Point Cir Ste 200, Folsom, CA, 95630-8813, United States

Base Pay
$8,416.00 - $12,203.00 / Month

Other Compensation
Merit and Performance Incentive Pay

Job Category
Data & Analytics, Business Analytics

Relocation Expense Covered
No

Employee Type
Exempt

Manage Others
No

Description
The salary above reflects the entire range for this classification. Starting salary is dependent on experience and may be offered up to the midpoint of the salary range. Any starting salary above the midpoint requires authorization by the PRISM Executive Committee.

We are seeking a Senior Data Engineer to play a central role in our data platform modernization. This is a hands-on technical position focused on migrating our on-premises MS SQL Server environment and Qlik reporting layer into Microsoft Fabric (Fabric Lakehouse, Data Factory, and Data Warehouse) with Power BI as our reporting layer. You will design and build robust data pipelines, establish solid data modeling standards, and help set the engineering foundation that the team will scale on for years to come.

This role also carries mentorship responsibility — you will collaborate with others in the Data & Analytics team, conduct code reviews, and help grow the team's collective capability on the new platform.

Job Responsibilities

Migration & Platform Engineering

Contribute to the technical migration from MS SQL Server (on-prem) and Qlik to Microsoft Fabric and Power BI
Design and implement data pipelines using Fabric Data Factory (pipelines and dataflows) and Fabric Notebooks, leveraging Python and Spark SQL for complex transformations and business logic
Build and maintain Lakehouse architecture on OneLake, including medallion layer design (Bronze / Silver / Gold)
Develop and optimize data models in Fabric Data Warehouse and/or Fabric Lakehouse
Write performant transformation logic using Python, Spark SQL, and T-SQL

Data Modeling & Architecture

Design scalable, maintainable data models aligned to business and reporting needs
Establish and enforce naming conventions, schema standards, and documentation practices
Collaborate with analysts and Power BI developers to ensure the semantic layer is well-structured and performs at scale

DevOps & Engineering Excellence

Own and maintain CI/CD pipelines for data assets using Azure DevOps.
Implement version control practices, testing frameworks, and deployment automation for data pipelines
Design and manage data platform orchestration across pipelines, notebooks, and warehouse workloads — including scheduling, dependency management, alerting, and failure handling
Proactively identify and resolve performance bottlenecks across pipelines, notebooks, SQL code, and overall platform architecture
Participate in architecture discussions and contribute to platform roadmap decisions

Compliance & Data Governance

Ensure all data handling practices comply with regulatory requirements and organizational PII/PHI policies
Implement appropriate data masking, access controls, and audit logging within the platform
Partner with security and compliance teams to maintain data governance standards

Mentorship

Partner with and actively uplift team members who are growing their Fabric skills
Conduct code reviews with constructive, solutions-oriented feedback
Contribute to internal documentation, runbooks, and knowledge sharing
Approach technical challenges with a growth mindset by modeling curiosity, continuous learning, and a bias toward practical, solutions-focused problem solving