Data Engineer

Aeries Software is a leading EdTech company providing a data-driven Student Information System used by numerous K-12 school districts. They are seeking a Data Engineer to design and implement data pipelines and migration frameworks, ensuring the accuracy and integrity of data as it transitions from legacy systems into the Aeries platform.

Responsibilities:

• 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

Requirements:

• 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
• Bachelor's degree in Computer Science, Information Systems, or a related field — or equivalent professional experience
• 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
• SIS, ERP or EdTech industry experience is strongly preferred
• Certifications in Microsoft SQL Server, Azure Data Engineering, dbt, or similar tools are a plus