DATA WAREHOUSE MANAGER SENIOR

Location : phoenix, AZ United States Job Title : DATA WAREHOUSE MANAGER SENIOR Company Name : Arizona State University Position Type : Full Time Post Date : 01 / 19 / 2022 Expire Date : 03 / 19 / 2022 Job Categories : Other Job Description DATA WAREHOUSE MANAGER SENIOR

Data Warehouse Manager Senior

Arizona State University

Data Success

Campus : Tempe

75299BR

Job Description

ASU, a leading innovator in Higher Education, is looking for an experienced Data Warehouse Manager Senior to lead our AWS Redshift Enterprise Data Warehouse team.

Our warehouse contains 80 schemas covering 4,000 tables and over 60 billion records. A successful candidate will have hands-on experience administering a large Redshift instance as well as the ability to manage a team of technologists who maintain the databases performance.

ASUs University Technology Office has over 500 employees, offering a variety of career paths in a high-energy working environment.

The technology initiatives were engaged in are transformative and unprecedented in Higher Education. Consider taking the step and joining the Sun Devil family!

As with everyone in the UTO family, our intentional focus on diversity, equity, inclusion and belonging as well as culture and communications are core responsibilities in this role.

With an increased emphasis on authenticity, compassion, and inclusivity, this position strives to embody and advance our UTO Positive Core.

ASU offers a total compensation package that includes valuable employee benefits. Click here to explore options.

Salary Range

$73,255 - $118,000 per year; DOE

Close Date

04-February-2022

Essential Duties

Manage the day-to-day operations of the team responsible for administering the Redshift Enterprise Data Warehouse. This includes database administration (performance, growth, troubleshooting) and orchestrating the ETL jobs that feed the warehouse

Own the future growth and development of the warehouse architecture. The candidate will keep abreast of new processes and technologies that will improve the performance and affordability of the warehouse

Perform maintenance and tuning required to administer our AWS Redshift database instance. This includes the current operations of the database as well as planning for future needs

Oversee intake of customer requests for data warehouse additions and enrichments. This Manager role will be accountable for assessing and fulfilling customer requests

Fiscal accountability for the warehouse including cloud costs, licenses, and staff

Assume or coordinate other duties as assigned or directed.

Take responsibility for fostering culture, advancing our values, and championing engagement in all its forms collaborating across our teams as well as participating in UTO / ASU events and programs.

Demonstrates commitment to valuing diversity and contributing to an inclusive working and learning environment. Advances our UTO Affirmative Pledge.

Minimum Qualifications

Bachelor's degree in Information Technology, Computer Information Systems, or related field AND five years of related experience, which includes three years of supervisory experience;

OR, Any equivalent combination of education and / or experience from which comparable knowledge, skills and abilities have been achieved.

Desired Qualifications

Experience administering an AWS Redshift instance highly preferred

Experience implementing and supporting ETL jobs (data ingest, copy, enrichment, scheduling) highly preferred

Ability to communicate and lead a team of experienced technology specialists highly preferred

Experience modeling relational database schema / tables / columns (e.g. using primary keys)

Experience administering security in a relational database in AWS

Experience troubleshooting common database issues (duplicate keys, inefficient joins / views, DB performance issues)

Experience in a decision support environment that uses both an Enterprise Data Warehouse and an Operational Data Store and knowing the respective benefits of each

Ability to communicate both technically (databases, relationships, performance) and functionally (processes and planning)

Ability to model empathy, compassion and emotional intelligence

Experience working in a values-led organization, emphasizing diversity, equity, inclusion and belonging

Ability to help foster a safe psychological space for all teammates where everyone can thrive

Ability to stimulate changes in individual, institutional, and corporate behaviors to create a more sustainable environment

Ability to lead by example in communicating, participating and encouraging support of the institutions sustainability programs

Working Environment

Activities are performed in an environmentally controlled office setting subject to extended periods of sitting, keyboarding, and manipulating a computer mouse;

required to stand for varying lengths of time and walk moderate distances to perform work. Frequent bending, reaching, lifting, pushing and pulling up to 25 pounds.

Ability to clearly communicate verbally, read, write, see and hear to perform essential functions.

Department Statement

The University Technology Office (UTO) embraces its role as both an enabler and catalyst for advancing the vision and work of the New American University.

We are a values-driven organization. Our commitments are reflected in all of the work we do in pursuit of operational excellence, the experience and delight of our community, and our strategic and innovation initiatives.

Applicants must be eligible to work in the United States.

Join the team that sparks human-centered innovation

UTO is a rapidly reconfigurable and entrepreneurial organization at ASU that prioritizes and executes to meet the needs of our community of learners, faculty, researchers and staff.

Our work emphasizes autonomy, flexibility and distributed decision-making to leverage the strengths of individuals. Together, we embrace a culture that nurtures, engages and embraces diverse voices with a shared lens of positive community impact and expanded opportunities for collaboration.

Mission oriented. Everything we do is to advance ASUs charter measuring who we include and how they succeed. We are staunch champions of learner success and put people first.

Flexibility. Our hybrid work environment prioritizes personal autonomy and trust around how work gets done. Staff touch base in person a few times per week with freedom to decide how, when and where.

Culture forward. We embrace a Positive Core culture : Belonging, Relational, Authentic, Visionary and Empowered. The UTO fabric weaves together diversity, equity and inclusion applied in our daily work and interactions.

Scale of impact. Our work changes the world. With 180k+ learners, faculty, researchers and staff, working with UTO means you have the capacity to improve many lives and entire communities.

World-class, low cost education. Our professional development is built in! UTO encourages staff to seek additional certificates and degrees via ASUs top ranked programs with major tuition breaks.

Exposure to industry giants. UTO partners with Amazon, Apple, Cox, Verizon, Salesforce, Alteryx and a diversity of technology companies to enhance our innovations and deepen their impact.

ASU Statement

Arizona State University is a new model for American higher education, an unprecedented combination of academic excellence, entrepreneurial energy and broad access.

This New American University is a single, unified institution comprising four differentiated campuses positively impacting the economic, social, cultural and environmental health of the communities it serves.

Its research is inspired by real world application blurring the boundaries that traditionally separate academic disciplines.

ASU serves more than 100,000 students i