What are the responsibilities and job description for the Business Intelligence Architect/Developer position at Expedite Technology Solutions LLC?
Section 1.0 Project Overview
1.1.The Colorado Department of Education (hereafter referred to as CDE or the Department or the State) is contracting uWork.com, Inc. dba *** (the Contractor), 200, Walker Ave St. SW, Atlanta GA, 30313, to provide a Business Analyst to support the Information Management Services and Accountability and Continuous Improvement teams to assess and improve the processes and code used by the Accountability Division to produce District and State Performance Framework reports (DPF and SPF, respectively).
1.2.This role will involve reviewing the existing data environment, processes, and collaborating with program staff to better understand business processes and technical needs. The ideal candidate will have a strong technical background, specifically in data analysis and coding, along with excellent communication skills to bridge the gap between technical and non-technical stakeholders.
1.3.The primary responsibility will be production of comprehensive technical business requirements and data processing documentation, for the purpose of supporting development and maintenance of Accountability DPF and SPF Reporting infrastructure and processes. The incumbent is expected to be technically self-sufficient and be able to navigate the data environment without technical support.
1.4.The Contractor may be asked to work with associated systems and programs including Oracle, Toad, Informatica, Tableau, and coding languages including SQL, Python, and R.
2.3. The Contractor shall work closely and collaboratively with the Department's Information
Management Services division (IMS) about Department coding standards, configuration
management controls, quality assurance processes and information security. Additionally,
collaboration is expected with IMS's business intelligence unit for any planned transition
of data to, storing of data within, or reporting of data from the Department's Data
Warehouse.
2.4.The Contractor shall coordinate and prioritize all work to ensure that all Deliverables and
Deadlines (as defined below in this Statement of Work (SOW)) are met.
2.5.The Contractor shall employ an internal quality control process to ensure that all
Deliverables are complete, accurate, easy to understand, and of high quality.
2.6.The Contractor shall provide Deliverables that, at a minimum, are responsive to the specific
requirements, organized into a logical order, contain no spelling or grammatical errors,
formatted uniformly, and contain accurate information and correct calculations.
2.7.Contractor shall submit each Deliverable to the Departments Project Managers for review
and approval.
2.8.The Contractor shall retain all work papers generated for reference through the duration of
the project and project acceptance.
2.9.The Contractor shall participate in the review and revision process, until the Department
provides written acceptance of the Deliverable.
2.10. Upon request by the Department, within five (5) days of the request, the Contractor
shall provide copies of any supporting documentation to the Department without
charge.
2.11. The Contractor shall respond to all telephone calls, voicemails, and e-mail inquiries
from the Department within one (1) Business day of receiving such calls, voicemails,
or email inquiries.
2.12. The Contractor shall enable all Contractor staff to exchange documents and electronic
files with the Department staff in formats compatible with the Departments systems.
The Department currently uses Microsoft Office 365 for PC.
Section 5.0 Project Requirements
5.1.Code and Data Review:
5.1.1. Review and analyze the current data processes and code used to generate State
Performance Framework (SPF) reports.
5.1.2. Identify inefficiencies, inconsistencies, or errors in the code and data flow.
5.1.3. Collaborate with technical teams to assess and improve data extraction, transformation,
and loading (ETL) processes.
5.1.4. Provide recommendations for enhancing the codebase for optimal performance and
accuracy in report generation.
5.2.Business Process Mapping And Documentation
5.2.1. Engage with program staff to understand and document the business and processes involved in generating state performance framework reports.
5.2.2. Document business rules associated with production of state performance framework reports.
5.2.3. Create process maps and workflows to illustrate current practices and identify areas for improvement.
5.2.4. Ensure alignment between business requirements and technical solutions by gathering and analyzing user needs.
5.3.Requirements Gathering And Documentation
5.3.1. Lead sessions with program staff, subject matter experts, and technical teams to gather, clarify, and document business and technical requirements.
5.3.2. Translate business requirements into functional specifications for data and reporting systems.
5.3.3. Maintain comprehensive documentation for current and future state business processes, ensuring that all stakeholders have a clear understanding of the project scope and deliverables.
5.4. Collaboration And Stakeholder Management
5.4.1. Serve as a liaison between technical teams and business units, ensuring effective communication and collaboration.
5.4.2. Facilitate meetings with program staff and stakeholders to review requirements, share findings, and propose improvements.
5.4.3. Support ongoing communication efforts to ensure alignment of project goals with business objectives.
1.1.The Colorado Department of Education (hereafter referred to as CDE or the Department or the State) is contracting uWork.com, Inc. dba *** (the Contractor), 200, Walker Ave St. SW, Atlanta GA, 30313, to provide a Business Analyst to support the Information Management Services and Accountability and Continuous Improvement teams to assess and improve the processes and code used by the Accountability Division to produce District and State Performance Framework reports (DPF and SPF, respectively).
1.2.This role will involve reviewing the existing data environment, processes, and collaborating with program staff to better understand business processes and technical needs. The ideal candidate will have a strong technical background, specifically in data analysis and coding, along with excellent communication skills to bridge the gap between technical and non-technical stakeholders.
1.3.The primary responsibility will be production of comprehensive technical business requirements and data processing documentation, for the purpose of supporting development and maintenance of Accountability DPF and SPF Reporting infrastructure and processes. The incumbent is expected to be technically self-sufficient and be able to navigate the data environment without technical support.
1.4.The Contractor may be asked to work with associated systems and programs including Oracle, Toad, Informatica, Tableau, and coding languages including SQL, Python, and R.
2.3. The Contractor shall work closely and collaboratively with the Department's Information
Management Services division (IMS) about Department coding standards, configuration
management controls, quality assurance processes and information security. Additionally,
collaboration is expected with IMS's business intelligence unit for any planned transition
of data to, storing of data within, or reporting of data from the Department's Data
Warehouse.
2.4.The Contractor shall coordinate and prioritize all work to ensure that all Deliverables and
Deadlines (as defined below in this Statement of Work (SOW)) are met.
2.5.The Contractor shall employ an internal quality control process to ensure that all
Deliverables are complete, accurate, easy to understand, and of high quality.
2.6.The Contractor shall provide Deliverables that, at a minimum, are responsive to the specific
requirements, organized into a logical order, contain no spelling or grammatical errors,
formatted uniformly, and contain accurate information and correct calculations.
2.7.Contractor shall submit each Deliverable to the Departments Project Managers for review
and approval.
2.8.The Contractor shall retain all work papers generated for reference through the duration of
the project and project acceptance.
2.9.The Contractor shall participate in the review and revision process, until the Department
provides written acceptance of the Deliverable.
2.10. Upon request by the Department, within five (5) days of the request, the Contractor
shall provide copies of any supporting documentation to the Department without
charge.
2.11. The Contractor shall respond to all telephone calls, voicemails, and e-mail inquiries
from the Department within one (1) Business day of receiving such calls, voicemails,
or email inquiries.
2.12. The Contractor shall enable all Contractor staff to exchange documents and electronic
files with the Department staff in formats compatible with the Departments systems.
The Department currently uses Microsoft Office 365 for PC.
Section 5.0 Project Requirements
5.1.Code and Data Review:
5.1.1. Review and analyze the current data processes and code used to generate State
Performance Framework (SPF) reports.
5.1.2. Identify inefficiencies, inconsistencies, or errors in the code and data flow.
5.1.3. Collaborate with technical teams to assess and improve data extraction, transformation,
and loading (ETL) processes.
5.1.4. Provide recommendations for enhancing the codebase for optimal performance and
accuracy in report generation.
5.2.Business Process Mapping And Documentation
5.2.1. Engage with program staff to understand and document the business and processes involved in generating state performance framework reports.
5.2.2. Document business rules associated with production of state performance framework reports.
5.2.3. Create process maps and workflows to illustrate current practices and identify areas for improvement.
5.2.4. Ensure alignment between business requirements and technical solutions by gathering and analyzing user needs.
5.3.Requirements Gathering And Documentation
5.3.1. Lead sessions with program staff, subject matter experts, and technical teams to gather, clarify, and document business and technical requirements.
5.3.2. Translate business requirements into functional specifications for data and reporting systems.
5.3.3. Maintain comprehensive documentation for current and future state business processes, ensuring that all stakeholders have a clear understanding of the project scope and deliverables.
5.4. Collaboration And Stakeholder Management
5.4.1. Serve as a liaison between technical teams and business units, ensuring effective communication and collaboration.
5.4.2. Facilitate meetings with program staff and stakeholders to review requirements, share findings, and propose improvements.
5.4.3. Support ongoing communication efforts to ensure alignment of project goals with business objectives.
