Program Manager I / Business Intelligence Analyst - 195068

State-of-South-Carolina; South Carolina; On-site; USD 60,000 - 90,000; Full time

Benefits offered by this job

Health insurance

Vacation leave

Sick leave

Paid holidays

State Retirement Plan

Employee Assistance Program

Job summary

The State of South Carolina's SCDMV seeks a Business Intelligence Analyst to design and maintain dashboards and BI solutions using Power BI, develop data models, and monitor reporting performance. Blythewood, SC-based position with strong collaboration across agency teams.

You will write SQL queries, analyze data from agency databases, and work with business units to define requirements, validate data quality, and document reporting methodologies to support governance and compliance.

Qualifications

• Bachelor's degree in a relevant field.
• Experience in government or large organizations preferred.
• Strong analytical and problem-solving skills.

Responsibilities

• Designs, develops, maintains, and enhances agency reports and BI solutions using Power BI.
• Develops SQL queries to extract, transform, and analyze information from databases.
• Collaborates with agency units to identify reporting requirements and deliver analytical solutions.
• Validates data accuracy, performs QA, and reconciles results with source data.
• Provides ongoing support and documents reporting methodologies and data sources.
• Performs other duties as assigned.

Skills

SQL

Relational databases

Data analysis

Power BI reporting

Dashboard development

Education

Bachelor's degree

Tools

Power BI

SQL Server

Data visualization tools

Job description

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,

This position is in the Business Intelligence Office, at SCDMV Headquarters, Blythewood, SC

Responsibilities of the Business Intelligence Analyst

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

The South Carolina DMV offers a robust and competitive benefits program.

• 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)
• Employee Assistance Program (EAP) at no cost to the employee or members of their household

Additional comments

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.

Supplemental questions are considered part of your official application. Any misrepresentation will result in your disqualification from employment. Please complete the state application to include all current and previous work history and education.

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.