Data Engineer - SQL Server - Microsoft Fabric - Power BI

Vernovis is recruiting for an unnamed client seeking a hands-on Data Engineer. The role combines operational support and data engineering, including SQL troubleshooting, ETL development, migration to Microsoft Fabric, data warehousing, and Power BI reporting.

Responsibilities

Develop and maintain data integration workflows using Microsoft SQL Server, SSIS, and Microsoft Fabric, including building ETL packages, transforming data, and automating processes across business systems

Support the organization's transition to Microsoft Fabric, helping migrate existing SQL Server workloads and data pipelines into a modern, cloud-based architecture while reducing reliance on traditional SQL infrastructure

Help design and build an enterprise-wide data warehouse, applying data modeling concepts, star schema architecture, fact and dimension tables, and medallion architecture to organize data for reporting and analytics

Troubleshoot and optimize SQL queries and data processes, identifying performance issues, improving query efficiency, resolving data discrepancies, and ensuring reliable data movement between systems

Develop and support reporting and automation solutions using Microsoft's Power Platform, including Power BI, Power Automate, and potentially Power Apps, while partnering with business teams to streamline manual processes and improve access to meaningful data

Support cloud and data modernization by helping the organization transition from traditional SQL Server environments toward Microsoft Fabric and serverless data solutions while gaining exposure to Python, PySpark, DAX, and potentially application development

Partner with business analysts, accounting, finance, and operational teams to identify key data entities, standardize business definitions, improve data accuracy, and reduce manual reporting processes

Preferred

Experience with medallion architecture (Bronze, Silver, Gold) is a plus

Exposure to Microsoft Fabric, Power Automate, Power Apps, or DAX is preferred

Basic exposure to Python or PySpark is a plus

Medallion Architecture

Microsoft Fabric

Power Automate

Power Apps

DAX

Python

PySpark

Company

Staffing, technology consulting, and business consulting services in the Midwest

Mason, Ohio, USA

https://www.vernovis.com/

Founded in 2009

51-200 employees

Qualifications

Strong experience with Microsoft SQL Server and T-SQL, including writing complex queries, developing stored procedures, troubleshooting failed SQL jobs, optimizing query performance, and resolving data-related issues

Hands-on experience with SSIS and ETL development, including designing, building, and maintaining workflow packages, integrating data from multiple systems, and automating data transformation processes

Solid understanding of data warehousing and data modeling concepts, including star schemas, fact and dimension tables, and structuring data for reporting and analytics

Experience developing reports and dashboards using Power BI and/or SSRS, with an understanding of data visualization, reporting requirements, and working with business stakeholders

Strong troubleshooting, analytical, and problem-solving skills, with the ability to investigate production issues, identify root causes, and implement long-term solutions

Must be collaborative, humble, eager to learn new technologies, and interested in growing with the organization

Applicants must be currently authorized to work in the United States on a full-time basis and not violate any immigration or discrimination laws

Experience with medallion architecture (Bronze, Silver, Gold) is a plus

Exposure to Microsoft Fabric, Power Automate, Power Apps, or DAX is preferred

Basic exposure to Python or PySpark is a plus

Required skills

Microsoft SQL Server, T-SQL, SSIS, ETL Development, Data Warehousing, Data Modeling, Power BI, SSRS, Microsoft Fabric, Power Automate, Python, PySpark

Preferred skills

Basic exposure to Python or PySpark is a plus, Mason, Ohio, USA, https://www.vernovis.com/, Growth Stage, Leadership Team, Bryan Kaiser, Chief Executive Officer and Founder, Recent News, Bizjournals.com Feed (2025-11-12 15:43:17), BizSpotlight: Vernovis, 2026-02-10, Business Journals, 2022-08-05, Company data provided by, AI Tools, Customize Your Resume, Maximize your interview chances, Build Cover Letter, Make your application stand out, Analyze How Well You Fit, Understand your strength & weakness

Experience

Mid level