ETL Developer

104850BR

Off-Campus: Scottsdale

Database Analyst (IT)

Job Description

EdPlus at ASU is a dynamic unit of Arizona State University focused on the design and scalable delivery of digital teaching and learning models to increase student success and reduce barriers to achievement in higher education. We advance the economic, social, cultural, and overall health of the local, national, and international communities served by ASU. Want to know more about working at EdPlus? Click here!

Action Lab is seeking a highly motivated, processes-oriented Database Analyst, a data engineer to
support Dreamscape Learn projects. Dreamscape Learn is a collaboration between Arizona State
University and Dreamscape Immersive, leveraging cinematic storytelling and VR technology to reenvision
how courses can be taught.

Action Lab combines the power of data and research to evaluate and inform business decisions to create
innovative solutions. Under the general guidance of a Data Architect, the Data Engineer will support and
extend projects in Action Lab’s Dreamscape Learn portfolio by automating processes, generating
complex datasets, and maintaining rigorous data standards.

This is a hybrid role. The incumbent of this position will be required to work from our office located in
Scottsdale, Arizona three days per week (ideally in office on Tuesdays and Thursdays, and one other day
that aligns with other work activities).

Essential Duties:

• Makes recommendations for enhancements to current procedures, including assessments of the algorithmic complexity, efficiency, and potential alternatives
• Translate business, research needs, and questions into reliable automated workstreams
• Periodically review configuration for enhancement opportunities; reviews current needs and provides ongoing support of data requirements through understanding of available data and active systems
• Query, transform and clean complex data; join data accurately across multiple data streams
• Work iteratively to create and maintain testing processes throughout development
• Reviews, modifies, and rewrites existing code to optimize it or adapt it to fit new requirements
• Troubleshoots, diagnoses, analyzes and resolves technical issues to ensure ongoing data integrity
• Work with stakeholders to identify data gaps and issues, then implement solutions
• Work alongside other EdPlus teams on the maintenance, testing, and implementation of data systems
• Works primarily within the scope of well-defined workstreams with high level guidance from senior staff
• Interpret and understand business requirements from researchers and instructional designers
• Assume or coordinate other duties or projects as assigned or directed
• Related analytical processes and reviews

Minimum Qualifications:
Bachelor's degree in Information Technology or closely related field and 2 years database modeling, creating and editing stored procedures including needs assessment of enterprise-wide database needs OR, Any equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved.

Desired Qualifications:

• Evidence of an advanced degree in Computer Science, IT, or related field
• Experience working in a higher education setting, preferably with higher education student data
• Ability to read, write, and debug code in Python, Javascript, or equivalent programming languages
• Experience in designing, developing, and maintaining ETL (Extract, Transform, Load) workflows
• Advanced SQL skills including CTEs, window functions, and complex joins
• Ability to develop and implement solutions in a Cloud environment like Google Cloud Platform, Amazon Web Services, or Microsoft Azure
• Proficiency with an ETL tool such as Alteryx
• Proficient with Microsoft Office tools including Word, Excel, Powerpoint, and Outlook as well as the corresponding Google Suite tools including docs, sheets, and slides
• Ability to work effectively in an environment requiring balancing multiple competing deadlines and priorities
• Skill in maintaining and managing small to medium-sized projects
• Experience with Jira or related project management tools
• Skill in thinking critically and developing creative solutions to challenging problems
• Ability to work both independently and in collaboration with a variety of individuals
• Ability to lead by example in communication, participation, and encouragement

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

• Healthcare
• Financial Security
• Retirement
• Family Resources
• Tuition Reduction (Eligible ASU Employee, their dependents and spouse.)
• Discounts

Job Family

Information Technology

Department Name

EdPlus AL Applied Data Science

Full-Time/Part-Time

Full-Time

VP Code

EdPlus at ASU

Scope of Search

Open

Grant Funded Position

This is not a grant funded position and is not contingent on future grant funding.

Salary Range

$75,000 - $80,000 per year; DOE

Close Date

07-October-2024

Category

02

Essential Duties

Please see above.

Minimum Qualifications

Bachelor's degree in Information Technology or closely related field and 2 years database modeling, creating and editing stored procedures including needs assessment of enterprise wide database needs OR, Any equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved.

Desired Qualifications

Please see above.

Working Environment

Activities are primarily performed in a regular, climate controlled office setting subject to extended periods of sitting, standing, walking. Visual acuity and manual dexterity associated with daily use of desktop computer; bending, stooping, reaching and lifting up to 20 pounds. Ability to clearly communicate to perform essential duties. Regular review of completed tasks.

Department Statement

EdPlus defines itself through a culture of curiosity, risk-taking and refusing to accept the status quo. As a central enterprise unit for ASU focused on the design and scalable delivery of digital teaching and learning models to increase student success and reduce barriers to achievement in higher education, our commitments support the university charter. ASU is a national service university and aspires to accelerate positive social outcomes through the seamless integration of cutting-edge technological innovation and scalability.

EdPlus employees are valued, respected, and encouraged to be their unique selves. We know that our ability to deliver high-quality services and educational experiences is strengthened by our culture of inclusion and through the diversity of our employees. Our innovative approach drives outcomes through serving learners, achieving milestones, striving for excellence, solving problems, embracing urgency, and being bold.

EdPlus at ASU

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 intellectual and cultural diversity, 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

Arizona State University is a VEVRAA Federal Contractor and an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, 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.

Instructions to Apply

Application deadline is 3:00PM Arizona time on the date indicated.

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 and cover letter should clearly illustrate how prior knowledge and experience meets the Minimum and Desired qualifications of this position.

ASU does not pay for travel expenses associated with interviews unless otherwise indicated.

Only electronic applications are accepted for this position.

Applicant must be eligible to work in the United States; EdPlus at ASU will not be a sponsor for this position.

IMPORTANT NOTE: What is the meaning of “equivalent combination” in the minimum qualifications? It means one year of higher education or 24 credit hours, is equal to one year of experience. For example, a four year Bachelor’s degree is equal to four years of experience.