Business Intelligence Architect/Developer

Position: Business Intelligence Architect/Developer

Location: Denver, CO – 100% Remote

Duration: Long Term Renewable Contract

Project Overview

This role involves reviewing the existing data environment and processes, collaborating with program staff to better understand business processes and technical needs. The ideal candidate will have a strong technical background in data analysis and coding, along with excellent communication skills to bridge the gap between technical and non-technical stakeholders.

Key Responsibilities

• Produce comprehensive technical business requirements and data processing documentation to support the development and maintenance of Accountability DPF and SPF Reporting infrastructure and processes.
• Work with associated systems and programs, including Oracle, Toad, Informatica, Tableau, and coding languages such as SQL, Python, and R.
• Collaborate closely with the Department's Information Management Services division on coding standards, configuration management controls, quality assurance processes, and information security.
• Coordinate and prioritize work to ensure that all deliverables and deadlines are met.
• Employ an internal quality control process to ensure deliverables are complete, accurate, easy to understand, and of high quality.
• Submit deliverables to the Department's Project Managers for review and approval.
• Participate in the review and revision process until the Department provides written acceptance of the deliverable.
• Respond to all telephone calls, voicemails, and email inquiries from the Department within one business day.
• Enable all staff to exchange documents and electronic files with the Department in formats compatible with the Department's systems.
  
  

Project Requirements

Code and Data Review

• Review and analyze current data processes and code used to generate State Performance Framework (SPF) reports.
• Identify inefficiencies, inconsistencies, or errors in the code and data flow.
• Collaborate with technical teams to assess and improve data extraction, transformation, and loading (ETL) processes.
• Provide recommendations for enhancing the codebase for optimal performance and accuracy in report generation.
  
  

Business Process Mapping and Documentation

• Engage with program staff to understand and document the business and processes involved in generating state performance framework reports.
• Document business rules associated with the production of state performance framework reports.
• Create process maps and workflows to illustrate current practices and identify areas for improvement.
• Ensure alignment between business requirements and technical solutions by gathering and analyzing user needs.
  
  

Requirements Gathering And Documentation

• Lead sessions with program staff, subject matter experts, and technical teams to gather, clarify, and document business and technical requirements.
• Translate business requirements into functional specifications for data and reporting systems.
• Maintain comprehensive documentation for current and future state business processes, ensuring all stakeholders have a clear understanding of the project scope and deliverables.
  
  

Collaboration and Stakeholder Management

• Serve as a liaison between technical teams and business units, ensuring effective communication and collaboration.
• Facilitate meetings with program staff and stakeholders to review requirements, share findings, and propose improvements.
• Support ongoing communication efforts to ensure alignment of project goals with business objectives.
  
  

Job #: 25-27697