Junior Data Analyst - Power BI

Job Purpose:

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.

About the Candidate:

Qualifications

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.

Required Experience

This position requires the following experience and/or knowledge:   

1.      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.

Job Specific Knowledge, Skills and Abilities

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.

  Primary Job duties and 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.