Sr IT Business Intelligence Engineer
RAYUS Radiology · St. Louis Park, Minnesota, United States · $105K–$120K/yr
Hospitals and Health Care · 1,001-5,000 employees
About the role
The Sr IT Business Intelligence Engineer will design and develop data warehouse and reporting solutions using Microsoft BI tools to support business needs. This role involves building end-to-end data pipelines, managing data ingestion, and optimizing database performance through complex SQL queries.
What they look for
Requirements
Candidates must have a bachelor's degree and at least seven years of experience in data warehouse and report development. Proficiency in SQL, ETL development, SSIS, and Azure data pipelines is required, with experience in Microsoft Fabric and Power BI.
Benefits
Full description
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 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
Qualifications
Required:
- High School Diploma, or equivalent
- Bachelor's degree in computer science, information technology, or a similar related, relevant and applicable field
- Seven (7) years' experience in data warehouse and report development
- Seven (7) years' experience in SQL development and report writing, ETL development with SSIS experience, data warehouse design and data integration
- Four (4) years' experience in Azure development for data pipelines and data integrations
- Four (4) years' experience in Power BI
- One (1) year experience in Microsoft Fabric and Medallion architecture
- Experience in Microsoft Reporting Services or other reporting tools
- Experience in Microsoft Analysis Services and Dashboards development
- Experience in Agile methodology software development
- Technical training and educational coursework in data warehouse and report development, design and administration
Preferred:
- Healthcare experience is highly desirable
RAYUS is committed to delivering clinical excellence in communities across the U.S., driven by our passion for and superior service to referring providers and patients. RAYUS Radiology is built on our brilliant medicine, brilliant team, brilliant technology and services - all to provide the highest level of patient care possible.
We bring brilliance to health and wellness. Join our team and shine the light on Radiology Services! RAYUS Radiology is an EO Employer/Vets/Disabled.
We offer benefits (based on eligibility) including medical, dental and vision insurance, 401k with company match, life and disability insurance, tuition reimbursement, adoption assistance, pet insurance, PTO and holiday pay and many more! Visit our career page to see them all www.rayusradiology.com/careers.
DailyPay implementation is contingent upon initial set-up period.
