The Sr. Manager, Business Intelligence Application Systems, will have oversight for the Enterprise Business Intelligence Solutions (EBIS) application development team responsible for the architecting, integration and development of all enterprise reporting, and business intelligence (BI) and analytics capabilities within Columbia University Information Technology (CUIT). Reporting to the Director of Enterprise Business Intelligence Solutions (EBIS), the incumbent will be responsible for successful execution of the strategic goals as outlined on the Business Intelligence roadmap to include managing BI resources, project schedules and deliverables. Incumbent will also be responsible for the processes associated with projects and initiatives needed to deliver BI (Business Intelligence) solutions to the business. The Sr. Manager will work closely with the business, enterprise applications, EBIS data architects, DBAs, deployment, systems, and functional teams to plan, manage, design and develop BI solutions. Therefore, proven ability to cultivate and maintain client relationships is essential.
CHARACTERISTIC DUTIES AND ESSENTIAL RESPONSIBILITIES: - Partners with customer and end users in understanding their requirements and prioritization and the Director, EBIS on the execution of strategic initiatives and directing resources in the management of day-to-day activities and execution. - Leads and mentors the BI team to implement BI and general IT best practices (i.e. data warehouse, reporting and analytics and application architecture best practices, ITIL, Change management, SDLC, Disaster Recovery, Incident Management, standards etc.). - Works closely with data architects and the build team leads to create plans, estimates and resource schedules. - Oversees the design, develop, implementation and support of various enterprise wide reporting solutions. Also works closely with team members, internal customers, DBAs, Data Architects, Deployment team and Infrastructure team to design solutions and to schedule resources. - Establishes and document SLAs and OLAs with customers and service providers. - Tracks change requests, incidents, and service requests utilizing ServiceNow. - Works with BI team to encourage contributions to the definitions found in the data dictionary. - Participates as a solution architect and designer for non-routine projects. - Reports to Director through status meetings and/or status reports, metric reports, and dashboards regularly or as requested. - Works to align work efforts with the goals, objectives and architectural vision of the Enterprise Application and EBIS organization. - Manages change management, service request and incident resolution process. Manages EBIS service providers as needed. - Supervises tool administration assure system availability commitments. - Oversees production management to include define and report on metrics associated with good performance (i.e. report times, load times, Incidents, Service Requests, CRs, etc.)
- Bachelor's degree and/or its equivalent required. Advanced degree desirable. - Minimum 5 - 7 years work related experience.
Applicant MUST meet these minimum qualifications to be considered an applicant.
- Minimum 5+ years prior experience directing a BI team and leading strategic initiatives including implementing new technology and BI best practices. - Strong DW and BI analytics experience. - Experience in DW design, Big data, Data lake, Machine learning and analytics experience is a big plus. - Strong experience in data integration and automation using batch and real time integration is a must. - 5+ years of software development experience with a specialty in business intelligence tools and data warehousing technology and architecture. - 5+ years' using Business Intelligence tools to implement standard reporting, self-service reporting, dashboards, database objects and analytics. - Deep knowledge of Oracle SQL programming (stored procedures, functions, complex SQL, performance tuning, etc.) 5+ years with SQL and PL/SQL using Oracle. - Prior experience developing reports in a Unix and/or Windows environment. - Prior experience in managing and leading enterprise level teams. - Prior experience developing project plans, resource plans, schedules, project requirements and scope documents. - Must have excellent written and verbal communication skills. Able to develop crisp documentation, design specifications, and training material. - Excellent listening, presentation, and interpersonal skills. Ability to communicate ideas in both technical and user-friendly language - Demonstrated ability to work in a fast-paced, deadline driven environment with a keen attention to detail. - Demonstrated excellence in a variety of competencies including teamwork/collaboration, problem solving/troubleshooting, analytical thinking, communication and influencing skills, and technical expertise. - Ability to work weekend and off-hour work on occasion. - Excellent understanding of a systems development lifecycle methodology. - Proven experienced implementing Data Warehouse and Data Mart architectures (i.e. Kimball).
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It... seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.