University at Albany — Senior Business Intelligence Developer

About University at Albany:
Established in 1844 and designated a University Center of the State University of New York in 1962, the University at Albany’s broad mission of excellence in undergraduate and graduate education, research and public service engages a diverse student body of more than 17,900 students in nine schools and colleges across three campuses.

Located in Albany, New York, New York State’s capital, the University is convenient to Boston, New York City and the Adirondacks.

Job Description:
The Senior Business Intelligence Developer position, reporting to the Manager of Business Intelligence Solutions in Information Technology Services, is responsible for providing support to UAlbany within the Reporting and Analytics service. This position specifically supports the continuously evolving UAlbany Business Intelligence (BI) system by capturing data requirements and employing technical and functional skills to build out a sustainable information analytics platform. This position will integrate institutional data into the UAlbany BI system that will inform decisions and support UAlbany’s strategic initiatives.

Primary Responsibilities:
Design, Develop, Implement and Maintain Extract, Transform and Load (ETL) Processes:

  • Document mappings between source systems and BI, including transformation logic
  • Use Oracle Data Integrator (ODI) to develop, implement, extract, transform and load logic to move data from the source to the BI System
  • Design, develop, perform and analyze test cases, including: unit tests, integration tests, and quality assurance plans
  • Work with users to identify issues and resolutions
  • Migrate ODI modules through multiple development environments and production
  • Design, develop, build and maintain ODI logic based on service requests and incidents
  • Monitor the success or failure of ODI Loads

Design, Develop, Implement and Maintain Dimensional Data Warehouse Enhancements:

  • Identify and document data requirements and sources
  • Design, develop and implement staging tables to hold the initial extracts of data from the system(s) of record
  • Design, develop and implement target tables that form Kimball’s star schema
  • Integrate additional Data Warehouse modules with the existing modules using tables identified as Conformed Dimensions

Design, Develop, Implement and Maintain the end user access to the BI:

  • Administer end user tools, such as Oracle Business Intelligence (OBIEE) to organize the BI data for the end user, ensuring accessibility, ease of use and security
  • Learn new data access tools and how to administer them
  • Build validation dashboards/analytics to validate the data in the BI against the source systems
  • Work with the user to identify issues and their resolution

Work Service Requests, Incidents and Project Tasks:

  • Use a ticketing system and project task list to work through assigned activities
  • Work within assigned timelines, notifying the manager of any anomalies
  • Design and build validation dashboards/analytics to compare the data in the BI system against data in the source systems for integrity and correctness
  • Work with the user to identify issues and their resolution

Requirements:
Minimum Qualifications:

  • Bachelor’s degree from a college or university accredited by a U.S. Department of Education or internationally recognized accrediting organization
  • Minimum of 5 years of data requirements analysis, dimensional data modeling, data warehousing, data analytics, SQL, and ETL experience, providing services to a wide range of business customers
  • Minimum 5 years’ experience with ODI or a similar ETL tool
  • Minimum 5 years’ experience with Oracle SQL Developer or Toad
  • Minimum 5 years’ experience with Oracle OBIEE or similar analytics tool
  • Excellent customer service skills
  • Excellent oral and written communication skills; writing skills will be assessed by application materials submitted
  • Applicants must address in their applications their abilities to work with a culturally diverse population.

Preferred Qualifications:

  • 7+ years’ experience in: 
    • ODI or a similar ETL tool
    • SQL Developer
    • OBIEE and Analytics/Dashboard development
  • Experience with data visualizations and story telling
  • Experience in higher education


Additional Information:
Professional Rank and Salary Range: University Data Base Administrator, SL-4

The Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, or Clery Act, mandates that all Title IV institutions, without exception, prepare, publish and distribute an Annual Security Report. This report consists of two basic parts: disclosure of the University’s crime statistics for the past three years; and disclosures regarding the University’s current campus security policies. The University at Albany’s Annual Security Report is available in portable document format [PDF] by clicking this link http://police.albany.edu/ASR.shtml

Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation.  If such information has been requested from you before such time, please contact the Governor’s Office of Employee Relations at (518) 474-6988 or via email at info@goer.ny.gov.

THE UNIVERSITY AT ALBANY IS AN EO/AA/IRCA/ADA EMPLOYER
Please apply online via https://albany.interviewexchange.com/jobofferdetails.jsp?JOBID=109163

Application Instructions:
Applicants MUST submit the following documents: 

  • Resume
  • Cover letter stating all the required minimum qualifications and any of the applicable preferred qualifications
  • List of references

Note: After submitting your resume, the subsequent pages give you instructions for uploading additional documents (i.e. cover letter etc.).

This search will remain open until filled.

Visa sponsorship is not available for this position.

Related: