Weekend Data Analyst Sql Excel Jobs in Kentucky (NOW HIRING)

Job Description Summary: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.Job Description:

ESSENTIAL JOB DUTIES

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 organizational 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 organization. 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.

JOB SPECIFICATIONS

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 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.

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 visualizations 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 clickhere.

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.

Job Family:

ACCTEmployee Type:EmployeeScheduled Weekly Hours:37.5City/State:Washington, District of Columbia