Intellias logo
Intellias Verified
IT Services, Software Development, Consulting, Digital Transformation

Senior Data Engineer

Minneapolis, Minnesota, United StatesOnsiteFull TimeSeniorPosted 2 months agoVisa sponsorship available

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

Intellias is seeking a Senior Data Engineer to lead the transformation of their data platform from a legacy Microsoft SQL Server environment to a modern Microsoft Fabric-based architecture. This hands-on role involves building scalable data pipelines, implementing Lakehouse architecture, and optimizing data processing with Spark and SQL. The ideal candidate will have 5+ years of data engineering experience, strong T-SQL and PySpark skills, and a solid understanding of data modeling and distributed data processing. Responsibilities include designing, building, and maintaining pipelines, migrating legacy systems, implementing Lakehouse layers, and ensuring data quality and performance.

Let’s breathe life into great tech ideas! With 3 000 people globally, Intellias is a company where benchmark technological solutions are born. Join in and take your part in digitalizing the world.

We are looking for a highly skilled Senior Data Engineer to support and execute the transformation of our data platform from a legacy Microsoft SQL Server-based environment to a modern architecture built on Microsoft Fabric.

This role is hands-on and focuses on building scalable data pipelines, implementing Lakehouse architecture, and enabling efficient data processing using Spark and SQL technologies.

Requirements:

- 5+ years of experience in Data Engineering
- Strong experience with Microsoft SQL Server,
T-SQL
, Stored Procedures, UDFs, data modeling
- Hands-on experience with PySpark, Spark, SQL, distributed data processing
- Experience building ETL/ELT pipelines in modern data platforms
- Familiarity with Microsoft Fabric or similar platforms (Databricks, Snowflake, Azure Synapse)
- Experience working with large datasets (Big Data processing)
- Solid understanding of data modeling concepts (dimensional modeling, star schema)
- Experience with notebook-based development environments
- Experience with Microsoft Fabric (Lakehouse, Warehouse, OneLake)

Will be a plus:

  • Experience migrating legacy systems to cloud data platforms
  • Familiarity with C#-based data integrations
  • Experience with real-time or streaming data pipelines
  • Knowledge of data governance and data quality frameworks
  • Experience with CI/CD for data pipelines

Responsibilities:

- Design, build, and maintain scalable data pipelines within Microsoft Fabric
- Execute migration from Microsoft SQL Server (T-SQL, Stored Procedures, UDFs, Triggers, Constraints, C# integrations) to Fabric
- Implement and support
Lakehouse architecture (Bronze / Silver / Gold layers)
:
- Ingest raw data into
Bronze layer
using PySpark and Spark SQL
- Develop transformation logic using PySpark and notebook-based workflows
- Build refined datasets in
Silver layer
using T-SQL, UDFs, and Stored Procedures
- Deliver business-ready data models in
Gold layer
- Convert legacy SQL Server logic (Stored Procedures, UDFs) into scalable ELT pipelines
- Develop and optimize
Spark jobs (PySpark, Spark SQL)
for large-scale data processing
- Work with T-SQL notebooks and Warehouse layers for structured analytics
- Ensure data quality, consistency, and reliability across pipelines
- Optimize performance and cost of data workloads
- Collaborate with Data Architects, Analysts, and BI teams to deliver high-quality datasets
- Participate in code reviews and enforce best practices in data engineering
- Monitor and troubleshoot data pipelines and production issues

At Intellias, where technology takes center stage, people always come before processes. We're dedicated to cultivating a tech-savvy environment that empowers individuals to unlock their true potential and achieve extraordinary results. Our customized benefits not only prioritize your well-being but also charge your professional growth, making this opportunity an ideal match for tech enthusiasts like you.

Ready to apply?
You'll be redirected to Intellias's application page.

Similar roles