Radiological Society of North America Logo

Radiological Society of North America

Business Intelligence Analyst

Posted 3 Days Ago
Be an Early Applicant
In-Office
Oak Brook, IL, USA
70K-90K Annually
Mid level
In-Office
Oak Brook, IL, USA
70K-90K Annually
Mid level
Develop and maintain Power BI reports and semantic models using T-SQL, DAX, and Power Query. Gather requirements from stakeholders, transform and validate data, troubleshoot reporting discrepancies, optimize performance, document report logic, and deliver reliable business-facing analytics independently.
The summary above was generated by AI

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.

HQ

Radiological Society of North America Oak Brook, Illinois, USA Office

Oak Brook, IL, United States

Similar Jobs

4 Days Ago
In-Office
2 Locations
Junior
Junior
Retail
Analyze logistics and shipping data to produce executive insights, evaluate rates and service standards, develop data models and visualizations, and support strategic improvements across Uline’s freight operations. The role collaborates cross-functionally and uses predictive analytics, AI-enabled tools, and business intelligence to inform decisions and forecast impacts.
Top Skills: Artificial IntelligenceExcelMicrosoft PowerpointMicrosoft WordPredictive AnalyticsSQL
4 Days Ago
Hybrid
Chicago, IL, USA
89K-101K Annually
Senior level
89K-101K Annually
Senior level
Professional Services
Develops and optimizes Power BI dashboards, semantic models, DAX measures, and enterprise reporting for project, financial, and business development performance. Analyzes ERP data, KPIs, revenue, margins, backlog, WIP, forecasting, and client trends. Ensures data integrity, supports automated reporting workflows, performs scenario analysis, and translates findings into actionable insights for executives and cross-functional teams.
Top Skills: Azure Data FactoryDaxDeltek VantagepointErp SystemsExcelPower BIPower QuerySQLSsis
9 Days Ago
Hybrid
Chicago, IL, USA
120K-175K Annually
Senior level
120K-175K Annually
Senior level
Business Intelligence • Consulting
Build and maintain Power BI or Tableau dashboards, write SQL against Snowflake, define KPIs and data models, validate AI-generated analytics, and improve report performance. Partner with finance, sales, operations, and data engineering stakeholders to scope reporting needs, manage dashboard projects, identify data quality issues, and develop semantic-layer definitions. Train business users, create documentation, support self-service analytics, gather feedback, and track dashboard adoption.
Top Skills: DaxDbtFivetranPower BIPower Bi CopilotSnowflakeSnowflake Cortex AnalystSQLTableau

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account