Address
Form of work
Salary
Founded in 1863, Boston College is a Jesuit, Catholic university located six miles from downtown Boston with an enrollment of 9,484 full-time undergraduates and 5,250 graduate and professional students. Ranked 35 among national universities, Boston College has 888 full-time and 1,281 FTE faculty, 2,711 non-faculty employees, an operating budget of $1.4 billion, and an endowment in excess of $3.5 billion.
Job Description
The Manager, Data Warehouse / Architecture manages the daily operations and projects for a group responsible for the University’s Data Warehouse, data marts and business intelligence functions. Oversees all operational aspects for supporting these environments. Determines corresponding project plans, priorities, budget items and resource requirements. Oversees the design of the Data Warehouse to include the data processing and decision support components. Ensures the timeliness, accuracy, quality and integrity of the data and consistency and coordination across the platform. Collaborates with their team and others within ITS to develop requirements, understand reporting needs and provide high level logical Data Warehouse and business intelligence solutions to meet users’ business needs and facilitate integration of the Data Warehouse into the ITS infrastructure.
The incumbent works with ITS and business teams to deliver effective methodologies for managing and maintaining the Data Warehouse. This encompasses effective reporting models and toolsets to allow diverse sets of users to access and extract information from the Data Warehouse. These systems must meet the specifications for academic, research or administrative needs. Administrative functions represent the primary audience, but other audiences may include faculty, staff, students, prospective students, alumni, parents, and external organizations.
This position also works closely with the Data Integration Manager for identifying and administering data integration to the data repositories and service level agreements with our business partners. The Data Warehouse Manager is knowledgeable with the tools used across the datacenter as well as to our Cloud vendors. This includes both datacenter and hybrid technology for delivering information to the University. Developing a secure and robust architecture is critical to supporting the business units as applications continue to migrate from our datacenter.
Full-Time Equivalent Hiring Range: $126,150 to $157,700; salary commensurate with relevant experience.
Requirements
- BA/BS in relevant discipline required. 8-10 years building and implementing large scale Data Warehouses including 4-6 years of project management experience.
Skills Required:
- Expert analyst skills for requirements development and technical specifications.
- Ability to work under a formal software development lifecycle.
- Expert knowledge of data warehousing methodologies (e.g. Kimball).
- Expert Knowledge of IBM DataStage and associated WebSphere/CloudPak technologies.
- Expert knowledge of following Oracle skills: SQL, PL/SQL, ETL toolsets, OLAP technologies.
- Expert knowledge of applying Oracle security to reporting solutions (roles, VPD, encryption, enterprise user).
- Expert knowledge of data modeling and use of data modeling tools .
- Expert knowledge of Business Intelligence tools: Cognos, ThoughtSpot.
- Strong logical and physical data modeling skills.
- Experienced mentor.
- Data Mart Design skills.
- Support and integration of new Oracle tools (Application Express, BI Publisher).
- Experience with source management tools such as Git.
- Excellent communication and documentation skills.
- Must be available to address critical system issues during off hours.
Closing Statement
Boston College offers a broad and competitive range of benefits depending on your job classification eligibility:
- Tuition remission for Employees
- Tuition remission for Spouses and Children who meet eligibility requirements
- Generous Medical, Dental, and Vision Insurance
- Low-Cost Life Insurance
- Eligibility for both University-Funded 401k and Employer-Sponsored 403b Retirement Plans
- Paid Holidays Annually
- Generous Sick and Vacation Pay
Boston College conducts pre-employment background checks as part of the hiring process.
Boston College is an affirmative action, equal opportunity employer. In concert with our Jesuit, Catholic mission, Boston College is dedicated to the goal of building a culturally diverse and pluralistic faculty and staff committed to teaching and working in a multicultural environment and strongly encourages applications for women, minorities, individuals with disabilities, and covered veterans.
