Business Intelligence (BI) Architect

June 13, 2026

Other Jobs To Apply

@media (min-width320px){ .careerSite{ width100%; max-width940px; margin-rightauto; margin-leftauto; } .cs-atscs-jobdet-rtpane{ padding-left 0; } .maincont{ positionrelative; top0; z-index 0; } .lpic{ floatleft; width50%; min-width305px; } .rpic{ floatleft; width50%; } .col1{ displayinline-block; width25%; min-width 125px; line-height 1.4; floatleft; } .col1 label{ font-size100%; color black; padding 0; } .col2{ displayinline-block; width75%; min-width100px; line-height 1.4; floatleft; } .col50per{ displayinline-block; width50%; min-width150px; line-height 1.4; floatleft; } .col25per{ displayinline-block; width25%; min-width150px; line-height 1.4; floatleft; } .fullwidth{ displayblock; line-height 1.4; width100%; text-aligncenter; } .threequarterwidth{ displayblock; line-height 1.4; width80%; text-aligncenter; margin-leftauto; margin-rightauto; } .g_row{ clearboth; width 100%; padding-top15px; } footer{ position relative; } } @media (min-width768px){ .cs-atscs-jobdet-rtpane{ padding-left 250px; } .maincont{ top0px; } } .emplink{ color blue; cursor pointer; text-decoration none; font-size 20px; font-weight bold; } Advertisement Closes 6/11/2026 (800 PM EDT) 26-02716 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 Click here for more details on state employment. 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. If you have questions about this advertisement, please contact Lori Casey at lori.casey@kyret.ky.gov An Equal Opportunity Employer M/F/D Apply To This Job

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...