Data Analyst, AWS Analytics

College Board - Technology Division - Exam Config

100% Remote

About the Team

The College Board's Exam Config team is a dynamic group of 12 collaborative, motivated technologists dedicated to implementing essential services that support the lifecycle of student assessments-from registration to score reporting. We continuously seek, experiment with, and utilize innovative technologies to build high-quality products, all with the singular purpose of providing comprehensive assessments to millions of students. As we transition to digital administration for SAT, PSAT, and AP exams, our team explores exciting new opportunities to contribute to initiatives crucial to our mission of clearing a path for all students to own their future.

About the Opportunity

As a Data Analyst, AWS Analytics on the Exam Config team, you are a detail-oriented collaborator and innovator with strong commitment to delivering exceptional quality. In this role, you will play a critical part in supporting data management and conducting root cause analysis to ensure the reliability and accuracy of Exam Config systems. Leveraging your AWS expertise, advanced SQL skills, and strong problem-solving abilities, you will work with complex data sets, automate key processes, and drive efficiency. Your excellent communication and interpersonal skills will enable you to collaborate effectively with cross-functional teams as you help enhance data accuracy and system performance. You are independent and proactive with exceptional problem-solving skills. You are proactive, independent and thrive in a fast-paced, Agile environment-eager to make a meaningful impact on the digital transformation of SAT, PSAT, and AP exams.

In this role, you will:

• Analyze data to identify trends, detect anomalies, and uncover opportunities for improvement
• Conduct root cause analysis (RCA) of system and data-related issues, documenting findings and recommending solutions
• Write and execute SQL queries to extract, manipulate, and analyze data from various sources
• Utilize AWS analytics tools (e.g. Athena, Postgres, Redshift) to perform advanced data analysis and generate meaningful reports
• Collaborate with business and technical teams to translate data insights into actionable recommendations
• Develop and review requirements, data mappings, user stories, and related documentation, clearly communicating to both business and technical team members
• Troubleshoot and resolve production issues by partnering with engineering teams to identify root causes and implement fixes
• Fulfill ad hoc data requests while ensuring compliance with governance and security policies
• Support functional testing efforts by validating data accuracy, system behavior, and process integrity

About You

You have:

• 6+ years of experience in enterprise-wide data management
• Advanced SQL skills with experience writing complex queries for data extraction and analysis
• Hands-on experience with AWS services and analytics tools, including Athena, Redshift/Postgres, DynamoDB, and S3
• Proven experience conducting root cause analysis and resolving data and system-related issues
• Skill in working with large, complex datasets to identify patterns, detect inconsistencies, and recommend optimizations
• Strong analytical and problem-solving skills with a keen eye for detail
• Excellent communication and collaboration skills for engaging with technical and business stakeholders
• Familiarity with functional testing practices and validating data/system behavior
• Understanding of Agile methodology and comfort working in a DevOps environment
• Proficiency with scripting languages such as Python or Shell scripting
• Bachelor's degree required; MS or MBA highly desirable
• Authorization to work in the United States

About Our Process

• Application review will begin immediately and will continue until the position is filled
• While the hiring process may vary, it generally includes: resume and application submission, recruiter phone/video screen, hiring manager interview, performance exercise such as live coding, a panel interview, a conversation with leadership and reference checks.

About Our Benefits and Compensation

College Board offers a competitive benefits and compensation program that attracts top talent looking to make a difference in education. As a self-sustaining non-profit, we believe in compensating employees equitably in relation to each other, their qualifications, their impact, and the relevant market.

The hiring range for a new employee in this position is $125,000 to $135,000. Your salary will be carefully determined based on your location, relevant experience, the external labor market, and the pay of College Board employees in similar roles. College Board strives to provide our best offer up front based on this criteria.

Your salary is only one part of all that College Board offers, including but not limited to:

• A comprehensive package designed to support the well-being of employees and their families and promote education. Our robust benefits package includes health, dental, and vision insurance, generous paid time off, paid parental leave, fertility benefits, pet insurance, tuition assistance, retirement benefits, and more
• Recognition of exceptional performance through annual bonuses, salary growth over time through market increases, and opportunities for merit raises and promotions based on increased scope of responsibility
• A job that matters, a team that cares, and a place to learn, innovate and thrive

You can expect to have transparent conversations about benefits and compensation with our recruiters throughout your application process.

About Our Culture

Our community matters, and we strive to practice and improve our culture daily. Here are some headlines:

• We are motivated to positively impact the educational and career trajectories of millions of students a year
• We prioritize building a diverse and inclusive team where every employee can thrive, and every voice is heard
• We are a dynamic hybrid team, giving staff members the choice to either be fully remote or hybrid if they live close to a College Board office. Hybrid employees go into offices every Tuesday and Wednesday
• We welcome staff to join any or all six of our affinity groups: ARISE (Alliance for Asian Retention, Inclusion, Success, and Engagement; DIASPORA (Alliance for Pan-African Success and Achievement); Pride (alliance for LGBTQ+ staff and allies); Resilience (alliance for Native staff and advocates); SALSA (Staff Alliance for Latinx Success and Achievement); and WIN (Women's Impact Network)
• We value learning and growth; we offer formal and informal ways to lead through your superpowers, sharpen your strengths, and meet your development goals
• Our high-performing engineers work with the latest technologies, so you will be constantly learning and sharpening your skills

#LI-MS1

#LI-REMOTE