Program Manager I​/Business Intelligence Analyst

Are you motivated to conduct testing and create change? Do you have what it takes to evaluate business processes, anticipate requirements, uncover areas for improvement, and develop and implement solutions? If so, then we may have the job for you! We are seeking an experienced Business Intelligence Analyst to join our team. The SCDMV helps maximize value through vendor relationships and ensures our internal and external business partners have the tools they need to succeed.

If you're ready to take your career to the next level and gain valuable experience,

• Designs, develops, maintains, and enhances agency reports, dashboards, and business intelligence solutions using Power BI and other reporting tools. Develops data models, calculations, and visualizations to present information accurately and effectively. Monitors existing reporting solutions and implements improvements to functionality, usability, and performance.
• Develops and maintains SQL queries to extract, transform, and analyze information from agency databases and other approved data sources. Evaluates data structures, performs calculations and prepares datasets to support reporting and analytical requirements. Identifies trends, patterns, and discrepancies to provide meaningful insights into agency operations and performance.
• Collaborates with agency business units and stakeholders to identify reporting requirements, understand business processes, and develop analytical solutions to meet agency needs. Communicates analytical findings and provides guidance to support informed business decisions.
• Validates the accuracy, completeness, and consistency of information used in agency reporting. Performs quality assurance testing, reconciles reporting results against source data, and investigates discrepancies. Coordinates with IT and subject matter experts to resolve data quality issues.
• Provides ongoing support and maintenance for existing reporting solutions. Maintains documentation of reporting methodologies, data sources, business rules, and calculations. Identifies opportunities to improve processes and supports compliance with agency's data governance requirements.
• Performs other duties as assigned.

• A bachelor's degree and relevant program experience. An equivalent combination of education and relevant experience may be accepted with prior approval.

• Must complete a nationwide criminal background check to include finger printing.

• Knowledge of SQL, relational databases, data analysis, and business intelligence concepts.
• Ability to develop reports and dashboards, validate data accuracy, interpret business requirements, troubleshoot discrepancies, and communicate findings effectively.
• Strong analytical, problem-solving, and organizational skills. Microsoft Certified:
  Power BI Data Analyst Associate (PL-300), CBIP, or CAP certification preferred.
• Under limited supervision, exercises independent judgement in analyzing data, developing reporting solutions, and resolving technical issues.
• Works within established agency policies and procedures, referring complex or sensitive matters to the manager.
• Work is performed primarily in an office environment with prolonged computer use.
• Requires collaboration with agency staff and occasional extended hours to meet operational needs.
• Limited travel may be required.

• Experience with SQL query development, Power BI reporting, relational databases, and data analysis.
• Microsoft Certified:
  Power BI Data Analyst Associate (PL-300), CBIP, or CAP certification…