4 Scope of Services

The consultant will
support the Office of Work Program and Budget (OWPB) by gathering and
analyzing data, conducting research, and identifying business needs and
system requirements to drive modernization initiatives. This includes
collaborating with stakeholders to define project scopes, develop functional
specifications, and prepare business cases aligned with long‑term
organizational and technology strategies. The consultant will also facilitate
communication across project teams, coordinate activities, and ensure
alignment between system enhancements and broader business objectives.

The role includes
performing process modeling, developing prototypes, and recommending
improvements to applications, workflows, reporting environments, and web‑based
systems. The consultant will design, develop, and maintain components of the
organization’s Internet and Intranet applications, including forms, pages,
graphics, and interactive interfaces, while ensuring cross‑browser
compatibility and up‑to‑date content. Responsibilities also include designing
and supporting interactive dashboards; performing data cleansing,
transformation, and multi‑source integration; developing automation to
streamline content publishing; and monitoring system and dashboard
performance to address user feedback and enhance usability and reliability.

Additional
responsibilities include ensuring accurate and comprehensive project
documentation throughout the lifecycle. This includes gathering and
organizing project information; documenting requirements, objectives,
deliverables, risks, issues, and mitigation strategies; and maintaining
documentation so that it remains current and accessible. The consultant will
also serve as an internal technical resource, advisor, and mentor supporting
the organization in adopting modern tools, improving workflows, and strengthening
technical capabilities. The role includes researching and recommending new
Internet tools, applications, and modernization techniques to support
continuous improvement across systems and reporting environments.

5 Education

Associate’s or Bachelor’s Degree, or technical
institute degree/certificate in Computer Science, Information

Systems, or other related field. Or equivalent work
experience.

6 Experience

1 to 3
years of IT work experience in computer systems or support with demonstrated
proficiency in data analysis methodologies, business analysis principles, and
data visualization tools such as Power BI or similar technologies. Skilled in
querying, extracting, cleaning, and interpreting complex data sets to
identify trends and translate business needs into actionable solutions.
Ability to manage multiple tasks, adapt to evolving requirements, maintain
attention to detail, and continuously learn new technologies.

7 Primary Job Duties/ Tasks

The submitted candidate
must be able to perform the
following duties
and/or tasks:

1. 
   Gather and analyze data, conduct research, and identify business
   needs and requirements. Collaborate with stakeholders to define project
   scopes, create functional specifications, and develop business cases.
   Facilitate communication and coordinate project activities to support
   effective implementation and ensure alignment with business strategies.
2. 
   Perform process modeling and develop prototypes, providing
   recommendations for process improvements and system enhancements to
   optimize workflow efficiency and support organizational goals.
3. 
   Design and create interactive dashboards using data visualization
   tools to present key metrics, trends, and insights. Perform data
   cleansing, transformation, and integration of multiple data sources to
   ensure comprehensive and accurate reporting.
4. 
   Provide ongoing dashboard support by monitoring performance,
   addressing user feedback, and implementing enhancements to improve
   functionality, usability, and reliability.
5. 
   Assist in project documentation by gathering and organizing
   project information, documenting requirements, objectives, and
   deliverables, and ensuring all documentation is accurate, accessible,
   and kept current throughout the project lifecycle.
6. 
   Support project risk and issue documentation by assisting in
   identifying risks, recording issues, tracking mitigation strategies, and
   ensuring proper communication to stakeholders.
7. 
   Diagnose and resolve basic software issues; escalate complex
   problems to senior technical staff as needed.
8. 
   Enter and maintain accurate support data in the tracking system.
9. 
   Learn and apply standard practices for system modernization and
   data integration.
10. 
    Participate in quality improvement activities and document
    findings for review.
11. 
    Assist in testing system changes and enhancements, including
    preparing basic test scenarios and validating results.
12. 
    Help maintain and update automated reports used by OWPB and
    District offices.
13. 
    Provide basic analysis of software issues impacting financial
    management systems and recommend escalation when necessary.
14. 
    Assist in documenting workflows and system processes for future
    reference and training.
15. 
    Learn and use a variety of platforms to support OWPB operations, such
    as Informatica and Snowflake.
16. 
    Communicate effectively with internal users to gather information
    about issues and provide status updates.

8 Job Specific Knowledge, Skills, and Abilities (KSAs)

The submitted candidate must be able to
apply common knowledge, skills, and abilities in the following areas:

1. 
   Basic understanding of application, reporting environments, and
   relational database concepts, including simple SQL queries.
2. 
   Proficiency with development and data tools such as Visual Studio,
   SQL Server Management Studio, and data visualization platforms.
3. 
   Knowledge of data analysis techniques, including querying,
   extraction, cleaning, transformation, and working with large datasets to
   ensure data quality.
4. 
   Ability to interpret complex data to identify trends, patterns,
   and actionable insights that support decision‑making.
5. 
   Ability to understand business needs and translate them into
   clear, data‑driven requirements and solutions.
6. 
   Strong organizational skills, including the ability to manage
   multiple tasks, prioritize effectively, maintain accuracy, and adapt to
   changing requirements or new technologies.
7. 
   Commitment to continuous learning in data analysis, business
   intelligence, and modernization tools and methodologies.
8. 
   Ability to learn processes related to complex financial management
   systems.
9. 
   Strong verbal and written communication skills for effective
   interaction with team members and internal customers.
10. 
    Ability to clearly document
    issues, resolutions, workflows, and information systems standards.
11. 
    Basic problem-solving and
    troubleshooting skills for software applications.
12. 
    Knowledge of system testing
    practices, including preparing test scenarios and validating results.
13. 
    Ability to work across
    multiple platforms and collaborate effectively in both independent and
    team environments.
14. 
    Demonstrated
    professionalism and a customer‑focused approach.

9 General Knowledge Skills and Abilities (KSAs)

The submitted candidate must
be able to apply common knowledge, skills, and abilities in the following
areas:

1.
Communication:
Ability to clearly convey information, in both written
and verbal formats, to individuals or groups in a wide variety of settings
(i.e., project team meetings, management presentations, etc.). Must have the
ability to effectively listen and process information provided by others.

2.
Customer Service:
Works well with clients and customers (i.e., business
office, public, or other agencies). Able to assess the needs of the customer,
provide information or assistance to satisfy expectations or resolve a
problem.

3.
Decision Making:
Makes sound, well-informed,
and objective decisions.

4.
Flexibility:
Open
to change, new processes (or process improvement), and new information. Has
the ability to adapt in response to new information, changing conditions, or
unexpected obstacles. Ability to receive and give constructive criticism and
maintain effective work relationships with others.

5.
Interpersonal:
Shows friendliness, courtesy,
understanding, and politeness to others.

6.
Leadership:
Motivates, encourages, and
challenges others. Adapt leadership styles in a variety of situations.

7.
Problem Solving:
Ability to identify, evaluate, and use sound judgement to
generate and evaluate alternative actions, and make recommendations as
accordingly.

8.
Team Building:
Encourages, inspires, and guides others toward
accomplishing the common goal.