"Alerted.org

Empire State University currently seeks an Associate Director of Business Analytics in the Office of Decision Support. The Associate Director of Business Analytics will support the design, development, and management of a data warehouse environment used for analytics and reporting.

As part of the Office of Academic Affairs, Decision Support collects, analyzes and disseminates information to support institutional planning, decision making, and reporting at Empire State University. Decision Support consists of four institutional research, outcomes assessment, strategic planning, and business analytics, which further includes data warehousing, initiatives in information management, and supports for decision making.

As part of Decision Support, the data warehouse team works with campus stakeholders to develop data models and intelligence delivery systems so the campus can achieve a wide range of strategic and tactical goals. The team is responsible for the entire scope of data warehousing and Business Intelligence, including requirements discovery, data mining and profiling, data model design, implementation, maintenance, training and support. The SUNY Empire State University data warehouse is expected to be a central part of all strategic initiatives for business and academic improvement at the University.

Responsibilities include:

+ Lead and manage business analytics projects focused on driving data-driven decision-making and business strategy.

+ Engage with stakeholders to gather/determine requirements, priorities, define key performance indicators (KPI) for reporting and analytic solutions in support of campus initiatives.

+ Design, develop and communicate appropriate data structures and architectures including data vault, star schema and data mining models.

+ Develop and test programs using TSQL, PLSQL and other various tools (e.g., WhereScape RED, SSIS, Python) to support reporting and extract solutions.

+ Support business and technical staff regarding the content and use of data warehouse objects.

+ Maintain table structures, programs, scripts and documentation and develop data management strategy.

+ Ability to conceive and portray the big data picture: initiate, evaluate, and influence projects from the perspective of the entire organization.

+ Implement sound data modeling and database design across all phases of development from conceptualization to database optimization; using skills that extend from SQL development to database administration.

Job Requirements:

Required Qualifications:

+ Bachelor's degree from an accredited college or university.

+ A minimum of 3 years' practical experience delivering business intelligence/analytic or related solutions.

+ Advanced SQL skills (e.g. functions, stored procedures, pivoting, cursors, triggers, indexes, constraints, etc.)

+ Ability to leverage various API's to integrate data to and from various sources.

+ Strong analytical, business process, and design skills.

+ Excellent presentation, written, verbal and communication skills with the ability to engage and influence employees and leaders at all levels of the organization.

+ Experience developing business intelligence and reporting solutions using any major industry standard tool (e.g. PowerBI, Cognos, MicroStrategy, Tableau, etc.).

Preferred Qualifications:

+ Knowledge of OLAP technologies and dimensional modeling, including their applicability to various reporting problems.

+ Knowledge of industry trends including data mining, visualization, and predictive modeling; experience with designing models to support enrollment prediction and forecasting is a plus.

+ Experience in higher education and their associated data landscapes or strong conceptual knowledge of a higher education systems (e.g. Banner, CRM Recruit, Advise, etc.).

+ Exposure to a team-oriented work environment.

+ Practical experience with data warehousing/business intelligence best practices, methodologies, standards, and architectures.

+ Knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems; preferably Oracle or MS SQL Server.

+ A minimum of 1 year of practical experience delivering business intelligence/analytic or related solutions.

+ Experience with Microsoft Fabric.

+ Supervisory Experience in a Unionized setting.

Special Information:

+ Occasional travel may be required to fulfill department and university-wide commitments.

+ SUNY Empire provides employees with robust remote and flexible work options to meet the needs of students, faculty, and staff in a dispersed work environment.

+ Applicants must be currently authorized to work in the United States on a full-time basis. VISA sponsorship is not available for this position.

Additional Information:

Rank/Salary: Staff Associate, SL4 / $90,000-$100,000, dependent on experience and qualifications.

We are pleased to offer our employees an excellent benefit package which includes NYS health insurance, free dental and vision, competitive retirement options, and generous vacation, sick and holiday accruals; and a strong emphasis on work-life balance. We also offer professional-development activities for professionals and support staff.

SUNY Empire is an AA/EEO/ADA employer. The University actively seeks applications from women, veterans, individuals with a disability, members of underrepresented groups or anyone that would enrich the diversity of the University. SUNY Empire is committed to fostering a diverse community of outstanding faculty, staff, and students, as well as ensuring equal educational opportunity, employment, and access to services, programs, and activities, without regard to an individual's race, color, national origin, religion, creed, age, disability, sex, gender identity, sexual orientation, familial status, pregnancy, predisposing genetic characteristics, military status, domestic violence victim status, or criminal conviction. Employees, students, applicants, or other members of the university community (including but not limited to vendors, visitors, and guests) may not be subjected to harassment that is prohibited by law or treated adversely or retaliated against based upon a protected characteristic.

SUNY Empire provides reasonable accommodations to applicants with disabilities, veterans, or wounded warriors where appropriate. If you need a reasonable accommodation for any part of the application and hiring process, please contact the Office of Human Resources at (518) 587-2100 ext. 2240.

In accordance with the Title II Crime Awareness and Security Act, a copy of our crime statistics is available upon request by calling (518) 587-2100, ext. 2800. It can also be viewed online at our Safety and Security website (https://sunyempire.edu/about/safety-security/jeanne-clery-act/annual-safety-security-report.html) .