The Whitman School of Management is seeking a Data Modeling Analyst to design, develop, and maintain dashboards, analyses, reports, and datasets to improve the performance of administrative and operational processes, monitor operations, and increase the effectiveness and efficiency of various school activities.
Requirements
- Proficiency with data modeing and visualization tools (e.g., PowerBI, Tableau)
- Experience with statistical programming software (e.g., SPSS, SAS, R) is preferred
- Understanding of relational and dimensional databases and SQL
Responsibilities
- Designing, developing, and maintaining comprehensive dashboards, analyses, reports, and datasets
- Develop and present operational and strategic data visualizations to address critical business questions and key performance metrics
- Create interactive dashboards with features like filtering and drill-down to enable insightful data exploration
- Perform comprehensive data analysis, including statistical evaluation, to inform decision-making processes
- Develop and manage complex SQL queries and database transformations
- Process, clean, and validate data integrity for analysis
- Document all aspects of data management, focusing on retrieval, data gaps, programming, workflows, and security
Other
- Collaborate with various stakeholders to understand and translate their data needs into compelling data stories
- Work closely with internal teams such as Whitman IT, and all other administrative units
- Forge strong connections with various departmental and program teams to ascertain and cater to their specific individual, management, and leadership reporting needs
- Advocate for high data quality and standards
- Contribute to the development of systems and procedures for improved data handling and reporting
