Program Manager I / Business Intelligence Analyst - 195068

Doc PersonalBeratung GmbH; South Carolina; On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health, dental, vision insurance

Vacation leave (15 days)

Sick leave (15 days)

Paid holidays (13)

State retirement plan

Employee Assistance Program

Job summary

The South Carolina DMV (SCDMV) is seeking an experienced Business Intelligence Analyst to design, develop, and maintain reports and dashboards using Power BI, modeling data and creating visualizations to present information clearly for agency decision‑makers.

The role involves writing SQL queries, evaluating data sources, collaborating with business units to define requirements, validating data accuracy, and maintaining documentation of methodologies.

Qualifications

• Bachelor's degree or equivalent plus relevant experience.
• Knowledge of SQL, relational databases, data analysis, and BI concepts.
• Ability to develop reports and dashboards, validate data accuracy, and communicate findings.

Responsibilities

• Design, develop, and maintain reports, dashboards, and BI solutions with Power BI.
• Develop SQL queries to extract and analyze data from agency sources.
• Collaborate with business units to identify requirements and translate them into analytic solutions.

Skills

SQL

Data analysis

BI concepts

Power BI

Education

Bachelor's degree

Tools

Power BI

SQL

Job description

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

So what are you waiting for?

Come be a part of a fast-growing, dynamic agency, and join a team that offers an opportunity for challenging and rewarding career!

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.