Job ID: VA-631260 (99590710)
SSRS Developer with SQL, Report Developer/Builder and Workstream (must) experience
Location: Chesterfield, VA (Chesterfield County)
Duration: 6 months
Interview: Phone only (local candidates only)
SKILLS /EXPERIENCE Required:
Microsoft SQL Queries Required 5 Years
Microsoft SQL Server Reporting Service (SSRS) Required 5 Years
Microsoft SSRS Report Developer Required 5 Years
Microsoft SSRS Report Builder Required 5 Years
Workstream experience Required
Prior work experience as a Report Lead Required
*please submit only senior level candidates with prior Workstream Lead experience
1) The Reports Workstream Lead will work primarily remotely via Microsoft Teams to collaborate with project team members.
a) Once safety requirements are lifted with COVID-19 precautions, the role will report to Chesterfield government complex as required for meetings and collaboration.
b) Travel and daily expenses will not be reimbursed
c) The County will provide necessary network, system, calendaring and computer access to perform in this role.
d) The role must have high-speed internet access to perform their duties effectively.
2) Reporting Lead: Leadership and Business Analytics
a) Lead a project Reporting work stream for a team of 7 departments. Oversee inventory tracking of reports to be created in preparation of a fall 2020 go-live of an enterprise land management system – Accela.
b. Schedule work session via Microsoft Outlook
c. Provide work stream progress and issue status updates in work stream lead meetings
i) Online references outlining Accela reporting management:
(1) https://av.accela.com/docs/ConceptsGuide/1-understandingReporting.html
(2) https://av.accela.com/docs/AdministratorGuide/1-settingUpReport.html
b) Work with 3rd party implementer to model report intake process, testing and completion process.
i) Business users will be required to complete an inventory of needed reports.
ii) Business users will be required to complete individual report design specification forms.
iii) Business users will prioritize reports for go-live and post go-live readiness.
iv) Report creation work will be shared with 3rd party implementer up to a maximum pre-allocated hours by the 3rd party implementer. The balance of a larger portion of reports will be the responsibility of the Reporting Lead to complete.
c) Primary workload for the Report Lead will be to work hands-on to create Microsoft SQL Server Reporting Service (SSRS) reports and managing report security
i) Report creation performance will continue past go-live of the system to complete reports prioritized to be in place in the weeks/months following this milestone.
ii) Reports for the purposes of this project are any output from the system the results in formatted artifact.
(1) These artifacts can include dynamic email correspondence, applications, letters, forms, reports for meetings and to departmental daily, monthly or quarterly reports, etc.
iii) Work with the County IST Data Services manager to establish protocols and quality standards that will be subscribed to in the creation of reports in keeping with County standards.
d) The report lead will conduct a mutually determined number of training sessions to train 20-25 business users in the use of two SSRS report creation tools.
i) Facilitate the growth of knowledge and use of SSRS Report tools working with the Azure hosted, Accela platform and other Azure hosted County data mart as well as other internal
ii) Users will need to be trained in one or both SSRS report creation products:
(1) SSRS Report Designer (for anyone to use other existing reports to create new ones, modify an existing report, create simpler reports. Runs from web browser)
(2) SSRS Report Builder (for advanced report creators, but who are not programmers or software coders. Installs stand-alone.
(3) Business users will not be equipped with Visual Studio that is traditionally used by developers or coders in the County. This Reporting Lead role may be equipped with this suite if necessary.
e) Where necessary, the Report Lead will guide the business to refine requirements in areas where specificity is required to ensure the resulting requirements are testable.
f) Work with the project manager to identify and prioritize gaps in the performance of the workstream to delivery prioritized reports managed under the Reports Work Stream.
g) Work with the report SMEs assigned to the Reports work stream to establish baseline measures and update intake and completion targets for report definition, development and testing.
h) Participate in Work Stream Lead meetings to participate in discussion and provide updates on the progress and risks for the Reports Work Stream.
Leave a Reply