Business Intelligence Specialist II

Association of American Medical Colleges; Washington (District of Columbia); Remote; USD 89,000 - 104,000; Full time

Benefits offered by this job

Hybrid/Remote work option

Health, dental, vision coverage

Paid time off & parental leave

403(b) retirement plan

Family & care support

Tuition reimbursement

Job summary

The Association of American Medical Colleges is seeking a Business Intelligence Specialist II to support organizational decision-making through timely reporting, dashboards, and data analysis using SQL and BI tools. You will translate business questions into meaningful insights, collaborating with stakeholders across the organization to improve forecasting and strategic planning.

You will contribute to dashboard development and maintenance, data validation, and ad hoc analyses, driving

Qualifications

• Bachelor's degree in a related field such as business analytics, data analytics, information systems, or equivalent.
• 2-4 years of related work experience.
• Experience with data, reporting tools, databases, or analytics projects.

Responsibilities

• Develop, maintain, and distribute recurring reports that provide insight into business performance and program outcomes.
• Analyze trends and summarize findings to support planning and decision-making.
• Produce regular reports that support forecasting, budgeting, and strategic decision-making.
• Collaborate with business teams to refine metrics and ensure reporting aligns with changing priorities.
• Partner with Product Management to analyze user behavior and outcomes to support roadmap planning.
• Support KPI development and documentation for product performance and engagement.

Skills

Data analysis

SQL

Reporting tools

Dashboard development

Education

Bachelor's degree in related field

Tools

Salesforce

Job description

Who We Are:

The Association of American Medical Colleges is a not-for-profit association dedicated to transforming health care by supporting the entire spectrum of medical education, medical research, and patient care conducted by our member institutions. We are dedicated to the communities we serve and steadfast in our goal to improve the health of all.

At the AAMC, we are committed to supporting our employees with a comprehensive and competitive benefits package designed to promote well-being, professional development, and work-life balance.

• HybridWork - Primarily remote roles with the ability to work across the U.S.
• Comprehensive Health & Wellness - Medical, dental, and vision coverage; wellness programs; and fitness reimbursement
• Generous Time Away - Paid time off, holidays, personal days, sick leave, paid parental leave and short and long term disability benefits.
• Retirement & Financial Well-Being - 403(b) retirement plan with generous employer contributions and financial planning resources
• Family & Care Support - Backup care for children, elders, and pets, plus resources for families with specialized needs
• Learning & Purpose: Tuition reimbursement, professional learning and development opportunities and the chance to advance a meaningful mission.

Additional information can be found on our website.

Why us, why now?

Business Intelligence Specialist II supports organizational decision-making by providing timely, accurate, and actionable business intelligence. This role fulfills data requests, develops and maintains reports and dashboards, performs data analysis using SQL and reporting tools, and translates business questions into meaningful insights. Working closely with stakeholders across the organization, the analyst helps improve operational effectiveness, forecast business trends, and support strategic planning through data-driven recommendations.

How will you make an impact?

Business Reporting & Analysis

• Develop, maintain, and distribute recurring reports that provide insight into business performance, customer engagement, operational metrics, and program outcomes.
• Analyze trends and summarize findings to support planning and decision-making.
• Produce regular reports that support forecasting, resource planning, budgeting, and strategic decision-making.
• Collaborate with business teams to refine metrics and ensure reporting aligns with evolving organizational priorities.
• Partner with Product Management to analyze user behavior, feature adoption, operational performance, and business outcomes to support roadmap planning and prioritization.
• Support the development, refinement, and documentation of key performance indicators (KPIs) that measure product performance, customer engagement, operational effectiveness, and business outcomes.
• Provide recommendations based on data analysis that help stakeholders evaluate opportunities, identify risks, and make informed business decisions.

Data Querying & Validation

• Develop, maintain, and optimize complex SQL queries to extract, transform, and validate data from multiple enterprise systems and databases.
• Perform quality assurance activities to ensure accuracy, completeness, and consistency of reporting outputs.
• Investigate data discrepancies, troubleshoot reporting issues, and collaborate with technology teams to resolve data-related concerns.
• Create reusable query logic, data definitions, and documentation to support efficient and scalable reporting processes.
• Assist in maintaining data governance standards and promoting the consistent use of business definitions and metrics across the organization.

Dashboard Development & Maintenance

• Design, develop, and maintain interactive dashboards and visualizations that provide internal users with self-service access to key business metrics and operational insights.
• Translate business requirements into effective visual solutions that improve understanding and support decision-making.
• Monitor dashboard performance, ensure data accuracy, and continuously enhance user experience through feedback and evolving business needs.
• Consult withinternal and external users throughout the dashboard development lifecycle to ensure visualizations are intuitive, actionable, and aligned with user expectations.
• Support adoption of business intelligence tools by providing training, guidance, and documentation to end users.
• Partner with internal business teams, IT colleagues, and external users/customers to gather requirements, understand reporting needs, and translate business objectives into effective dashboard solutions.

Data Requests and Ad Hoc Analysis

• Evaluate external data requests against CES and AAMC policies and governance standards to evaluate external data request.
• Partner with Data Operations and Services to fulfil data requests as needed.
• Respond to requests for data, metrics, and analysis.
• Identify appropriate data sources, perform analyses, and communicate findings in a clear and actionable manner.
• Use Salesforce to document and respond to external requests for data.
• Maintain a tracking system for requests.

Process Improvement & Documentation

• Document reporting processes, business rules, data definitions, and data sources to support consistency and knowledge sharing.
• Maintain business definitions, data dictionaries, and reporting governance standards.
• Identify opportunities to automate recurring reporting activities, improve data accessibility, and increase operational efficiency.
• Participate in testing and validation activities related to reporting enhancements, system changes, and new data sources.
• Contribute to continuous improvement initiatives that strengthen analytical capabilities and data-informed decision-making across the organization.

What you will bring to the role:

Required Qualifications:

• Bachelor's degree in business Analytics, Data Analytics, Information Systems, Statistics, Mathematics, Economics, Computer Science, or related field.
• 2-4 years of related work experience.
• Experience working with data, reporting tools, spreadsheets, databases, or analytics projects through internships, coursework, academic research, or professional experience.

Preferred Qualifications:

• Experience developing dashboards and reports using business intelligence tools.
• Familiarity with SQL and data visualization best practices.
• Experience working in a mission-driven organization, higher education, healthcare, or nonprofit environment is a plus.

Remote Work Eligibility

This is a remote-eligible position at AAMC. Candidates may reside anywhere within the contiguous United States, excluding California, Massachusetts, New York, and Oregon.

Compensation Grade Range

$88,740.00-$104,400.00

Multiple factors are taken into consideration to arrive at the final hourly rate/annual salary to be offered to the selected candidate. Factors may include, but are not limited to, the scope and responsibilities of the role, the selected candidate's work experience, education and training, as well as internal equity, market, and business considerations.

Equal Opportunity Statement

The AAMC is an Equal Opportunity Employer. The AAMC is committed to an Equal Employment Opportunity policy in recruitment, hiring, career advancement, and all other personnel practices. The AAMC will not discriminate on the basis of race, color, sex, national origin, religion, age, marital status, personal appearance, sexual orientation, gender identity or expression, family responsibilities, matriculation, political affiliation, genetic information, disability, past or current military service, or any other legally protected characteristic. The AAMC is committed to the full inclusion of all qualified individuals. As part of this commitment, the AAMC will ensure that people with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, perform essential job functions, and/or receive other benefits and privileges of employment, please contact the talent acquisition team.