Program Manager I / Business Intelligence Analyst - 195068

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 SCDMV helps maximize value through vendor relationships and ensures our internal and external business partners have the tools they need to succeed. This position is in the Business Intelligence Office, at SCDMV Headquarters, Blythewood, SC.

Job Responsibilities

• 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.

Minimum Requirements

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

Agency Requirements

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

Additional Requirements

• 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.

Agency Preferred

• 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 preferred.

What’s in it for you?

At the SCDMV you get to be part of exceptional team and diverse culture that nurtures mutual success for our customers, employees and our communities. We give you the tools to be successful; all you need to do is bring your best ideas, your energy and a desire to develop your skills, experience and career.

Benefits

• Health, dental, vision, long term disability, and life insurance for employees, spouse and children (also available for temporary employees working over 30 hours per week).
• 15 days annual (vacation) leave per year.
• 15 days sick leave per year.
• 13 paid holidays.
• State Retirement Plan and Deferred Compensation Programs (optional for Temporary Employees).
• An exceptional Employee Assistance Program (EAP) at no cost to the employee or members of their household.

Equal Opportunity Statement

The Department of Motor Vehicles is committed to providing equal employment opportunities to all applicants and does not discriminate on the basis of race, color, religion, sex (including pregnancy, childbirth, or related medical conditions, including, but not limited, to lactation), national origin, age (40 or older), disability or genetic information.

Applicants must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.