Senior Business Intelligence Engineer

American Academy of Orthopaedic Surgeons (AAOS); Rosemont (IL); Hybrid; USD 110,000 - 120,000; Full time

Job summary

Join a leading organization as a Senior Business Intelligence Engineer, shaping the future of data management. You will tackle complex data challenges, enhance operational efficiency, and drive strategic initiatives through innovative BI solutions across key departments. Your expertise will guide decisions that impact the Academy’s success and member experiences.

Qualifications

• 10+ years of overall IT industry experience.
• 5+ years’ development experience with data visualization tools.
• Strong SQL skills and familiarity with Azure data services.

Responsibilities

• Provide expertise to internal and external stakeholders.
• Create and utilize modeling, analytics, and reporting tools.
• Lead data analysis and generate actionable insights.

Skills

Data visualization

Data analysis

Collaboration

Education

Bachelor's degree in computer science, finance, statistics or math

Master’s degree (preferred)

Tools

Power BI

Azure

SQL Server Reporting Services

Job description

Join to apply for the Senior Business Intelligence Engineer role at American Academy of Orthopaedic Surgeons (AAOS)

6 days ago Be among the first 25 applicants

Join to apply for the Senior Business Intelligence Engineer role at American Academy of Orthopaedic Surgeons (AAOS)

Driven by a passion for turning data into meaningful insights, you thrive on supporting strategic initiatives across the Academy’s Membership, Marketing, Education, and e-Commerce areas. You take pride in building and maintaining scalable BI solutions, seamlessly integrating diverse data sources, and crafting impactful visualizations with tools like Power BI and Azure. Collaborating closely with stakeholders, you contribute to smarter, data-informed decisions that enhance operational efficiency and elevate customer experience. With a strong commitment to continuous improvement and innovation, you bring thoughtful analysis and a collaborative spirit to every challenge.

If this sounds like you, please read on!

The Senior Business Intelligence Engineer will provide quantitative and qualitative subject matter expertise to the Academy’s Membership, Marketing, Education, and e-Commerce customer base, including internal and external business stakeholders, to identify trends and outcomes that lead to decisions improving the business, financial, and customer service experience. This position is responsible for creating, refining, and utilizing a variety of modeling, analytics, and reporting tools to help interpret data and support the decision-making process. The incumbent will serve in a senior leadership role, assisting the Academy in its continuous improvement efforts of academy-wide data systems, including configuring data elements, generating reports, and integrating internal and external data sources. In collaboration with the Data Scientist, the Senior Business Intelligence Engineer will define and standardize data mining and statistical modeling techniques, creating new insights for business stakeholders and establishing scalable, efficient, automated processes for large-scale data analyses.

The Senior Business Intelligence Engineer role involves frequent interaction with senior leaders and executives. Candidates must navigate ambiguity, excel in a fast-paced environment, continuously improve technical skills, pay attention to detail, and collaborate with customers to translate business problems into requirements and deliverables.

Functions as the BI subject matter expert for platform development and administration, under direction of management. Ensure that the Academy is harvesting and maximizing knowledge and insights gained from analysis of transactional and historical data repositories. Acquires a deep understanding of the business questions or problems and proactively translate them into appropriate mathematical representations providing analysis for strategic priorities. Identifies and presents actionable patterns in data, and research data trends that will positively influence organizational decisions regarding industry and market changes thereby informing future product planning strategies.

Leads data analysis, identifies patterns, and generates actionable insights. Utilizes complex programs for data mining, trend searching, and data extraction from various sources. Collaborates with business stakeholders to analyze data using advanced models and statistics. Designs, builds, and maintains scalable BI solutions with Power BI and other visualization tools. Creates semantic data models and data marts for self-service analytics.

Develops standardized methods for database design and validation reports. Gathers data for a centralized warehouse with application analysis and data modeling. Extracts, interprets, and presents large volumes of data in clear charts and tables. Conducts business and financial analyses, providing accurate trends focused on actionable outcomes. Works independently with stakeholders to define analyses, develop complex models, and communicate findings effectively.

Develops and improves the Academy's analytics platform, manage BI environment health and cloud services. Performs capacity planning, enhances reporting models, schedules data refreshes, and monitors usage. Documents feasibility assessments, evaluates data gaps, and communicates with teams about data analysis and quality tasks. Establishes processes for security, monitoring, development, adheres to data management standards, and assists in creating prototypes as needed.

Integrates AI capabilities into BI solutions for enhanced data insights and automation. Builds and maintains AI-powered visualizations that leverage natural language generation, forecasting, or key influencer analysis to support executive decision-making. Collaborates with Data Scientists and ML Engineers to embed machine learning model outputs into Power BI reports and dashboards. Promotes best practices around analytical modeling techniques and data visualization

Exemplifies The Following Essential Values Of The Academy

• Teamwork: Effective collaboration and team-focus to solve complex problems and drive innovation.
• Empowerment: The authority, information, and skills to make decisions and drive results.
• Accountability: Ownership of process and results that drive decisions and ensure implementation.
• Mindset of Growth/Continuous Learning: Focused on and invested in self and staff development to become more adaptable, making the Academy more agile, innovative, and sustainable.
  
  

