Data Engineer
Location
Remote, ET timezone
Experience Level
Senior
Type Of Employment
Contract
Remote
Yes
Domain
EdTech
We’re looking for a strong Data Engineer with advanced SQL Server skills and a solid grasp of Microsoft technologies to take ownership of our client's current data processing pipelines. You’ll dive into a wide range of incoming data sources—including CSVs, APIs like PowerSchool—and help transform, streamline, and scale processes. This role requires someone with deep ETL experience, strong scripting capabilities, and the ability to work hands-on with legacy processes while modernizing data stack alongside a new technical team.
Key Responsibilities
- Take full ownership of existing data ingestion and transformation scripts.
- Work with multiple external data sources (e.g., CSV, APIs like PowerSchool).
- Process, clean, and transform data into SQL Server databases using advanced SQL.
- Collaborate with the team to streamline pipelines using modern tools and best practices.
- Monitor data flows, improve automation, and build robust, error-resistant workflows.
- Participate in analytics efforts to ensure data is accurate, usable, and timely.
- Document all scripts, flows, and system changes clearly.
Required Skills & Experience
- Advanced SQL Server skills, including stored procedures, complex queries, and performance tuning.
- Deep ETL experience, including custom scripting and tool-based integration.
- Strong experience with C# and scripting for data transformation and automation.
- Familiarity with PowerSchool API or similar educational/enterprise data systems a plus.
- Solid understanding of data formats (CSV, JSON, XML, etc.).
- Strong Excel and reporting skills.
- Experience working with AWS services is a plus (e.g., S3, Lambda, RDS).