This role is responsible for the analysis, design, implementation, documentation, and maintenance of analytics solutions, data extractions and processing to support mission-critical analyses, reports, visualizations and dashboards that drive key business decisions.
Work with business users to gather business requirements and complete analysis, design, development, testing and implementation of reporting, analytics and visualization needs across the campus using Cognos or other appropriate BI tools.
Identify data sources and build necessary queries, views, and/or Cognos packages to develop the reports, dashboards or analytics applications.Â
Create, enhance and maintain Framework Manager data models to support business requirements.
Monitor, investigate and troubleshoot data integrity and data quality between source systems (Banner, Degree Works, Slate, Canvas, etc.) and ODS.
Performance tuning of existing reports and analytics solutions.
Manage end user access in Cognos.
Document requirements, designs and data/metadata definitions.
Develop and manage reporting standards based on best practices while conforming to existing internal security guidelines.
Ensure proper configuration of production and non-production reporting and BI environments, co-ordinate and manage updates and patches to keep software platforms current, and provide on-going production support.
Contribute to report development end-user training and materials.Â Conduct training sessions as necessary.
Perform other duties as assigned.
Management retains the right to add or change job duties at any time.
Bachelor's Degree in Information Systems, Computer Science, engineering or other technical areas which provides analysis and programming or equivalent experience
Minimum of 4 years of experience writing complex SQL, PL/SQL queries
Minimum of 2 years of experience working with users in requirements gathering, developing and implementing analytics solutions and developing documentation
Minimum of 2 years of experience with Cognos Report Studio, Cognos Administration, and Framework Manager
Solid understanding of database, data warehousing and ETL/ELT concepts
Excellent interpersonal and communication skills
Strong analytical, conceptual and problem solving skills
Ability to work independently as well as within a team
Experience in a Higher Education environment
Experience with data analysis tools, including Python, R, SPSS, Tableau
Experience with transforming disconnected data from multiple sources into actionable information
Working knowledge of Oracle Data Integrator (ODI), Workato or similar integration tools
Experience with xml and json files
Experience with log file processing and analysis
Experience with visual analytics design
Knowledge of Data Management and Governance principles
Experience with Ellucian Banner, Banner ODS, Tableau Server, Workday, Canvas Learning Management System, EAB Navigate, Data Cookbook
Interested candidates will need to submit a resume and cover letter for consideration.
Organizational Marketing Statement:
With a proud history and a vibrant future, Montclair State University is one of New Jersey’s most diverse and dynamic institutions of higher education. One of four public research institutions in the state, Montclair State is a designated R2 Research Doctoral University by the Carnegie Classification of Institutions of Higher Education.
Located 12 miles west of New York City on a 252-acre suburban campus which boasts modern, state-of-the-art facilities complemented by green spaces, public plazas and striking Spanish Mission architecture, the University offers a comprehensive undergraduate curriculum with a global focus; a broad variety of superior graduate programs through the doctoral level; and a highly productive, dedicated and diverse faculty and student body.
The University’s 11 colleges and schools offer more than 300 undergraduate and graduate majors, minors, concentrations and certificate programs, and with more than 120 student organizations and 18 NCAA Division III athletic teams for men and women, Montclair State offers its students a comprehensive college experience.
Montclair State University is an Equal Opportunity/Affi...rmative Action institution with a strong commitment to diversity. Additional information can be found on the website at www.montclair.edu/human-resources/about-us/eo-aa-and-diversity/