Job Details

Program Manager - Luma Report Writer

  2023-11-24     Idaho Department of Health and Welfare     450 W State Street     $33.96 - $44.00 hour  



People Making a Difference!


The Division of Management Services (DMS) is excited to announce an opening for Program Manager to join our team. This position will complete design, develop, and validate reporting related to the LUMA system.

This position will be focused on leading and guiding the development, implementation, and continuous improvement of reporting to support critical business processes. In this role, the Program Manager will use SQL to ensure adequate business reports support the alignment between business operations, compliance, policies, and processes. This person will be responsible for managing report development projects from concept to implementation, analyzing problems and identifying potential solutions. The successful candidate will identify and prioritize business reporting needs, develop solutions, work with various reporting tools, and assess the effectiveness of reporting solutions post-implementation for a wide variety of policy and program changes related to both the Human Capital Management (HCM) and Financial Services Management (FSM) modules of LUMA. They will be a strong team contributor, possess the ability to lead and manage multiple projects, and work with various subject matter experts and project teams. We are searching for an individual with exceptional business analysis skills, experience in finance and payroll, SQL skills, critical thinking, interpersonal skills, and someone that is driven to produce end-user focused reports that include holistic systems-thinking competencies.

Incumbent will be able to telework and/or come into the office as needed.



We have one of the Nation's best state retirement systems (PERSI) that offers a lifetime benefit. 


  • excellent medical, dental and vision insurance- (full-time/30+ hours per week) employee only coverage for PPO $65/month for medical and vision & $11.80/month for dental
  • generous vacation and sick leave accrual beginning as soon as you start 
  • 11 paid holidays a year 
  • paid parental leave
  • multiple savings plans, optional 401K, and optional 457
  • basic life insurance for employee and family (employee covered at one times annual salary; spouse covered at $10,000; child covered at $5,000)
  • wellness programs 
  • ongoing training opportunities 
  • an opportunity for student loan forgiveness
  • and more!


  • Develop and maintain a report working group (both within DMS and external as needed) that brings in subject matter experts to provide guidance and advice on each report.
  • Develop a data dictionary for report fields and what they mean. Ensure standardization of report terms so there is consistency in reporting to ensure confidence in the data and the system.
  • Act as a functional and technical liaison – deeply understand both the functional side of the business each report is supporting, and the technical ability to match reporting needs with system limitations.
  • Develop, build, test, and maintain standardized reports (including financial, payroll, grant, encumbrance, statistical, program specific, position control, and other operating reports) that support LUMA system operations policies and procedures and support department, federal and state regulations related to reporting through the use of SQL, Tableau, Cognos, and/or other reporting systems.
  • Automate system output for critical reports.
  • Participate in developing data governance policies and procedures.
  • Develop recommendations for specifications for software modifications by IT staff.
  • Identify and recommend enhancements and modifications to the system where necessary and appropriate.
  • Participate in implementation and Joint Integration Testing (JIT).
  • Coordinate problem resolution with end users of reports.


You must possess all the minimum qualifications and specialty minimum qualifications below to pass the exam for this position. Please make sure your resume or work history supports your meeting the minimum and specialty qualifications for this position. Failure to do this may disqualify you from being considered for this position. It is highly recommended to attach a one-page cover letter to your application to demonstrate how you meet the requirements below.

  • Some knowledge of management practices and some experience managing a major program and supervising staff. Typically requires at least one-year experience managing a major program and providing leadership of professional staff. Candidates may also qualify through completing upper-division college-level management coursework along with experience in a significant leadership role.


  • Some experience working with Enterprise Resource Planning Systems (ERP Systems) related to finance and payroll or fully integrated accounting software. Typically requires at least one year of experience working with an ERP utilized for budget planning, financial management, procurement, payroll, and human capital management.
  • Experience working with SQL. Typically gained by at least three years of work working with SQL to develop end user reports using data from an ERP or data warehouse.
  • Some experience working with Cognos, Tableau, or other reporting tool. Typically required at least one year of experience working with data-cube based reporting tool.

Below is preferred experience. It is not required for the position but applicants with this experience may receive consideration over other applicants.

1. Bachelor’s or Master’s Degree in Business, Accounting, Finance, or other related area.

2. Experience working with Human Capital Management (HCM) and Finance Services Management (FSM) modules of LUMA (Infor).  Typically requires some experience working in one or both of the modules of LUMA/Infor.

Apply here:

Learn About a Career with DHW

***PLEASE NOTE: application assistance is not available after the business hours listed below, on the weekends, or on holidays and you must apply before 4:59 pm on the closing date. When applying, use CHROME as your browser to avoid complications.

If you have questions, please contact us at:

Email is the quickest way to get an answer to your questions.

(answered Monday through Friday during business hours MST)


PHONE: (208) 334-0681


The State of Idaho is committed to providing equal employment opportunities and prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on their race, color, religion, political affiliation or belief, sex, national origin, genetics, or any other status protected under applicable federal, state, or local laws.

The State of Idaho is committed to access and reasonable accommodations for individuals with disabilities, auxiliary aids and services are available upon request. If you require an accommodation at any step in our recruitment process, you are encouraged to contact (208) 334-2263 (TTY/TTD: 711), or email

Preference may be given to veterans who qualify under state and federal laws and regulations.

Do not contact this company in solicitation of any product or service.

apply below | save job

Apply for this Job

Please see the job description for instructions on how to apply.

Back to Search

Want an email alert with jobs like this one? Sign up today!