Data Analyst

Compensation Range:

Position Summary

The Data Analyst on the Data & Insights team works cross-functionally with data engineers, data scientists, and business experts in an agile environment to help National University deliver a better student experience using data and analytics. The analyst collaborates on a variety of projects that include building analytical models, coding, data visualizations, and storytelling to help identify opportunities for our students, our faculty, and our staff. This role is particularly focused on supporting the Financial Aid department and understanding higher education financial aid systems and regulations. Our teams and projects are organized in an agile methodology, with scrum teams serving distinct pillars of the organization, allowing the incumbent to become an expert in one of our key business and data domains: i.e., academics and institutional research, student operations (advising, financial aid, etc.), marketing/enrollment, and University partnerships.

Additionally, the analyst responds to requests, gathers requirements, and designs reporting, with an opportunity to work cross-functionally and develop relationships with business owners, helping them apply data and insights for student success, continuous organizational improvement, and achievement of strategic goals. The analyst conducts full lifecycle analysis to include requirements, activities, design, and reporting.

The Data Analyst turns data into actionable insights that can inform business decisions, helping to ensure that National University meets regulatory requirements while enhancing financial performance.

Essential Functions:

• Use Structured Query Language (SQL) to gather and assess data across new and legacy data warehouses.
• Engage with stakeholders, particularly within the Finance, Accounting, Financial Aid, Financial Aid, and Compliance departments, to translate data requests into technical requirements for reporting and accurately size requests for sprint planning.
• Collaborate with data engineers and data governance colleagues on the data production lifecycle from request to fulfillment, communicating on request requirements, definitions, database needs, quality assurance (QA), security, and development operations movement between DEV, UAT, and PROD environments.
• Design and develop compliance-driven reports for federal, state, and internal financial aid reporting, including but not limited to financial statements, budgeting, forecasting, and other financial compliance reports, ensuring accuracy and regulatory compliance.
• Adhere to style guides and, where appropriate, templates in developing Excel files, Power BI paginated reports, and Power BI dashboards that convey information in an actionable and understandable format.
• Identify, analyze, and interpret trends or patterns in complex data sets, particularly in the context of financial performance and compliance.
• Manage stakeholder expectations and project manage design, development, …