Job Description

Reporting to the Director of Business Intelligence of Enterprise Data and Solutions of Information Technology, the Data Visualization Analyst is a key contributor to the Business Intelligence team responsible for the development of BI solutions through dashboards, reports, and data visualizations to answer key data and business questions for decision support. The role analyzes complex datasets to solve business issues, ensures data quality, data policies and standards are enforced across the College’s ecosystem. The Analyst will participate in multi-year BI program initiatives in designing, developing, testing and training business users on BI products. This position requires hands-on dashboard development experience, with solid data analysis and data modeling skills. Experience developing solutions using industry-leading BI tools, such as Tableau, and working with scaling the campus operational reporting platform, Argos, are key success factors. The position plays a key role in the creation and delivery of the business intelligence strategy that shapes the future of the college’s data analytics. Excellent data query and data analytical ability with strong academic and business knowledge are essential.
ESSENTIAL JOB DUTIES
Contribute to the strategic planning process for business intelligence initiatives, recommend innovative technologies, methods, and industry-leading tools and best practices, design and maintenance of a system to warehouse data and information, including structured and unstructured data sets.
Scale Argos and Tableau platforms through building advanced dashboards and incorporate new and diversified data sources. Actively organize and participate in data literacy, report and dashboard training to key business users. Through storytelling to evolve data analytics for department engagement.
Manages all technical aspects of our business intelligence environment, including data transformation and governance, performance monitoring and identification and support of analytics tools.
Use complex data analysis and query, data science and data modeling techniques to develop report and data analytics solutions for decision support. This includes developing data models, engineering solutions in the form of business dashboards, reports and data visualizations integrating with other 3rd party applications.
Partner with academic units and business departments such as Institutional Research, Enrollment Management, Registrar, Finance, HR, Financial Aid and Institutional Advancement to define and execute potential BI initiatives. Analyze data needs, gather report or dashboard requirements, perform data mapping including multiple internal data sources and/or the use of public data, to create BI solutions to solve business issues. This often involves conducting complex root cause analysis to troubleshoot data discrepancies, work with end users to correct business processes, and systematically cleanse inaccurate data sets.
Identify performance metrics and KPIs with relevant business area leaders. Apply innovative visualization and data science techniques to develop interactive dashboards, and to analyze and interpret trends or patterns using a large data population.
Effectively work and collaborate with PMO on BI projects, ensure deliverables are completed on time, and objectives are met.
Manage tables and data views within Oracle database, SQL Server, PostgreSQL and synchronize with data models with corresponding data mapping and appropriate ETL tools. Keep current on the latest technologies, develop proof-of-concept prototypes to advance the BI program.
Commit to professional development by fostering a climate of team learning, cross-training and knowledge base building.
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 team 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
Bachelor’s Degree in Computer Science, Management Information Systems, Business or a similar degree, combined work experience and education as equivalent. Higher Education experience preferred
10 years of experience as data visualization analyst, business intelligence analyst or advanced report writer.
5+ years of Tableau Dashboard development experience.
Experience working with data stewards, data governance, and data standards.
Experience working with Ellucian Banner, Slate, Canvas or Workday preferred
Certification in Tableau or other applicable business intelligence tools preferred
Experience in data warehouse or data modeling preferred
Familiarity with HelioCampus, Redshift, Python or other scripting or data integration technologies preferred
KNOWLEDGE, SKILLS, AND ABILITIES
Strong SQL query and Oracle relational databases skills.
Strong Excel skill and efficient use of visual tools.
Ability to optimize performance of dashboards and data sources.
Ability to extract diverse datasets, perform data mapping, and ETL data transformation.
Knowledge of SDLC and project management best practices.
PHYSICAL ABILITIES
Requires ability to lift and move objects that are light
Requires ability to move materials occasionally