Sr IT Business Intelligence Engineer

RAYUS now offers DailyPay! Work today, get paid today!

The pay range for this position is $105,000 - $120,000 based on direct and relevant experience.

RAYUS Radiology is looking for a Sr IT Business Intelligence Engineer to join our team. We are challenging the status quo by shining light on radiology and making it a critical first step in diagnosis and proper treatment. Come join us and shine brighter together! As a Sr IT Business Intelligence Engineer, you will be responsible for the development and delivery of Business Intelligence and Data Warehouse solutions including dashboards, scorecards, reports, and associated data structures, using Microsoft Business Intelligence technologies, applications, and tools. This role interfaces with business users to understand their needs and translate them into solutions which deliver business value.

This is a full-time hybrid position working 40 hours per week. Shifts are Monday-Friday.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

(45%) Business Intelligence Solutions

Design and develop data warehouse and reporting solutions utilizing Microsoft Business Intelligence based tools, services and support (SSIS, SSAS, SSRS)

Analyze BI requirements and design/develop reporting solutions to support standard reporting, dashboard and self-service environment

Serve as the subject matter expert on data warehouse architecture, data warehouse, and data mart models

Provide on-going support for operational, corporate and data warehouse team members in relation to existing reports with respect to their definitions and differences

Participate in quality assurance testing and monitor ticketing system

Design, build, and optimize end-to-end data pipelines using Microsoft Fabric components, including Data Factory, Lakehouse, Warehouse, and Notebooks

Manage ingestion of data from cloud, on-premises systems, APIs, and third-party applications

Build semantic models and support reporting solutions using Power BI

Develop notebooks using Python / SQL / Spark

(50%) Data Warehouse

Analyze and design ETL solutions based on data mapping and provide data specifications for integrating new and/or updating data within the data warehouse

Design and develop database objects (databases, tables, stored procedures, views, etc.) to support ETL and data integrations

Write complex SQL queries

Continually review/analyze data loaded into the data warehouse for accuracy and provide solutions for enhancing data accuracy and data processing performance

(5%) Other Duties and Projects as Assigned