WIDA Data Integration Analyst

University of Wisconsin Madison
$31.47 HOURLY
life insurance, paid time off, remote work
United States, Wisconsin, Madison
21 North Park Street (Show on map)
Jan 16, 2025
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. Remote work is an option for this position on a voluntary basis; however, it is important to note this role is headquartered in Madison, WI and the tasks of the position require occasional work-related travel. If working remotely out-of-state, travel back to UW-Madison would not be reimbursable and other business travel will require cost comparisons between your home and Madison, WI. UW Travel Policy and Remote Work Policies outline business travel requirements for fully remote employees, and WIDA is committed to supporting employees with their business travel and minimizing or eliminating out of pocket expenses whenever possible. Please review UW Remote Work Policy UW-5087, in particular, Section III, Part G which addresses an employee's Headquarters Location. We will be happy to support and address questions about remote work or travel during the interview process. WIDA operates in a Windows-based environment and a Dell PC laptop will be issued for use in this role. Software and virtual connection tools that are critical to our work dictate that WIDA staff work on a PC. 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: Minimum Years of Experience/Required Skills and Knowledge: * Minimum 2 years of proven experience writing complex SQL queries as a database developer or data analyst * Minimum of 2 years' experience with data integrations and transformation of data * Experience with Azure Data Factory * Experience working with Salesforce data * Experience with data analysis and visualization tools like Tableau or Power BI * Strong attention to detail * Collaborative approach to problem solving * Excellent communication, customer service, teamwork, and issue resolution skills Work Schedule: 40 hours per week, Monday through Friday. WIDA Core hours: 9 a.m. - 3 p.m. CT. The 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 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/ 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. For more information and news about our center, please go to https://wcer.wisc.edu/. How to Apply: Please click on the "Apply Now" 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: 310424-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.