D&A Process Automation & Analytics Specialist

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.  

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.