Manager Data Warehouse & Integrations - IT Solutions

TITLE

Manager Data Warehouse & Integrations

JOB SUMMARY

The Manager Data Warehouse & Integrations is responsible for leading the development maintenance and continuous improvement of university-wide data warehouse business intelligence (BI) data integration and web services. They will serve as a champion advisor and liaison to university partners and key stakeholders for the development and effective use of this suite of services as well as the primary contact for application vendors and service providers. Additionally they will coordinate business processes between their area and other ITS teams and facilitate key divisional processes including incident and problem management knowledge management service process design and performanceanalysis.

The Manager Data Warehouse & Integrations will assist the Director of Enterprise Applications in fostering strong and collaborative partnerships between IT Solutions and greater university community. In support of this goal they will assist in the design delivery and assessment of a portfolio of enterprise application technology services that support and enhance teaching learning research and administrative functions.

As a member of the IT Solutions (ITS) leadership team the Manager Data Warehouse & Integrations will help lead the division in realizing its mission to empower an agile digital university and elevate technology as a strategic institutional asset. They are expected to work with the CIO Deputy CIO and other divisional leaders to drive cultural and technological transformation within IT Solutions and promote a collaborative human-centered innovative accountable transparent and inclusive culture within ITS.

ORGANIZATIONAL RELATIONSHIPS

Reports to:Director Enterprise Applications

Supervises:Application Integration Engineer Application Developer ERP Administrator Senior Database Administrator Database Administrator Data Warehouse & BI Solution Architect Data & Reporting Developer and StudentAssistants

ESSENTIAL DUTIES -May include but not limited to the following:

Management (35%)

• Builds supports and expands a culture that is supportive of diversity equity and inclusion where employees from all backgrounds can succeed andthrive.
• Trains coaches and mentors employees under theirsupervision.
• Plans and conducts performance appraisals of employees under theirsupervision.
• Conducts research on emerging products services protocols and standards in support of the functions withinIntegration.
• Prepares area budget and evaluate costs and performance of existing and new initiatives.
• Assists in the development and implementation of major projecttimelines.

Operations (30%)

• Consults with university partners and key stakeholders on design and implementation of new and re-designed systems to ensure that technology projects meet functional requirements system compliance and interfacespecifications.
• Manages complete solution development lifecycle including gathering requirements analysis design application development testing implementation maintenance user follow up support and projectmanagement.
• Plans prioritizes and manages the activities of team members to provide administrative and technical direction in support of the universitys operations and ensure efficient utilization of resources and completion of work tostandards.
• Leads project work of varying complexity and priority. Actively participates in or leads workgroups and meetings at the department division or universitylevel.
• Analyzes performance of activities within their area and document resolutions identify and remediate problem areas and devise and deliver solutions to enhance the quality of areas systems andservices.
• Identifies and executes continuous improvements to process andsystems.
• Tracks and analyzes department and/or service trends and generate reports for internal and externalaudiences.

Relationship Building (25%)

• Builds strong and collaborative campus partnerships for enterprise application support building and maintaining relationships with key constituents creating leading or participating in communities of practice working groups planning or assessment sessions and other collaborative efforts with key applicationstakeholders.
• Collaborates on and/or leads initiatives focused on promoting digital dexterity across the university raising awareness of current ITS services and other available or emerging technology tools and enhancing training and developmentopportunities.

ADDITIONAL DUTIES

Participation & Support (10%)

• Maintains awareness of current practices and future trends and best practices in business intelligence and data warehousing data integration and webservices.
• Represents IT Solutions and participates in the campus community by serving on working groups project teams and universitycommittees.
• Performs other duties asrequested.

EDUCATION

Bachelors degree in computer science Data Science or any other related discipline is required. Additional job-related experience may substitute for the required education on a year-for-year basis.

EXPERIENCE

Five years of relevant experience in data management data architecture data integration business intelligence data warehouse solutions web service development information systems management application architecture or similar. Supervisory experience required. Additional job-related education may substitute for the required experience on a year-for-yearbasis.

REQUIREMENT

Regular and reliable attendance at the University during regular scheduled days and work hours is an essential function of this position.

Work is performed under minimal supervision and performance is based on the effective operation of the administrative function. The performance evaluation is conducted through the performance evaluation system and in accordance with the University Policies & Procedures

All employees share the responsibility of maintaining information security and privacy requirements within the university by adhering to Federal and State regulations and TWU Policies & Procedures.

KNOWLEDGE SKILLS AND ABILITIES- The following are essential:

• Ability to manage enterprise-level application development and maintenance using SDLC and Software Development Methodologies such as Agile DevOps Waterfall Rapid Application Developmentetc.

• Technical knowledge of one or more of the following: integration platforms (eg Azure Data Factory Oracle Integration Cloud Snaplogic Mulesoft Dell Boomi); web applications; client/server software tools and languages such as PL/SQL Java C# Groovy Grails Javascript JQuery JSON XML Oracle software; ETL (Extract Transform and Load) architecture; and data warehousing technologies and tools (eg SAS Data Management platform Informatica DataStageSSIS).
• Skill in data management tools e.g. Informatica MDM or equivalent.
• Skill in Microsoft Power BI SSRS or similar reporting tools.
• Skill in implementing data governance policies procedures and tools.
• Strong written and oral communication skills (including ability to present ideas in user- friendly business-friendly and technical language) and interpersonal skills with a focus on rapport-building listening and questioningskills.
• Proven analytical and problem-solving abilities including ability to anticipate identify and solve criticalproblems.
• Exceptional customer serviceskills.
• Ability to build effective relationships and strong commitment to working collegially and collaboratively with constituents at all levels in a diverse and distributedenvironment.
• Ability to use a personal computer and other office equipment including related university software andemail.

Additional/Desirable Skills & Abilities

• Knowledge of relevant data-related certifications e.g. CDMP CBIP etc.
• Knowledge of effective IT or other shared governancemodels.
• Skill in budgeting financial planning and businessoperations.
• Skill in data modeling (dimensional modeling data vault 3NF etc.) data mining and logical/physical data modeling concepts (including complex data andstructures).
• Ability to create and maintain a datadictionary.
• Knowledge of ERP (such as Ellucian Colleague Oracle E-Business Suite Oracle Cloud) and CRM softwareapplications.
• Knowledge of Application-as-a-Service development(SaaS).
• Demonstrated skill in identifying and executing continuous improvements to process and systems.
• Ability in in analyzing documenting and modifying businessrequirements.
• Demonstrated ability in managing an application developmentteam.
• Strong documentationskills.
• Ability to conduct research into a wide range of computing issues asrequired.
• Ability to be highly organized and self-driven with ability to multi-task and perform in a fast-paced environment across a portfolio ofprojects.
• Ability to work in a team-oriented collaborativeenvironment.