Business Intelligence Developer



Posting Details
Posting Summary


Posting Number STA00037PO17 Classification Title Systems Programmer/Developer II Internal Title Business Intelligence Developer Campus Columbia 01 College/Division Division of Development Department Development Office Band 6 Advertised Minimum Salary $44,056 Advertised Salary Range $44,056 - $70,000 Location of Vacancy Part/Full Time Full Time Hours per week 37.5 Work Schedule

37.5 hours per week. Monday to Friday, 8:30 am to 5:00 pm. May be required to work evenings, weekends, and travel occasionally to conferences for continued training and professional development.

Type of Staff Position Full-time Equivalent (FTE) Basis 12 months Job Search Category Information Technology

About UofSC

The University of South Carolina is a premiere flagship research institution in South Carolina and one of the top 50 “Best Colleges” according to U.S. News and World Report. With more than 46,000 students on eight campuses, the University of South Carolina is a leader in improving the lives of individuals in South Carolina and around the world. Founded in 1801, the University of South Carolina employs almost 14,000 people. At the University of South Carolina, our employees include some of the brightest minds and most accomplished professionals in the world. The diversity of thought and active engagement of our colleagues makes for a dynamic and interesting work environment. The University has been named a best place to work, and a big part of that is the people. Our diverse faculty and staff embody a dedication to serve our students, so that a job becomes a passion with no limits.



Benefits for Temporary Positions

The University of South Carolina (UofSC), through the State of SC and Public Employee Benefit Authority (PEBA), offers state employees a valuable benefits package, including health and life insurance, generous paid leave and retirement programs. To learn more about UofSC benefits, navigate here: http://sc.edu/about/offices_and_divisions/human_resources/benefits/index.php.



Position Description

Advertised Job Summary

Under general supervision, reporting to the Director of Data Services, the Business Intelligence Developer is responsible to document, design, develop, test and implement complex reporting, scripts, bulk loads, extracts and other software solutions to new or existing systems according to project plans, business requirements and specifications. Works collaboratively with business users verbally and through written communications to understand and translate reporting objectives and business requirements into technical specifications, report design and code. Writes code that is traceable to business requirements, design and technical specifications. Works with the Director of Data Services to analyze and investigate complex reporting requirements and coordinates with requesters to clarify details of the reporting request. Uses SQL or MDX/DAX to develop logic for the requested reports. Designs solutions using Microsoft BI stack (SSIS, SSAS, SSRS) or Power BI to publish on central SharePoint site. Works closely with Director of Data Services, peers and Line of Business (LOB) managers to verify quality of report produced. Consults requester on report definition, collaborates on accuracy of the work performed compared to the requirements delivered.

Minimum Qualifications (Classified and Unclassified positions)

Bachelor's degree in Information Technology Systems or related field and 3 years related experience; or equivalency.
Experienced application level knowledge of capabilities, programming techniques, and intricacies of information systems. This position is required to travel overnight to conferences, work evenings and weekends.

Preferred Qualifications

Bachelor's degree and a minimum of 3 years of technical development experience, preferably in nonprofit or higher education. Graduate degree is preferred. Proven experience assisting with technical management of an applications portfolio i.e., ability to translate operational technical needs into complete, deliverable solutions and ensure client acceptance. Enterprise CRM experience is preferred, familiarity with Millennium donor database or other nonprofit and/or higher education is a plus. Microsoft certifications in SQL and/or SharePoint.

Complex MSSQL/T-SQL (stored procedures, views, queries)
Design and development experience using Microsoft's Business intelligence stack preferred (SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and SharePoint.

Knowledge of other reporting/dashboards tool like Power BI, Tableau and Qlik.

Knowledge/Skills/Abilities

Candidate should possess professional level experience leading BI application development, BI solution support and good understanding of Advancement CRM and Donor Management System in Higher Education Institution Advancement/ Development environment.
Ability to handle multiple, simultaneous tasks, and excellent attention to detail. Excellent analytical skills required. Ability to travel overnight to conferences, work evenings and weekends, as required.



Posting Detail Information

Number of Vacancies 1 Desired Start Date 09/01/2017 If Research Grant/Time Limited, give end date Job Open Date 07/12/2017 Job Close Date 08/13/2017 Open Until Filled No Special Instructions to Applicant Quicklink for Posting http://uscjobs.sc.edu/postings/16630 EEO Statement

The University of South Carolina does not discriminate in educational or employment opportunities on the basis of race, color, religion, national origin, sex, sexual orientation, gender, age, disability, veteran status or genetics.



Position Attributes

Hazardous weather category Non-Essential Safety Sensitive or Security Sensitive No

Supplemental Questions

Required fields are indicated with an asterisk (*).

  1. * As part of meeting the minimum qualifications for this position, do you have a bachelor's degree in Information Technology Systems or related field, and 3 years related experience; or equivalency?
    • no response
    • Yes
    • No
  2. * Are you able to travel overnight to conferences, work evenings, and weekends as required by this position?
    • Yes
    • No
    • no response
  3. * Tell us about your knowledge of reporting/dashboard tools like Power BI, Tableau, and Qlik.

    (Open Ended Question)

  4. * Tell us about your work as it relates to experienced application level knowledge of capabilities, programming techniques, and intricacies of information systems.

    (Open Ended Question)



Applicant Documents
Required Documents
  1. Cover Letter
  2. Resume
  3. List of References and Contact Information
Optional Documents

    PI98657406