Senior Business Data Analyst

The National Academies of Sciences, Engineering, and Medicine is an institution that supports research, strategy, peer review, and evidence-based decision-making. The Senior Business Data Analyst serves as a senior analytics partner, transforming complex data into actionable insights through analysis, visualization, dashboards, reporting, and stakeholder consultation. The role also develops analytics infrastructure and data assets, supports data quality, and may train or supervise analytical staff.

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

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
• 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
• Master's Degree is preferred
• Experience with Snowflake preferred