Associate Director, Business Intelligence

Emerson College•Boston, MA

5d•$116,950 - $146,250•Hybrid

About The Position

The Associate Director of Business Intelligence is a technical and strategic leader on the BI team, reporting to the Senior Director of Institutional Research. The role contributes to BI planning, execution, and daily operations, and leads data and BI projects from inception through completion, including data modeling and engineering solutions. It applies emerging technologies, complex analysis, data science, and predictive modeling to achieve business outcomes and participates in the College’s AI initiatives. The position oversees the College’s Snowflake data warehouse and data pipelines, designs and maintains data models and warehousing solutions, and develops reports, dashboards, and analytical solutions for institutional subject areas. It works with area leaders to identify metrics and KPIs, supports data quality and governance, and communicates technical work and findings to internal teams and external business users. The role also fosters team learning and handles complex data issues with minimal supervision. This is primarily a hybrid position, with expected weekly office days arranged upon hire. Candidates must live within a reasonable commuting distance of the Boston campus, and the arrangement requires approval under the Remote Work Policy. The scheduled workweek is 36.25 hours. Compensation is $116,950–$146,250 annually, commensurate with experience. The position is in the Division of Physical & Digital Infrastructure and is categorized as regular employment.

Requirements

Bachelor’s degree in Computer Science, Management Information Systems, Business, or a similar field, or an equivalent combination of education and experience.
10 years of combined experience as a data modeler, business intelligence analyst, or advanced report writer.
6 years of experience in database systems management, including hands-on data model or data warehouse design and understanding of dimensional/fact table structures and data aggregation.
5 years of experience with ETL tools and procedures.
Programming language experience for ETL and data pipelining.
3 years of Tableau or other dashboard development experience.
Strong SQL query, PL/SQL, and Oracle relational database skills.
Strong Excel skills and efficient use of visual tools.
Knowledge of data modeling, data extraction, and data transformation using SQL, PostgreSQL, Oracle, or ETL tools.
Ability to ingest, organize, and represent data in models that are accessible and understandable and meet business objectives.
Expertise in relational, dimensional, unstructured, and master data, and ability to communicate data concepts to technical and non-technical audiences.
Ability to develop end-to-end solutions, from constructing datasets to visualizing information in tools such as Tableau or Argos.
Experience with data mapping, business process analysis, criteria, and data-flow documentation.
Excellent written, oral, presentation, and storyboarding skills.
Ability to optimize data model performance and work with data stewards and data governance.
Knowledge of SDLC and project management best practices.
Strong organization, creativity, problem-solving, time management, and multitasking skills; ability to work independently and with a team and deliver within deadlines.
Ability to learn and apply emerging technologies and stay current through technology training and professional development.
Self-motivated, responsible, and detail-oriented.

Nice To Haves

Higher education experience.
Experience with Ellucian Banner, Slate, Canvas, or Workday.
Snowflake administration experience.
Python programming experience for API extraction.
Alteryx or SnapLogic ETL experience.
Familiarity with AWS Redshift or Snowflake.
Python, other scripting, or data integration technologies.

Responsibilities

Lead BI project planning and execution, provide technical direction, manage team performance, and coordinate timely deliverables with the Project Management Office.
Recommend and implement technologies, methods, data warehousing tools, and best practices to advance the BI program and support strategic outcomes.
Oversee the technical aspects of the Snowflake data warehouse, including infrastructure, standards, security, performance troubleshooting, and documentation.
Design and maintain data warehousing systems for structured and unstructured data, including queries, tables, views, and data applications supporting the College’s Data Strategy roadmap and strategic plan.
Design and implement data models that reduce redundancy, streamline data movement, and adhere to data security and privacy standards across institutional subject areas.
Build end-to-end ETL data pipelines using APIs, scripts, web services, files, and RaaS; administer and evolve integration processes and monitor data usage and performance in Snowflake.
Maintain data quality, knowledge retention, and process consistency through the institutional data dictionary, catalog, and business glossary.
Apply data analysis, data science, statistical analysis, predictive modeling, and data mining to develop reports and analytical solutions and identify trends and patterns in business and academic performance.
Work with area leaders to identify relevant performance metrics and KPIs and develop interactive dashboards using visualization and advanced analytics.
Advance College AI initiatives by researching emerging technologies, implementing AI and machine learning models for data initiatives, and presenting on AI use to the College community.
Communicate through written, verbal, and visual storytelling; prepare technical specifications, data mappings, and data-flow documentation for analytics projects.
Resolve complex data issues with minimal supervision and use sound judgment to escalate critical issues to management.
Foster team learning, cross-training, and knowledge building through professional development.
Map data from new sources to the central data model, validate data, gather requirements, and execute data extraction, transformation, and loading procedures.
Develop dashboards, reports, and visualizations that integrate internal and external public data sources, such as College Board or IPEDS.
Perform other duties as assigned.