Arizona State University
Database Analyst (IT)
Arizona State University, Scottsdale, Arizona, us, 85261
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 tosupport Dreamscape Learn projects. Dreamscape Learn is a collaboration between Arizona StateUniversity and Dreamscape Immersive, leveraging cinematic storytelling and VR technology to reenvisionhow courses can be taught.
Action Lab combines the power of data and research to evaluate and inform business decisions to createinnovative solutions. Under the general guidance of a Data Architect, the Data Engineer will support andextend projects in Action Lab's Dreamscape Learn portfolio by automating processes, generatingcomplex 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 inScottsdale, Arizona three days per week (ideally in office on Tuesdays and Thursdays, and one other daythat aligns with other work activities).
Essential Duties:Makes recommendations for enhancements to current procedures, including assessments of the algorithmic complexity, efficiency, and potential alternativesTranslate business, research needs, and questions into reliable automated workstreamsPeriodically review configuration for enhancement opportunities; reviews current needs and provides ongoing support of data requirements through understanding of available data and active systemsQuery, transform and clean complex data; join data accurately across multiple data streamsWork iteratively to create and maintain testing processes throughout developmentReviews, modifies, and rewrites existing code to optimize it or adapt it to fit new requirementsTroubleshoots, diagnoses, analyzes and resolves technical issues to ensure ongoing data integrityWork with stakeholders to identify data gaps and issues, then implement solutionsWork alongside other EdPlus teams on the maintenance, testing, and implementation of data systemsWorks primarily within the scope of well-defined workstreams with high level guidance from senior staffInterpret and understand business requirements from researchers and instructional designersAssume or coordinate other duties or projects as assigned or directedRelated analytical processes and reviewsMinimum 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 fieldExperience working in a higher education setting, preferably with higher education student dataAbility to read, write, and debug code in Python, Javascript, or equivalent programming languagesExperience in designing, developing, and maintaining ETL (Extract, Transform, Load) workflowsAdvanced SQL skills including CTEs, window functions, and complex joinsAbility to develop and implement solutions in a Cloud environment like Google Cloud Platform, Amazon Web Services, or Microsoft AzureProficiency with an ETL tool such as AlteryxProficient with Microsoft Office tools including Word, Excel, Powerpoint, and Outlook as well as the corresponding Google Suite tools including docs, sheets, and slidesAbility to work effectively in an environment requiring balancing multiple competing deadlines and prioritiesSkill in maintaining and managing small to medium-sized projectsExperience with Jira or related project management toolsSkill in thinking critically and developing creative solutions to challenging problemsAbility to work both independently and in collaboration with a variety of individualsAbility to lead by example in communication, participation, and encouragementASU offers a total compensation package that includes valuable employee benefits. Click here to explore options.
HealthcareFinancial SecurityRetirementFamily ResourcesTuition Reduction (Eligible ASU Employee, their dependents and spouse.)Discounts
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.
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.
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.
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 ReportIn 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.
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.
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 tosupport Dreamscape Learn projects. Dreamscape Learn is a collaboration between Arizona StateUniversity and Dreamscape Immersive, leveraging cinematic storytelling and VR technology to reenvisionhow courses can be taught.
Action Lab combines the power of data and research to evaluate and inform business decisions to createinnovative solutions. Under the general guidance of a Data Architect, the Data Engineer will support andextend projects in Action Lab's Dreamscape Learn portfolio by automating processes, generatingcomplex 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 inScottsdale, Arizona three days per week (ideally in office on Tuesdays and Thursdays, and one other daythat aligns with other work activities).
Essential Duties:Makes recommendations for enhancements to current procedures, including assessments of the algorithmic complexity, efficiency, and potential alternativesTranslate business, research needs, and questions into reliable automated workstreamsPeriodically review configuration for enhancement opportunities; reviews current needs and provides ongoing support of data requirements through understanding of available data and active systemsQuery, transform and clean complex data; join data accurately across multiple data streamsWork iteratively to create and maintain testing processes throughout developmentReviews, modifies, and rewrites existing code to optimize it or adapt it to fit new requirementsTroubleshoots, diagnoses, analyzes and resolves technical issues to ensure ongoing data integrityWork with stakeholders to identify data gaps and issues, then implement solutionsWork alongside other EdPlus teams on the maintenance, testing, and implementation of data systemsWorks primarily within the scope of well-defined workstreams with high level guidance from senior staffInterpret and understand business requirements from researchers and instructional designersAssume or coordinate other duties or projects as assigned or directedRelated analytical processes and reviewsMinimum 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 fieldExperience working in a higher education setting, preferably with higher education student dataAbility to read, write, and debug code in Python, Javascript, or equivalent programming languagesExperience in designing, developing, and maintaining ETL (Extract, Transform, Load) workflowsAdvanced SQL skills including CTEs, window functions, and complex joinsAbility to develop and implement solutions in a Cloud environment like Google Cloud Platform, Amazon Web Services, or Microsoft AzureProficiency with an ETL tool such as AlteryxProficient with Microsoft Office tools including Word, Excel, Powerpoint, and Outlook as well as the corresponding Google Suite tools including docs, sheets, and slidesAbility to work effectively in an environment requiring balancing multiple competing deadlines and prioritiesSkill in maintaining and managing small to medium-sized projectsExperience with Jira or related project management toolsSkill in thinking critically and developing creative solutions to challenging problemsAbility to work both independently and in collaboration with a variety of individualsAbility to lead by example in communication, participation, and encouragementASU offers a total compensation package that includes valuable employee benefits. Click here to explore options.
HealthcareFinancial SecurityRetirementFamily ResourcesTuition Reduction (Eligible ASU Employee, their dependents and spouse.)Discounts
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.
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.
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.
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 ReportIn 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.
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.