Senior Data Warehouse Developer

Arizona State University • Tempe, AZ

2d • $105,000 - $115,000

About The Position

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.

Requirements

• 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.
• 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.
• 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.
• 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.

Nice To Haves

• Familiarity with Python, Unix and cloud data platforms (e.g., AWS, GCP, 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.
• 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 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.

Responsibilities

• 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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level