Senior Business Data Analyst

The National Academies of Sciences, Engineering, and Medicine•Town of Johnstown, NY

3d•$92,040 - $126,550•Hybrid

About The Position

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.

Requirements

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 organizational, 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 organizational 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.
Bachelor’s Degree in relevant field or related field, or equivalent knowledge.
Six years of related professional experience.
Tableau, data analysis, and visualizations is required.
Advanced experience in Tableau Desktop and Tableau Prep is required.
Ability to work at a computer for extended periods of time.

Nice To Haves

Master’s Degree is preferred.
Experience with Snowflake preferred.

Responsibilities

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.
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.
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.
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.
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.
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.
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 organizational policies.
Initiates personnel actions, including performance and compensation reviews and disciplinary actions.
Mentors, collaborates with, and advises data analytics team members.
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 organization.
Ensures that any privileged, sensitive, or confidential information is securely stored, disposed of, and transmitted according to the Institutional guidance.
Related duties and special projects as assigned.