Business Intelligence Analyst

Radiological Society of North America; Oak Brook (IL); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Radiological Society of North America, Inc. is seeking a Business Intelligence Analyst to develop, maintain, and optimize Power BI reports that transform data from relational databases, the enterprise data warehouse, and data marts into reliable, business-facing analytics.

You will partner with business stakeholders to clarify reporting requirements, manage end-to-end reporting, ensure data quality, and deliver scalable, maintainable insights in a hybrid/remote work environment.

Qualifications

• Bachelor's degree in computer science, information systems, or a related field, or equivalent experience and certifications.
• 3+ years of hands-on experience in business intelligence or data analytics with strong proficiency in T-SQL, including the ability to explore an unfamiliar schema, profile data, and identify the right source tables.
• 3+ years building Power BI reports in a production environment, including semantic modeling, DAX measures, and Power Query.
• Demonstrated ability to gather requirements from non-technical stakeholders, translate them into a technical approach, and deliver a complete, validated report independently and on schedule.

Responsibilities

• Write, optimize, and maintain T-SQL queries, views, functions, and stored procedures for reporting.
• Design, build, and publish Power BI reports including semantic model, DAX measures, Power Query transformations, and scheduled refresh.
• Meet with business stakeholders to gather requirements and determine the T-SQL and Power BI approach.
• Validate report output against source data and resolve discrepancies before release.
• Document report logic, data definitions, and validation for maintainability.
• Identify trends and relationships across data sources to translate findings into business insights.
• Perform other duties as assigned.

Job description

Job Description

Job Description

The Business Intelligence Analyst develops, maintains, and enhances Power BI reports that turn data from relational databases, the enterprise data warehouse, and data marts into reliable, business-facing analytics. You will partner with business stakeholders to clarify reporting requirements and take assignments from requirements through implementation and ongoing support. Responsibilities include investigating and transforming data using T-SQL and Power Query, developing Power BI semantic models and DAX measures, building interactive reports, optimizing performance, and validating results against source data and business requirements before release.

The ideal candidate has strong T-SQL and DAX skills and experience working with complex datasets and data relationships. You will work with the business and the Business Intelligence team to resolve data quality issues and identify reporting data needs, document report logic and definitions, and apply sound technical judgment and independent problem-solving skills to deliver accurate, maintainable reporting solutions.

This job might be for you if you're interested in:

• Working at a member-focused, mission-driven, not-for-profit organization.
• Joining a welcoming and supportive environment where you can make an impact on patient care.
• Enjoying excellent work-life balance, reasonable working hours, and generally no evening or weekend work in a hybrid or fully remote environment.
• Receiving a competitive compensation package that includes outstanding medical and dental benefits, an employer-funded 403(b) retirement contribution of 10 to 15 percent of salary after one year of service, generous time off including a week-long Winter Break, paid parental leave, and more.
• Expanding your skills through training and professional development, including Microsoft Fabric and AI-assisted analytics.
• Joining a team with longstanding tenure at RSNA, a culture of continuous improvement, a strong sense of teamwork, and a fabulous sense of humor.
• Solving a variety of challenges in your day-to-day work.

Responsibilities

• Write, optimize, and maintain T-SQL queries, views, functions, and stored procedures to extract, transform, and aggregate data for reporting.
• Design, build, and publish Power BI reports, including the semantic model, DAX measures, Power Query transformations, interactive features appropriate to the business need, and scheduled refresh.
• Meet with business stakeholders to gather and clarify requirements, identify appropriate data sources, and determine the T-SQL and Power BI approach.
• Validate report output against source data and resolve discrepancies before release.
• Support and enhance existing reports, including troubleshooting issues reported by stakeholders and updating logic as business rules change.
• Document report logic, data definitions, and validation so that others can maintain the work.
• Identify trends and relationships across data sources and translate findings into business insights for stakeholders.
• Perform other duties as assigned.

Core Competencies

• Analytical reasoning and problem-solving: Investigates unfamiliar data, tests assumptions, evaluates potential approaches, and develops solutions without relying on step-by-step direction.
• Resourcefulness and ownership: Moves work forward independently, recognizes when additional information is needed, asks focused questions, and follows through to completion.
• Creative report development: Translates business needs into clear, practical, and user-friendly reporting solutions.
• Troubleshooting: Traces report results through T-SQL queries, Power Query transformations, model relationships, and DAX calculations to identify and resolve discrepancies.
• Communication and collaboration: Demonstrates strong verbal and written communication skills, clearly explains technical decisions, raises questions and concerns promptly, and incorporates feedback from peer reviews and QA.

Requirements

• Bachelor's degree in computer science, information systems, or a related field, or equivalent experience and certifications.
• 3+ years of hands-on experience in business intelligence or data analytics with strong proficiency in writing, reading, and debugging T-SQL queries, views, functions, and stored procedures, including the ability to explore an unfamiliar schema, profile data, and identify the right source tables.
• 3+ years building Power BI reports in a production environment, including semantic modeling, DAX measures, and Power Query.
• Demonstrated ability to gather requirements from non-technical stakeholders, translate them into a technical approach, and deliver a complete, validated report independently and on schedule. Candidates should be prepared to walk through a report they built this way.

The organization is unable to provide employment visa sponsorship for this position. Applicants must be authorized to work in the United States without the need for current or future employer-sponsored work authorization. This includes, but is not limited to, employer-sponsored H-1B, H-1B1, E-3, TN, O-1, L-1, and other employment-based visa classifications, as well as employer-sponsored extensions, changes of status, or transfers where applicable.

The Radiological Society of North America is an equal opportunity employer and prohibits discrimination and harassment of any kind. RSNA is committed to hiring and employing qualified people without regard to race, color, religion, sex, marital status, national origin, age, disability, veteran status, citizenship status, genetic information, sexual orientation, unfavorable military discharge, ancestry, order of protection status, pregnancy, or any other legally protected characteristic. All employment decisions at RSNA are based on business needs, job requirements, and individual qualifications.