Fast Facts

Aeries is seeking a Data Engineer to design and evolve data pipelines and migration frameworks that support their data-driven Student Information System for K-12 schools. This role focuses on migrating legacy customer data while leveraging AI tools for enhanced efficiency.

Responsibilities: Design and execute ETL processes, validate and reconcile data, partner with coordinators for timely project delivery, identify automation opportunities, evaluate conversion methods, and document processes.

Skills: Strong analytical skills, proficiency in TSQL and Python, experience with ETL and relational databases, and familiarity with AI data tools are essential.

Qualifications: 3+ years in data conversion or migration, Bachelor’s degree in a related field, and experience in EdTech or related industries preferred.

Location: Primarily remote with a requirement to work from specific states, including AZ, CA, TX, and others.

Compensation: $95000 - $125000 / Annually

We’re looking for a Data Superstar!

All About Aeries

Aeries is a leading EdTech company with a data-driven Student Information System (SIS) used by over 750 K-12 school districts with millions of users throughout California and Texas. With a rich history of innovation and a proven track record of developing software focused on the whole student, Aeries ensures that student data empowers success and never impedes. 

At Aeries, our mission is to deliver data-driven, intuitive, and innovative solutions that unite learning communities to advance student success. We believe strongly in the supporting role of technology in education but recognize that there’s no replacement for the wisdom and determination of the real people supporting students’ academic successes every day. That’s why our goal is to build tools that allow educators to focus on what they do best: educating.

All About the Job

As a Data Engineer, you are a technically rigorous and innovation-minded professional responsible for designing, building, and evolving the data pipelines, migration frameworks, and integration systems that power Aeries implementations. While the initial focus of this role centers on migrating customer data from legacy Student Information Systems into Aeries, the scope is intentionally built to expand. As our data infrastructure, AI tooling, and Professional Services offerings grow, this role will grow with them.

We're looking for someone who sees process gaps as opportunities, embraces AI-assisted tooling as a force multiplier, and is energized by the challenge of scaling what works.

Your mission

• Design and execute ETL processes using TSQL, Python, and related scripting tools to migrate millions of structured and unstructured records across concurrent district projects, ensuring accuracy and integrity at scale as data moves from diverse legacy source systems into the Aeries platform.
• Work with diverse data formats including Excel, CSV, Access databases, and SQL Server or other relational database extracts.
• Validate and reconcile migrated data to ensure integrity, completeness, and alignment with district requirements.
• Partner with Implementation Coordinators to deliver conversions on schedule and within defined scope.
• Identify repetitive or manual conversion tasks as candidates for AI-assisted automation and contribute to process redesign efforts.
• Leverage AI tools to accelerate data mapping, anomaly detection, and quality validation workflows.
• Establish and document process baselines to measure time saved and efficiency gained through AI and automation adoption.
• Continuously evaluate conversion methodologies and contribute to the development of repeatable, scalable frameworks.
• Document standardized approaches, scripting patterns, and conversion playbooks for cross-team use.
• Manage multiple concurrent conversion projects, maintaining clear priorities and proactive communication with stakeholders.
• Communicate conversion status, risks, and outcomes clearly to both technical and non-technical audiences.

About You

• Strong analytical and problem-solving skills with a bias toward efficient, scalable solutions.
• Ability to manage competing deadlines across multiple projects with minimal supervision.
• Collaborative team orientation with a proactive approach to identifying and resolving cross-functional dependencies.
• Clear and concise written and verbal communication skills tailored to both technical and non-technical stakeholders.
• Agile process familiarity and comfort working in iterative, feedback-driven delivery environments.
• AI literacy and a growth mindset toward continuous tool adoption and workflow improvement.

Knowledge and Experience

• 3+ years of data conversion, data migration, or data integration experience.
• Proficiency in TSQL and at least one additional language such as Python or C#.
• Hands-on experience with ETL processes and relational database structures.
• Working knowledge of data formats including CSV, Excel, Access, and SQL Server extracts.
• Familiarity with AI-assisted data tools, including Claude Code, and a willingness to evaluate and adopt new technologies.
• SIS, ERP or EdTech industry experience is strongly preferred.
• Bachelor's degree in Computer Science, Information Systems, or a related field — or equivalent professional experience.
• Certifications in Microsoft SQL Server, Azure Data Engineering, dbt, or similar tools are a plus.

Position Details

Status

• Full-time
• Salaried, exempt

Work Location

• Primarily remote; a reliable, distraction-minimized home workspace is expected.
• Must work from one of the following states: AZ, CA, FL, MD, ME, MI, MO, NV, NY, OK, OR, SC, TX, UT, WA, WY 

Travel Requirements

• Minimal to none

Physical Requirements

• Prolonged periods of sustained focus during screen and computer-based work

Compensation

• $95,000 - $125,000 base salary, based on experience & skills
• Annual bonus based on employee and company performance
• Health insurance coverage for employees and covered dependents
• Health Savings Account with employer contributions
• 401(k) plan with up to 4% employer match
• “Responsible PTO” with additional paid time off for sick time, volunteering, bereavement, and jury duty
• 11 paid holidays with additional paid closure between Dec 26–Jan1
• Educational Reimbursement program and opportunities for ongoing professional development

Aeries’ Integrity

Aeries Software provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Aeries Software, LLC, is unable to sponsor, or take over sponsorship of employment visas at this time.