DATA ETL MANAGER

Data ETL Manager

Arizona State University

EdPlus Data Analysis

Off-Campus: Scottsdale

75047BR

Job Description

EdPlus at ASU is currently seeking an energetic Data ETL Manager to join our high performing team.

We are proud to be on the forefront of Educational Innovation by using the latest analytics tools and processes so that we’re able to maximize our offerings and deliver unparalleled service and support. This is an exciting opportunity for a highly innovative person to work in a fast pace, dynamic environment. Duties include, but are not limited to, coordinates and monitors the design, development, modification and implementation of the department’s DataMart; provides technical support and leadership for the environment; coordinates and monitors the access of stakeholders to the department DataMart.

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.

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

Salary Range

Depends on experience

Close Date

25-January-2022

Essential Duties

• Provide team management, leadership, and guidance to continue to advance the Data ETL team.
• Assist in resource planning and schedule and train ETL development resources
• Analyze and interpret complex data on source and target systems and analyze and provide resolutions to any data issues and coordinate with data analyst to validate requirements, perform interviews with users and developers.
• Collaborate with business analyst, data analyst and data scientist to construct data models to be used to define the transformation stage and underlying technologies that will perform formatting.
• Develop Datamart models and prepare reports for meta data integration into systems and draft ETL scripts and prepare required reports for all end users.
• Outline the ETL process, setting the borders of data processing and design system architecture for each element and the whole data pipeline
• Coordinate and Implement ETL procedures for new projects and maintain effective awareness of production activities according to required standards and provide support to existing applications.
• Develop and perform tests on ETL codes and design data mapping techniques for data models in systems.
• Collaborate with all developers and business users to gather required data and execute ETL programs and scripts on systems and implement Datamart activities and prepare reports for same.
• Document technical and system specifications for ETL processes and perform unit tests on processes and prepare required programs and scripts.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
• Perform tests and provide update to ETL activities within schedule and provide support to large data volumes and assist in data processing.
• Perform tests and validate data flows and prepare ETL processes according to business requirements and incorporate business requirements into design specifications.
• Perform root cause analysis on ETL processes and resolve any production issues and validate data and perform routine tests on databases and provide support to ETL applications.
• Provide support to ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on ETL processes.
• Assist leadership in the strategic planning of the future of the Data ETL Team.
• Assumes or coordinates other duties or projects as assigned or directed.

Minimum Qualifications

Bachelor's degree in Information Technology or closely related field.8 years web, database or related with 3 years full project management within an IT environment.

Desired Qualifications

• Evidence of a Bachelor's degree or higher in a related field.
• Experience managing or leading project development teams
• Demonstrated knowledge proficiency about data virtualization
• Experience in at least one ETL tool (Alteryx, SSIS, Talend, Pentaho, etc.). ETL tool like Alteryx or Matillion is a plus.
• Experience in SQL and AWS Redshift development
• Evidence of expertise in scripting languages (Python, Bash, Perl, etc.). Python is a plus
• Experience in programming languages (JavaScript, Java, C++, etc.)
• Evidence of specialization in database engineering skills (SQL, RedShift, NoSQL, etc.)
• Experience in modelling techniques and modeling tools (Toad Data Modeler, Erwin, etc.).
• Evidence of parameterization of ETL jobs for better time management.
• Demonstrated knowledge proficiency about OLAP, SSAS, SSIS, and MDX.
• Evidence of data analytical, thinking, and troubleshooting skills
• Evidence of project management skills
• Evidence of effective communication skills
• Demonstrate ability to solve complicated technical issues, understand risks prior to the occurrence
• Evidence of competence to understand the large picture of the organizational data situation
• Evidence of collaborative and team skills
• Demonstrate abilities of task organization, time management, and project management skills
• Evidence of creative, innovative, out-of-the-box thinking and drive to learn new things.
• Evidence of problem-solving 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 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.

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.

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.

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/relocation-services.

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.

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# 75047BR