Protect our Land, Ascend with Us!

Ascension LLC is seeking a Data Analyst / Reporting Specialist to support a large-scale Advanced Metering Infrastructure program for WSSC Water. This role is designed for a highly organized, detail-oriented data and reporting professional who can transform deployment, billing readiness, installation progress, stakeholder engagement, inventory, and system health information into clear, accurate, and leadership-ready reporting products.

WSSC Water’s AMI Program Manager requirement calls for regular reporting to WSSC Water stakeholders, with data analytics presented through dashboards or other visual media. The solicitation identifies monthly reporting at a minimum, supplemented by weekly progress meetings, and includes reporting on project health, KPIs, system health, installation progress, billing readiness, meter reading updates, stakeholder engagement, inventory outlook, risks, lessons learned, and external stakeholder reports. The pricing proposal identifies this labor category as a part-time role with 5,200 estimated hours over the 5-year base term.

The ideal candidate will bring strong technical reporting skills, excellent data quality discipline, and the ability to work across program management, field installation, customer engagement, billing, technology, and executive stakeholders. This person should be comfortable working in an environment where data is coming from multiple sources and must be validated, reconciled, structured, and presented in a way that supports fast decision-making.

Summary of the Contractor Role

The Data Analyst / Reporting Specialist will develop and maintain AMI program dashboards, KPI trackers, reporting templates, recurring status reports, and executive briefing materials. The role will support the AMI Program Manager and broader program management team by consolidating information across installation progress, billing readiness, customer engagement, opt-out tracking, inventory reporting, system health, risk reporting, and lessons learned.

This position requires a professional who can build reliable reporting tools, identify data inconsistencies, support recurring reporting cycles, and translate complex program data into practical insights for WSSC Water leadership. The contractor will support weekly and monthly reporting rhythms, maintain reporting repositories, and ensure that reports are accurate, version-controlled, visually clear, and aligned with WSSC Water-approved formats.

The role should be staffed by someone with strong experience using Power BI, Excel, SharePoint, Microsoft 365, and structured reporting processes. Experience with utility, AMI, metering, infrastructure deployment, billing, field operations, or customer engagement data is strongly preferred, but a highly skilled reporting analyst with complex program reporting experience may also be a strong fit.

Expected Day-to-Day Activities

The Data Analyst / Reporting Specialist will be expected to:

• Develop and maintain AMI program dashboards in Power BI, Excel, SharePoint, or other approved visualization tools.
• Track and report KPIs related to installation progress, billing readiness, customer engagement, opt-outs, inventory, and system health.
• Compile monthly and weekly reporting inputs from the Program Manager, Deputy Program Manager, Scheduler, Field Inspector, Customer Engagement Manager, Change Management Specialist, and AMI Technology Specialist.
• Validate data for accuracy, completeness, consistency, and alignment across multiple reporting streams.
• Prepare project health reporting that includes schedule status, cost updates, KPI performance, risks, issues, decisions, and upcoming milestones.
• Produce installation progress reports by phase, including inspection schedules, inspection results, post-installation QA/QC findings, issues, and resolution progress.
• Support billing readiness reporting, including data quality, customer conversion from quarterly to monthly billing, billing error trends, and related issue tracking.
• Support meter reading and route reporting, including route optimization updates and opt-out participation impacts.
• Support stakeholder engagement reporting, including customer contact update campaign progress, community meeting status, call center performance, customer feedback, and engagement insights.
• Track and summarize inventory outlook information related to meter, transmitter, device, material acceptance, storage, staging, and related deployment reporting.
• Develop lessons learned reports that capture trends, recurring issues, field insights, customer concerns, and operational improvement opportunities.
• Prepare external stakeholder reports with high-level progress metrics, as needed.
• Develop executive briefing materials, including PowerPoint slides, dashboards, one-page summaries, and data-driven talking points.
• Maintain reporting calendars, data call schedules, report templates, version histories, and reporting repositories.
• Coordinate with functional leads to resolve discrepancies, missing data, or unclear reporting inputs.
• Support development of visual reports that are clear, accessible, and appropriate for executive and operational audiences.
• Identify data trends, anomalies, and performance risks requiring escalation to the Program Manager.
• Maintain SharePoint-based reporting libraries, dashboards, data trackers, and supporting documentation.
• Support continuous improvement of reporting workflows, templates, data definitions, and dashboard usability.