Sr IT Business Intelligence Engineer

RAYUS Radiology•St. Louis Park, MN

4d•$105,000 - $120,000•Hybrid

About The Position

RAYUS Radiology is hiring a Sr IT Business Intelligence Engineer to develop and deliver Business Intelligence and Data Warehouse solutions, including dashboards, scorecards, reports, and supporting data structures, using Microsoft Business Intelligence technologies, applications, and tools. The role works with business users to understand their needs and translate them into solutions that deliver business value. This is a full-time hybrid position working 40 hours per week, Monday through Friday. The pay range is $105,000–$120,000, based on direct and relevant experience.

Requirements

High school diploma or equivalent.
Bachelor's degree in computer science, information technology, or a similar related, relevant, and applicable field.
Seven years of experience in data warehouse and report development.
Seven years of experience in SQL development and report writing, ETL development with SSIS, data warehouse design, and data integration.
Four years of experience in Azure development for data pipelines and data integrations.
Four years of experience in Power BI.
One year of experience in Microsoft Fabric and Medallion architecture.
Experience with Microsoft Reporting Services or other reporting tools.
Experience with Microsoft Analysis Services and dashboard development.
Experience with Agile methodology software development.
Technical training and educational coursework in data warehouse and report development, design, and administration.

Nice To Haves

Healthcare experience is highly desirable.

Responsibilities

Design and develop data warehouse and reporting solutions using Microsoft Business Intelligence tools, services, and support, including SSIS, SSAS, and SSRS.
Analyze BI requirements and design and develop reporting solutions for standard reporting, dashboards, and self-service environments.
Serve as a subject matter expert on data warehouse architecture, data warehouse models, and data mart models.
Support operational, corporate, and data warehouse team members regarding existing reports, including report definitions and differences.
Participate in quality assurance testing and monitor the ticketing system.
Design, build, and optimize end-to-end data pipelines using Microsoft Fabric components, including Data Factory, Lakehouse, Warehouse, and Notebooks.
Manage data ingestion from cloud and on-premises systems, APIs, and third-party applications.
Build semantic models and support reporting solutions using Power BI.
Develop notebooks using Python, SQL, and Spark.
Analyze and design ETL solutions based on data mapping and provide data specifications for integrating new or updated data into the data warehouse.
Design and develop database objects, including databases, tables, stored procedures, and views, to support ETL and data integrations.
Write complex SQL queries.
Review and analyze data loaded into the data warehouse for accuracy and develop solutions to improve data accuracy and processing performance.
Perform other duties and projects as assigned.