Business Data Analyst

The Business Process Analyst will serve as the primary liaison between agency subject matter experts (SMEs) and technical report developers to support the design, development, and implementation of reporting solutions. This role is responsible for eliciting, documenting, and translating business reporting requirements into functional specifications that guide development using Snowflake and Power BI.

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.

• 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

• Analyze end‑to‑end business processes 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

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

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

• 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

• 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

• 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 working with:
  • Advantage (or similar ERP systems)
  • Snowflake (data warehousing)
  • Power BI (reporting and visualization)
• Familiarity with data modelling concepts and ETL/ELT processes
• Experience in public sector or large enterprise environments
• Knowledge of Agile and/or hybrid SDLC methodologies
• Communication:
  Ability to translate complex technical concepts into business‑friendly language
• 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

• 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

The Company is an Equal Opportunity Employer and is committed to creating an equitable and inclusive environment for all.