Data Analyst (NY)
Excellence Community Schools Data Analyst (NY)
- Create and maintain recurring reports, dashboards, and visualizations for operational and academic stakeholders.
- Support report card, progress monitoring, enrollment, attendance, assessment, and other school-based reporting processes.
- Conduct analyses to identify trends, patterns, and actionable insights that support school and organizational goals.
- Present findings and recommendations clearly to technical and non-technical stakeholders.
- Support analytical projects using quantitative and statistical methods.
- Conduct trend analysis and support forecasting and planning initiatives using historical and operational data.
- Analyze program effectiveness and operational outcomes to support continuous improvement efforts.
- Identify patterns, risk indicators, and opportunities for operational and academic improvement.
- Perform data validation, auditing, cleaning, and quality assurance checks across multiple systems and datasets.
- Identify, investigate, and resolve data inconsistencies, missing values, and reporting anomalies.
- Support efforts to improve data accuracy, consistency, reliability, and documentation practices.
- Maintain documentation related to reports, metrics, business rules, and data processes.
- Support the maintenance and monitoring of data systems and data warehouse processes.
- Assist with data integration, transformation, and validation activities.
- Troubleshoot data discrepancies, report issues, and address system-related data concerns.
- Collaborate with internal teams to support operational and reporting needs across schools and departments.
- Work collaboratively with school-based and central teams to understand reporting and analytical needs.
- Support users with dashboards, reports, data interpretation, and troubleshooting.
- Participate in continuous improvement initiatives related to analytics, reporting, and data governance.
- Bachelor’s degree in Data Analytics, Statistics, Mathematics, Computer Science, Information Systems, Economics, or a related field with at least 2 years of relevant analytics experience; or Master’s degree in a related field.
- Strong analytical and problem-solving skills.
- Familiarity with data analysis concepts and statistical methods.
- Experience working with spreadsheets and datasets.
- Basic proficiency in SQL for querying and manipulating data.
- Strong attention to detail and commitment to data accuracy.
- Ability to communicate findings clearly and effectively.
- Ability to manage multiple tasks and meet deadlines.
- Experience with data visualization and reporting tools (e.g., Power BI or similar).
- Familiarity with Python or R for data analysis and data cleaning.
- Understanding of relational databases and data warehouse concepts.
- Knowledge of ETL processes and data transformation workflows.
- Familiarity with statistical analysis techniques such as regression, forecasting, or trend analysis.
- Ability to interpret data and provide actionable recommendations.
- Experience working in K-12 education, nonprofit, healthcare, or mission-driven organizations is a plus.
- Familiarity with student information systems, enrollment data, attendance data, assessment data, or report card processes is a plus.
- Python or R
- Power BI
- SQL
- Excel
- Data visualization tools
- Statistical analysis
- Data cleaning and validation
- Reporting and dashboard development
- Problem-solving mindset
- Detail-oriented mindset
- Critical thinking and curiosity
- Effective written and verbal communication
- Ability to work independently and collaboratively
- Strong organizational skills
- Interested in using data to support educational outcomes and organizational decision-making.
- Curious and eager to learn new analytical tools and techniques.
- Comfortable working with data and identifying patterns, trends, or operational challenges.
- Able to balance technical tasks with communication and collaboration.
- Interested in applying analytical and quantitative methods to solve operational and educational problems.
- Starting Salary $65,000. Salary commensurate with experience and qualifications.
- Health Benefits: Medical, dental, and vision insurance.
- Retirement: 403(b) retirement plan – Employer Match
- Leave: Paid time off, paid sick leave, parental leave, and FMLA.
- Additional Benefits: Short-term and long-term disability coverage, life insurance, and $5,000 annual tuition reimbursement.