Senior Data Engineer

About the role

Join a passionate, close-knit team supporting a dynamic suite of tools and programs that streamline and expedite the Higher Education recruitment and admissions process. The team is responsibly experimenting with AI to help institutions connect with millions of high school students each year, and prides itself on continuously innovating its products and services. You'll collaborate with a mix of full-time staff and contractors — including three architects and three-plus engineers — across multiple time zones to deliver a range of services and tools.

Responsibilities

• Build and maintain data pipelines and microservices using AWS services including Redshift, Lambda, S3, SQS, SNS, DynamoDB, QuickSight, and OpenSearch
• Create and maintain automated functional and system tests that replicate real-world scenarios
• Develop code and test automation to support security features and technical scoping, ensuring high-quality, reliable feature delivery
• Support continuous integration practices and help the team continuously raise the bar on code quality
• Coordinate with other engineers, architects, UX, and infrastructure teams as needed
• Help implement cloud-first architectural solutions and best practices
• Participate in agile ceremonies — sprint planning, backlog grooming, daily standups, and sprint demos
• Participate in peer reviews of software engineering artifacts
• Mentor team members by developing training materials on current and future product architecture
• Provide constructive feedback on code and design artifacts to technical staff

Requirements

• Ideal 6+ years of software development experience in a production environment
• Expertise writing and optimizing complex SQL queries (SELECT, JOIN, GROUP BY, HAVING, window functions, etc.)
• Expertise integrating Redshift/Redshift Serverless with AWS services such as S3, Glue, Lambda, Athena, DynamoDB, and Kinesis, along with BI tools like Tableau, QuickSight, or Looker for real-time analytics and dashboards
• Expertise building serverless ETL pipelines with Lambda to automate data ingestion and transformation into Redshift
• Required: Python. Nice to have: React and Node.js
• Experience building event-driven, serverless cloud applications on AWS
• Solid technical grounding in cloud computing, DevOps, and microservices architecture
• Excellent communication skills, with the ability to translate technical concepts into business-friendly language
• Proven ability to build strong working relationships with stakeholders and customers
• Strong analytical, conceptual, and problem-solving skills
• Ability to prioritize and execute effectively in a fast-paced, high-pressure environment

Qualifications

• Required: Bachelor's degree in Computer Science, Engineering, or a related field
• Preferred: Master's degree in Computer Science, Engineering, or a related field

Skills

• Expertise in AWS services including Redshift, Lambda, S3, SQS, SNS, DynamoDB, QuickSight, and OpenSearch
• Experience with Redshift Serverless
• Experience with AWS Glue, Athena, and Kinesis
• Experience with BI tools like Tableau, QuickSight, or Looker
• Experience with Python, Node.js, and React
• Experience with CI/CD pipelines and automation
• Experience with Agile methodologies and Scrum

Benefits

• Medical Insurance
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan