Job Title: Data Engineer

Company Name: Aeries Software

Job Details: $95k-$125k/yrRemoteFull,Time

Job Url: https://hiring.cafe/viewjob/5nooipgzmlvyrin7

Job Description: Posted 21h agoData Engineer@ Aeries SoftwareView All JobsWebsiteOrange, California, United States$95k-$125k/yrRemoteFull TimeResponsibilities:Design ETL, Migrate data, Validate dataRequirements Summary:3+ years data conversion/migration/integration; TSQ L and Python/C#; ETL and relational databases; various data formats; AI-assisted tooling experience; SIS/EdTech familiarity.Technical Tools Mentioned:TSQL, Python, C#, ETL, Relational databases, SQL Server, CSV, Excel, Access, AI-assisted tools, dbt
We’re looking for a Data Superstar!All About AeriesAeries 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 JobAs 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 missionDesign 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 YouStrong 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 Experience3+ 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 DetailsStatusFull-timeSalaried, exemptWork LocationPrimarily 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 RequirementsMinimal to nonePhysical RequirementsProlonged periods of sustained focus during screen and computer-based workCompensation$95,000 - $125,000 base salary, based on experience & skillsAnnual bonus based on employee and company performanceHealth insurance coverage for employees and covered dependentsHealth Savings Account with employer contributions401(k) plan with up to 4% employer match“Responsible PTO” with additional paid time off for sick time, volunteering, bereavement, and jury duty11 paid holidays with additional paid closure between Dec 26–Jan1Educational Reimbursement program and opportunities for ongoing professional developmentAeries’ IntegrityAeries 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.