Database Administrator II (Business Intelligence Developer)

About Our Agency

The South Carolina Department of Disabilities and Special Needs (DDSN) is the state agency that plans, develops, coordinates and funds services for South Carolinians with the severe, lifelong disabilities of:

• intellectual disability and related disabilities
• autism spectrum disorder
• traumatic brain injury
• spinal cord injury and similar disability

We are looking for an experienced and organized Business Intelligence (BI) Developer to be responsible for the upkeep and development of warehouse data to support our Agency's decision support efforts. The Bl Developer builds and maintains a data warehouse design to generate reports on financial and operational intelligence to aid in business performance monitoring and business decision support.

The candidate will be working on designing various analytical reports and dashboards of the agency's data and delivering them to top management and other interested parties.

As a Bl developer, you will be working with business users collecting their requests, and then updating the set of existing Bl reports to accommodate business needs. The Bl developers will be expected to establish company standards and common reporting terminology, and to help align existing and future reporting requests to such standards. The candidate will also be interacting with Business Analyst and Developers whenever data schemas need redesigning to accommodate new reporting requirements.

• Translates business needs to technical specifications
• Designs, builds and deploys Bl solutions using Microsoft Power Bl.
• Maintains and supports data analytics platforms {e.g. Microsoft Power Bl)
• Creates tools to store data {e.g. OLAP cubes)
• Conducts unit testing and troubleshooting
• Evaluates and improves existing Bl systems
• Collaborates with teams to integrate systems
• Develops and executes database queries and conduct analyses
• Creates visualizations and reports for requested projects
• Develops and updates technical documentation
• Provides internal or external Power BI training and/or documentation

A bachelor's degree in computer science or related field and experience in computer system development and modification. Relevant experience may be substituted for bachelor's degree on a year-for-year basis.

Proven experience as a Bl Developer or Database Administrator; Industry experience is preferred; Background in data warehouse design (e.g. dimensional modeling) and data mining; In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework;; Familiarity with Bl technologies (e.g. Microsoft Power Bl)

EEO Statement: SC DDSN provides affirmative action and equal opportunity in employment for all qualified persons regardless of race, color, sex -including the basis of pregnancy, childbirth, or related medical conditions, national origin, age, religion, or disability.

Record Check: Criminal background check will be conducted by SLED, FBI, and DSS Child Registry that indicates no record of conviction, child abuse or neglect. Employment would also be contingent on your passing a pre-employment drug test. DDSN reserves the right to rescind any employment offer in the event our review of your background develops information, including opinions of previous employer or colleagues that cause us to conclude, at our sole discretion, that you are not suited for the position.

Driving Record: If this position requires the applicant to possess a valid driver's license to operate a state vehicle or personal vehicle, any applicant being considered in the final stages of selection for the position will be required to provide a certified copy of a 10-year driving record.

Supplemental Questions: 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. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position.

Employee Referral: The South Carolina Department of Disabilities and Special Needs supports a Referral Incentive Reward and a Retention Bonus program. You may contact Human Resource for further information.

Overtime: Covered nonexempt employees must receive overtime pay for hours worked over 40 per workweek at a rate not less than one and one-half times the regular rate of pay.