Technical Integration Lead

The Technical Integration Lead working under the guidance of the Product Development Director is responsible for driving all data migration, conversion and integration activities pertaining to the build and release of a replacement Student Information System (New SIS).

The legacy Student Information System consists of a mainframe with a combined web interface, served primarily by batch processing. The University's legacy SIS is a mission critical, enterprise-wide application that has successfully served the University for more than 20 years. New SIS provides for a modern, engaging user experience for students and administrators that can scale to meet the ongoing needs of the University. New SIS leverages the Python-Django REST framework, fronted by Angular2 single page web apps to enable a microservice based architecture that is resident in the cloud. Replacing the legacy SIS will be completed with a phased approach whereby the legacy SIS and the New SIS will operate in parallel, however, with different sets of functionality. As new functionality is released, the similar capability in the legacy SIS will be replaced by New SIS. The user experience will remain seamless via deep linking between the New and legacy SIS applications.

Given the nature of the data, it's critical that data displayed in either system be accurate and that the integrity of the data be maintained throughout the integration, migration and conversion processes. Significant progress on this project has been achieved so far and this role is needed to accelerate the rigorous testing, validation, and migration of critical data. This effort is complex and is managed as a top priority project, driven by a defined schedule, and comprising multiple technology teams, The Office of the Registrar, Student Financial Services and various schools and institutions. As such, coordination and the ability to work collaboratively with others is crucial and scrutiny of processes and outcomes should be expected.

As technical lead, you are required to collaborate with key stakeholders to execute a comprehensive, repeatable and iterative data migration and integration process. A well-defined process allows for continuous data cleansing, ensures the integrity of the data in the new replacement system and is based upon approved sponsor's requirements. Inherent in the requisite duties of this role will be to: establish a means to trace all changes, defects, and issues; account for the various feeds and integrations; comply with existing Security/Risk guidance and adopt best practices; and ensure the integrity of the final product.

The role is technical and hands-on in nature and requires well rounded skills to address complex business and technical problems. Additional responsibilities include but are not limited to leading analysis, documenting, redesign, development, implementation activities, and automating and driving standardization. Success criteria will focus on the efficacy of the process and its design, with an emphasis on reusability, scalability, optimization, and security. The person in this role will work closely with data modelers, business analysts, technical architects, ETL developers, and integration specialists and will personally complete tasks as needed, such as SQL programming, to accelerate the completion of activities.

CHARACTERISTIC DUTIES AND ESSENTIAL RESPONSIBILITIES:

• Demonstrate strong problem-solving capabilities
• Oversee daily data migration operations; tracing, triaging and documenting all problems
• Work with other project leads and necessary team members to provide remediation alternatives
• Address data quality and integrity issues pertinent to data migration and conversion activities
• Manage the analysis and review of daily integration activities
• Oversee mapping, migration and conversion/translation of data between source and target system(s)
• Map data and document conversion rules between source and new systems
• Plan and execute preload and postload data validation activities
• Report on task status and conversion readiness, escalate risks and provide recommendations
• Monitor post-migration data results and coordinate support to assure a seamless data use
• Collaborate with the data management team to ensure adherence to the data governance requirements
• Possess a methodical and logical approach to work and good time management skills
• Works closely with Business Analysts, Project Leads, Developers and SMEs on systems design, validation, and other related activities
• Manages and completes tasks according to the approved project timeline

• Technical Background: 5+ years of experience being involved and playing a key role in enterprise-scale projects pertaining to data conversion, data migration and/or leading related work streams on major technology projects
• At least 3+ years' Python experience
• At least 3+ years' SQL experience
• SQL querying for researching, analyzing, and troubleshooting data
• Expertise in data extraction, cleansing, transformation, loading and validation from legacy systems
• Experience with converting data related to individuals, vendors, transactional and historical data
• Experience with data conversion activities related to conversion planning, timing of data loads, managing object dependencies, and sequencing of tasks
• In-depth knowledge of data integration concepts and tools
• Experience with data validation throughout the conversion process
• Bachelor's degree and/or its equivalent work experience required

• Familiarity with Django framework is a plus
• Strong communication and analytical skills
• Gathering, cleaning and transforming data from various databases or systems into one place
• Understanding and conveying client needs from a technical perspective
• Ability to work with minimal supervision and with changing priorities in a fast-paced, deadline driven environment
• Ability to be precise and attentive to detail
• Ability to work weekends and off-hour work as required to meet deadlines