Senior Business Intelligence Developer/Analyst

Apply for this Position

Application Form     (* indicates required field)

Please attach the following files

Please upload either a word or PDF version of your cover letter for this position.
Please upload either a word or PDF version of your current resume.
Such as letters of recommendation, work examples, etc.

I certify that all the information submitted by me is true and complete, and I understand that if any false information, omissions, or misrepresentations are discovered, my candidacy may be rejected and, if I am employed, my employment may be terminated at any time. I authorize the American Academy of Orthopaedic Surgeons (AAOS) to conduct employment reference checks. I understand that I may request that AAOS share with me the nature and substance, but not the source of the information so provided.

You must agree to the disclosure statement provided in order for us to accept your application.

You will receive confirmation after we have received your application.

You are a natural seeker of collaboration. You are eager to harvest and maximize knowledge and insights gained from the analysis of transactional and historical data, knowing it will make a difference in a world class organization. You go above and beyond in all that you do. You are both influential and a thought leader who can push boundaries and concepts with tact. You use new ideas to leverage creativity in the organization. Your knowledge of big data, business intelligence and analytics is remarkable. You know enterprise data systems, data warehousing, relational databases and related technological platforms like no other. You are qualitative and quantitative, driven, efficient, and thrive in transformation.  

If this sounds like you, read on:

The Senior Business Intelligence Developer/Analyst will provide quantitative and qualitative subject matter expertise to the Academy’s member and customer base systems including internal and external business stakeholders with the objective of identifying trends and outcomes leading to decisions that improve the quality of care across participating organizations. The position is responsible for creating, refining, and utilizing a variety of data modeling, analytics, and reporting tools to assist in the interpretation of data and execution in the decision-making process. The incumbent will serve in a lead role helping the Academy in its continuous improvement efforts of constituent data systems, including configuration of data elements, reports and integrations with internal and external data sources. The Senior Business Intelligence Data Analyst, in collaboration with the Data Scientist, will define and standardize data mining and statistical modeling techniques that create new insights for business stakeholders and establish scalable, efficient, automated processes for enterprise level data analyses.

Under management direction assess and ensure that the Academy is harvesting and maximizing knowledge and insights gained from analysis of transactional and historical data repositories. Acquire a deep understanding of the business questions or problems and proactively translate them into appropriate mathematical representations providing analysis for strategic priorities. Identify and present 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.

Lead and perform explanatory data analysis, generating and testing working hypotheses that identify patterns in the Academy’s data and result in actionable outcomes. Using complex computer programs, mine data sources and look for trends, extract data from databases and data warehouses for reporting and facilitate sharing between multiple data systems. Analyze and interpret data in collaboration with internal business stakeholders by designing and implementing advanced models, leveraging statistics, mathematics and econometrics to support short and long- term business strategies.

Standardize the Academy’s data collection by developing methods for database design and validation reports. Provide application analysis and data modeling design to collect data for the continued development of a centralized data warehouse. Proficiently extract and manage large volumes of data, synthesize and interpret the results and display the findings as appropriate, in creative and easy to understand charts and tables. Conduct healthcare procedure analyses and provide accurate interpretations and trends that focus on quality outcome measures. Work independently with stakeholders to define ad-hoc analyses and develop complex modeling tools and repeatable business process. Demonstrate a strong ability to effectively communicate findings, reports and charts to organizational stakeholders.

Oversee the development of the Academy’s analytic platform and capabilities, identify opportunities to improve existing tools and processes contributing to streamlined activities. Govern the overall health of the BI environments including cloud services. Perform environment capacity planning, enhance the Tabular model and scheduling refreshes, and implement usage monitoring for the environments. Develop a comprehensive working knowledge of the Academy’s tools, applications, and databases. Document business and technical feasibility assessments related to business requirements, evaluating gaps in data and technical capabilities, and communicating with business and technical teams on the responsibilities related to performing data analysis and data quality tasks. Establish processes that facilitate with the security, monitoring and development of work ensuring adherence to the data management and data quality standards and assist with developing proofs of concepts and/or prototypes as required. Perform other duties as assigned.

Required Qualifications:

  • Bachelor's Degree in computer science, finance, statistics or math required; or a minimum of 5+ years of experience analyzing data and developing solutions utilizing business analysis tools

  • Strong analytical skills; 3 - 5 years development experience with data visualization tools including PowerBI desktop, services, embedded and architecture

  • Demonstrated technology skills in SSAS, SSIS, SQL Server Analysis Services, Microsoft Azure, Active Directory

  • Ability to serve as a subject matter expert in data visualization and storytelling, providing both reactive and proactive consultative guidance for internal business partners

  • Proven UX design skills to ensure a positive user experience with all self-serve BI solutions

  • Promote best practices around analytical modeling techniques and data visualization

  • Experience publishing BI applications and reports in an enterprise environment

  • Experience working with embedded object mashup pages in a custom web application environment

  • Ability to work with mathematical concepts such as probability and statistical inference

  • Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations

  • Ability to apply principles of logical or scientific thinking to a wide range of intellectual and practical problems

  • Structure data visualization tools for appropriate data source, filtering, and statistical methodology application

  • Maintain a positive team attitude that fosters creative development within the organization

  • Proven experience developing and executing strategic projects and initiatives

  • Ability to participate in emerging data governance standards initiatives to remain current on evolving standards that impact Academy systems

  • Advanced SQL and data blending skills

  • Expert proficiency in Microsoft Office (Word, Excel, Access, PowerPoint, Visio) 

  • Exceptional organizational and planning skills 

  • Excellent verbal, written and interpersonal communication skills

  • Ability to function in multi-project environment with tight deadlines 

  • Strong organizational skills and user orientation


    Desired Qualifications:

  • M.S. degree in Computer Science or equivalent

  • Experience with Association Management Systems a plus

  • Formal software engineering process training

  • Familiarity with HIPAA/HITECH regulatory requirements for Information Security & Data Privacy


If this describes YOU, please share the following:

-Clearly communicate why you are the ideal candidate for this role, providing specific examples and experiences as proof points.

-Attach your resume, cover letter and any additional materials that support your application.





Location: Rosemont, IL
Apply for this Position Job code: HR/SBIDA
Apply at: