Responsibilities

• Business Intelligence, Dashboarding & Reporting
• Design, build, and maintain Power BI dashboards and data models that surface campaign performance, funnel conversion, and recruitment trends for marketing, admissions, and leadership stakeholders.
• Write and optimize SQL queries to extract, join, and transform data across CRM, lead-management, and reporting systems.
• Deliver end-to-end, data-powered solutions including problem definition, data acquisition, exploration, visualization, and interpretation of results.
• Analyze large datasets to monitor campaign performance, identify growth opportunities, and recommend improvements to recruitment efficiency, conversion, and overall campaign performance.
• Produce both recurring reporting dashboards and ad hoc analysis in response to stakeholder needs.
• Data Routing & Data Integrity
• Understand and optimize the mechanics and data underpinning each marketing channel and segment.
• Ensure accurate, timely inquiry routing through the CRM platform, and proactively troubleshoot perceived data issues.
• Own the MAP analytics program, delivering geographic (including zip-code and territory routing) and demographic data intelligence.

Requirements

• Associate or bachelor's degree in business, mathematics, finance, computer science, or marketing/data analytics (or equivalent work experience).
• 2–3 years of experience in business, finance, higher education, or marketing analytics (including related internships).
• Demonstrated proficiency building dashboards and reports in Power BI (DAX and data modeling a strong plus).
• Working proficiency in SQL, including writing queries against relational databases to extract and transform data.
• Proficiency in data mining, statistical analysis, and data visualization.
• Experience with CRM platforms (e.g., Salesforce, LeadSquared) and lead-management systems (e.g., Sparkroom).
• Strong proficiency in the MS Office Suite, including Excel (pivot tables), Word, and PowerPoint.
• Excellent analytical, numerical, and critical-thinking skills.
• Strong written and verbal communication and presentation skills.
• Ability to run, review, and interpret data for stakeholders.