Program Manager I / Business Intelligence Analyst - 195068 — Blythewood, SC

Job Responsibilities

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, apply today!

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

Minimum and Additional 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.

Preferred Qualifications

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.

Additional Comments

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 YDp8f eBVeb8Sp dFd 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

• MCR6e uxytQxx3Xn 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

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 F7VFnW without the need for employer sponsorship, now or at any time in the future.

Benefits For negGv dVz95ZxUx

The rgTtf ym cmRSB HyvazsNX offers eligible employees generous benefits, including health and dental insurance; retirement and savings plan options; and paid vacation and sick leave. Plus, work-life balance programs such as telecommuting and flexible work schedules are available to employees of some state agencies.

Insurance Benefits

Eligible employees may enroll in health insurance, which includes prescription coverage and wellness benefits. Other available insurance benefits include dental, vision, term life insurance, long term disability and flexible spending accounts for health and child care expenses.

Retirement Benefits

5FTTX employees are also offered retirement plan options, including defined benefit and defined contribution plans. Additionally, eligible employees may elect to participate in the QTQNh QE9q77Bn cjRCb7pt Compensation Program, which is a voluntary, supplemental retirement savings plan offering 401(k) and 457 plan options.

Workplace Benefits

5FTTX employees may also be eligible for other benefits, including tuition assistance; holiday, annual and sick leave; and discounts on purchases, travel and more.

Note: The benefits above are available to most state employees, with the exception of those in temporary positions. Employees in temporary grant and time-limited positions may be eligible for all, some or none of these benefits as benefits are associated with each position type. For these positions, contact the hiring agency to determine what benefits may be available.

01

I understand that any misrepresentation, falsification, or material omission of information or data may result in exclusion from further consideration or, if hired, termination of employment. By answering “yes” I agree that I have read each question carefully and affirm or attest that all questions answered are true and accurate.

• Yes

02

I acknowledge that if I am deemed eligible for this position, I must complete a Pre-Employment Hiring Assessment.

• Yes

• No

03

I acknowledge this assessment will be sent to the email address I have provided and will fully commit to the time and attention required to complete this assessment realizing that the approximate time to complete this assessment may be up to 25 minutes.

• Yes

• No

04

Do you have a bachelor's degree and relevant program experience? An equivalent combination of education and relevant experience may be accepted with prior approval.

• Yes

• No

05

If the answer to the above question is "Yes", please detail your education and explain your experience.

06

If you answered "No" to the above question, please describe how your education and experience are relevant to this position and meets the requirements of this job.

07

This is an onsite position based in Blythewood, SC. If hired, are you able to commute to the worksite daily?

• Yes

• No

08

This position has a salary of $84,500.00 and is nonnegotiable. Will you accept this salary if offered this position? (Internal Candidates will retain performance retention increases in accordance with the agency pay policy).

• Yes

• No

09

Will you be able to work the hours of 8:30 a.m. - 5:00 p.m. Monday through Friday?

• Yes

• No

10

Are you willing to work extended hours outside of the normal scheduled work week and be subject to overnight state wide travel?

• Yes

• No

11

Describe a situation where you translated a business requirement into a report, dashboard, or analytical solution. What was your approach, and how did you ensure the final product met the business need?

12

Do you have experience writing and troubleshooting SQL queries to extract, join, and analyze data from relational databases?

• Yes

• No

13

If so, please list the database, business intelligence, and data analysis tools you have used, including your level of proficiency with each.

14

Do you have experience developing and maintaining Microsoft Power BI reports or dashboards, including data modeling, Power Query, or DAX calculations?

• Yes

• No

15

If the answer to the above question is "Yes", please explain.

16

Do you have experience analyzing large datasets to identify trends, patterns, discrepancies, and opportunities for operational improvement?

• Yes

• No

17

If the answer to the above question is "Yes", please describe a project where you analyzed data, explain the tools or methods used, and how your findings supported business decisions.

18

Do you have experience validating and reconciling data from multiple sources to ensure accuracy, completeness, and consistency of reports?

• Yes

• No

19

Describe your experience working with business stakeholders to gather reporting requirements and translate them into reports, dashboards, or other analytical solutions.

20

Do you have a valid driver's license? If yes, please provide the license number and the state in which the license was issued. (Example DL#987654321 / RCmyv J4vz96: Georgia)

21

Please enter your name exactly as it appears on your Social Security Card.

22

Are you currently a SCDMV employee?

• Yes

• No

23

Have you worked previously for the DMV or another Qp85t kaXuPQ?

• Yes, DMV

• Yes, another Qp85t kaXuPQ

• No

24

If the answer to question #22 or #23 is "Yes", please include what agency, what state, what facility, what department, address/location, current/former reporting manager, dates of employment, job title, job responsibilities/duties, reason for leaving. (If No, put N/A)

25

Do you wish to claim Veteran Preference? If yes, you must submit a copy of your DD Form 214 (Member Page 4 or Service Copy 2) with your job application in order to qualify and claim this preference.

• Yes

• No

• Required Question