Senior Manager, Enterprise Integration

Austin Community College • Austin, TX

2d

About The Position

The Sr. Manager Enterprise Integration is responsible to build and manage enterprise data hub to share the data among multiple systems and Identify silos and bring such data into the main stream and create a strategy for such silo systems. The Manager should also have Data Architect knowledge and able to leading the definition and roadmap for the college's BI Strategy that includes data warehousing, analytical reporting, operational reporting, ETL, data governance, and master data management.

Requirements

• Familiar with data technology design, implementation, or consulting in one or more of the following areas: Enterprise Data Warehouse Business Intelligence Reporting & Analytics Tools Cloud Platforms Data Lake and Big Data Artificial Intelligence
• Familiar working with enterprise architecture or solution architecture frameworks, methodologies, templates, and tools.
• Extensive knowledge in good data modeling techniques.
• Competent in MS SQL Server, Oracle SQL, stored procedures, and other SQL.
• Knowledge of best practice for Data Quality Management, Master Data Management and near real time data warehousing.
• Experience with ETL/ELT tools such as Informatica IICS Suite.
• Maintaining an established work schedule.
• Effectively using interpersonal and communications skills including tact and diplomacy.
• Effectively using organizational and planning skills with attention to detail and follow-through.
• Outstanding analytical and problem-solving abilities.
• Presentation skills with a high degree of comfort with both large and small audiences.
• Ability to take complex concepts and create models for discussion, evaluation, and collaboration.
• Excellent oral and written communication skills. This includes the ability to explain technology concepts to business leaders, as well as business concepts to technologists, and the ability to sell ideas and processes internally at all levels.
• Ability to work independently and be self-motivated, committed and detail oriented.
• Ability to understand and follow instructions precisely.
• Maintaining confidentiality of work-related information and materials.
• Establishing and maintaining effective working relationships.
• Experience in strategic technology planning and execution, as well as policy development and maintenance.
• Knowledge and skills in SQL (structured Query language).
• Use a variety of spreadsheet, word processing, database, and presentation software.
• Use query and control languages, administer applications, and provide technical support to end users.
• Skills in modelling tools such as ERWIN, Embarcadero, Visio, and LucidChart.
• Bachelor's degree.
• Reliable transportation for travel in the Austin area as required.

Nice To Haves

• Unidata experience a plus.
• Experience with modern databases such as SQL Server, Oracle, or DB2.
• Experience in modern analytics platforms such as Tableau, SAS, Domo, Microsoft Power BI.
• Hands on experience with ETL using leading ETL vendor software such as Informatica cloud (IICS) Suite, DataStage, Micrsoft SSIS.
• Hands on experience with SQL and ETL Tuning.

Responsibilities

• Supervises, trains, coaches, directs, coordinates, and disciplines personnel while adhering to organizational human resource policies and procedures as well as related employment laws.
• Recommends hire and termination personnel actions for positions supervised.
• Defines and designs the data warehousing solution and ETL/ELT processes.
• Works closely with the business to understand the data and provide meaningful analytics to users/customers.
• Manages Informatica IICS and data projects, performs strategic analysis of data best practices, design databases and data profiling.
• Supervises the ETL and Informatica Developers.
• Prioritizes and delegates requests received by the product owner and scrum manager.
• Communicates with the multiple teams for the data requirement.
• Analyzes data and develop data architecture.
• In coordination with Quality Control team, ensures accuracy of standards and procedural documentation related to data.
• Participates in the definition, implementation, and support of the overall integration strategy.
• Participates in the selection, design, and implementation of the data hub, the data warehouse, operational data layers, and ETL.
• Participates in meeting with customers, gathering requirements, and working with developers to provide solutions to end users.
• Provides technical leadership to other members of the Business Intelligence Team.
• Participates in BI product evaluations and business decisions to ensure fit and scale into the platform and the organization.
• Participates in an energetic team of experienced people in an agile environment.
• Creates high level and detailed design of current and future state of BI System.
• Creates architecture diagrams and models of Data, Data Warehouse, and Integration and mapping documents with high level design.
• Supervise safe operation of unit.
• Facilitate safety inspections.
• Take reasonable and prudent actions to eliminate identified hazards.
• Ensure employees receive appropriate safety training and foster a workplace safety culture.

Benefits

• Benefits include medical, dental, life insurance, short- and long-term disability, retirement plans, and AD&D.
• ACC does not participate in Social Security.
• ACC participates in the Teacher Retirement System of Texas (TRS) and the Optional Retirement Program (ORP-Faculty and Administrators Only).
• Hourly employees participate in the ACC Money Purchase Plan (ACCMPP) as a retirement program required by federal law.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 1,001-5,000 employees