CSpring

Fabric Engineer

CSpring  •  Indianapolis, IN (Hybrid)  •  5 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

At CSpring, we believe in the power of data to drive decisions and real-world impact. We’re a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results.

We’re seeking talented professionals who are collaborative, curious, and committed to making a difference—people who thrive at the intersection of data, technology, and business strategy. Whether you're passionate about modernizing enterprise data platforms, optimizing complex SQL workloads, or enabling scalable analytics solutions, you'll find meaningful work and purpose here.

Why You'll Love Working Here

Purposeful Projects – Help organizations modernize legacy data systems and unlock scalable, cloud-based analytics capabilities that improve decision-making and operational outcomes.

People-First Culture – We’re as committed to your growth as we are to delivering high-impact solutions. You’ll find support, autonomy, and community here.

Strategic, Hands-On Work – From SQL modernization and Fabric architecture to pipeline migration and reporting continuity, you’ll influence every step of the transformation journey.

Collaborative Trust – Our clients rely on us to guide modernization efforts with technical expertise, integrity, and practical problem-solving.

What You'll Do

CSpring is looking for a Senior Microsoft Fabric Engineer with deep expertise in Azure SQL modernization, Microsoft Fabric, and data engineering. In this role, you will lead the migration of Azure SQL-based workloads into Microsoft Fabric while helping clients modernize data architectures, optimize performance, and support enterprise reporting and analytics needs.

This role is ideal for someone who enjoys solving complex data engineering challenges, modernizing legacy systems, and designing scalable cloud-native solutions across the Microsoft ecosystem.

As a Senior Microsoft Fabric Engineer, you will work closely with architects, DBAs, developers, analysts, and business stakeholders to assess existing SQL workloads, refactor and migrate critical processes, and implement modern Fabric-based data solutions.

Azure SQL Modernization & Stored Procedure Migration

  • Assess existing Azure SQL stored procedures, functions, views, scripts, SQL Agent-style jobs, dependencies, parameters, temp table usage, dynamic SQL, transaction handling, and performance characteristics
  • Refactor and migrate Azure SQL stored procedures into scalable Microsoft Fabric execution patterns, including: 1. Fabric Data Warehouse stored procedures, 2. SQL analytics endpoint queries, 3. Lakehouse and Warehouse ELT processes, 4. Fabric Data Factory pipelines, 5. Dataflows Gen2, 6. Spark notebooks where distributed processing is more appropriate
  • Identify unsupported or inefficient T-SQL patterns and recommend Fabric-native alternatives
  • Re-engineer procedural or cursor-heavy SQL logic into scalable, set-based transformation patterns
  • Create migration playbooks, testing templates, validation frameworks, and code conversion standards
  • Tune migrated SQL workloads for performance, maintainability, and cost efficiency
  • Develop reconciliation and validation processes using row counts, checksums, sample comparisons, business-rule testing, and performance baselines

Microsoft Fabric Engineering & OneLake Architecture

  • Design and implement modern data solutions using OneLake, Lakehouses, Warehouses, Fabric Data Factory, Dataflows Gen2, notebooks, semantic models, and Power BI
  • Build medallion-style architectures using bronze, silver, and gold data layers
  • Leverage OneLake Shortcuts to reduce unnecessary data movement and improve governed data access
  • Develop reusable deployment patterns, operational runbooks, monitoring approaches, and Fabric engineering standards
  • Support hybrid migration environments where Azure SQL, Synapse, ADLS Gen2, Azure Data Factory, and Fabric coexist during transition phases

Azure Data Factory & Synapse Migration

  • Maintain, enhance, and migrate Azure Synapse Analytics and Azure Data Factory workloads
  • Build and support ADF pipelines, linked services, datasets, triggers, integration runtimes, and parameterized orchestration patterns
  • Translate existing Synapse and ADF pipeline logic into Fabric Data Factory pipelines
  • Monitor pipeline execution, troubleshoot failures, optimize data movement, and improve reliability

