American College of Education · 8 hours ago

Data Analyst

United States

Full-time

Remote

Mid Level

3+ years exp

Maximize your interview chances

Education

Culture & Values

Insider Connection @American College of Education

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Gather, analyze, and interpret data from diverse sources to inform strategic planning, enhance departmental reporting, drive institutional improvements, and support evidence-based decision-making

Lead the data gathering and completion of external compliance reports (e.g., IPEDS, HLC, NC-SARA, state, partnerships) and surveys (e.g., U.S. News), ensuring timely and accurate submissions

Prepare clear, user-friendly data visualizations and summaries for presentations, reports, and dashboards using PowerPoint, Excel, Word, and Power BI

Leverage advanced Excel functions (e.g., pivot tables, conditional formatting, complex formulas), SQL proficiency, and Power BI ability to gather and conduct data analysis work

Serve as contact for data requests, partnering with requestors to define scope, develop project plans, and ensure effective project delivery

Perform thorough validation and quality checks to ensure data accuracy, completeness, and integrity, proactively identifying and resolving anomalies

Help develop and maintain a data dictionary, standardized data definitions, and operating procedures to ensure data consistency and quality

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data AnalysisSQLPower BIAdvanced ExcelCompliance KnowledgeData PrivacyProject ManagementData Visualization

Required

Bachelor's degree in Data Science, Statistics, Mathematics, Business, Analytics, or a related field

Minimum of 3 years of experience in institutional research, data analysis, or business intelligence, ideally in a higher education setting

Advanced proficiency in Excel for data analysis and visualization

Skilled in writing and troubleshooting SQL queries

Experience with Power BI for data visualization

Familiar with compliance and survey reporting requirements (e.g., IPEDS, HLC, NC-SARA, US News)

Strong time management and organizational skills, with the ability to manage multiple projects, prioritize tasks, and meet deadlines in a fast-paced environment

Demonstrated focus on accuracy, reliability, and maintaining data integrity

Excellent written and verbal communication skills, translating complex data insights for diverse audiences

Effective team player who can also work independently and is adaptable to changing project demands

Skilled in handling sensitive information in compliance with FERPA and other state and federal data regulations