Frontline Education
D&A Process Automation & Analytics Specialist
🇺🇸
Remote - US
🕑
Full-Time
💰
$80K - $90K
💻
Data Science
🗓️
June 2nd, 2026
Airflow
Docker
K-12
Edtech.com's Summary
Frontline Education is hiring a D&A Process Automation & Analytics Specialist. The role involves automating processes, conducting data analysis, building Excel and Python-based tools, and collaborating with stakeholders to enhance operational workflows and reporting quality.
Highlights
- Clean, organize, and validate datasets for analytics and automation.
- Develop and maintain Excel templates, calculators, dashboards, and Python scripts.
- Use SQL to extract and troubleshoot data across systems.
- Collaborate with customer service and stakeholders to gather requirements and deliver tailored solutions.
- Participate in testing cycles and maintain documentation.
- Advanced Excel skills with formulas, pivots, and debugging complex workbooks required.
- Proficient in Python coding, especially with data processing libraries like pandas.
- Comfortable writing SQL queries involving joins, filters, and aggregations.
- Preferred experience with workflow automation tools, BI platforms (Power BI, Tableau), Docker, AWS, and K–12 education.
- Compensation includes a base salary of $80,000-$90,000, bonus structure, 401k match, PTO, and tuition reimbursement options.
D&A Process Automation & Analytics Specialist Full Description
D&A Process Automation & Analytics Specialist
Location: United States
Description
Job Description
Process Automation & Analytics Specialist
Overview
We are seeking a highly motivated and technically strong Process Automation & Analytics Specialist to support our automation, reporting, and data quality initiatives. This role works closely with senior team members, customer service partners, and cross-functional stakeholders to build high-quality deliverables, investigate issues, and enhance the performance of our tools and workflows. This role reports to the Director, Analytics.
We are seeking a highly motivated and technically strong Process Automation & Analytics Specialist to support our automation, reporting, and data quality initiatives. This role works closely with senior team members, customer service partners, and cross-functional stakeholders to build high-quality deliverables, investigate issues, and enhance the performance of our tools and workflows. This role reports to the Director, Analytics.
An ideal candidate is detail-oriented, skilled in Excel and Python, comfortable with SQL, and eager to understand the "why" behind each problem they solve. Strong communication skills and a proactive mindset are essential.
Key Responsibilities
- Clean, organize, and validate datasets used for analytics, calculators, automation, and reporting deliverables.
- Build, update, and refine Excel-based templates, calculators, dashboards, and other logic-driven tools.
- Perform research and collaborate with stakeholders in key states to create tailored deliverables that support market growth and retention (TX Charter schools, etc.).
- Develop and maintain Python scripts for data processing, automation workflows, testing utilities, and performance improvements.
- Write and execute SQL queries to extract, analyze, and troubleshoot data across systems.
- Investigate issues reported by customer service, advisors, and internal teams; identify root causes and help deliver solutions.
- Meet with customer service and other stakeholders to gather requirements and translate them into clear technical tasks.
- Participate in structured testing cycles and maintain documentation of test plans, results, and fixes.
- Contribute to ongoing improvement of internal tools, workflows, and deliverable performance.
Required Qualifications
Technical Skills
- Excel: Advanced formulas, lookups, logical functions, pivots, structured calculators; ability to debug complex workbooks.
- Python: Ability to write clean, structured code; familiarity with libraries such as pandas, automation scripts, data processing utilities.
- SQL: Comfortable writing joins, aggregations, and filters; able to diagnose data issues using SQL queries.
- Comfortable working with structured data formats (CSV, JSON, XML).
- Ability to create and follow structured testing and documentation practices.
Communication & Collaboration
- Strong interpersonal skills with the ability to gather requirements from non-technical stakeholders.
- Clear communicator who can explain logic and findings in simple terms.
- Collaborative team member who works well with customer-facing groups (e.g., customer service, implementation, advisor teams).
Problem-Solving & Work Style
- Self-starter who takes initiative and seeks to understand the underlying problem before building solutions.
- Curious and analytical mindset with strong attention to detail.
- Organized, able to manage multiple tasks, and comfortable working in a structured workflow.
- Reliable documentation habits and willingness to ask clarifying questions when needed.
Preferred Qualifications
- Experience in K–12 education.
- Experience with workflow automation tools (Power Automate, Apache Airflow, etc.).
- Familiarity with dashboarding or BI tools (Power BI, Tableau, etc.).
- Familiarity with containerized environments (Docker).
- Exposure to QA practices, performance optimization, or internal tooling.
- Experience improving efficiency or scalability of spreadsheets, scripts, or reporting assets.
- AWS experience.
- Understanding of Fund Accounting.
Frontline Education is a pioneer of school administration software purpose-built for K-12 districts. We provide innovative, connected solutions for student and special programs, business operations, and human capital management with powerful data and analytics to empower educators and administrators. We earn the trust of K-12 leaders across the U.S. by serving as a consistently high-performing, forthright partner of school districts through every dimension of the company.
We're a group of unique and talented individuals that love what we do. We've been lucky enough to land jobs with a rapidly growing tech company that supports an appreciative and friendly customer base. We work hard to make our customers happy, but we like to have a good time in the process. We are a company that strives to think in terms of “we” instead of “me.” We believe in the philosophy of servant leadership and that it’s all about putting others first. We also value the balance between family and work.
Frontline embraces inclusion and belonging. We are intentionally building a workplace that respects, supports, and values the identities of all our employees. We believe this to be foundational in developing a strong community in our company. Frontline Education is an equal opportunity employer and we do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
The perks of being a Frontliner:
Frontline offers a competitive compensation package including a base salary of $80,000-$90,000 a year, rewarding bonus structure, 401k match, and personalized PTO! Our company growth has created a promising environment for career advancement and rewarding challenges. We offer a tuition reimbursement program for eligible college credit coursework available to employees depending on their status and length of employment.
Similar Jobs
Lead Principal Data Analyst
Cornerstone OnDemand
🇺🇸 Remote - US
Data Analyst - (JSOM CMC)
The University of Texas at Dallas
🇺🇸 Richardson, TX
Data Management Analyst I
University of Florida
🇺🇸 Gainesville, FL
Director for Accounting, Data Analytics and Business Intelligence - School of Medicine
Emory University
🇺🇸 Hybrid - Atlanta, GA
Data Engineer II
Pearson
🇺🇸 Remote - US
