Business Intelligence Developer




About Salve Regina University:

Salve Regina University, ranked as one of the most transformative colleges in the United States by Money Magazine and among the best regional universities in the north by U.S. News and World Report, is a comprehensive Catholic University located in the scenic coastal community of Newport, Rhode Island. The University's commitment to academic success and personal discovery extends beyond its historic campus into a dynamic world where the application of higher thinking and skill are most valued. Salve Regina offers associate, bachelor's and master's degree programs, graduate certificates, and doctoral programs in humanities, international relations and nursing. Enrollment includes more than 2,600 undergraduate and graduate students from across the U.S. and around the world.


Job Description:

BASIC FUNCTION:

Design and maintain operational data stores, data warehouse, ETL/ELT, reporting and visualization in support of the University Business Intelligence efforts. Develop integrations using API tools. Supports data quality efforts and assurance testing.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

  • Develop ETL/ELT processes in support of business intelligence reporting
    • Develop pipelines to transport, normalize, aggregate, organize and process data among administrative and reporting systems
    • Identify sources of analytic data within administrative systems
    • Design and test data models and integrations
    • Optimizes ETL/ELT processes
  • Maintenance and administration of the MS SQL Server data repositories and business intelligence infrastructure
  • Ensure quality and integrity of data being imported into the data repositories and support quality assurance efforts
  • Develop integrations for on premise and cloud applications using API tools
  • Adheres to data security and change management best practices


OTHER DUTIES AND RESPONSIBILITIES:

  • Collaborates within IT to identify data issues and makes recommendations to improve data quality, models, and system architecture / performance
  • Documents system procedures, guidelines and program modifications
  • Assists with the creation of data dictionaries, schema documentation and efforts in support of self-service reporting
  • Assists with the development and delivery of ad hoc reports, BI analysis and dashboards
  • Assists with testing of reports and dashboards
  • Identify reporting and BI requirements of University stakeholders
  • Participates in all efforts of the Office of Information Technologies to deliver effective technology solutions to the University community
  • Perform such other related duties that may be assigned


LICENSES, TOOLS, AND EQUIPMENT:

N/A

ENVIRONMENTAL CONDITIONS:

The incumbent is not substantially exposed to adverse environmental conditions.


Requirements:

  • Bachelor's degree in Computer Science, Information Systems, Mathematics or related field
  • A minimum of three years' experience in data analysis, development or related work
  • Expertise in MS SQL Server development, SSIS, SQL query, data manipulation and Enterprise Integration platforms
  • Expertise with ETL / ELT tools
  • Demonstratable knowledge of database design methodologies
  • Experience with data analysis and related reporting and visualization tools such as SAP Business Objects, Tableau, Power BI
  • Demonstratable knowledge of .Net, Javascript, Python, R, Ruby or other programming language
  • Experience with Wherescape Red, Wherescape 3D, Power BI, Ellucian Colleague and or similar system in a higher education environment a plus


Demonstrate the ability to:

  • Exhibit analytical and problem-solving skills
  • Organize and prioritize multiple tasks with the ability to follow each through to resolution
  • Focus on details
  • Demonstrate leadership and initiative as a self-starter
  • Present excellent oral and written communication skills at both the technical and non-technical levels
  • Work effectively as a team member or independently as appropriate
  • Collaborate with administrative users and Information Technologies staff members



Additional Information:

Salve Regina University offers generous benefits to eligible employees including:

  • health and dental coverage
  • life insurance
  • long-term disability
  • 403B plan
  • tuition benefits and more


Salve Regina University strives to provide equal opportunity in employment and education to all employees, students and applicants. No employee, student or applicant shall be discriminated against or harassed on the basis of race, color, national and ethnic origin, sex, sexual orientation, gender identity or expression, religion, disability, age, marital or parental status, military or veteran status, genetic information or any other basis protected by applicable federal or state law, in the administration of Salve Regina's employment policies, education policies, admission policies, scholarship and loan programs, athletic and other University administered programs. In accordance with Title IX, it does not discriminate on the basis of sex in any of its educational programs or activities. Salve Regina is also committed to making its programs and campus accessible to its visitors and compliant with all applicable non-discrimination laws.


Application Instructions:

Applicants must apply online for any open staff and faculty positions by providing a cover-letter and resume. Pre-employment background checks and reference checks are required of successful candidates. Salve Regina University participates in E-verify.

URL: www.salve.edu


Similar jobs

Similar jobs