Data Warehouse/Application Architect

Data Warehouse/Application Architect

St. John Fisher University is an independent, liberal arts institution that provides a transformative education to approximately 3,800 undergraduate, master’s, and doctoral students each year. Across its five Schools, Fisher offers nearly 40 majors in the humanities, social sciences, natural sciences, business, education, and nursing; 11 pre-professional programs; and master’s and doctoral programs in business, nursing, education, pharmacy, and public health. The University’s residential campus boasts a robust living and learning community and a successful intercollegiate athletics program. Fisher is a community where all are welcome, regardless of religious or cultural background.
The University continues to honor its founders, the Congregation of St. Basil, by embracing their motto, “Teach Me Goodness, Discipline, and Knowledge.” We are located in Pittsford, N.Y., seven miles outside of the city of Rochester. The campus is situated on 164 park-like acres—a beautiful setting for a warm, friendly campus community.

The Position of Data Warehouse / Application Architect is responsible for the design, development and management of a data warehouse environment used for analytics and reporting. The data warehouse team campus stakeholders to develop data models and intelligence delivery systems so the campus can achieve the aggressive goals of a wide range of strategic and tactical initiatives. This individual is responsible for data warehousing, including requirements discovery, data mining and profiling, data model design, implementation, maintenance, training, and support. The team operates in an agile mode with extensive collaborations with users across the campus.
Job Responsibilities include:

• Engage with stakeholders to gather requirements for reporting and analytic solutions in support of campus initiatives.
• Manages and coordinates the completion and change management of multiple projects at a time.
• Create High level architecture, specifications to ensure feasibility, functionality, and integration.
• Design, develop and communicate appropriate data structures and architectures including data vault, star schema and data mining models; ability to emphasize methodology, modeling, and governance, technologically and politically neutral, articulate, persuasive, and enthusiastic
• Develop and test programs using TSQL and other ETL tools (e.g., SQL Server Integration Services, PowerShell) to support reporting and extract solutions.
• Support business and technical staff regarding the content and use of data warehouse objects.
• Maintain table structures, programs, scripts, and documentation to ensure alignment with the data warehouse strategy and architecture.
• Conceive and portray the big data picture: initiates, evaluates, and influences projects from the perspective of the entire organization.
• Complete in-depth data modeling and database design with proficiency across all phases of data modeling, from conceptualization to database optimization with skills that extend from SQL development and to database administration.

Bachelor’s degree in computer science, information science or related field. 8-10 years of experience in BI data warehousing or related field with work focused on data modeling and data warehousing. Advanced degree in related field a plus.

Required Skills:

• Extensive architectural design experience for Business Data Warehouse and Analytics.
• Architecture and deployment experience with IBM BI & Analytical Tools, Oracle’s Database, Microsoft’s Server, and Information Server products.
• Experience implementing data governance principles and utilizing commercial tools for data governance and stewardship.
• Experience working independently with customers to determine information technology status, desires, needs and cross-system issues on projects of high sensitivity or complexity.
• Project lead cross functional teams using project management techniques and skills.
• Proven ability to provide the highest levels of interpersonal communications with sensitivity to and understanding of the demands of a higher education environment.
• Demonstrated knowledge of data warehousing/business intelligence best practices, methodologies, standards, and architectures.
• Proven track record of delivering BI projects through software development lifecycle including requirements gathering, design, development, analytics, measurement, implementation, and support.
• Experience with Microsoft SQL Server BI technology stack, specifically T-SQL, SSAS cubes, Stored Procedures, Self-service BI, XMLA.
• Knowledge of ROLAP/MOLAP technologies and dimensional modeling, including their applicability to various reporting problems.
• Extensive knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems preferably Oracle 21c or MS SQL Server 2019+.
• Experience with contemporary BI tools (IBM Cognos 11, Microsoft Reporting Services).
• Significant training and experience in dimensional data modeling, data architecture, cube building, and ETL tools are required.
• Includes experience designing and building type 1 and type 2 dimensions, aggregate tables, and materialized views.
• Proficiency in working in Unix and Windows environments.
• Proficiency in basic Database design concepts Unix – Solaris, HP/UX, and/or Linux.

• Experience in higher education and their associated data landscapes.
• Substantive experience with Oracle databases, SQL.
• Experience with Banner Higher Education ERP systems preferred.
• Strong communication and collaboration skills.
• Strong Oracle SQL and PL/SQL programming.
• Strong Microsoft SQL/TSQL, and PowerShell.
• Unix Shell scripting.
• 3rd party software install/configuration.

N/A

Well-lighted, well-ventilated, pleasant work area.

• Oracle SQL Developer
• Microsoft SQL Server Management Studio and Azure Data Studio
• Microsoft Visual Studio Code and Visual Studio 2019
• IDERA ER/Studio- Data Modeling
• PowerShell scripting
• Subversion Client
• MS Office Suite (Excel, Word, Outlook, PowerPoint)
• Postman (REST API Investigations)

40-hour work week, 12 months a year

It is the policy of St. John Fisher University to provide Equal Employment Opportunity to all employees and applicants for employment in accordance with the applicable federal, state, and local laws governing non-discrimination in employment in each locality in which the University has employees.
The University does not discriminate against applicants or employees in hiring, promotion, termination or the terms and conditions of employment on the basis of race, color, religion, gender, sex, perceived sex, gender identity, gender expression, the status of being transgender, sexual orientation, national origin, citizenship, age, disability, marital status, military status, veteran status, predisposing genetic, characteristics or genetic information, arrest or conviction record, status as a victim of domestic violence, or any other characteristic protected by law.
The Title IX Coordinator is the designated University official with primary responsibility for coordinating compliance with Title IX and related federal and state laws. The Title IX Coordinator, Meg Flaherty, Ph.D., can be reached by phone (585-385-8232), email (titleix@sjfc.edu), in-person in Campus Center 206, or outside of business hours by contacting the Office of Safety and Security (585-385-8111).

3690 East Ave., Rochester, NY 14618

Exempt

77.8-91.5k

The salary range for this role is set based on a variety of factors, including but not limited to internal equity, qualifications, experience, and education. The above hiring range is one component of the University’s competitive Total Rewards package which can be viewed here

S00597P

06/01/2024