Senior Data Analyst – Faculty Analytics

Senior Data Analyst – Faculty Analytics

Requirements

• Advanced SQL proficiency, with experience writing queries and subqueries, modifying data (INSERT, UPDATE, DELETE), creating views, and knowledge of different join types, filtering, sorting, aggregation, window functions, common table expressions (CTE), and performance tuning.
• Highly proficient and experienced in using tools like Tableau and Power BI to present data and information utilizing charts, graphs, and maps, in ways that make it easy to understand trends, patterns, and outliers.
• Ability to interpret and design models that describe how data relate to one another, and to the properties of the real-world entities they represent. Understands conceptual and logical data modeling, and has experience with dimensional models, star schema, and snowflake schema.
• Experienced with descriptive statistics, causal analysis, and inference.
• Comfortable with common project management methodologies and frameworks (e.g., Waterfall, Agile, SDLC).
• Proficient in MS Office suite, including advanced Excel knowledge.
• Proficient in flowchart and diagramming tools like Miro, Visio, Lucidchart, and similar applications.
• Familiarized with the university’s most relevant KPIs, the drivers that affect them, and plays an active role in their definition and tracking.
• Ability to apply sound judgment, systems-thinking, and analytical skills to assess risks, perform root-cause analyses, make recommendations, and drive cross-functional decisions that contribute to the achievement of the university’s objectives.
• Ability to perform with a very high level of autonomy, reliability, self-direction, and with a bias for action. Manages conflicting and concurrent activities with minimal need for supervision.

Responsibilities

• Drives the documentation of data and analytics needs in projects of high complexity with a student and equity-centered lens, collaborating with peers, cross-functional partners, faculty staff, and leaders. Translates of user stories into technical requirements.
• Sets and manages expectations about analytics tasks and activities through clear, timely, and effective communication with partners and stakeholders.
• Answers complex business questions requiring extensive knowledge of the university’s data assets across several domains and departments.
• Identifies adequate data sources and data sets to evaluate hypotheses, build forecasts, and support findings of research projects and experiments.
• Collaborates with Data Engineering in the development of complex ETL/ELT processes and data pipelines.
• Identifies, investigates, and solves complex data issues, contributing to the accuracy, completeness, consistency, timeliness, and validity of the university’s data.
• Collaborates with Data Engineering and other data & analytics partners to define standards and best practices that increase data quality across the university.
• Combines data analysis, visualization, and narrative structures to convey information in compelling ways that instigate deliberate action.
• Utilizes software, scripts, and algorithms to perform data-related tasks (e.g. importing, cleaning, transforming, analyzing, displaying) without human intervention.
• Conveys information effectively to peers, partners, and senior leaders, using a variety of resources and formats (synchronous and asynchronous, verbal and written) such as e-mails, presentations, meetings, and workshops.
• Creates and organizes information about processes, projects, operations, data assets, and insights from analyses and research, making it accessible in ways that increase the university’s knowledge and efficiency.
• Writes and interprets technical documentation (e.g., Entity-Relationship, Conceptual, Logical, and Physical data models).
• Contributes actively to the development of the university’s data management platforms (e.g., data dictionaries, catalogs, etc.).
• Supports and accelerates other team members’ development through constructive feedback and sharing of technical and institutional knowledge.
• Drives tasks, activities, and small-scale projects with high levels of autonomy, confidence, and collaboration with peers and partners.
• Tracks and reports own progress, dependencies, and challenges diligently. Breaks down complex goals into concrete tasks and activities.
• Works actively to improve own skills and knowledge through internal and external, formal and informal, structured and unstructured learning. Is a lifelong learner and embodies a growth mindset. Stays abreast of innovative developments in their area of work and plays an active role in deploying them at the university.
• Understands and abides by the relevant policies and methods to access, use, transform, store, and delete data in responsible, secure, and compliant ways.
• Collaborates effectively with other technical specialists (e.g. data engineers) in the construction of data products, systems, and applications.
• Performs other job-related duties as assigned.

Preferred Qualifications

• Familiarized with the university’s most relevant KPIs, the drivers that affect them, and plays an active role in their definition and tracking.