Business Process Analyst

Job Title: Business Process Analyst (Reporting & Data Integration Liaison)

Position Overview

The Analyst will ensure that reporting solutions align with business processes, data structures, and decision-making needs, while facilitating collaboration across functional and technical teams.

Key Responsibilities

Stakeholder Engagement & Liaison Support

• Serve as the primary point of contact between agency SMEs, business users, and report developers
  
• Facilitate requirements workshops, interviews, and working sessions to gather reporting needs
  
• Translate business needs into clear, actionable functional and technical requirements
  
• Manage stakeholder expectations, ensuring alignment between business priorities and technical feasibility
  

Business Process Analysis

• Analyze end-to-end business processes within Advantage 4 to identify reporting opportunities and data dependencies
  
• Document current-state and future-state workflows, including data flows and reporting touchpoints
  
• Identify gaps, inefficiencies, and risks related to reporting and data availability
  
• Recommend process improvements to support accurate and efficient reporting
  

Reporting Requirements & Documentation

• Develop and maintain detailed requirements documentation, including:
  
• Business requirements documents (BRDs)
  
• Functional specifications
  
• Data mapping and transformation rules
  
• Report mockups and wireframes
  
• Ensure requirements are complete, testable, and aligned with reporting standards and governance practices
  

Technical Collaboration (Snowflake & Power BI)

• Partner with data engineers and developers to support:
  
• Data ingestion and transformation in Snowflake
  
• Data modeling and semantic layer design
  
• Power BI dashboard and report development
  
• Clarify requirements, answer developer questions, and support iterative design
  
• Validate that technical solutions meet documented requirements
  

Testing & Validation

• Develop and execute User Acceptance Testing (UAT) plans and test cases
  
• Coordinate testing activities with SMEs and stakeholders
  
• Track, document, and resolve defects or discrepancies
  
• Ensure reports meet business, data quality, and compliance requirements
  

Governance & Best Practices

• Support the establishment and enforcement of reporting standards, naming conventions, and data governance practices
  
• Ensure alignment with enterprise reporting frameworks and data policies
  
• Maintain traceability between requirements, development, and delivered reports
  

Required Qualifications

• Bachelor’s degree in Business Administration, Information Systems, Data Analytics, or related field
  
• 5+ years of experience as a Business Analyst or Business Process Analyst in a data/reporting environment
  
• Demonstrated experience serving as a liaison between business stakeholders and technical teams
  
• Strong experience with requirements elicitation, documentation, and process mapping
  
• Experience supporting BI/reporting initiatives
  

Preferred Qualifications

• Experience working with:
  
• Advantage (or similar ERP systems)
  
• Snowflake (data warehousing)
  
• Power BI (reporting and visualization)
  
• Familiarity with data modeling concepts and ETL/ELT processes
  
• Experience in public sector or large enterprise environments
  
• Knowledge of Agile and/or hybrid SDLC methodologies
  

Key Competencies

• Communication: Ability to translate complex technical concepts into business-friendly language
  
• Facilitation: Strong workshop facilitation and stakeholder engagement skills
  
• Analytical Thinking: Ability to connect business processes with data and reporting requirements
  
• Attention to Detail: Ensures accuracy in requirements, data mapping, and validation
  
• Collaboration: Works effectively across cross-functional teams
  

Example Deliverables

• Business Requirements Document (BRD) for agency reporting needs
  
• Data mapping document linking Advantage 4 fields to Snowflake tables
  
• Power BI report mockups with defined KPIs and filters
  
• UAT test scripts and defect log
  

Success Measures

• Reports delivered meet business requirements with minimal rework
  
• Stakeholder satisfaction with reporting outputs and collaboration process
  
• Reduced gaps between business expectations and technical delivery
  
• Timely completion of reporting deliverables aligned with project milestones