Power BI Integration & Reporting Continuity

  • Partner with reporting teams to ensure downstream Power BI reports and semantic models continue to function after migration
  • Support transitions from DirectQuery or live-connected datasets toward Direct Lake architectures where appropriate
  • Assist with DAX validation, aggregation strategies, and post-migration report performance tuning

Governance, Documentation & DevOps

  • Collaborate with BAs, architects, engineers, DBAs, and reporting teams to understand and document business logic embedded within SQL workloads
  • Document lineage, source-to-target mappings, dependencies, transformation rules, and migration decisions
  • Apply security, environment management, deployment pipelines, Git integration, CI/CD practices, and release management standards
  • Support production cutover planning, rollback strategies, performance testing, and post-migration stabilization efforts
Requirements

What You Bring

  • 7+ years of hands-on experience with Azure SQL Database, including development, tuning, debugging, and refactoring of complex stored procedures, functions, views, and dynamic SQL
  • Strong experience modernizing and migrating SQL workloads into Microsoft Fabric or comparable cloud data platforms
  • Practical experience with Microsoft Fabric technologies including Fabric Data Warehouse, Lakehouse, OneLake, Fabric Data Factory, Dataflows Gen2, and SQL analytics endpoints
  • Experience designing and supporting Azure Data Factory (ADF) pipelines, orchestration patterns, triggers, monitoring, and error handling
  • Experience with Azure Synapse Analytics, including Synapse SQL, pipelines, and migration strategies
  • Strong understanding of data warehousing concepts, dimensional modeling, incremental loading strategies, ELT/ETL patterns, and data quality validation
  • Experience identifying unsupported or non-portable T-SQL patterns and converting them into scalable cloud-native solutions
  • Strong performance tuning and optimization experience, including query plans, partitioning strategies, and large-volume data processing
  • Working knowledge of Power BI semantic models, Direct Lake, DirectQuery, and downstream reporting impacts during platform migration
  • Familiarity with Git, CI/CD pipelines, deployment automation, and release management practices in Azure or Fabric environments
  • Strong troubleshooting, communication, collaboration, and stakeholder-management skills
  • Bachelor’s degree in computer science, IT, analytics, mathematics, engineering, or a related field

Preferred Qualifications

  • Experience with Fabric Mirroring and low-latency replication strategies into OneLake
  • Familiarity with Fabric Data Agents and conversational AI capabilities across data platforms
  • Exposure to Azure Machine Learning, MLOps, batch scoring, or integration of ML outputs into analytics environments
  • Working knowledge of Spark, PySpark, Delta Lake, Parquet, and lakehouse design patterns
  • Familiarity with Microsoft Purview, including data governance, cataloging, and lineage concepts
  • Prior experience migrating workloads from Azure SQL, Synapse dedicated/serverless pools, or traditional data warehouses into Microsoft Fabric
  • Advanced Power BI experience, including DAX optimization, aggregation strategies, and row-level security redesign
  • Microsoft certifications such as: Microsoft Certified: Fabric Data Engineer Associate (DP-700), Azure Data Engineer Associate, Azure Database Administrator Associate, and/or Power BI Data Analyst Associate

Come Build With Us

At CSpring, we unlock the potential of people and data. If you're ready to help organizations modernize enterprise data platforms, collaborate with passionate teams, and grow your career in a people-first consulting environment—we’d love to hear from you.

CSpring

About CSpring

CSpring delivers the solutions and expertise needed to achieve technology-enabled business goals. Our team of full-time consultants focus on data-driven solutions that align business goals with technology and make information accessible, reliable, and engaging.

We collaborate with our clients to develop technology strategies and roadmaps, architect data solutions, build and integrate software, and create visualizations that ensure technology meets each client’s unique needs.

Since 1996, CSpring has served both public and private sector clients. CSpring is proud to be a certified Woman-owned Business Enterprise (WBE) and a Best Place to Work in Indiana.

Industry
Unknown
Company Size
11-50 employees
Headquarters
Indianapolis, Indiana
Year Founded
1996
Social Media