ETL ANALYST

ETL Analyst

Arizona State University

EdPlus Data Analysis

Off-Campus: Scottsdale

74931BR

Job Description

EdPlus at ASU is currently seeking an experienced and energetic ETL Analyst and developer in the EdPlus department. This is an exciting opportunity for a highly innovative person to work in a fast paced, dynamic environment. Duties will include, but are not limited to, database scripting and development, system design and architecture, development and support for our multi-faceted analytics environment. Additional responsibilities will entail development of database stored procedures, SQL scripts and web services to integrate university mission critical applications.

EdPlus is a unit of the ASU Enterprise 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.

EdPlus at ASU

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

Salary Range

Depends on experience

Close Date

20-January-2022

Essential Duties

• Works collaboratively with users and team members to gather requirements; develops project specifications, scope and estimated effort; develops database design, table structure and writes store procedures to meet user objectives/outcomes.
• Monitors and troubleshoot the existing ETL processes.
• Enhances existing and create new ETL processes.
• Monitors and troubleshoots existing BI applications, including frameworks, cubes and reports and ensures the availability of Tableau/SSRS reporting for the end users.
• Enhances existing and creates new BI applications.
• Collaborates with the Analytics Technical Manager to design and implement data extraction programs that integrate seamlessly into BI solutions to meet the needs of the end users.
• Analyzes data to ensure information is accurate and reconcilable to its source of origin.
• Performs quality assurance testing as appropriate prior to releasing data/information/reports into production / end users.
• Explores and understands capabilities of BI tools (Tableau/SSRS) to expand BI knowledge.
• Demonstrates knowledge acquired by incorporating best practices in projects. Shares knowledge acquired with BA team members and end users when appropriate.
• Collaborates with the Data Analytics team to support all aspects of the DW/BI infrastructure.
• Develops, maintains, and delivers technical documentation related to ETL development, scheduled processes, frameworks, transformations, etc.
• Performs the design, development, implementation, operation and maintenance of data systems largely focused on AWS Aurora and AWS Redshift.
• Develops methodology for the ongoing assessment of database performance; identifies and resolves conflicts arising over the creation, control and use of data
• Maintains a high degree of technical knowledge and expertise on database systems and a group of technology products.
• In the review of existing systems and processes, applies the techniques and principles of process and procedure reengineering in the design and development of new systems and processes. Where possible develops and recommends alternative solutions to existing systems and processes.
• Establishes and maintains effective communications with customers, other technology specialists, and vendors about services.
• Collaborates and teams with others on a variety of technology and technology support projects.
• Conducts special projects/research as requested.
• Assumes or coordinates other duties or projects as assigned or directed.

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 a Bachelor's degree or higher in a related field.
• Experience with the following:
• Designing and implementing effective database systems to fulfill business requirements.
• ETL work, performance tuning and SQL tuning.
• Working with database structures and platforms including MS SQL Server, Oracle, AWS Redshift and/or AWS Aurora
• Developing and maintaining SQL code including stored procedures, functions, tables, views, triggers, indexes and constraints
• Developing and deploying SQL Server Integration Services (SSIS) packages
• Developing and implementing web services
• Evidence of effective written and verbal communication skills

Working Environment

EdPlus at ASU is located at SkySong, the ASU Scottsdale Innovation Center. The center houses a diverse business community that links technology, research, education and entrepreneurship to position ASU and Greater Phoenix as global leaders in the knowledge economy.

Activities are primarily performed in a regular, climate-controlled office setting subject to extended periods of sitting or standing. Daily use of desktop or laptop computer is required. Ability to clearly communicate verbally in English, read, write, see, and hear to perform essential duties. Regular review of completed tasks.

EdPlus at ASU supports flexible work options, ranging from alternate work schedules to hybrid remote work schedules, subject to approvals per ASU policy.

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.

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

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.

COVID-19 Vaccination Requirements: Arizona State University is a federal contractor and subject to federal regulations which may require you to produce a record of a COVID-19 vaccination. For questions about medical or religious accommodations, please visit the Office of Diversity, Equity and Inclusion's webpage.

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.

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

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

If you are an ASU internal applicant, please click on the ASU Employees link located on the Careers at ASU webpage to apply.

Only electronic applications are accepted 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.

To apply please go to www.asu.edu/asujobs/ see Req Id# 74931BR.