Data Warehouse Manager
Apply NowCompany: Arizona State University
Location: Tempe, AZ 85281
Description:
ASU, a leading innovator in Higher Education, is looking for an experienced data professional to lead our AWS Redshift Enterprise Data Warehouse team. Our warehouse contains over 90 schemas with 3,000 tables and upwards of 60Tb of data. A successful candidate will have hands-on experience running ETL processes from applications to an enterprise data warehouse, as well as the ability to manage a team of technologists who maintain the database's content and performance. ASU's Enterprise Technology team has over 600 employees, offering a variety of career paths in a high-energy working environment. The technology initiatives we're engaged in are transformative and unprecedented in Higher Education. Consider taking the step and joining the Sun Devil team!
As with all members of the Enterprise Technology team, this role carries core responsibilities, including fostering a sense of belonging and cultivating a culture that is relational, visionary, and empowering. With a strong emphasis on authenticity and compassion, this position is dedicated to embodying and advancing our culture.
Apply before 11:59 PM Arizona time the day before the posted End Date.
Job Profile:
IT Data Infrastructure Manager 2
Job Family:
IT Data Infrastructure
Time Type:
Full time
Max Pay - Depends on experience:
$130,000.00 USD Annual
Job Description:
Salary Range $105,000 - $130,000
Essential Duties
Work Environment
Minimum Qualifications
Bachelor's degree and five (5) years of experience appropriate to the area of assignment/field including two (2) years managerial experience; OR, Any equivalent combination of experience and/or training from which comparable knowledge, skills and abilities have been achieved.
Desired Qualifications
Department Statement:
Enterprise Technology (ET) 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
ET 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 many voices with a shared lens of positive community impact and expanded opportunities for collaboration.
Why join us?
Mission oriented. Everything we do is to advance ASU's charter -- measuring who we include and how they succeed. We are staunch champions of learner success and put people first.
Flexibility. Our flexible work environment allows employees to explore opportunities with their supervisor beyond the traditional work schedule. Opportunities include hybrid work where staff are in person three days per week.
Culture forward. We embrace a Positive Core culture: Belonging, Relational, Authentic, Visionary and Empowered.
Scale of impact. Our work changes the world. With 200k+ learners, faculty, researchers and staff, working with ET means you have the capacity to improve many lives and entire communities.
World-class, low cost education. Our professional development is built in! ET encourages staff to seek additional certificates and degrees via ASU's top ranked programs with major tuition breaks.
Exposure to industry giants. ET partners with Amazon, Apple, Arista, Cox, Verizon, Salesforce, Alteryx and a diversity of technology companies to enhance our innovations and deepen their impact.
Minimum Qualifications:
Bachelor's degree and five (5) years of experience appropriate to the area of assignment/field including two (2) years managerial experience; OR, Any equivalent combination of experience and/or training from which comparable knowledge, skills and abilities have been achieved.
Driving Requirement:
Driving is not required for this position.
Location:
Campus: Tempe
Funding:
No Federal Funding
Instructions to Apply
Current Employees and Students should apply directly within Workday using the Jobs Hub. Use this link and log in using SSO:
https://www.myworkday.com/asu/d/inst/1$9925/9925$4981.htmld
To be considered, your application must include all of the following attachments:
Note: Multiple documents can be submitted into the attachment box. Alternatively, merge all documents into one PDF for submission.
Please include all employment information in month/year format (e.g., 6/88 to 8/94), job title, job duties and name of employer for each position. Resume should clearly illustrate how prior knowledge and experience meets the Minimum and Desired qualifications of this position. NOTE: GA and Intern positions are counted as .5 for job experience (ie. 1 year equals 6 months experience equivalency). Only electronic applications are accepted for this position.
Need help finding the right job?
We can recommend jobs specifically for you! Create a custom Job Alert by selecting criteria that suit your career interests.
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 in metropolitan Phoenix, Arizona, the nation's fifth largest city. ASU champions inclusive excellence, and welcomes students from all fifty states and more than one hundred nations across the globe.
ASU is a tobacco-free university. For details visit https://wellness.asu.edu/explore-wellness/body/alcohol-and-drugs/tobacco
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, or any other basis protected by law.
Notice of Availability of the ASU Annual Security and Fire Safety Report
In compliance with federal law, ASU prepares an annual report on campus security and fire safety programs and resources. ASU's Annual Security and Fire Safety Report is available online at https://www.asu.edu/police/PDFs/ASU-Clery-Report.pdf. You may request a hard copy of the report by contacting the ASU Police Department at 480-965-3456.
Relocation Assistance - For information about schools, housing child resources, neighborhoods, hospitals, community events, and taxes, visit https://cfo.asu.edu/az-resources.
Employment Verification Statement
ASU conducts pre-employment screening which may include verification of work history, academic credentials, licenses, and certifications.
Background Check Statement
ASU conducts pre-employment screening for all positions which includes a criminal background check, verification of work history, academic credentials, licenses, and certifications. Employment is contingent upon successful passing of the background check.
Fingerprint Check Statement
This position is considered safety/security sensitive and will include a fingerprint check. Employment is contingent upon successful passing of the fingerprint check.
As with all members of the Enterprise Technology team, this role carries core responsibilities, including fostering a sense of belonging and cultivating a culture that is relational, visionary, and empowering. With a strong emphasis on authenticity and compassion, this position is dedicated to embodying and advancing our culture.
Apply before 11:59 PM Arizona time the day before the posted End Date.
Job Profile:
IT Data Infrastructure Manager 2
Job Family:
IT Data Infrastructure
Time Type:
Full time
Max Pay - Depends on experience:
$130,000.00 USD Annual
Job Description:
Salary Range $105,000 - $130,000
Essential Duties
- Manage the day-to-day operations of the team responsible for administering the Redshift Enterprise Data Warehouse. This primarily includes orchestrating the ETL jobs that feed the warehouse (over 3,000 jobs nightly)
- 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 and associated tools including cloud costs, licenses, and staff.
- Take responsibility for fostering a positive culture, upholding organizational values, and championing engagement in all its forms.
- Collaborate across teams and actively participate in ET/ASU events and programs.
Work Environment
- Activities primarily take place in a standard, climate-controlled office environment and may involve extended periods of sitting, standing, or moving between office spaces.
- This role involves regular use of a computer (desktop and/or laptop), including a keyboard and mouse.
- Responsibilities may require the ability to adapt quickly to shifting priorities.
- Effective communication and proficiency with a variety of technologies are essential for collaboration with the broader team.
Minimum Qualifications
Bachelor's degree and five (5) years of experience appropriate to the area of assignment/field including two (2) years managerial experience; OR, Any equivalent combination of experience and/or training from which comparable knowledge, skills and abilities have been achieved.
Desired Qualifications
- A proven leader who has led a team of database professionals. This leader understands the strengths and weaknesses of team members and helps them develop their skillsets
- Successful experience in a technology service role. This professional has worked with customers to meet their technological needs, communicated complex processes, and set expectations for outcomes
- Experience implementing and supporting ETL jobs (data ingest, copy, enrichment, scheduling) on an enterprise scale. This includes using enterprise ETL tools for moving data (preferred tool is Snaplogic), familiarity with data integrations (table copy, API, FTP, pub/sub), and methods for staging and transforming data
- Experience modeling relational database schema/tables/columns
- Experience administering security in a relational database in AWS
- Experience troubleshooting common database issues (duplicate keys, inefficient joins/views, DB performance issues)
- Ability to communicate both technically (databases, relationships, performance) and functionally (processes and planning). This role will need to communicate externally (with customers), up (with technology leaders, across (with technology peers) and down (with their team of ETL developers)
Department Statement:
Enterprise Technology (ET) 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
ET 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 many voices with a shared lens of positive community impact and expanded opportunities for collaboration.
Why join us?
Mission oriented. Everything we do is to advance ASU's charter -- measuring who we include and how they succeed. We are staunch champions of learner success and put people first.
Flexibility. Our flexible work environment allows employees to explore opportunities with their supervisor beyond the traditional work schedule. Opportunities include hybrid work where staff are in person three days per week.
Culture forward. We embrace a Positive Core culture: Belonging, Relational, Authentic, Visionary and Empowered.
Scale of impact. Our work changes the world. With 200k+ learners, faculty, researchers and staff, working with ET means you have the capacity to improve many lives and entire communities.
World-class, low cost education. Our professional development is built in! ET encourages staff to seek additional certificates and degrees via ASU's top ranked programs with major tuition breaks.
Exposure to industry giants. ET partners with Amazon, Apple, Arista, Cox, Verizon, Salesforce, Alteryx and a diversity of technology companies to enhance our innovations and deepen their impact.
Minimum Qualifications:
Bachelor's degree and five (5) years of experience appropriate to the area of assignment/field including two (2) years managerial experience; OR, Any equivalent combination of experience and/or training from which comparable knowledge, skills and abilities have been achieved.
Driving Requirement:
Driving is not required for this position.
Location:
Campus: Tempe
Funding:
No Federal Funding
Instructions to Apply
Current Employees and Students should apply directly within Workday using the Jobs Hub. Use this link and log in using SSO:
https://www.myworkday.com/asu/d/inst/1$9925/9925$4981.htmld
To be considered, your application must include all of the following attachments:
- Cover letter
- Resume/CV
Note: Multiple documents can be submitted into the attachment box. Alternatively, merge all documents into one PDF for submission.
Please include all employment information in month/year format (e.g., 6/88 to 8/94), job title, job duties and name of employer for each position. Resume should clearly illustrate how prior knowledge and experience meets the Minimum and Desired qualifications of this position. NOTE: GA and Intern positions are counted as .5 for job experience (ie. 1 year equals 6 months experience equivalency). Only electronic applications are accepted for this position.
Need help finding the right job?
We can recommend jobs specifically for you! Create a custom Job Alert by selecting criteria that suit your career interests.
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 in metropolitan Phoenix, Arizona, the nation's fifth largest city. ASU champions inclusive excellence, and welcomes students from all fifty states and more than one hundred nations across the globe.
ASU is a tobacco-free university. For details visit https://wellness.asu.edu/explore-wellness/body/alcohol-and-drugs/tobacco
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, or any other basis protected by law.
Notice of Availability of the ASU Annual Security and Fire Safety Report
In compliance with federal law, ASU prepares an annual report on campus security and fire safety programs and resources. ASU's Annual Security and Fire Safety Report is available online at https://www.asu.edu/police/PDFs/ASU-Clery-Report.pdf. You may request a hard copy of the report by contacting the ASU Police Department at 480-965-3456.
Relocation Assistance - For information about schools, housing child resources, neighborhoods, hospitals, community events, and taxes, visit https://cfo.asu.edu/az-resources.
Employment Verification Statement
ASU conducts pre-employment screening which may include verification of work history, academic credentials, licenses, and certifications.
Background Check Statement
ASU conducts pre-employment screening for all positions which includes a criminal background check, verification of work history, academic credentials, licenses, and certifications. Employment is contingent upon successful passing of the background check.
Fingerprint Check Statement
This position is considered safety/security sensitive and will include a fingerprint check. Employment is contingent upon successful passing of the fingerprint check.