Business Intelligence Analyst

Radiological Society of North America • Oak Brook, IL

6d

About The Position

The Business Intelligence Analyst develops, maintains, and enhances Power BI reports that transform data from relational databases, the enterprise data warehouse, and data marts into reliable business-facing analytics. The role partners with business stakeholders to clarify reporting requirements and carries assignments from requirements gathering through implementation and ongoing support. It includes investigating and transforming data with 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 analyst works with business partners and the Business Intelligence team to resolve data-quality issues and identify reporting data needs. The role documents report logic and definitions and applies sound technical judgment and independent problem-solving to deliver accurate, maintainable reporting solutions. The organization describes itself as a member-focused, mission-driven not-for-profit, with a supportive team, generally reasonable working hours, and a hybrid or fully remote environment. The position also offers opportunities for training and professional development, including Microsoft Fabric and AI-assisted analytics.

Requirements

• Bachelor's degree in computer science, information systems, or a related field, or equivalent experience and certifications.
• At least 3 years of hands-on business intelligence or data analytics experience.
• Strong proficiency writing, reading, and debugging T-SQL queries, views, functions, and stored procedures, including exploring unfamiliar schemas, profiling data, and identifying appropriate source tables.
• At least 3 years of experience building Power BI reports in a production environment, including semantic modeling, DAX measures, and Power Query.
• Ability to gather requirements from non-technical stakeholders, translate them into a technical approach, and independently deliver a complete, validated report on schedule.
• Candidates should be prepared to walk through a report they built using this process.
• Must be authorized to work in the United States without current or future employer-sponsored work authorization; the organization cannot provide employment visa sponsorship.
• Strong verbal and written communication, analytical reasoning, problem-solving, resourcefulness, ownership, troubleshooting, and collaboration skills.

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 semantic models, DAX measures, Power Query transformations, business-appropriate interactive features, and scheduled refreshes.
• 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, troubleshoot issues reported by stakeholders, and update logic as business rules change.
• Document report logic, data definitions, and validation so 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.

Benefits

• Outstanding medical and dental benefits.
• 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.
• Training and professional development, including Microsoft Fabric and AI-assisted analytics.
• Competitive compensation package.
• Hybrid or fully remote work environment and generally no evening or weekend work.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level