Reporting/Analytics Consultant

Capio Group•Sacramento, CA

22h•$100,000 - $115,000•Remote

About The Position

Capio Group is looking for an experienced Reporting/Analytics Consultant! Full-time employee - Remote Salary: $100,000 - $115,000 About Us: Capio Group is a California-based Information Technology Consulting firm serving the public sector since 2010. We assist the Government in delivering large, complex systems and solutions. Capio Group is a small, but quickly growing firm that mixes good ideas, with great people, to achieve extraordinary results for our clients. We offer the salary and benefits of the bigger companies, with the added bonus of a flexible workplace and a great work-life balance. Scope of Work: Capio Group is looking for an experienced Reporting/Analytics Consultant to work as a part of the team to enhance the client's existing systems into a single solution by integrating a centralized database system. This integrated solution will eliminate duplicate and redundant data systems which would improve the tracking, regulation of licensing, compliance, and laboratory activities. The centralized system would streamline services for consumers, support more robust reporting, such as real-time tracking of applicant, licensee and compliance performance measures, trend analysis to inform policy development, and data-driven adjustments to business processes that increase efficiency and accountability. A centralized system would strengthen the client oversight by increasing operational efficiency, supporting evidence-based decision-making, improving customer service, and accelerating regulatory responsiveness. The Reporting/Analytics Consultant will be responsible for tasks including but not limited to: Perform all tasks within the Technical Team during the development, implementation, and maintenance and operations of the client’s solution. Management of Reports Requirements and Reports Specifications Enterprise Reporting Framework and Reporting Platform, Architecture Improvements. Design and development of Business Intelligence reports and dashboards. Provide data and technology support necessary to enable the client to meet related business objectives. Will ensure the timely creation of reports to meet various business needs, as well as assist in batch file testing, defining processes, standards, and best practices in reports development. Helping the client establish an enterprise reporting framework that aligns with other areas of the overall enterprise architecture. Provide a plan detailing the data flow, and tools necessary to maintain data quality standards and synchronicity with the systems. Defect and incident management similar to Information Technology Infrastructure Library (ITIL) methodology. Security monitoring, assessments, and variance management. Testing and development as it relates to interfaces meeting set standards and requirements. System or environment monitoring and reporting for uptime agreements and useful metrics. Data governance, publishing, and analysis on an ongoing or ad-hoc basis. Technical Knowledge Transfer to client staff and other/Additional Administrative Tasks.

Requirements

Within the last ten (10) years, must have a minimum of five (5) years of experience as a data analyst or in other quantitative analysis or related disciplines, such as researcher, data engineer or BI analyst.
Must possess a Bachelor’s Degree. Additional qualifying experience may be substituted for the required education on a year-for-year basis. A copy of the degree must be provided upon request.
Within the last ten (10) years, must have a minimum of five (5) years of working with enterprise reporting and analytics.
Within the last ten (10) years, must have a minimum of two (2) years of hands-on experience with Google Cloud Platform (BigQuery, Looker, Data Studio).
Must possess Google Cloud Data Engineer or Analytics certifications. A copy of the certification must be provided upon request. May not be substituted with additional experience. A copy of the certification must be provided upon request.
Within the last ten (10) years, must have a minimum one (1) year of experience with Accela Civic Platform or Accela licensing and enforcement modules.
Must be able to provide a client/user end reference contact information for each applicable project meeting the requirements upon request in the qualification form. In addition, you must be able to submit completed reference forms when requested. Each reference form must be signed by the referenced individual. The reference contact must be a representative of the company for which the project was developed and must have served in a management or supervisory role.

Nice To Haves

Within the last ten (10) years, ability to work with data from COTS platforms (e.g., Accela) and integrated systems.
Within the last ten (10) years, experience designing dashboards for regulatory, compliance, or enforcement reporting.
Possession of any SQL / data visualization credentials. A copy of the credentials must be provided upon request.

Responsibilities

Perform all tasks within the Technical Team during the development, implementation, and maintenance and operations of the client’s solution.
Management of Reports Requirements and Reports Specifications Enterprise Reporting Framework and Reporting Platform, Architecture Improvements.
Design and development of Business Intelligence reports and dashboards.
Provide data and technology support necessary to enable the client to meet related business objectives.
Will ensure the timely creation of reports to meet various business needs, as well as assist in batch file testing, defining processes, standards, and best practices in reports development.
Helping the client establish an enterprise reporting framework that aligns with other areas of the overall enterprise architecture.
Provide a plan detailing the data flow, and tools necessary to maintain data quality standards and synchronicity with the systems.
Defect and incident management similar to Information Technology Infrastructure Library (ITIL) methodology.
Security monitoring, assessments, and variance management.
Testing and development as it relates to interfaces meeting set standards and requirements.
System or environment monitoring and reporting for uptime agreements and useful metrics.
Data governance, publishing, and analysis on an ongoing or ad-hoc basis.
Technical Knowledge Transfer to client staff and other/Additional Administrative Tasks.