Data Engineer - SQL Server - Microsoft Fabric - Power BI

About the role

Vernovis is a Total Talent Solutions company that specializes in Technology, Cybersecurity, Finance & Accounting functions. They help professionals achieve career goals, matching them with innovative projects and dynamic direct hire opportunities in Ohio and across the Midwest. 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. The 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. The client is working toward an enterprise-wide data warehouse and a more serverless architecture over the next two to three years.

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.

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 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.
• Applicants must be currently authorized to work in the United States on a full-time basis and not violate any immigration or discrimination laws.