Data Integration Architect

Data Integration Architect (Software Engineer /Developer III) reports to the Director of Enterprise Information Systems.

The position has a pivotal role in the integration of enterprise systems, including Peoplesoft Campus Solutions, Workday, BP Logix, Transact, Stellic, and others. The developer collaborates closely with functional stakeholders, vendors, and Learning and Information Technologies (LIT) teams to build and maintain, secure, efficient, and scalable enterprise solutions.

Essential Job Functions and Responsibilities

• Performs comprehensive data integration across various enterprise systems, as well as operations, academic, research, and auxiliary/third-party systems utilized throughout the University.

• Ensures efficient, accurate and secure data exchange between SIS, CRM, Finance, HR, LMS, data warehouses, and other UW-System, campus and third-party vendors.

• Implements and supports data cleaning, validation techniques, creating test plans, and audits to maintain high-quality, accurate data.

• Writes complex queries, procedures, and scripts to support data retrieval, transformation, and processing needs.

• Ensures data systems adhere to privacy regulations (e.g., FERPA) and institutional policies.

• Provides project and change management related to the enterprise system integration. Conduct systems analysis, interface with stakeholders, create business process maps, interpret system requirements and create project plans and communication strategies.

• Create and maintain detailed system design specifications and documentation., * Keep abreast of the latest trends, best practices, and emerging technologies in data integration, data base systems, and cloud services.

• Identify opportunities to incorporate new features, tools, or methodologies that can elevate the user experience or streamline development workflows.

• Attend relevant conferences, webinars , or training sessions to build expertise and contribute innovative ideas to the team.

• Close work with Enterprise information System team members, data stewards and custodians, functional service owners, UW-System and third-party vendor technical staff, and serve as an escalation point of contact for complex integration related service requests.

Physical Demands

While performing the duties of this position, the employee must have the mobility to work in a standard office setting and to use standard office equipment, hearing and speech to converse in person and over the telephone and vision to read printed materials and a computer screen. Accommodation may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation., * Trains and provides technical guidance to lower level staff

• Reviews application design specifications, codes new applications, and makes enhancements to existing applications

• Contributes to the development of data structure and systems performance strategies

• Leads sub-functional team for application development or enhancement

• Conducts analysis for the evaluation and selection of vendor software solutions and packages

• Reviews application modules for quality assurance and checks compliance with application architecture standards

• Conducts systems analysis, reviews and interprets system requirements, and develops detailed system design specifications for system integration and upgrades

• Develops, prepares, or modifies technical specifications for complex projects, system integrations, and upgrades

• Prepares program documentation and training requirements

• Designs and implements test plans, and prepares systems test data

Department:

Learning and Information Technology ( LIT) is UW-Stout's steward of technology in support of education. We are committed to providing and maintaining secure, high-quality, reliable, and flexible solutions in alignment with UW-Stout's mission and vision.

The Enterprise Information Systems department serves UW-Stout's academic and workforce development communities through the implementation and management of enterprise information systems that support the teaching and learning, research, and administrative functions of the college., The Universities of Wisconsin provides an excellent benefits package including participation in the Wisconsin State retirement plan, demonstrating our commitment to the diverse needs of our employees.

• Employee Benefits: https://www.wisconsin.edu/ohrwd/benefits/

• To calculate the estimated value of your total compensation, use the Health & Retirement Contributions Estimator | Employee Benefits (wisconsin.edu)

Employment is contingent upon the final candidate's completing a criminal background check and being cleared to work by the Human Resources Office. Employment is also contingent upon the final candidate passing reference checks and an essential job function test, as applicable. The reference check process includes asking the final candidates' professional references questions regarding employee misconduct, sexual violence, and sexual harassment. Reference checks must be conducted at a minimum with three professional references, at least one of which must be a prior supervisor.

Final candidates with previous employment within the Universities of Wisconsin and State of WI agencies will be subject to additional reference checks.

In response to a public records request, the Universities of Wisconsin will not reveal the identities of applicants who request confidentiality in their online application, except that the identity of the successful final candidate will be released. See Wis. Stat. sec. 19.36(7).

UW-Stout is committed to providing safety and security of all members of our community in accordance with the Clery Act. For campus safety information and crime statistics visit: https://www.uwstout.edu/life-stout/police-and-parking/clery-information

Do you have experience in Test Planning (Quality assurance practices)?, Do you have a Bachelor's degree?, * A bachelor's degree in computer science, software engineering, or a related field.

• Proven experience with enterprise data integration in a higher education setting, including data modeling cloud platform integration, and data transformation/ETL.

• Database management (Oracle, Postgres/Redshift, MS-SQL)

• Integration platform experience such as Informatica, Peoplesoft Integration Broker, and technologies including API's web services and webhooks.

• Experience with programming and scripting languages used in data integration such as python and java.

• Complex problem solving and analytical skills.

• Knowledge of higher education business processes and administrative functions.

• Ability to plan and manage enterprise projects, including business process mapping, the use of project management tools, and creating documentation for a variety of audiences.

• Work collaboratively and communicate clearly across multiple functional areas, both technical and non-technical.

• A fundamental knowledge of Artificial Intelligence and its use in design, function, and development related to system integration., * A bachelor's degree in computer science, software engineering, or a related field.

• Proven experience with enterprise data integration in a higher education setting, including data modeling cloud platform integration, and data transformation/ETL.

• Demonstrated expertise in database management (Oracle, Postgres/Redshift, MS-SQL).

• Experience with integration platforms, such as Informatica, Peoplesoft Integration Broker, and technologies including APIs, web services and webhooks.

• Experience with programming and scripting languages used in data integration such as python and java.

• Demonstrated complex problem-solving and analytical skills

• A strong knowledge of higher education business processes and administrative functions

• Experience planning and managing enterprise projects, including business process mapping, the use of project management tools, and creating documentation for a variety of audiences.

• Ability to work collaboratively and communicate clearly across multiple functional areas, both technical and non-technical.

• A fundamental knowledge of Artificial Intelligence and its use in the design, function, and development related to system integration., * Demonstrated experience with Oracle PeopleTools, PeopleCode, Integration Broker, and Application Designer.

• Experience with AWS data management including Lambda, Athena, Glue, and Redshift

• Strong experience in data governance, including the use of the Collibra Platform

4.34.3 out of 5 stars Full-time, Weekends Hybrid work in 712 Broadway St S, Menomonie, WI 54751, Some travel is required for necessary meetings, workshops, conferences, etc., including some nights and weekends., Competitive salary commensurate with qualifications and experience.