Senior Business Data Analyst

ViziRecruiter,LLC.; Washington (District of Columbia); Hybrid; USD 92,000 - 127,000; Full time

Benefits offered by this job

60% telework eligible

Job summary

The National Academies of Sciences, Engineering, and Medicine is seeking a Senior Business Data Analyst to serve as a senior analytics partner and BI subject matter expert. You will transform complex data into meaningful, actionable insights, define business questions, develop trusted data assets, and create dashboards to support strategic decision-making for multiple offices.

You will design dashboards in Tableau, build a unified analytics foundation, ensure data quality, and provide expert

Qualifications

• Thorough knowledge of up-to-date data analysis techniques.
• Deep understanding of Tableau and data visualization tools.
• Strong SQL, Excel, and Google Analytics skills.
• Ability to manage complex data pipelines and data quality.
• Excellent communication and presentation skills.
• Ability to work in a fast-paced office environment with deadlines.

Responsibilities

• Partner with leadership to understand business needs and define analytical questions.
• Design, build, test, publish, and maintain Tableau dashboards.
• Develop a unified analytics foundation with reusable data assets.
• Ensure data quality and governance across analytics products.
• Provide expert guidance on data interpretation and reporting approaches.
• May train and mentor analytics staff and supervise others.

Skills

Tableau

SQL

Excel

Data analysis

Communication

Problem-solving

Presentation

Education

Bachelor's degree

Master's degree preferred

Tools

Tableau Desktop

Tableau Prep

Snowflake

Job description

Introduction

The National Academies of Sciences, Engineering, and Medicine value diversity in our members, volunteers, and staff and strive for a culture of inclusion in our workplace and activities. Convening a diverse community to exchange ideas and perspectives enhances the quality of our work and increases our relevance as advisers to the nation about the most complex issues facing the nation and the world.

Overview

Requisition Number: R0002750

As a Senior Business Data Analyst, you will serve as a senior analytics partner and business intelligence subject matter expert, helping offices across the institution transform complex data into meaningful, actionable insights by conducting analysis, visualizing data, providing context, and helping stakeholders understand trends, performance, risks, and opportunities. In this role, you will work closely with leadership and staff to define business questions, clarify analytical needs, develop trusted data assets, and create dashboards and reporting that support strategic decision-making. You will play a key role in expanding analytics support beyond the Office of the Chief Financial Officer to institutional partners such as the Office of Strategy and Engagement, the Office of Peer Review, and the National Research Council Executive Office.

Responsibilities

Duties may be performed solely for a specific business or functional area or a combination of areas.

Institutional Analytics and Stakeholder Partnership: Partners with leadership and staff across institutional units to understand business needs, define analytical questions, clarify reporting goals, identify relevant metrics, assess available data, and determine the most effective analytical approach. Conducts analysis to identify trends, patterns, risks, opportunities, and key findings, and translates those findings into clear insights that support planning, operational improvement, performance tracking, and senior leadership decision-making.

Dashboard Development and Business Intelligence: Designs, builds, tests, publishes, and maintains dashboards and reporting products in Tableau and related business intelligence platforms. Creates dashboards that are accurate, accessible, visually clear, and aligned with stakeholder needs. Manages the release of assigned dashboards, including requirements gathering, stakeholder review, testing, documentation, publication, and post-release support.

Analytics Infrastructure: Develops and maintains a unified analytics foundation for Tableau by creating consistent structures, reusable data assets, transformation logic, and common business rules that allow data from multiple sources to be used reliably across Business Data Analytics products. Ensures that analytical workflows are sustainable, scalable, well-documented, structured in a way that supports consistent analysis, reduces duplication, and strengthens confidence in reported results and designed to support both current reporting needs and future growth.

Data Assets: Designs, builds, and maintains data assets in the Tableau data ecosystem for senior leadership decision support by ensuring the overall accuracy, completeness, and reliability of datasets and data models.

