Grant Systems Data Reporting Lead

State of Wisconsin
United States
about 1 month ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$76,960.0 - $88,920.0
Working hours
Shift work
Job source

Tech stack

Extract Transform Load (ETL) Data Mining Systems Analysis Power BI SQL Databases Data Streaming Tableau (Software) Performance Monitor Custom Reports

Job description

The newly established Office of Grants Management (OGM) within the Department of Health Services (DHS) is hiring a Grant Systems Reporting Lead. In collaboration with subject matter experts throughout DHS, OGM provides the agency with centralized grantmaking functions to focus on customer service, compliance with federal requirements, and the overall consistency and quality of the grants process., As the Grants Systems Reporting Lead, you will provide expert technical and analytical leadership for the design, configuration, and maintenance of OGM’s enterprise grants administration reporting systems. You will ensure that data flows, integrations, and reports enable efficient, transparent, and compliant grant management across all DHS grant programs.

You will serve as the primary architect for OGM’s reporting framework, developing automated dashboards and data models that transform complex grant information into actionable insights for leadership, fiscal staff, and program managers. This role requires strong collaboration with the department’s IT, fiscal, and grant program staff to ensure that reporting solutions meet business needs and regulatory standards., * All applicants who may be appointed will be required to allow DHS to conduct a background check to determine whether the circumstances of any conviction may be related to the job being filled.

  • For positions that allow remote working flexibility, working outside of Wisconsin or in bordering cities will not be allowed except in extremely limited circumstances due to the need to report to an office location in Wisconsin on short notice.
  • Employees must have access to both a private workspace and secure high-speed internet for remote work option. Mileage reimbursement to the employee’s headquarter location is not provided.
  • DHS does not sponsor work visas for this position, thus, in compliance with federal law, selected candidates will be required to verify eligibility to work in the United States by completing the required I-9 form upon hire. DHS is not an E-Verify employer nor a STEM-OPT eligible employer.

Requirements

Minimally qualified applicants will have all the following:

  • Experience developing standardized and customized reports and dashboards using tools such as Power BI, Tableau, or SQL.
  • Experience collaborating with technical and non-technical teams to design and develop reports/dashboards that support program performance monitoring, fiscal oversight, or compliance tracking.
  • Experience developing, updating, or maintaining a comprehensive reporting framework and associated technical documentation (e.g., reporting processes, visualization standards, templates, reporting protocols, etc.).

Well-qualified applicants will also have one or more of the following:

  • Experience with tools and methodologies used in information systems analysis in a government, grant, finance, or accounting, or program management environment following federal Uniform Guidance or internal control requirements (e.g., business requirements gathering, process mapping, user acceptance testing, etc.).
  • Experience maintaining security of protected data (e.g., PII, PHI, PCI, etc.) in a government, grant, finance, or accounting environment.
  • Experience developing analytical reports and dashboards that follow ADA accessibility standards.
  • Experience in data extract, transformation, and load (ETL/ELT) techniques and execution.

Benefits & conditions

As an employee of the State of Wisconsin, you’ll have access to an amazing benefits package, including:

  • 3.5 weeks of vacation, 9 paid holidays and ample sick time; limitations may apply for leave time usage in the first six months.
  • Top rated health plan options starting at $47/month for single plans and $117/month for family plans, after 2 months of state service.
  • Exceptional pension plan with a 7.25% employer match in 2027 with lifetime retirement payment. Plus, a tax advantaged supplemental retirement savings plan which allows you to save money directly from your paycheck for retirement. Use this Total Rewards Calculator to see the total value of our competitive benefits package!
  • Several flex spending accounts: medical, dependent care, commuter, parking and High Deductible Health Savings.
  • Well Wisconsin Wellness Program
  • A free and confidential employee assistance program that offers employees and their immediate family dependents a variety of tools, resources, and professional consultation services to support their health, goals, and overall well-being.
  • Public Service Loan Forgiveness Program employer., The starting pay is between $37.00-$42.75 per hour (approximately between $76,900-$88,900 per year) depending on qualifications, plus excellent benefits. A 12-month probationary period is required.

About the company

This position can work remotely up to 5 days per week but is required to report to the Madison office at 201 E. Washington Ave. occasionally to complete certain tasks such as quarterly in-person OGM staff meetings and onboarding. The position can be headquartered at one of our central or regional offices.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…