Senior Data Warehouse Developer

Job Profile:
Business and Data Analyst 3

Job Family:
Business and Data Analytics

Time Type:
Full time

Max Pay - Depends on experience:
$115,000.00 USD Annual

Apply before 11:59 PM Arizona time the day before the posted End Date.

Minimum Qualifications:
Bachelor's degree and five (5) years of experience appropriate to the area of assignment/field; OR, Any equivalent combination of experience and/or training from which comparable knowledge, skills and abilities have been achieved.

Job Profile Summary:
Defines systems requirements, makes recommendations for technology selection, and performs moderately complex data analysis to ensure data management objectives within a work unit are met.

Job Description:

ASU, a leading innovator in Higher Education, is looking for an experienced Senior ETL Developer to support our AWS Redshift Enterprise Data Warehouse. Our large-scale environment contains over 90 schemas with 3,000 tables and upwards of 60Tb of data. We're looking for a senior technologist with strong hands-on experience building and optimizing ETL pipelines from enterprise applications into a data warehouse environment. The ideal candidate excels in performance tuning, data modeling, and ensuring data quality across complex systems. This role also includes supporting daily data loads and participating in on-call rotations as part of ongoing data warehouse maintenance. ASU's Enterprise Technology team includes 600+ professionals and offers dynamic growth opportunities in a high-energy, transformative environment. Join us and help shape the future of data at ASU.

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.

Salary Range: $105,000 - $115,000 per year; DOE

Essential Duties:

• Design, develop, and maintain scalable ETL pipelines that ingest, integrate, transform, and apply complex business rules to data from multiple internal and external sources, delivering trusted data to the enterprise data warehouse.
• Ingest high volumes of data from diverse source systems and access methods (APIs, databases, flat files, cloud storage, third-party platforms) ensuring reliable and secure data acquisition.
• On-call support for ETL operations, overseeing job orchestration, workflow scheduling, and timely resolution of pipeline failures across thousands of nightly batch processes
• Manage and maintain enterprise ETL platforms and data warehouse environments, including system administration, patching, upgrades, conversions, performance tuning, and configuration to ensure continuous, reliable, and secure operations.
• Collaborate with data architects, customers and analysts to support data modeling, schema design, and dimensional structures for reporting and analytics.
• Optimize ETL processes for performance, scalability, and efficiency, while enforcing data quality, validation, and reconciliation controls to ensure accurate, complete, and consistent warehouse data.
• Deploy code and objects through SDLC environments including development, QA, and Production along with partnering with production services to ensure the correct job scheduling is in place.
• Develop automation, logging, alerting, and documentation to improve operational stability, governance, and maintainability of ETL processes.
• Participates in team activities and contributes to discussions, such as production support triage, incident management, code reviews, architecture reviews, and technology standards definitions.
• Leverage AI in routine tasks and contribute ideas for using AI to improve the unit's efficiency and overall performance.
• 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.

Desired Qualifications:

• Demonstrated experience on multiple projects using Data Warehousing and ETL technologies, with strong knowledge of data warehousing and business intelligence lifecycle concepts, methodologies, and best practices.
• Proficiency in SQL/PL/SQL, including experience with analytic functions and techniques for tuning large-volume queries.
• Familiarity with Python, Unix and cloud data platforms (e.g., AWS, Google Cloud Platform, Azure) is preferred.
• Experience in administration of ETL or middleware tools (e.g., SnapLogic, Matillion, Informatica), including configuration, patching, upgrades, and maintenance
• Kimball methodologies include star schema design and accumulating and periodic snapshots.
• Strong understanding of data lakes, data warehouses, and modern data architecture principles for large-scale organizations, including metadata management, governance, and scalable design.
• Experienced Data Warehouse Developer skilled in architecting and developing complex data pipelines, scripts, and data objects, delivering scalable and high-performance solutions and supporting the team through technical mentorship.
• Experience administering security in a relational database in AWS.
• Experience troubleshooting common database issues (duplicate keys, inefficient joins/views, DB performance issues).
• 5+ years of experience applying Agile software development methodologies, utilizing tools such as JIRA, Confluence, or cloud platforms (e.g., AWS) for project tracking, collaboration, and delivery.
• Collaborative team player with excellent communication and leadership skills.
• Experience in a University or Higher Education setting.
• Demonstrated ability to model empathy, compassion, and emotional intelligence.
• Experience in a values-driven organization with a strong commitment to inclusion and belonging.
• Ability to cultivate a psychologically safe environment where all team members can thrive.
• Capacity to inspire and drive meaningful change in individual, institutional, and corporate behaviors to support a more sustainable environment.
• Commitment to leading by example through effective communication, active participation, and advocacy for the institution's sustainability programs.

Working 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.
• Effective communication and proficiency with a variety of technologies are essential for collaboration with the broader team.
• Required to stand for varying lengths of time and walk moderate distances to perform work.
• Regular responsibilities may require the ability to quickly change priorities, which may include and/or are subject to resolution of conflicts.

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.

Driving Requirement:
Driving is not required for this position.

Location:
Campus: Tempe

Funding:
No Federal Funding

Instructions to Apply:

Current employees, student workers seeking staff opportunities, and students applying for student worker positions must apply directly through the Workday Jobs Hub.

Please use the link below to log in using single sign-on.
$9925/9925$19313.htmld

To be considered, your application must include all of the following attachments:

• Cover letter
• Resume or CV

Multiple documents may be uploaded in the attachments section. Alternatively, applicants may combine all required materials into a single PDF for submission. Please ensure uploaded documents are clearly labeled and include your name.

Please ensure your resume includes all employment information in month and year format, for example 6/04 to 8/14, along with job title, job duties, and employer name for each position. Your resume should clearly demonstrate how your experience and background meet the minimum and desired qualifications for this position. Incomplete applications or missing required materials may not be considered.

Important: Do not withdraw your application to make edits. Once an application is withdrawn, it cannot be edited, reactivated, or replaced with a new submission. If you have questions or need assistance, please contact HR Talent Acquisition before the posting close date to request edits.

Graduate Assistant, Intern and part-time positions are counted as half time for experience equivalency, meaning one year equals six months of experience.

Only electronic applications will be accepted for this position. By submitting an application, you confirm that the information provided is accurate and complete.

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

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 You may request a hard copy of the report by contacting the ASU Police Department at .

Relocation Assistance - For information about schools, housing child resources, neighborhoods, hospitals, community events, and taxes, visit ;br>
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.