Data Engineer

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

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

Pulled from the full job description

• Tuition reimbursement
• Paid parental leave
• Parental leave
• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance, 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.), * 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