WIDA Data Integration Analyst

Salary:

Minimum $31.47 HOURLY
Depending on Qualifications
This position offers a comprehensive benefits package, including generous paid time off, competitively priced health/dental/vision/life insurance, tax-advantaged savings accounts, and participation in the nationally recognized Wisconsin Retirement System (WRS) pension fund. For a summary of benefits, please visit: https://hr.wisc.edu/benefits/

Job Summary:

The Data Integration Analyst position is located within the Administration and Operations department and will report to the Assistant Director of Information Technology. This position will be responsible for managing the data and synchronization between WIDA's core applications, including Salesforce CRM, Canvas LMS, Eloqua and a custom developed WIDA Secure Portal. This position will be responsible for working with developers and other IT staff to define and design data sync processes between these critical systems and will provide continued support of these processes with monitoring and remediation of issues. Additionally, this role will create and support ad-hoc data loads and extracts in and out of our systems and develop custom reports and dashboards to present data to users.

Working fully remote is an option for this position within the United States (working remotely internationally is not an option). Requests to work remotely would need to be reviewed based on the UW and School of Education (SoE) remote work policies and go through the SoE implementation process. To learn more about these policies, visit https://businessoffice.education.wisc.edu/human-resources/remote-work/ .

WIDA values linguistic and cultural diversity both as an end and a means for success in the field of education. As such, we strongly encourage applications from a diverse pool of candidates. For more information on WIDA's Mission and Values, please visit https://wida.wisc.edu/about/mission-history .

Responsibilities: Assists in the assessment, design, implementation, and maintenance of databases, data warehouses, and data models needed to support analysis and reporting. Provides routine operational support and assists in training, development, and facilitation.

• 20% Assists in assessment of business requirements, determination of appropriate strategy, and making recommendations
• 15% Assists in the design, implementation, and maintenance of data warehouses and data models needed to support analysis and reporting
• 10% Provides routine operational support and issue resolution of a data warehouses and associated processes
• 10% Provides guidance to internal stakeholders on data warehousing, database application programs, and automated procedures and reporting
• 5% Assists in the identification, development, and facilitation of training opportunities regarding data sets and programs
• 15% Collaborates with other IT professionals in the development of appropriate data warehousing design guidelines and effective use of tools for building and managing data models for data warehouses
• 10% Implements and tests routine data warehousing tools and data models
• 15% Supports the data cleaning, integration, and transformation of data in accordance with the defined target data model

Institutional Statement on Diversity:

Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals.

The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people from every background - people who as students, faculty, and staff serve Wisconsin and the world.

For more information on diversity and inclusion on campus, please visit: Diversity and Inclusion

Education:

Required
Bachelor's Degree

Qualifications:

Required
* Minimum of 2 years of proven experience writing complex SQL queries as a database developer or data analyst
* Minimum of 2 years of experience with data integrations and transformation of data
* Experience with ETL tools like Informatica
* Experience creating reports or data visualizations
* Strong attention to detail
* Collaborative approach to problem solving
* Excellent communication, customer service, teamwork, and issue resolution skills

Preferred Criteria
* Experience working with Salesforce data
* Experience with data analysis tools like Tableau or Power BI

Work Schedule:

40 hours per week, Monday through Friday. WIDA Core hours: 9 a.m. - 3 p.m. CT. Schedule will be determined upon hire.

Work Type:

Full Time: 100%

It is anticipated this position will be remote and requires work be performed at an offsite, non-campus work location.

Appointment Type, Duration:

Ongoing/Renewable

Additional Information:

What is WIDA? For over 20 years, WIDA has provided a trusted, comprehensive approach to supporting, teaching, and assessing multilingual learners. We are an educational services organization that advances language development and academic achievement for multilingual children in early childhood and grades K-12. In short, we provide educators around the world with high-quality language standards, assessments, professional learning, and research. We are proud to be a part of the Wisconsin Center for Education Research (WCER) within UW-Madison's nationally ranked School of Education. Visit https://wida.wisc.edu/about/careers and watch our Introduction to WIDA video to see why WIDA is an incredible place to work!

The Wisconsin Center for Education Research (WCER), established in 1964, is one of the first, most productive, and largest university-based education research and development centers in the world. WCER's researchers and staff work to make teaching and learning as effective as possible for all ages and all people. WCER's mission is to improve educational outcomes for diverse student populations, impact education practice positively and foster collaborations among academic disciplines and practitioners. To this end, our center helps scholars and practitioners develop, submit, conduct, and share grant-funded education research.

WCER's Commitment to Diversity, Equity & Inclusion:
Diversity is a source of strength, creativity, and innovation for UW-Madison and The Wisconsin Center for Education Research (WCER). Individual differences and group diversity inspire creative and equitable outcomes. WCER actively affirms values and seeks to increase diversity in our everyday interactions, practices, and policies. For more information and news about our center, please go to https://wcer.wisc.edu/ .

If you need to request an accommodation because of a disability during the recruitment process, please email education-HR.DDR@education.wisc.edu , and one of our Division Disability Representatives will contact you. More information can also be found at https://employeedisabilities.wisc.edu/disability-accommodation-information-for-applicants/ .

How to Apply:

Please click on the "" button to start the application process. As part of the application process, you will be required to submit:
- A cover letter describing how your experience and qualifications meet the requirements of this position.
- A current resume or CV.
- A list of at least three professional references, including contact information.

A successful applicant will be responsible for ensuring eligibility for employment in the United States on or before the effective date of the appointment.

Contact:

Kelly Krahenbuhl
humanresources@wida.us
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.

Official Title:

Database Report Writer I(IT027)

Department(s):

A17-SCHOOL OF EDUCATION/WCER

Employment Class:

University Staff-Ongoing

Job Number:

301875-CP

The University of Wisconsin-Madison is an Equal Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence through diversity and encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, click here

If you need to request an accommodation because of a disability, you can find information about how to make a request at the following website: https://employeedisabilities.wisc.edu/disability-accommodation-information-for-applicants/

Employment may require a criminal background check. It may also require you and your references to answer questions regarding sexual violence and sexual harassment.

The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7).

The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department .