Business Intelligence (BI) Architect

Commonwealth of Kentucky; Frankfort (KY); On-site; USD 75,000 - 92,000; Full time

Benefits offered by this job

KPPA retirement plan

First-day health insurance

Dental and vision insurance (optional)

Health flexible spending account

Life insurance

Wellness incentive program

Paid holidays and vacation

Paid sick leave

Employer paid leave

Discounts for state employees

Training and career development

Deferred compensation (401k/457)

Flexible work schedules

Ample parking

Walkable campus

Job summary

Kentucky Public Pensions Authority in Frankfort seeks a Business Intelligence Architect to design BI architecture, data models and warehouses. You will drive BI strategy and analytics, ensuring data quality, security, and regulatory compliance while guiding BI staff.

The role requires 6 years in BI/data analysis, proficiency with Tableau/Power BI and strong problem solving. Located in Frankfort, with generous state benefits and a 37.5-hour work week.

Qualifications

• Bachelor's or Associate's degree in IT or related field (or related certification).
• Six years of professional experience in data analysis, BI, or reporting tech.
• Experience with BI tools (Tableau/Power BI) and data governance basics.

Responsibilities

• Design and maintain BI architecture, data models and data warehouses.
• Develop BI strategy, KPIs, reporting and analytics aligned to priorities.
• Establish data governance, security, quality, and regulatory compliance.
• Provide technical leadership and mentoring to BI staff.
• Perform other duties to support organizational needs.

Skills

BI Tools

Problem Solving

Detail Orientation

Education

Bachelor's or Associate's IT related

Tools

Tableau

Power BI

SQL Reporting Services

Excel

SharePoint

Teams

Job description

Advertisement Closes

9/6/2026 (11:59 PM ET)

2604566

Business Intelligence (BI) Architect

Pay Grade 17

Salary

$83,752.00 Annually

Employment Type

EXECUTIVE BRANCH | FULL TIME | ELIGIBLE FOR OVERTIME PAY | 18A | 37.5 HR/WK

Hiring Agency

General Government Cabinet | Kentucky Public Pensions Authority

Location

1260 Louisville Road

Frankfort, KY 40601 USA

Description

Kentucky Public Pensions Authority (KPPA) is currently seeking a Business Intelligence (BI) Architect in the Division of Enterprise and Technology Services. Located in Frankfort, Kentucky, KPPA is responsible for the investment of funds and administration of pension and health insurance benefits for nearly 444,000 state and local government employees, state police officers, and nonteaching staff of local school boards and regional universities. Daily system activities, including administrative support, investment management, benefits counseling, accounting and payroll functions, and legal services, are performed by a staff of professional employees working as the KPPA. KPPA covers three separate systems: Kentucky Employees Retirement Systems (KERS), County Employees Retirement System (CERS), and the State Police Retirement System (SPRS).

This position is in the Enterprise Project Management Office (EPMO) within the KPPA Division of Enterprise and Technology Services (ETS). The ETS division is staffed by 50 technology professionals divided into seven branches. The EPMO branch consists of 3 skilled professionals that work in a variety of areas including procurement, project management, training, and data analytics.

Generous benefits for full‑time employees include:

• a KPPA retirement plan
• first-day health insurance
• optional dental and vision insurance
• an optional health flexible spending account
• life insurance
• a wellness incentive program
• 12 ½ paid holidays
• paid vacation leave
• paid sick leave
• employer paid leave
• state employee discounts
• training and career development opportunities
• an optional deferred compensation program (401k and 457)
• flexible work schedules
• ample parking
• a walkable campus

Key Responsibilities

• BI Architecture and Data Integration: Design and maintain BI architecture, data models, data warehouses, and data integration processes.
• BI Strategy and Analytics: Develop BI strategies, KPIs, reporting, and analytics solutions aligned with organizational priorities.
• Data Governance and Security: Establish standards that ensure data quality, integrity, security, and regulatory compliance.
• BI Solutions and Technical Leadership: Evaluate and implement BI technologies and solutions while providing technical guidance and mentoring to BI staff.
• Other Duties: Perform other duties as assigned to support organizational and departmental needs.

Preferred Knowledge, Skills and Abilities

• Business Intelligence tools including but not limited to; Tableau, Microsoft Power BI, or SQL Reporting Services
• Microsoft Office Suite, including Excel, SharePoint, Word and Teams
• Strong problem resolution skills
• Detailed oriented

Minimum Requirements

EDUCATION:

Graduate of a college or university with a bachelor's degree OR a graduate of a college or university with an associate's degree in information technology (IT) or related field OR certification in an IT related field.

EXPERIENCE, TRAINING, OR SKILLS:

Six years of professional experience in data analysis, business intelligence, or database and reporting technologies.

Substitute EDUCATION for EXPERIENCE:

A master's degree in computer science will substitute for the required experience on a year-for-year basis.

Substitute EXPERIENCE for EDUCATION:

Two years of additional experience in data analysis, business intelligence, database and reporting technologies will substitute for the education requirement.

SPECIAL REQUIREMENTS (AGE, LICENSURE, REGULATION, ETC.):

NONE

Working Conditions

Typical working conditions for a specific position may be listed on the individual position description.

Probationary Period

This job has an initial and promotional probationary period of 6 months, except as provided in KRS 18A.111.

If you have questions about this advertisement, please contact Lori Casey at [e-mail]

An Equal Opportunity Employer M/F/D