Senior Data Analyst
Job Description
Support student-level data accuracy and reporting for the Oklahoma Department of Education in an onsite role in Oklahoma City.
Responsibilities
- Work with cross-functional teams to support compliance with federal and state reporting requirements
- Ensure accurate and timely submission of required state data, including assistance with federal and state reporting needs
- Use programming languages to extract data from multiple sources and translate findings into recommendations for decision-making, design, and issue resolution
- Analyze, manage, and support large datasets within established parameters
- Generate reports using student-level information in response to specific requests
- Improve data collection and management processes to ensure efficient handling of valuable information
- Contribute to the design and implementation of web-based data collection projects for student-level data
- Assist with organization and validation of accountability systems and educational data
- Maintain and organize data for use in the State Accountability System
- Apply subject matter expertise in business rules, supporting datasets, and data integrity processes for identified state and federal reports
- Deliver high-level technical assistance, training, and troubleshooting to school districts
- Create custom student-level reports for legislative, agency, or public requests
- Resolve inquiries proactively, using transparency and open communication to build trust
Requirements
- Bachelor’s Degree in Computer Science, Mathematics, Statistics, Informatics, Management Information Systems, or a related field dealing with quantitative data (official transcripts required upon hire)
- 2 years of experience using data management systems, including creating intermediate to advanced SQL queries and writing stored procedures or functions
- Experience with analytic tools including Excel, R, Power BI, SAS, and SPSS
- Current authorization 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
- Valid driver’s license from a U.S. state or territory to support job-related travel
- Successful completion of a skills assessment as part of the screening process
Technologies
- SQL
- Stored procedures
- Excel
- R
- Power BI
- SAS
- SPSS
Benefits
- Generous Benefits Allowance: up to $21,934.08 annually, tailored to family size, for purchasing benefits
- Comprehensive Insurance Plans: choose from plans with no pre-existing conditions, exclusions, or limitations
- Flexible Spending Accounts: healthcare expenses and/or dependent care
- Full Participation in TRS: employer-covered contributions (7.5% of annual salary) for Teacher’s Retirement System participation
- Generous Leave Policy: 15 days of vacation and 15 days of sick leave in the first year (full-time)
- Paid Holidays: 11 paid holidays per year
- Employee Discounts: discounts with various companies and vendors
- Longevity Bonus: 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
Location and Work Schedule Notes
- Location: Oliver Hodge Building, Oklahoma City, Oklahoma
- Work arrangement: onsite only; no remote work, including telecommuting or hybrid arrangements
- Travel: requires a valid driver’s license for necessary job-related travel
- Onsite physical presence: responsibilities require physical presence at the designated workplace in Oklahoma City
Physical Demands and Work Environment
- Ability to stand, reach, and bend 50% of the time
- Operates a computer and office productivity machinery (calculator, copy machine/printer, office telephone) 75% of the time
- Ascends/descends stairs 25% of the time
- Ability to lift up to 25 lbs
- Cognitive requirements: clear and accurate communication, strong analytical skills, ability to evaluate information and make timely decisions
- Cognitive requirements: sustained focus and attention to detail
- Cognitive requirements: memory retention of policies, procedures, and facts across various time frames
- Cognitive requirements: adaptability and mental flexibility to handle changing information, work conditions, and unexpected challenges
Salary: $60,000 per year • Experience: 2 years • Employment type: full-time • Location: Oklahoma County, OK (onsite)