Job description

Data Engineer Must be in Central MN and have reasonable commute to St. Cloud, MN due to in-office requirements. SCHEDULE: Full-Time, Monday-Friday, 8:00am-5:00pm COMPENSATION: Starting Pay $82,000 – $102,500 per year. (The estimated range is the budgeted amount for this position. Final offers are based on various factors, including skill set, experience, location, qualifications and other job-related reasons.) WHO WILL SHINE IN THIS ROLE Are you looking for an opportunity to build modern data solutions , work with Microsoft Fabric , and make an impact with enterprise data ? PCI is seeking an MS Fabric Data Engineer who is analytical, collaborative, and passionate about data engineering . You'll design and optimize data pipelines , build Medallion (Bronze/Silver/Gold) architecture , and support our migration from SQL Server to Microsoft Fabric . This is an exciting opportunity to work with Microsoft Fabric, PySpark, dbt, and Power BI , solve complex data challenges , and grow your expertise in cloud data engineering and emerging technologies . WHAT YOU’LL DO • Design and build ingestion pipelines from on-premises SQL Server and other source systems into Fabric using Mirroring, Copy Activity/Data Factory pipelines, and Fabric Notebooks. • Develop and maintain medallion architecture (Bronze, Silver, Gold) transformations using PySpark notebooks and dbt (Data Build Tool). • Implement schema evolution handling, watermark-based incremental loads, and data quality checks (row count drift, freshness, referential integrity) across pipeline layers. • Available for off-hours support as needed to address data pipeline failures or critical issues impacting production data systems. • Translate existing on-premises stored procedures and ETL logic into Fabric-native pipelines and dbt models as part of the SQL Server-to-Fabric migration. • Identify and remediate data pipeline failures, performance bottlenecks, and capacity constraints within Fabric capacity limits. WHAT WE’RE LOOKING FOR Must-Have Qualifications: • BS in Computer Science or equivalent program or equivalent experience • 3-4 years of overall data engineering experience, with 1-2 years (minimum) of hands-on experience in Microsoft Fabric • Proficiency in PySpark and/or Python for data transformation and pipeline development • Strong T-SQL skills and understanding of relational database and dimensional modeling concepts Nice to have but not Required! • Experience with DBT (Data Build Tool) • Exposure to MS Azure resources (e.g.-Functions, Eventhub etc.) • Experience with Power BI including semantic layer models • Familiarity with Azure DevOps, Git-based version control, and CI/CD pipelines LOCATION & WORK SETTING • Office Address: 628 Roosevelt Rd, St. Cloud, MN, 56301 • Schedule: Full-Time, Monday–Friday 8:00am-5:00pm CST • Work Setting: Hybrid COMPETITIVE COMPENSATION & BENEFITS • Starting Pay: $82,000 – $102,500 per year. • The estimated range is the budgeted amount for this position. Final offers are based on various factors, including skill set, experience, location, qualifications and other job-related reasons. PCI offers competitive and comprehensive benefits including medical, dental, vision, short-term disability, long-term disability, and voluntary benefits. Additional Perks that Go the Extra Mile: • Annual Discretionary Bonus • Earned Safe & Sick Time (ESST) • Paid Maternity & Paternity Leave • Paid Time Off (PTO) & 8 Paid Holidays • Donation Matching & Paid Volunteer Time • 401(k) Match – 100% of your deferrals up to 5% • Tuition Reimbursement & Student Loan Match Program HOW TO APPLY It only takes a couple minutes ! Submit your resume on our website at preferredcredit.com/careers . EQUAL EMPLOYMENT OPPORTUNITY PCI is an equal employment opportunity employer committed to diversity, equity, & inclusion. We make hiring decisions based on qualifications, merit, and business needs. If you need assistance or an accommodation due to disability, please contact PCI HR at PeopleOps@preferredcredit.com.

Requirements

Must-haves

Data Engineer
Must be in Central MN and have reasonable commute to St. Cloud, MN due to in-office requirements.
SCHEDULE: Full-Time, Monday-Friday, 8:00am-5:00pm
This is an exciting opportunity to work with Microsoft Fabric, PySpark, dbt, and Power BI , solve complex data challenges , and grow your expertise in cloud data engineering and emerging technologies .
Design and build ingestion pipelines from on-premises SQL Server and other source systems into Fabric using Mirroring, Copy Activity/Data Factory pipelines, and Fabric Notebooks.
Develop and maintain medallion architecture (Bronze, Silver, Gold) transformations using PySpark notebooks and dbt (Data Build Tool).
Implement schema evolution handling, watermark-based incremental loads, and data quality checks (row count drift, freshness, referential integrity) across pipeline layers.
Available for off-hours support as needed to address data pipeline failures or critical issues impacting production data systems.
Translate existing on-premises stored procedures and ETL logic into Fabric-native pipelines and dbt models as part of the SQL Server-to-Fabric migration.
Identify and remediate data pipeline failures, performance bottlenecks, and capacity constraints within Fabric capacity limits.
BS in Computer Science or equivalent program or equivalent experience
3-4 years of overall data engineering experience, with 1-2 years (minimum) of hands-on experience in Microsoft Fabric
Proficiency in PySpark and/or Python for data transformation and pipeline development
Strong T-SQL skills and understanding of relational database and dimensional modeling concepts
Experience with DBT (Data Build Tool)
Exposure to MS Azure resources (e.g.-Functions, Eventhub etc.)
Experience with Power BI including semantic layer models
Familiarity with Azure DevOps, Git-based version control, and CI/CD pipelines
Office Address: 628 Roosevelt Rd, St. Cloud, MN, 56301
Schedule: Full-Time, Monday–Friday 8:00am-5:00pm CST
Work Setting: Hybrid
Starting Pay: $82,000 – $102,500 per year.

Nice-to-haves

Nice to have but not Required!
Annual Discretionary Bonus

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonazureci/cdgo

Platform: ukg
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Pto

Paid Time Off