Business Intelligence Developer

Position Information

Position Information

Present Position Number FP619W
Role Code Title Prof/Lecturer/11-12Mth
Position Title Business Intelligence Developer
Position Summary

Information Technology (IT) is responsible for providing, promoting, and servicing a modern technology infrastructure for the William and Mary. IT is a service-based organization providing faculty, staff, and students with the necessary tools and resources to maximize the teaching and learning experience. Information Technology provides creative, stimulating, and innovative solutions always in keeping with the William and Mary standards of excellence.

William & Mary invites qualified applicants to apply for the Business Intelligence Developer position to join a dynamic team of IT professionals. The ideal candidate will possess strong analytical and problem-solving skills with the ability develop strategies to support the college needs. The ideal candidate will also have strong interpersonal skills with the proven ability to work collaboratively within a team and interface successfully with business leaders campus wide.


Working with a team of IT professionals, reporting to to the Director of Data Management, the Business Intelligence Developer will develop, implement, and maintain systems and strategies to support the college’s business intelligence, data-driven decision making, and data integration requirements.

Responsibilities include (but not limited to):

  • Participate in the development of business cases and requirements gathering including conducting user interviews, documenting use cases, and ensuring requirements for reporting and visualization needs are met.
  • Employ best practices in developing reporting and business intelligence applications to meet business process needs, and in the on-going maintenance and enhancements of reporting, business intelligence and analytic applications (from ad hoc data discovery to large-scale system implementations).
  • Participate in the assessment, improvement and governance of quality and use of data assets.
  • Participate in data governance and stewardship initiatives to ensure responsibilities for content owners are clearly defined and communicated, data metadata and metrics definitions are clearly documented, and that there is clear understanding among stewards and consumers of data.
  • Design, build, and deliver value-added, high quality reporting, business intelligence, dashboard and analytic solutions.
  • Design, build, and maintain data integrations across cloud and on-premise software systems.
Required Qualifications

Bachelor’s degree in a related field with substantive experience or specialized expertise directly related to the position.


  • Proficiency in SQL, data warehousing, business intelligence tools, reporting tools, or visualization and data discovery tools (e.g, Tableau, Qlikview).
  • Strong analytical and problem-solving skills with the ability develop strategies to support the college needs, troubleshoot software issues as well as support others in problem resolution.
  • Demonstrated research and technical writing skills; with the ability to research new technologies and recommend technical solutions to management.
  • Strong interpersonal and communications skills, with the ability to work collaboratively with team members and effectively support application / database users in a professional manner.
  • Strong organizational skills, with the ability to manage multiple and competing tasks.


  • Experience in data warehousing, business intelligence, and data analytics or applications programming and reporting in a relational database environment.
  • Experience in design, development, implementation of dashboards and BI applications or other web-based database applications.
  • Experience with reporting and data extraction in a relational database environment.
  • Experience with relational databases, APIs, and database programming languages.
Preferred Qualifications


  • Strong understanding of Master Data Management and ETL processing Is highly preferred.
  • Working knowledge of multiple data discovery tools and analytics tools is highly desirable.
  • Working knowledge of QlikSense or QlikView data visualization tools is highly desirable.
  • Data Modeling skills is highly desirable.
  • Knowledge of Salesforce CRM is a plus.


  • Experience implementing or working with Banner or other higher education enterprise-wide system is highly preferred.
  • Experience with large database systems is highly desirable.
  • Experience using Master Data Management tools, advanced analytics tools, or multiple data discovery tools is desirable.
  • Experience using QlikSense, QlikView, or Qlik nPrinting to develop BI applications.
  • Experience with data analysis, trending and KPI development.
  • Experience with ETL processing between on-premise and cloud software solutions.
  • Experience with Oracle Databases and PL/SQL.
  • Experience with ETL processing for Salesforce CRM is a plus.
  • Experience working in a higher education environment is a plus.
Advertised Pay Range Commensurate with experience.
Department IT - 3H7000
Location William & Mary
University Salary Range

Job Open Date 10/27/2017
Review Begin Date
Job Close Date
Open Until Filled Yes
Employment Category Professional FT
Position Term 12-Month
Special Application Instructions
Conditions of Employment:
  • This position is subject to additional hours that extend beyond the typical work hours, to include weekend or holiday work.
  • This position May require occasional overnight travel as needed.

Information Security:

  • This position requires administrative access to the College’s information systems and/or sensitive College data.
  • The incumbent is expected to be aware of and adhere to the Information Security policies of the College as well as all applicable federal, state, and local laws and follow information security best practices applicable to their job area and to pursue information security training and awareness opportunities when possible.
EEO Statement

The College of William & Mary values diversity and invites applications from underrepresented groups who will enrich the research, teaching and service missions of the university. The College is an Equal Opportunity/Affirmative Action employer and encourages applications from women, minorities, protected veterans, and individuals with disabilities.

Background Check Statement

The College of William & Mary is committed to providing a safe campus community. W&M conducts background investigations for applicants being considered for employment. Background investigations include reference checks, a criminal history record check, and when appropriate, a financial (credit) report or driving history check.

Supplemental Question

Required fields are indicated with an asterisk (*).

Supplemental Documents

Required Documents
  1. Resume/Curriculum Vitae
  2. Cover Letter
Optional Documents