Travel

• Up to 5 days per year
  
  

Qualifications

Required:

• Bachelor's degree in computer science, finance, statistics or math required, master’s degree preferred.
• 10+ years of overall IT industry experience relevant to this position
• 5+ years’ development experience with data visualization tools, including PowerBI desktop, services, embedded, and architecture
• Demonstrated experience with Azure Analysis Services, Azure Analysis Services Tabular Models and SQL Server Reporting Services
• Strong experience with Microsoft Fabric, including Data Pipelines and Dataflows Gen2
• Solid understanding and implementation experience of Medallion Architecture
• Expertise in designing and implementing Star and Snowflake schema data models
• Strong understanding of Power Platform tools and Machine Learning Concepts
• Strong SQL skills and familiarity with Azure data services (e.g., Data Lake, Data Mart, Azure SQL)
• Experience with CI/CD processes and version control in Power BI development environments
• Experience with Power BI Copilot, Azure Cognitive Services, or Azure Machine Learning.
• Experience with AI-powered visualizations that leverage natural language generation, forecasting, or key influencer analysis.
• Demonstrated expertise in user-centered design to deliver intuitive and effective self-service BI solutions that enhance user adoption and engagement.
• Extensive experience in publishing and managing enterprise BI reports and applications, ensuring scalability, accessibility, and security compliance.
• Strong foundation in statistical concepts such as probability and inference, with the ability to support predictive analytics and advanced insights.
• Collaborative and solution-oriented mindset, contributing to a positive and innovative team culture that supports agile and creative development.
• Expert proficiency in Microsoft Office tools (Word, Excel, PowerPoint, Visio)
• Excellent verbal, written and interpersonal communication skills
• Self-starter, multi-tasker, comfortable in fast paced environment
• Strong Communication and stakeholder management skills
  
  

Desired

• Experience implementing AI and ML initiatives
• Knowledge of data governance, data cataloging, and metadata management.
• Exposure to scripting languages (e.g., Python) for data transformation and analysis.
• Experience with Association Management Systems a plus
• Microsoft certifications in Power BI or Fabric
• Experience with large-scale BI environments or enterprise-level reporting infrastructures
• Familiarity with HIPAA/HITECH regulatory requirements for Information Security & Data Privacy
  
  

Salary Range: $110,000-$120,000, depending on qualifications and experience.

Join us and help shape the future by turning data into actionable insights, enhancing operational efficiencies, elevating our members’ experience, while shaping AAOS’ success!

If this resonates with you, apply today by sharing the following:

• -Clearly communicate why you are the ideal candidate for this role, providing specific examples and experiences as proof points.
• -Resumes must be accompanied by a cover letter with salary expectations to be considered.
• Please note:
• This hybrid position is based in Rosemont, Illinois and is open to applicants who are able to commute bi-weekly to this office.
• Applicants must already be authorized to work in the United States on a full-time basis. We are unable to sponsor or take over sponsorship of work visas.
  
  

JOB CODE: 1000132

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  Non-profit Organizations

Referrals increase your chances of interviewing at American Academy of Orthopaedic Surgeons (AAOS) by 2x

Sign in to set job alerts for “Business Intelligence Engineer” roles.

Chicago, IL $100,000.00-$167,500.00 6 days ago

Business Intelligence Analyst, Global Affairs

Chicago, IL $117,000.00-$167,000.00 1 day ago

Business Intelligence Developer (BI Developer)

Chicago, IL $100,000.00-$130,000.00 4 days ago

Deerfield, IL $98,600.00-$157,500.00 6 days ago

Deerfield, IL $98,600.00-$157,500.00 6 days ago

Glenview, IL $80,000.00-$120,000.00 16 hours ago

Deerfield, IL $98,600.00-$157,500.00 6 days ago

Chicago, IL $125,000.00-$150,000.00 1 week ago

Healthcare Business Intelligence Developer

Chicago, IL $125,000.00-$163,000.00 2 weeks ago

Deerfield, IL $98,600.00-$157,500.00 2 months ago

Business Intelligence Developer - Perm only #966391

Chicago, IL $130,000.00-$170,000.00 1 week ago

Bedford Park, IL $109,200.00-$160,871.00 1 week ago

Chicago, IL $99,600.00-$139,440.00 1 week ago

Chicago, IL $145,000.00-$165,000.00 1 week ago

Chicago, IL $100,000.00-$150,000.00 1 week ago

Chicago, IL $112,597.33-$152,810.66 1 month ago

Chicago, IL $95,000.00-$215,000.00 1 week ago

Chicago, IL $124,000.00-$178,000.00 2 weeks ago

Senior Business Intelligence Analyst, Global Affairs

Chicago, IL $141,000.00-$207,000.00 1 day ago

Software Engineer (Python), Data Platform

Chicago, IL $165,000.00-$195,000.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.