Data Analyst and Report Writing Services

The Vendor is required to provide for data analyst and report writing services.
- Business intelligence, data integration, and advanced data analytics solutions to support data-driven decision-making across the district.
- These services are currently provided by temporary labor on a part-time basis, and while the District does not anticipate these services requiring full-time support there may be increases in support needs to meet project requirements throughout the year.
- Services will also include reviewing the legacy reporting systems developed and assisting the District in converting and/or modernizing static reports into automated, dynamic reporting solutions to improve accuracy and efficiency in billing and financial workflows.
- Key Responsibilities
•    Design, develop, and maintain interactive dashboards and reports in Power BI.
•    Write advanced SQL queries and stored procedures to support financial and billing-related reporting.
•    Develop and maintain SSRS reports.
•    Convert legacy reports into scalable and maintainable Power BI solutions.
•    Build and manage ETL processes using SSIS and Power BI Dataflow.
•    Perform data analysis and provide insights related to various data sources
•    Collaborate with stakeholders to gather data and reporting requirements to ensure report accuracy and usability.
•    Automate data refresh, notifications, and report delivery workflows using SQL Reporting Services and/or Power Automate to streamline business processes and reduce manual effort.
•    Prepare and maintain financial reporting within the Open Gov online reporting platform, ensuring alignment with internal and external reporting requirements.
•    Functional and user-friendly dashboards and reports in Power BI that align with business and financial reporting needs.
•    Well-documented SQL scripts, ETL workflows (via SSIS and Power BI Dataflows), and clear data transformation logic.
•    Automated report distribution and workflow notifications that are configured through SQL SSRS or Power Automate.
•    Scheduled and on-demand reports delivered via SSRS and Power BI.
•    Ad-hoc data analysis and visualizations tailored to executive and departmental requests.
•    Accurate and timely Budget vs. Actuals reports on a monthly and quarterly basis, including detailed variance analysis and trend commentary.
•    Financial data reporting packages that are prepared in OpenGov ensure consistency between internal data sources and public-facing platforms.
•    Clear, structured documentation for all assets and workflows to ensure seamless handover, maintenance, and audit readiness.

- Contract Period/Term: 3 years
- Pre-Proposal Conference (Non-Mandatory) Date: August 13, 2025
- Questions/Inquires Deadline: August 14, 2025