Data Engineer

Data Engineer 

College Board - Technology 

Location: This is a fully remote role. Candidates who live near College Board offices have the option of being fully remote or hybrid (Tuesday and Wednesday in office) 

Type: This is a full-time position 

About the Team  

Interflow is a team of 12 highly collaborative, engaged, and motivated technologists responsible for implementing core services that are leveraged by other teams at College Board through the lifecycle of a student’s digital assessment, from registration to score reporting. We constantly seek out, experiment with, and harness new technologies to build quality products that deliver comprehensive assessments to the millions of students we serve. With the digital SAT and PSAT administration, our team continues to have new opportunities to work on challenging initiatives that are vital to our organization’s mission to connect students to college success and opportunity. 

About the Opportunity   

As a Data Engineer, you will be responsible for understanding our business use cases, extracting the data using SQL and building reports for our digital test administration. You will get the chance to be a part of a team that is in the limelight, collaborating closely with our Digital Assessment and Bluebook teams. Because of your ability to comprehend data and begin to develop insights, students from around the world can have a smooth testing experience and we can continue improving for generations to come.  

In this role, you will:  

Extract, Analyze, and Report (80%)   

• Develop complex SQL scripts to extract data in Athena, Timestream and Redshift  

• Access, trace, analyze and remediate data issues or inconsistencies through leveraging SQL and applicable AWS tools such as Redshift and Athena 

• Apply business logic to retrieve or change data sets from gaining a good understanding of the data structure and definitions  

• Trace changes in data and nail down edge cases for data scenarios 

• Design and manage information systems, conduct analysis, and generate accurate and comprehensive reports on operational data 

• Automate the data extract using Python and visualize these on charts and graphs using Tableau/Quicksight 

• Follow best practices around coding, version control, testing, and automated build processes 

• Explore and engage in opportunities to be hands on with new AI, data engineering tools and ML technologies available in the current market.  

Support (10%)   

• Support peak time test days with insight into issues and resolutions needed for test administration 

• Troubleshoot and resolve application