Job Description

ob Description
The Whitman School of Management is seeking a highly skilled and motivated Data Modeling Analyst to join our operations team. The successful candidate will be critical in designing, developing, and maintaining comprehensive dashboards, analyses, reports, and datasets that inform and enhance the performance of our administrative and operational processes. Reports and dashboards will monitor operations and increase the effectiveness and efficiency of career services, internal/external engagement, classroom management, rankings, assessment, performance management, budget, and other activities related to the Whitman School of Management. This person will proactively work with internal and external campus personnel, including data custodians, the data warehouse team, and internal IT staff, to ensure seamless collaboration and effective data modeling. They will coordinate across offices to build and execute on data structures, reporting, and visualizations, that focus on end-user adaptation and requirements.
Qualifications
A Bachelor’s degree in Data Science, Statistics, Mathematics, Analytics, or a related field required.
Four (4) plus years of relevant experience or an equivalent combination of education and experience required.
Job Specific Qualifications
Proficiency with data modeling 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.
Excellent communication skills for effective interaction with executives and non-technical stakeholders.
Responsibilities
Collaborate with various stakeholders to understand and translate their data needs into compelling data stories.
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.
Ensure data accuracy and integrity in all visualizations and analyses.
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.
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.
Assist in data collection and dashboard design for external and internal reporting.
Create training program that includes in-person opportunities and on demand videos to promote usage of new tools.
Advocate for high data quality and standards.
Contribute to the development of systems and procedures for improved data handling and reporting.
Monitors and maintains data and dashboards. Responsible for identifying and communicating any potential issues with data or tools quickly and clearly to appropriate team members.