Business Intelligence Developer
Logo 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 - $60,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
The University of South Carolina System is comprised of the state's flagship university in Columbia (founded in 1801 and currently one of the top 50 "Best Colleges" according to U.S. News and World Report), three regional comprehensive universities (USC Aiken, USC Beaufort and USC Upstate), and Palmetto College consisting of four two-year campuses (USC Lancaster, USC Salkehatchie, USC Sumter, USC Union and Fort Jackson/Extended University). Together, the USC System institutions offer more than 450 degree programs on campus and online and are uniquely positioned to meet the state's educational, cultural, health and research needs. The System employs nearly 14,000 people who work daily to improve the lives of students, fellow South Carolinians and the world. Our diverse engaged faculty and staff enjoy a dynamic and intellectually stimulating work environment.
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.
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 10/02/2017 Job Close Date 10/23/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.
Hazardous weather category Non-Essential Safety Sensitive or Security Sensitive No
Required fields are indicated with an asterisk (*).
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
Are you able to travel overnight to conferences, work evenings, and weekends as required by this position?
- no response
Tell us about your knowledge of reporting/dashboard tools like Power BI, Tableau, and Qlik.
(Open Ended Question)
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)
- Cover Letter
- List of References and Contact Information