Data Analyst
Under general supervision, designs, develops, and maintains a variety of data sets, data analysis, and report solutions for the Cleveland Metropolitan School District. Utilizes a variety of software applications (i.e., R, SQL, Microsoft Excel, and Power BI) to complete the work. Essential Duties And Responsibilities Extracts/retrieves data from multiple data sources to create reports and perform data validation Performs complex data analysis in support of ad-hoc and standing data/information requests from internal and external stakeholders Prepares documentation necessary to develop reports for all levels of management and operations and identifies the data elements needed to complete the reports Develops dynamic scripts to automate business processes between multiple disparate systems, applications, and data Defines, designs, develops, and implements technology solutions to improve business functions Supports advanced analytic work (predictive modeling, machine learning, sample matching, etc.) Monitors the accuracy and completeness of reported information. Conducts research necessary to resolve discrepancies in data. Ensures that reported data meets all applicable laws and regulations as they relate to the reporting requirements Provides technical expertise on complex data projects and makes suggestions on using technology to improve business process efficiencies. Prepares presentations that help explain complex analyses for a wide audience Provides administrative and communications support necessary to put the department's strategy and plans into action Partners with internal stakeholders to help develop standard processes for accessing and examining internal data systems Participates in professional development activities (i.e., meetings, seminars, conferences, etc.) to improve and remain abreast of professional and legislative advancements and innovations. Remains abreast of changing and emerging technologies. Performs other duties as assigned Level Of Supervision No supervisory responsibilities. Qualifications Bachelor's degree from an accredited college or university Minimum of one year of experience with data analysis, statistical reporting, or similar data-rich work Experience using quantitative skills to examine and transform large datasets using statistical (R, Stata) and/or database programs (Microsoft SQL Server, Oracle). Experience creating SQL queries. Demonstrated experience designing research projects and/or implementing advanced statistical methods (quasi-experimental techniques, multi-level modeling, machine learning, etc.) Experience working with large datasets from multiple source systems. Experience with data visualization tools (PowerBI, Tableau) is a plus. Experience with queries and advanced functions. Proficiency with ETL processes, Oracle, SPSS, or other statistical software, and proficiency with numbers/data/statistics Proficiency with general office technologies (i.e., PC, tablets, etc.), virtual meeting platforms (i.e., Zoom, Teams, etc.), and software packages (i.e., Microsoft Office). Proficiency with enterprise technologies and databases (i.e., Workday, VAX, PowerSchool, etc.), online data management systems, and data collection methodology Strong analytical, organizational, decision-making, and problem-solving skills Good customer service, verbal and written communication, and presentation skills. Strong interpersonal relationship skills, including cultural sensitivity and competence. Meticulous attention to detail Ability to perform analysis using large and complex sets of data Ability to critically assess challenges and identify flexible, effective solutions Ability to assert self to managers and executive leadership when appropriate and necessary Ability to establish and maintain effective working relationships with other District departments and external stakeholders (i.e., parents, city legislators, and the general public) Ability to efficiently multi-task on a daily basis while meeting deadlines and producing quality results Ability to perform with confidence and openness in the face of change, ambiguity, and uncertainty Ability to preserve the confidentiality of District information Valid Ohio driver's license and reliable transportation The characteristics listed below are representative of the work environment typically encountered by an individual while performing the essential duties of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform essential duties. Expected to move, walk, and stand consistently with an office environment and occasionally lifting up to 15 pounds Occasional light physical effort required While performing the duties of this job, the employee is regularly required to sit, carry, push, pull, climb, balance, and stoop; use hands to finger, handle, or feel; and reach with hands and arms The employee is frequently required to talk and/or hear. Specific vision abilities required by this job include close vision, color vision, depth perception, and the ability to adjust focus. While performing the duties of this job, the employee is exposed to a typical office environment with minimal exposure to adverse conditions. Work beyond regular working hours may be needed. Local and out-of-state travel may be required for training/meetings. The above-stated duties are intended to outline those functions typically performed by individuals assigned to this classification. This description of duties is not intended to be all-inclusive or to limit the discretionary authority of management to assign other tasks of a similar nature or level of responsibility.
Under general supervision, designs, develops, and maintains a variety of data sets, data analysis, and report solutions for the Cleveland Metropolitan School District. Utilizes a variety of software applications (i.e., R, SQL, Microsoft Excel, and Power BI) to complete the work. Essential Duties And Responsibilities Extracts/retrieves data from multiple data sources to create reports and perform data validation Performs complex data analysis in support of ad-hoc and standing data/information requests from internal and external stakeholders Prepares documentation necessary to develop reports for all levels of management and operations and identifies the data elements needed to complete the reports Develops dynamic scripts to automate business processes between multiple disparate systems, applications, and data Defines, designs, develops, and implements technology solutions to improve business functions Supports advanced analytic work (predictive modeling, machine learning, sample matching, etc.) Monitors the accuracy and completeness of reported information. Conducts research necessary to resolve discrepancies in data. Ensures that reported data meets all applicable laws and regulations as they relate to the reporting requirements Provides technical expertise on complex data projects and makes suggestions on using technology to improve business process efficiencies. Prepares presentations that help explain complex analyses for a wide audience Provides administrative and communications support necessary to put the department's strategy and plans into action Partners with internal stakeholders to help develop standard processes for accessing and examining internal data systems Participates in professional development activities (i.e., meetings, seminars, conferences, etc.) to improve and remain abreast of professional and legislative advancements and innovations. Remains abreast of changing and emerging technologies. Performs other duties as assigned Level Of Supervision No supervisory responsibilities. Qualifications Bachelor's degree from an accredited college or university Minimum of one year of experience with data analysis, statistical reporting, or similar data-rich work Experience using quantitative skills to examine and transform large datasets using statistical (R, Stata) and/or database programs (Microsoft SQL Server, Oracle). Experience creating SQL queries. Demonstrated experience designing research projects and/or implementing advanced statistical methods (quasi-experimental techniques, multi-level modeling, machine learning, etc.) Experience working with large datasets from multiple source systems. Experience with data visualization tools (PowerBI, Tableau) is a plus. Experience with queries and advanced functions. Proficiency with ETL processes, Oracle, SPSS, or other statistical software, and proficiency with numbers/data/statistics Proficiency with general office technologies (i.e., PC, tablets, etc.), virtual meeting platforms (i.e., Zoom, Teams, etc.), and software packages (i.e., Microsoft Office). Proficiency with enterprise technologies and databases (i.e., Workday, VAX, PowerSchool, etc.), online data management systems, and data collection methodology Strong analytical, organizational, decision-making, and problem-solving skills Good customer service, verbal and written communication, and presentation skills. Strong interpersonal relationship skills, including cultural sensitivity and competence. Meticulous attention to detail Ability to perform analysis using large and complex sets of data Ability to critically assess challenges and identify flexible, effective solutions Ability to assert self to managers and executive leadership when appropriate and necessary Ability to establish and maintain effective working relationships with other District departments and external stakeholders (i.e., parents, city legislators, and the general public) Ability to efficiently multi-task on a daily basis while meeting deadlines and producing quality results Ability to perform with confidence and openness in the face of change, ambiguity, and uncertainty Ability to preserve the confidentiality of District information Valid Ohio driver's license and reliable transportation The characteristics listed below are representative of the work environment typically encountered by an individual while performing the essential duties of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform essential duties. Expected to move, walk, and stand consistently with an office environment and occasionally lifting up to 15 pounds Occasional light physical effort required While performing the duties of this job, the employee is regularly required to sit, carry, push, pull, climb, balance, and stoop; use hands to finger, handle, or feel; and reach with hands and arms The employee is frequently required to talk and/or hear. Specific vision abilities required by this job include close vision, color vision, depth perception, and the ability to adjust focus. While performing the duties of this job, the employee is exposed to a typical office environment with minimal exposure to adverse conditions. Work beyond regular working hours may be needed. Local and out-of-state travel may be required for training/meetings. The above-stated duties are intended to outline those functions typically performed by individuals assigned to this classification. This description of duties is not intended to be all-inclusive or to limit the discretionary authority of management to assign other tasks of a similar nature or level of responsibility.