Recent Searches

You haven't searched anything yet.

3 Data Warehouse/Application Architect Jobs in Rochester, NY

SET JOB ALERT
Details...
St. John Fisher College
Rochester, NY | Full Time
$119k-146k (estimate)
3 Weeks Ago
Beyond TalentEdge
Rochester, NY | Full Time
$113k-138k (estimate)
1 Week Ago
Beyond TalentEdge
Rochester, NY | Full Time
$111k-136k (estimate)
7 Days Ago
Data Warehouse/Application Architect
$119k-146k (estimate)
Full Time | Utilities 3 Weeks Ago
Save

St. John Fisher College is Hiring a Data Warehouse/Application Architect Near Rochester, NY

Position Details
Posting Summary
Position Title Data Warehouse/Application Architect
Overview
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.
Job Responsibilities
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.
Education / Experience
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.
Competencies / Skills
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.
Preferred Skills:
  • 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.
Supervision of Employees
N/A
Work Environment
Well-lighted, well-ventilated, pleasant work area.
Equipment to be Used
  • 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)
Work Hours
40-hour work week, 12 months a year
Special Conditions for Eligibility
EEO Statement
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).
Work Location 3690 East Ave., Rochester, NY 14618
FLSA Exempt
Salary / Hourly Range 77.8-91.5k
Notes
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
Posting Detail Information
Posting Number S00597P
Desired Start Date 06/01/2024
Open Date
Open Until Filled
Special Instructions to Applicant
Supplemental Questions

Required fields are indicated with an asterisk (*).

Documents Needed to Apply
Required Documents
  1. Resume
  2. Cover Letter
  3. Letter of Recommendation 1
Optional Documents
  1. Transcripts

Job Summary

JOB TYPE

Full Time

INDUSTRY

Utilities

SALARY

$119k-146k (estimate)

POST DATE

05/24/2024

EXPIRATION DATE

07/23/2024

WEBSITE

sjfc.edu

HEADQUARTERS

WEBSTER, NY

SIZE

500 - 1,000

FOUNDED

1948

CEO

BRAD BURNS

REVENUE

$50M - $200M

INDUSTRY

Utilities

Related Companies
About St. John Fisher College

St. John Fisher College is an independent, liberal arts institution in the Catholic tradition of American higher education. The College emphasizes liberal learning for students in traditional academic disciplines, as well as for those in more directly career-oriented fields. The College welcomes qualified students, faculty, and staff regardless of religious or cultural background. The campus is situated on 164 park-like acres-a beautiful setting for modern buildings and a warm, friendly campus community. The College now offers 37 academic majors in the humanities, social sciences, sciences, bu...siness, education, and nursing, as well as 11 pre-professional programs. Fisher offers a number of master's degree programs in nursing, education, business, and data science and three doctoral programs. More
Show less

Show more
Show more

St. John Fisher College
Full Time
$141k-180k (estimate)
4 Days Ago
St. John Fisher College
Full Time
$50k-60k (estimate)
1 Week Ago
St. John Fisher College
Part Time
$41k-55k (estimate)
2 Weeks Ago