Advertisement Closes
6/11/2026 (8:00 PM EDT)
26-02716
Business Intelligence (BI) Architect
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 Rd Frankfort, KY 40601 USA The agency may authorize the selected candidate to telecommute. The agency may terminate or modify the
telecommuting arrangement at any time.
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/457), flexible work schedules, ample parking, and a walkable campus.
Key Responsibilities:
Analyzes and designs the overall architecture of Business Intelligence (BI) solutions. Designs data
warehousing solutions, data integration strategies, and data governance to ensure data is used efficiently and
effectively.
Manages multiple projects throughout all phases of the project lifecycle. Contributes to scope, development of
goals and deliverables, preparation of work plans, test scripts, training materials.
Plans, develops, and presents information technical trainings and enterprise-wide training programs for the
agency.
Supports IT (Information Technology) procurement activities. Works with IT leadership to maintain and document
IT Budget and expenditures.
Provides support to SharePoint and MS Teams administrators.
Performs other duties as assigned.
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
eMARS Experience
Strong problem resolution skills
Detailed Oriented
For more information about Kentucky Public Pensions Authority, visit our website at
https://kyret.ky.gov/Pages/index.aspx
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.
An Equal Opportunity Employer M/F/D