Data Quality: Supports strong data quality practices within Business Data Analytics by helping ensure that key metrics, definitions, assumptions, and business rules are applied consistently across analytics products. Identifies and communicates data quality issues, source system limitations, and interpretation considerations that may affect reporting or decision-making. Contributes to clear, transparent use of data with documentation.

Consultation: Provides expert guidance to stakeholders on data interpretation, reporting approaches and analytical best practices. Supports technical components of dashboard development such as consulting on coding buildout.

Staff Management: May train and coach analytical staff. If supervising staff, provides leadership and mentors employees. Trains and develops employees to successfully perform current responsibilities and encourages development of staff for future roles. Forms effective teams and cultivates a work environment that fosters teamwork. Interprets and ensures consistent application of organisational policies. Initiates personnel actions, including performance and compensation reviews and disciplinary actions. Mentors, collaborates with, and advises data analytics team members.

Confidentiality: Maintains an appropriate standard of confidentiality. Maintains strict confidence and exercises care when handling secure, privileged, sensitive, or confidential information and matters to prevent disclosure to others. Accesses confidential information for work-related reasons only, following the policies and procedures of the organisation. Ensures that any privileged, sensitive, or confidential information is securely stored, disposed of, and transmitted according to the Institutional guidance.

NONESSENTIAL JOB DUTIES

• Related duties and special projects as assigned.

Requirements

Required Knowledge, Skills, and Abilities: Thorough knowledge of up-to-date data analysis techniques. Deep understanding of utilization of data analysis and visualization tools, platforms, and software (i.e., Tableau). Above average to advance level computer skills which may include SQL, Excel and Google Analytics. Abilities to manage data pipelines for highly complex data. Strong organisational, problem-solving, and presentation skills. Excellent attention to detail. Ability to meet deadlines in a fast-paced office environment during peak periods. Ability to manage and maintain privileged, sensitive, and confidential information and matters appropriately. Ability to solve non-routine intellectual problems of substantial variety and complexity using originality and ingenuity. Serves as a resource to others in the resolution of complex problems. Ability to use substantial latitude for independent judgment and action. Experience working in complex environments with a high degree of organisational effectiveness. Ability to successfully work in a team environment and to form and maintain effective teams. Ability to develop relationships with co‑workers and employees in other National Academies’ departments through effective communication. Excellent communication skills with a proven ability to effectively interact with all levels of employees.

Minimum Education/Training Requirements: Bachelor’s Degree in relevant field or related field, or equivalent knowledge. Master’s Degree is preferred.

Minimum Experience: Six years of related professional experience. Tableau, data analysis, and visualisations is required. Advanced experience in Tableau Desktop and Tableau Prep is required. Experience with Snowflake preferred.

Physical Capabilities: Ability to work at a computer for extended periods of time.

Required Licenses, Certification or Registration: None.

Supervisory Responsibilities/Controls: Reports to Director of Business Data Analytics. General direction is provided. May supervise staff.

Work Environment: Office environment with occasional travel between National Academies’ facilities and to off‑site locations. Additional hours may be required to support internal and external deadlines during peak periods. 60% telework eligible.

Compensation & Benefits: An estimated compensation range for this position is $92,040 - $126,550. Compensation offered to the selected candidate will be based on the candidate’s relevant knowledge, skills, and work experience, commensurate with compensation of current employees in comparable positions with similar knowledge, skills and work experience, and subject to budget parameters. Note it is not typical for a candidate to be hired at the higher end of the range. This is a benefits‑eligible position. Our Benefits Plan offers competitive and comprehensive benefit options, including medical, dental and vision insurance, life insurance, disability coverage, retirement and savings benefits, leave benefits such as paid holidays and paid personal leave, transportation subsidies, and education assistance. For more information, please click here.

Any qualification to be considered equivalent, in lieu of stated minimum, requires the prior approval of the Office of Human Resources.

The above statements are intended to describe the general nature and level of work performed by employees assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. Some functions in this description may be specific to a particular unit of the National Academies and not applicable to other units.