Business Intelligence (BI) Architect

Kentucky Personnel Cabinet•Frankfort, KY

12h•Onsite

About The Position

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.

Requirements

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.
Six years of professional experience in data analysis, business intelligence, or database and reporting technologies.
A master's degree in computer science will substitute for the required experience on a year-for-year basis.
Two years of additional experience in data analysis, business intelligence, database and reporting technologies will substitute for the education requirement.

Nice To Haves

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

Responsibilities

Design and maintain BI architecture, data models, data warehouses, and data integration processes.
Develop BI strategies, KPIs, reporting, and analytics solutions aligned with organizational priorities.
Establish standards that ensure data quality, integrity, security, and regulatory compliance.
Evaluate and implement BI technologies and solutions while providing technical guidance and mentoring to BI staff.
Perform other duties as assigned to support organizational and departmental needs.