Senior Data Analyst

State-of-Oklahoma; Oklahoma; On-site; USD 54,000 - 66,000; Full time

Job summary

State of Oklahoma, Department of Education, seeks a Senior Data Analyst to ensure accuracy, integrity, and compliance of student-level data. You will manage and analyze large datasets, support data collection processes, and generate reports for decision-making.

The role involves collaboration across teams and participation in web-based data collection projects. The ideal candidate has strong data extraction and analysis skills, with proficiency in SQL, Excel, Power BI, SAS, and SPSS, and a keen

Qualifications

• Must have a Bachelor's degree in a quantitative field (e.g., Computer Science, Mathematics, Statistics, Informatics).
• 2 years of experience with data management systems and SQL queries (intermediate to advanced).
• Experience with Excel, Power BI, SAS, and SPSS for data extraction and reporting.

Responsibilities

• Ensure accuracy and integrity of student-level data and compliance with reporting requirements.
• Extract, analyze, and report on large datasets; provide actionable insights for decision-making.
• Develop and support web-based data collection projects and accountability systems.

Skills

SQL

Data analysis

Excel

Power BI

SAS

SPSS

R

Data management

Education

Bachelor's Degree in STEM

Tools

Stored procedures

Job description

Job Posting TitleSenior Data 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$60,000Job DescriptionJOB SUMMARYThe Senior Data Analyst plays a critical role in ensuring the accuracy, integrity, and compliance of student-level data. This position is responsible for managing and analyzing large datasets, supporting data collection processes, and ensuring adherence to federal and state reporting requirements. The Data Analyst will collaborate with cross-functional teams to develop and maintain data standards, extract meaningful insights, and generate reports that support informed decision-making. Additionally, this role will contribute to the design and implementation of web-based data collection projects, assist in organizing accountability systems, and provide technical support for data management initiatives. The ideal candidate will have strong analytical skills, proficiency in data extraction and analysis tools, and keen attention to detail in maintaining data accuracy and compliance.Please note: this role does not allow for any form of remote work, including telecommuting or hybrid arrangements. The nature of this position necessitates a consistent in-person presence. Prospective candidates should be aware that the responsibilities associated with this role require physical presence at the designated workplace in Oklahoma City, Oklahoma.ESSENTIAL FUNCTIONSReasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.Data Compliance and Reporting: Collaborate with cross-functional teams to facilitate compliance with federal and state reporting requirements; guarantee the accurate and timely submission of essential state data; assist with federal and state reporting requirements, ensuring compliance and timely submission.Data Extraction and Analysis : Utilize programming languages to extract data from diverse sources and distill findings into actionable recommendations for decision-making, design, and issue resolution; analyze, manage, and support large datasets within established parameters; produce reports utilizing student-level information in response to specific requests.Data Management and Support : ensure efficient and effective handling of valuable information by enhancing data collection and management processes; actively contribute to the design and implementation of web-based data collection projects targeting student-level data; assist in the organization and validation of accountability systems and educational data; maintain and organize data for use in the State Accountability System.Technical Contribution: Demonstrate subject matter expertise in business rules, supporting datasets, and data integrity processes for identified state and federal reports.Operational Support: Provide high-tier technical assistance, training, and troubleshooting to school districts. Produce custom, student-level reports in response to legislative, agency, or public requests. Proactively resolve inquiries, building trust through transparency and open communication.MINIMUM QUALIFICATIONSBachelor’s Degree in Computer Science, Mathematics, Statistics, Informatics, Management Information Systems, or a related field dealing with quantitative data [official transcripts required upon hire];Two (2) years of experience using data management systems, including creating intermediate to advanced SQL queries, stored procedures or functions; and analytic tools such as Excel, R, Power BI, SAS, and SPSS;Or an equivalent combination of education and experience that provides the required knowledge, skills, and abilitiesSPECIAL 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.PHYSICAL DEMANDS AND WORK ENVIRONMENTLocation : Oliver Hodge Building, Oklahoma City, Oklahoma Physical Demands include :o Ability to stand, reach, and bend 50% of the time;o Operates a computer and other office productivity machinery, such as a calculator, copy machine/printer, and office telephone 75% of the time;o Ascends/descends stairs 25% of the time;o Ability to lift to 25 lbs. Cognitive Requirements :o This role requires clear and accurate communication, strong analytical skills, and the ability to evaluate information and make timely decisions.o Sustained focus and attention to detail are essential, along with memory retention of policies, procedures, and facts over various time frames.o Adaptability and mental flexibility are also necessary to handle changing information, work conditions, and unexpected challenges.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