As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Location (Full Address):

Select a Shipping Address, Rochester, New York, United States of America, 14627

Opening:

Worker Subtype:

Regular

Time Type:

Full time

Scheduled Weekly Hours:

40

Department:

100089 University IT / C&DS

Grade:

UR URGB 112

Compensation Range:

$65,000.00 - $135,000.00

The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.

Responsibilities:

Analyzes problems, provides complex program specifications, develops or modifies programs, assists in the scheduling of programming projects, and supervises the technical activities of assigned personnel.Schedule 8 AM-5 PM Responsibilities General Purpose: The Data Warehouse Architect Developer responsibilities include architecting, designing, developing, implementing, and supporting various components for the enterprise data warehouse and associated data sources. The lead works independently and provides support for reporting projects as well as providing process and architectural recommendations. Responsibilities include mentoring staff, demonstrating best practices, planning for business continuity and sustainability and working on projects that support Business Intelligence and Data Warehousing functions as assigned. Responsibilities: Independently manages projects and requests - Works with the user community and reporting team to understand business data and data transformation requirements. - Converts those requirements to functional/technical specifications for database and integration design. - Manages requests and/or components of larger projects with appropriate documentation and status reports Data Integration Architecture and Design - Architects data integration and transformation processes across on premise and cloud data sources. - Provides leadership and is a subject matter expert depending on area of focus. Data Integration Development - Develops data integration and transformation processes across on premise and cloud data sources using tools including Oracle Data Integrator, Boomi Atomsphere, Informatica as determined by the environment. Data Warehouse Design and Development - Develops data models and database design leverage their knowledge of data warehouse modeling best practices Mentoring best practices - Collaborates with other team members using scrum processes or other project management disciplines depending on area of focus. - Follows best practices for change and code management. - Provides supporting technical documentation that is written, organized and maintained. Education & outreach: - Participates in ongoing stabilization, support and maintenance. - Provide on call support as needed for business continuity and operations. - Attends webinars, reads case studies and white papers, and participates in opportunities to further refine skills and stay apprised on functional area topics. - Maintains current knowledge of technology, equipment, and/or systems and advises on newer technologies. Other duties as assigned Qualifications: - Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required - 5+ years of related experience - or an equivalent combination of education and experience required. - Master's degree preferred. Required and Preferred as specified: - Strong Analytical and problem solving abilities required - Ability to actively participate and collaborate on a team required. - Excellent written communication skills. Ability to translate functional business requirements into documented system requirements and designs required. - Understanding of data warehouse and agile software development processes required - Multiple project experience with data warehouse design and dimensional data models - Multiple project experience with Data Warehousing ETL technologies and overall knowledge of Data Warehousing/Business Intelligence lifecycles required. Experience with Oracle Data Integrator a plus - In depth understanding and development experience using SQL, Pl/SQL and UNIX scripting languages with SQL based databases (Oracle, DB2 or SQL Server) - Proficiency in developing data transformation packages/stored procedures required. - Experience with dimensional data models required - Experience with service oriented architecture and enterprise information integration preferred. Experience with the development of web services preferred. Experience with Dell Boomi Atomsphere a plus. - Experience with integrating data warehouses with business intelligence metadata tools a plus The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion to advance the University's mission to Learn, Discover, Heal, Create - and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion/creed, sex, sexual orientation, citizenship status, or any other status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.

Notice: If you are a Current Employee, please log into myURHR to search for and apply to jobs using the Jobs Hub. Your application, if submitted using this portal, cannot be moved forward.

Learn. Discover. Heal. Create.

Located in western New York, Rochester is our namesake and our home. One of the world’s leading research universities, Rochester has a long tradition of breaking boundaries—always pushing and questioning, learning and unlearning. We transform ideas into enterprises that create value and make the world ever better.

If you’re looking for a career in higher education or health care, the University of Rochester may offer the perfect opportunity for your background and goals

At the University of Rochester, we commit to diversity, equity, and inclusion and united by a strong commitment to be ever better—Meliora. It is an ideal that informs our shared mission to ensure all members of our community feel safe, respected, included, and valued.