Data Analyst

State-of-Oklahoma; Oklahoma; On-site; USD 49,000 - 59,000; Full time

Benefits offered by this job

Health insurance

Paid holidays

Pension/TRS benefits

Job summary

Oklahoma State Department of Education seeks a Data Analyst to collaborate with stakeholders, perform data analysis, develop dashboards, and ensure data integrity. The role emphasizes in-person work at the Oklahoma City office, handling complex data requests, and promoting data-driven decision-making in education.

Required qualifications include a Bachelor's degree, 1 year of BI tool experience, 2 years of SQL/programming, and strong data management skills.

Qualifications

• Bachelor's degree in a relevant field required (official transcripts upon hire).
• 1 year of experience with a data visualization tool (Power BI or Tableau).
• 2 years of programming experience in SQL or other languages.
• 2 years data management and evaluation of web applications and data sets.
• Proficiency with Excel, SAP, SPSS, SAS, R or Python; proficiency test required.

Responsibilities

• Develop complex SQL queries to analyze education data.
• Create data visualizations, reports, and dashboards for stakeholders.
• Perform data audits to ensure accuracy, integrity, and confidentiality.
• Collaborate with IT and stakeholders to manage data requests and workflows.
• Document data processes and promote standardized reporting across teams.

Skills

SQL development

Data visualization

ETL processes

Attention to detail

Analytical reasoning

Education

Bachelor's degree in a relevant field

Tools

Power BI

Tableau

Excel

SAP

SPSS

SAS

R

Python

Job description

Job Posting TitleData AnalystAgency265 DEPARTMENT OF EDUCATIONSupervisory OrganizationDepartment of Education–Oliver Hodge Education BuildingJob Posting End DateRefer to the date listed at the top of this posting, if available. Continuous if date is blank.Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above.Estimated Appointment End Date (Continuous if Blank)Full/Part-TimeFull timeJob TypeRegularCompensation$54,000Job DescriptionJOB SUMMARYThe Data Analyst position at the Oklahoma State Department of Education is a multifaceted role, collaborating with stakeholders, providing technical assistance, conducting audits, managing data requests, integrating systems, and streamlining data reporting processes. Your contributions will be vital in supporting informed decision-making and driving continuous improvement in the education sector. As a Data Analyst, you will have a crucial responsibility in ensuring the accuracy, integrity, and accessibility of education data. By playing an active role in shaping data-driven education policies and practices, you will have the opportunity to make a significant impact on improving education outcomes for students throughout Oklahoma.Please note: This role requires a consistent, in-person presence at the designated workplace in Oklahoma City, Oklahoma, and does not offer remote, telecommuting, or hybrid options.ESSENTIAL FUNCTIONSReasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.Knowledge and Experience: Strong SLQ skills with the ability to author complex queries, analytical and problem-solving skills with the ability to interpret complex data sets and generate actionable insights. Familiarity with education data systems, reporting requirements, policies, and regulations. Attention to detail, prioritizing data accuracy, integrity, and confidentiality. Proficiency in ETL processes and creating visually compelling data visualizations, reports, and presentations.Data Analysis and Management: Perform comprehensive data analysis, utilizing statistical techniques and data visualization tools. Develop documentation for data processes and collections, promoting consistent and effective data management practices.Data Integrity and Reporting: Implement quality control measures for data integrity, conduct audits, and ensure compliance with state and federal reporting requirements. Collaborate with stakeholders to develop standardized reports and dashboards for monitoring educational performance and progress.Technical Assistance and Research: Provide technical assistance to school districts and stakeholders, offering guidance on data-related inquiries and data-driven approaches. Support research initiatives, collect, analyze, and interpret data, and collaborate on evaluation methodologies for evidence-based decision-making.Data System Management and Coordination: Collaborate with IT teams to enhance data systems, promote data sharing, and ensure accurate submission of federal and state-mandated reports. Coordinate large data requests from various agencies and organizations. Communicate software requirements and create comprehensive test cases.Engagement and Professional Development: Engage in advanced SQL courses and training opportunities through internal and external resources, actively participate in reporting-focused meetings, and engage in professional development activities to stay updated on data analysis methodologies, tools, and education policies.MINIMUM QUALIFICATIONSBachelor's degree in a relevant field (e.g., Data Science, Statistics, or related field [official transcripts required upon hire];One (1) year of experience with a data visualization and business intelligence tool (e.g., Power BI, Tableau)Two (2) years of programming experience in SQL, and/or other programming languagesTwo (2) years of experience in data management, evaluation of web applications and data sets;Proficiency in data analysis and reporting tools/software (e.g., Excel, SAP, SPSS, SAS, R, Python) and successful completion of a proficiency test.Or an equivalent combination of education and experience that provides the required knowledge, skills, and abilities.SPECIAL REQUIREMENTSApplicants must be currently authorized to work in the United States on a full-time basis without sponsorship now or in the future;Successful completion of a pre-employment background check;Must possess a valid driver’s license from a U.S. state or territory to perform necessary job-related travel.Successful completion of a skills assessment as part of the screening process.Less than 10% i n-state/out-of-state travel may be required.Discover the Benefits of Joining Our Team!Are you ready to take the next step in your career with an agency that values your well-being? Look no further! At OSDE, we're proud to offer a robust benefits package designed to support you and your family every step of the way.Generous Benefits Allowance : Up to $21,934.08 annually, tailored to family size, for purchasing benefits.Comprehensive Insurance Plans : Choose from a variety of insurance plans with no pre-existing conditions, exclusions, or limitations.Flexible Spending Accounts : Manage healthcare expenses and/or dependent care with ease.Full Participation in TRS : Enjoy employer-covered contributions (7.5% of annual salary) for Teacher’s Retirement System participation.Generous Leave Policy : Full-time employees receive 15 days of vacation and 15 days of sick leave in their first year.Paid Holidays : Benefit from 11 paid holidays per year.Employee Discounts : Access discounts with various companies and vendors.Longevity Bonus : Earn a bonus after completing two years of service, with bonuses continuing annually thereafter.Compensatory Time : FLSA Exempt and Nonexempt employees receive compensatory time.Employee Assistance Program : Access support and resources through our Employee Assistance Program.Equal Opportunity EmploymentThe State of Oklahoma is an equal opportunity employer and does not discriminate on the basis of genetic information, race, religion, color, sex, age, national origin, or disability.Current active State of Oklahoma employees must apply for open positions internally through the Workday Jobs Hub .If you are needing any extra assistance or have any questions relating to a job you have applied for, please click the link below and find the agency for which you applied for additional information:Agency Contact