Data Engineer - SQL Server - Microsoft Fabric - Power BI

Job Title:

 Data Engineer – SQL Server / Microsoft Fabric / Power BI

Location

: Onsite

 

Who We Are:

Vernovis is a Total Talent Solutions company that specializes in Technology, Cybersecurity, Finance & Accounting functions. At Vernovis, we help these professionals achieve their career goals, matching them with innovative projects and dynamic direct hire opportunities in Ohio and across the Midwest. 

Come join us:

Vernovis is

looking for a hands-on Data Engineer who enjoys solving problems, building data integrations, and helping an established organization modernize its data environment. This role combines day-to-day operational support with longer-term data engineering and business intelligence initiatives. This person will troubleshoot failed SQL jobs, broken reports, and dashboard issues while identifying root causes and implementing preventative solutions. They will also develop ETL workflows, move and transform data through Microsoft Fabric's medallion architecture, and design Power BI reports that support business decision-making. Our client is working toward an enterprise-wide data warehouse and a more serverless architecture over the next two to three years. The ideal candidate brings a strong SQL and SSIS foundation, understands data modeling, and is excited to grow their skills in Microsoft Fabric, Python, and modern data engineering technologies.

What You'll Do:

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

What You'll Have:

• 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 with medallion architecture (Bronze, Silver, Gold) is a plus.
• Experience developing reports and dashboards using Power BI and/or SSRS, with an understanding of data visualization, reporting requirements, and working with business stakeholders. Exposure to Microsoft Fabric, Power Automate, Power Apps, or DAX is preferred.
• Strong troubleshooting, analytical, and problem-solving skills, with the ability to investigate production issues, identify root causes, and implement long-term solutions. Basic exposure to Python or PySpark is a plus. Must be collaborative, humble, eager to learn new technologies, and interested in growing with the organization.

The Vernovis Difference:

Vernovis does not accept inquiries from Corp to Corp recruiting companies. Applicants must be currently authorized to work in the United States on a full-time basis and not violate any immigration or discrimination laws.

Vernovis provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.