Apply on Employer Site

Empire State University · 10 hours ago

Associate Director of Business Analytics

New York, United States

Full-time

Hybrid

Lead/Staff, Director/Executive

$90K/yr - $100K/yr

3+ years exp

Empire State University is seeking an Associate Director of Business Analytics in the Office of Decision Support. This role involves leading business analytics projects, engaging with stakeholders to define KPIs, and managing data warehouse environments for analytics and reporting.

Higher Education

No H1B

Responsibilities

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

Qualification

Advanced SQL skillsBusiness intelligence toolsData warehousingData modelingData miningAnalytical skillsSupervisory experienceCommunication skillsTeam-oriented

Required

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

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