Reporting to the Senior Director of Institutional Research, the Associate Director of Business Intelligence (BI) functions as a key technical and strategic leader, contributing to the planning, execution, and daily operations of the BI team. The Associate Director is responsible for leading BI and data projects from inception to completion, including the development and oversight of data modeling and engineering solutions. The Associate Director is expected to demonstrate rapid learning and technical agility, applying emerging technologies and complex data analysis, data science and predictive modeling to achieve meaningful business outcomes. Active participation in AI initiatives is also a core responsibility.
ESSENTIAL JOB DUTIES
- Lead the planning and execution of Business Intelligence (BI) projects, providing technical direction, managing team performance, and ensuring timely deliverables in collaboration with the Project Management Office (PMO).
- Recommend and implement innovative technologies, methods, and industry-leading data warehousing tools and best practices to advance the BI program and achieve strategic business outcomes.
- Oversee all technical aspects of the Snowflake data warehousing environment, including infrastructure, standards (table naming, schema, user security), performance troubleshooting, and documentation.
- Design and maintain a robust data warehousing system for structured and unstructured data, developing queries, tables, views, and data applications to support the College's Data Strategy roadmap and strategic plan.
- Design and implement robust data models that reduce redundancy, streamline data movement, and ensure adherence to data security and privacy standards across institutional subject areas (e.g., Enrollment Management, Academic Affairs, Finance, HR and Enterprise integration domain).
- Implement end-to-end data pipelines (ETL) utilizing APIs, scripts, web services, files, and RaaS.
- Administer and evolve data pipeline and integration processes, monitoring data usage and performance in Snowflake.
- Enforce data quality, knowledge retention, and process consistency through the curation and expansion of the institutional data dictionary and business glossary.
- Apply complex data analysis, data science, and modeling techniques to develop advanced reports and analytical solutions, including statistical analysis, predictive modeling, and data mining to identify trends and patterns in business and academic performance.
- Identify business-relevant performance metrics and KPIs with area leaders (e.g., Enrollment Management, Finance, Academic Affairs, HR), and apply innovative visualization and advanced analytics to develop interactive dashboards that create new business value.
- Drive the College’s Artificial Intelligence (AI) initiatives by researching and utilizing cutting-edge technologies, implementing AI and Machine Learning models to support data initiatives, and presenting on AI usage to the broader College community.
- Communicate effectively with internal teams and external business users through written, verbal, and visual storytelling, and develop detailed technical specifications, data mapping, and data flow documentation for major analytics projects.
- Handle complex data issues with minimal supervision, using sound judgment to escalate critical issues to management.
- Commit to professional development by fostering team learning, cross-training, and knowledge building.
- Map data from new sources to the central data model to support the creation of new or extension of existing reports/dashboards and perform data validation. Provide requirements and execute data extraction, transformation, and load procedures.
- Use complex data analysis and query, data science and data modeling techniques to develop reports and data analytics solutions. This includes engineering solutions in the form of business dashboards, reports and data visualizations integrating with internal and external public data sources like College Board or IPEDS. Provide statistical analysis of data, predict trends on business and academic performance, use data mining to extract information from data sets and identify correlations and patterns.
- Handle complex data issues with minimal supervision, while escalating critical issues to management using sound judgment.Enforce data quality, knowledge retention, and process consistency through the curation and expansion of the institutional data dictionary/catalog.
- Communicate effectively with internal teams and external business users through written, verbal and visual storytelling. Develop detailed technical specifications, data mapping and data flow documentations for major data analytics projects.
- Perform other duties as assigned.
QUALIFICATIONS – Qualifications are deemed required or preferred and represent what is needed to effectively perform job.
- Bachelor’s Degree in Computer Science, Management Information Systems, Business, or a similar field, or equivalent combination of education and experience required.
- 10 years’ combined experience as data modeler, business intelligence analyst or advanced report writer required.
- 6 years’ experience in database systems management. Hands-on experience in data model/data warehouse design. Solid understanding of dimension/fact table structure and data aggregation required.
- 5 years of experience in ETL tools and procedures required.
- Programming language(s) for ETL and data pipelining required.
- 3 years of Tableau or other dashboard development experience required.
- Higher Education experience preferred.
- Experience working with Ellucian Banner, Slate, Canvas or Workday preferred.
- Experience with Snowflake administration preferred.
- Experience in Python programming for API extraction preferred.
- Alteryx or Snaplogic ETL experience preferred.
KNOWLEDGE, SKILLS, AND ABILITIES – May be representative, but not all-inclusive, of those knowledge, skills, and abilities commonly associated with the job.
- Demonstrated organization, creativity, and agile problem-solving approach to resolve problems of diverse scope and complexity within deadlines.
- Excellent organizational, creativity, and problem-solving skills.
- Ability to multi-task and manage time effectively.
- Active participation in organization level activities and events related to learning, training, special projects etc.
- Experience ingesting, organizing, and representing data within a data model in formats that are easy to use, understand and meet business objectives.
- Expertise in defining and managing relational data, dimensional data, unstructured data, and master data to effectively translate and communicate data to both technical and non-technical audiences.
- Can develop end-to-end solutions from constructing the data set to visualizing information in a tool like Tableau or Argos reports and dashboards.
- Demonstrates best practices to use modern layouts, typography and interaction design.
- Excellent knowledge on data modeling, data extraction and data transformation using SQL, PostgreSql, Oracle or ETL tools.
- Excellent written and oral communication skills and ability to deliver messages and ideas effectively for different audiences.
- Experienced with data mapping, business process analysis, criteria and data flow documentation in written or visual format.
- Excellent presentation and storyboarding skills.
- Experience working with data models or data warehouses.
- Capable of working on problems of diverse scope and complexity, is resourceful in developing solutions encompassing challenges to deliver solutions before the deadlines.
- Following standard practices and procedures in analyzing situations or data to obtain trustworthy results.
