BI Program Manager | Power BI & SQL

South Carolina Department of Motor Vehicles; Columbia (SC); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health, dental, vision insurance

Vacation and sick leave

State retirement plan

Employee Assistance Program (EAP)

Job summary

The South Carolina Department of Motor Vehicles (SCDMV) is seeking a Business Intelligence Analyst to design, develop, and maintain Power BI dashboards and BI solutions. The role involves building data models, writing SQL, and collaborating with agency units to translate requirements into analytical deliverables.

You will validate data accuracy, support governance, and contribute to performance improvements while working in an office environment with potential extended hours to meet operational

Qualifications

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

Responsibilities

• Designs, develops, maintains, and enhances agency reports, dashboards, and BI solutions using Power BI and other tools.
• Develops and maintains SQL queries to extract, transform, and analyze information from agency databases and other sources.
• Collaborates with agency business units and stakeholders to identify reporting requirements and develop analytical solutions.
• Validates data accuracy, completeness, and consistency in agency reporting; coordinates with IT to resolve data quality issues.
• Provides ongoing support and maintenance for reporting solutions and documents methodologies and data sources.
• Performs other duties as assigned.

Skills

Analytical skills

Problem solving

Organizational skills

Communication

Data interpretation

Education

Bachelor's degree

Power BI Data Analyst Associate (PL-300)

CBIP

CAP certification

Tools

Power BI

SQL

Relational databases

Job description

The South Carolina Department of Motor Vehicles (SCDMV) is seeking a Business Intelligence Analyst to design, develop, and maintain Power BI dashboards and BI solutions. The role involves building data models, writing SQL, and collaborating with agency units to translate requirements into analytical deliverables.

You will validate data accuracy, support governance, and contribute to performance improvements while working in an office environment with potential extended hours to meet operational