General Definition of Work

The data and reporting analyst, under moderate supervision, performs complex work with minimal decision-making discretion related to compiling data and building data models to support the development and implementation of data analytics and business intelligence platforms. This position performs analyst work in support of existing business intelligence systems and utilizes data to inform district decision-makers about the effectiveness of district initiatives and programs. Employee performs district-level work to carry out Board of Education policies under the direction of the Executive Director of Data Analytics and Research.

Qualifications

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Salary/Status

Salary NC 13/Full-time, 12 months

Reports To

Executive Director of Data Analytics and Research

Place of Work

The normal place of work is on the premises used by Charlotte-Mecklenburg Schools. Charlotte- Mecklenburg Schools reserves the right to require you to work at such other place(s) as it may reasonably require from time to time.

Essential Functions

• Adhere to all state, federal, and local laws, policies, and procedures
• Fulfill data requests received from internal and external stakeholders without errors and develop solutions to automate and streamline how the district provides requested data to stakeholders in ways that improve staff efficiency and maintain data security
• Generate accurate and on-time reports that summarize data, analysis, and insights to help inform decision-making
• Support the development of data structures, analytic systems, and reporting using programming languages and tools like SQL, Microsoft Power BI, Microsoft PowerApps, and other Microsoft suite tools
• Design, develop, and implement data imports, dataflows, and solutions to consume data from various internal and external sources
• Support the development of new or improved data-related reporting systems
• Assist the research and evaluation team in developing systems and processes for collecting, organizing, and managing data for research and program evaluation
• Provide guidance in adhering to quality control processes and protocols to ensure that data are being stored, accessed, queried, analyzed, and reported in accurate and appropriate ways, reflecting best practices in the field
• Remain current in the fields of education data and reporting, data visualization, and business intelligence
• Participate in professional development focused on acquiring and improving skills and knowledge
• Perform related duties as assigned
  
  

Knowledge, Skills, Abilities

• Knowledge of federal, state, and local regulatory requirements applicable to school system technology
• Knowledge of relational databases, database management systems, and business intelligence tools
• Skilled in data visualization tools, including Power BI and Tableau
• Skilled in compiling, manipulating, and analyzing data using SQL
• Skilled in logical thinking, problem-solving, and developing innovative solutions
• Skilled in time management with the ability to organize, prioritize, manage, and carry out duties efficiently and within established timeframes in a fast-paced environment
• Skilled in communication, both verbal and written
• Skilled in computers and software including Microsoft Office and Google Workspace
• Ability to identify and correct errors, maintaining a strong attention to detail
• Ability to adapt/respond to different types of situations, professionally and respectfully
• Ability to identify patterns in data
• Ability to analyze and interpret data to make data-driven decisions
• Ability to reason, make judgments, and maintain effective working relationships
• Ability to take initiative, work independently, and exercise sound judgment
• Ability to learn and use specialized tools, equipment, or software related to business needs
• Ability to work with large data sets from a variety of data systems
• Ability to handle confidential information responsibility
• Ability to employ positive communication skills in all settings/mediums
• Ability to contribute to team efforts and foster a positive atmosphere
• Ability to work confidentially and with discretion to maintain data security and privacy
• Ability and willingness to reflect on and improve own performance and professional practice
• Ability to present complex technical issues and their impact in an easy-to-understand manner
  
  

Education And Experience

• Bachelor's degree in data science, computer science, statistics, social sciences, or a related field that emphasizes data analytics required
• Experience compiling, manipulating, and analyzing data using SQL required
• Experience working for a school district or with educational data preferred
• Equivalent combination of education and experience