Data Engineer

$132,000 - $143,000/Yr

The College Board

Full-time - Mid Level

Remote

Educational Services

About the position

As a Data Engineer on the Higher Ed Elevate team at College Board, you will play a crucial role in developing and maintaining high-quality software solutions that enhance the recruitment and admission processes in higher education. This position emphasizes a strong commitment to software engineering excellence, collaboration with cross-functional teams, and the application of advanced data analytics practices within an AWS environment.

Responsibilities

• Build, test, deploy and maintain production code for complex transactional applications using event-driven microservices, node.js, and Python.
• Incorporate Cloud technologies on new application development, including microservices, SQL, and AWS services such as Lambda, S3, SQS, SNS, DynamoDB, Quicksight, AWS Redshift, and Opensearch.
• Create and maintain automated functional and system tests to replicate complex real-world scenarios.
• Develop code and test automation suite to support security features and technical scoping, ensuring high-quality functionality.
• Ensure continuous integration is performed on the application source code and enhance continuous integration methods.
• Support and coordinate with other Engineers, Architects, and teams such as User Experience and infrastructure teams.
• Implement cloud-first architectural solutions and best practices.
• Participate in agile scrum ceremonies and contribute to team deliverables.
• Participate in peer reviews of software engineering artifacts.
• Mentor team members by designing and developing training materials and providing feedback on code and design artifacts.

Requirements

• 4+ years of software development experience in a production environment, including 18+ months experience with AI technology solutions.
• Expertise in writing and optimizing complex SQL queries for data extraction, transformation, and reporting.
• Expertise integrating Redshift Serverless with AWS services such as S3, Glue, Lambda, Athena, DynamoDB, and BI tools like Tableau, Quicksight, or Looker.
• Expertise in building serverless ETL pipelines with Lambda for data ingestion and transformation into Redshift.
• Experience with Python; React and Node.js are nice to have.
• Experience building event-driven cloud-based serverless applications and deploying to AWS.
• Technical knowledge of Cloud Computing, DevOps, and Microservices.
• Excellent communication skills with the ability to present ideas in business-friendly and user-friendly language.
• Demonstrated ability to develop and maintain good customer working relationships.
• Exceptional analytical, conceptual, and problem-solving abilities.

Nice-to-haves

• Experience with React and Node.js.

Benefits

• Health, dental, and vision insurance
• Generous paid time off
• Paid parental leave
• Fertility benefits
• Pet insurance
• Tuition assistance
• Retirement benefits
• Annual bonuses and salary growth opportunities
• Transparent conversations about benefits and compensation