IT Enterprise Data Architect

Employment Type

: Full-Time

Industry

: Miscellaneous



SunIRef:it

IT Enterprise Data Architect

Syracuse University

497 reviews

-

Syracuse, NY

Syracuse University

497 reviews

Read what people are saying about working here.

Posting Details

Job #

******

Department Code

20701-6024

Department

Information Technology Services

Job Title

IT Enterprise Data Architect

Location

Syracuse, NY

Pay Range

Commensurate with Experience

Staff Level

S6

FLSA Status

Exempt

Hours

Standard University business hours

8:30am -5:00pm (academic year)
8:00am - 4:30pm (summer)

Hours may vary based on operational needs.

Job Type

Full-time

Campus

Syracuse, NY

Unionized Position Code

Not Applicable

Job Description

The IT Enterprise Data Architect is required for the designing, modeling, and presentation of data. The data needs to be easily accessible, defined, and easy to use. University decision makers will use this data to build reports and dashboards, to help respond to changes and trends, and to forecast the future.

The IT Enterprise Data Architect works with functional business analysis from Academic Affairs; Business, Finance, and Administration; and University schools and colleges to interpret business processes, determine the proper data needs, and ultimately architect the solution.

The IT Enterprise Data Architect leads and participates in all aspects of design and development of data structures to support relational and dimensionally modeled data warehouses and associated analytics resources. These structures are used for external reporting and internal analytics supporting strategic University initiatives and the departments/offices involved in the same. Provides domain expertise and facilitates development of knowledge and skills among existing staff. Coordinates processes required for logical and physical modeling of data. The IT Enterprise Data Architect will collaborate with others on technical architecture.

Qualifications

Bachelor's degree or higher in computer science, information science, or related field.
Minimum 8 years of experience in BI data warehousing or related field with work focused on data modeling.

Job Specific Qualifications

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.
Proven ability to work in distributed systems.
Substantive experience with Oracle and SQL databases.
Demonstrated success collaborating with other technical staff.
Experience with OBIEE, IBM DataStage and PeopleSoft Higher Education ERP systems preferred.
Must be able to develop creative solutions to problems.
Strong communication and collaboration skills.

Responsibilities

Expands existing dimensional data model infrastructure using type 1 and type 2 dimensions, aggregate tables, and materialized views.
Provides data mapping.
Work closely with our software, application development, and functional teams to recommend database structures based on the data storage and retrieval needs within each department.
Defines and distributes requirements for developers executing ETL identifying and ensuring use of best practices.
Designs and leads development of ROLAP and MOLAP data structures.
Provide maintenance and support for current data architecture.

Physical Requirements

Tools/Equipment

Application Instructions

In addition to completing an online application, please attach a resume and cover letter for consideration.

About Syracuse University

Syracuse University is a private research university of extraordinary academics, distinctive offerings and an undeniable spirit. With a gorgeous campus in the heart of New York State, a global footprint and a history that dates to 1870, we embrace diverse backgrounds and viewpoints.

Our student population includes nearly 15,000 undergraduates and 5,000 graduate students, representing all 50 U.S. states and 123 countries. Our proud commitment to veterans and their families is unrivaled in higher education. Home to 11 schools and colleges, Syracuse University blends the foundational power of the liberal arts with the intense focus of professional programs. We offer undergraduate, graduate, and professional degrees in Architecture, Arts and Sciences, Education, Engineering and Computer Science, Sport and Human Dynamics, Information Studies, Law, Management, Citizenship and Public Affairs, Public Communications, and Visual and Performing Arts.

A medium-sized city situated in the geographic center of the state, Syracuse, N.Y., is approximately a four-hour drive from New York City, Boston, Philadelphia, Toronto and Montreal. With a metropolitan population of 700,000, Syracuse is a center for cultural, recreational and artistic events, including the Everson Museum of Art, Syracuse Stage, Symphoria, Destiny Mall, multiple sporting events, and festivals including Jazz Fest and Winterfest. The outdoor enthusiast will enjoy having the Adirondack Mountains, the Finger Lakes, Lake Ontario, and the Thousands Islands Region within easy driving distance of the Syracuse campus.

EEOC

Syracuse University is an equal-opportunity, affirmative-action institution. The University prohibits discrimination and harassment based on race, color, creed, religion, sex, gender, national origin, citizenship, ethnicity, marital status, age, disability, sexual orientation, gender identity and gender expression, veteran status, or any other status protected by applicable law to the extent prohibited by law. This nondiscrimination policy covers admissions, employment, and access to and treatment in University programs, services, and activities.

Commitment to Supporting and Hiring Veterans

Syracuse University has a long history of engaging veterans and the military-connected community through its educational programs, community outreach, and employment programs. After World War II, Syracuse University welcomed more than 10,000 returning veterans to our campus, and those veterans literally transformed Syracuse University into the national research institution it is today. The University's contemporary commitment to veterans builds on this historical legacy, and extends to both class-leading initiatives focused on making an SU degree accessible and affordable to the post-9/11 generation of veterans, and also programs designed to position Syracuse University as the employer of choice for military veterans, members of the Guard and Reserve, and military family members.

Commitment to a Diverse and Inclusive Campus Community

Syracuse University maintains an inclusive learning environment in which students, faculty, administrators, staff, curriculum, social activities, governance, and all other aspects of campus life reflect a diverse, multi-cultural, and international worldview. The University community recognizes and values the many similarities and differences among individuals and groups. At Syracuse, we are committed to preparing students to understand, live among, appreciate, and work in an inherently diverse country and world made up of people with different ethnic and racial backgrounds, military backgrounds, religious beliefs, socio-economic status, cultural traditions, abilities, sexual orientations and gender identities. To do so, we commit ourselves to promoting a community that celebrates and models the principles of diversity and inclusivity.

About Syracuse University

About the Syracuse area

EEOC

Commitment to Supporting and Hiring Veterans

Commitment to a Diverse and Inclusive Campus Community

Quick Link

***************************************

Job Posting Date

06/26/2019

Application Deadline

Full Consideration By

Job Category

Staff

Message to Applicants

Syracuse University - Just posted
report job

- original job

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...