Data Engineer Contract

Position: Data Engineer (Contract)

Mode: Contract - long term

Location: Remote

Tech Stack Grid:

• NO Awareness of technology (0)
• LITTLE Awareness - read/heard of technology (1)
• EXPOSURE to technology in environment (2)
• SOME development in technology (3)
• Very COMFORTABLE developing in technology (4)
• EXPERTISE in technology i.e. could teach a class (5)

SQL, Level - 5

Tableau Desktop/Creator, Level - 3

Tableau API Integration, Level - 1

Glue, Level - 3

AWS - Athena, Level - 4

Redshift, Level - 5

AWS - Lambda, Level - 1

AWS - S3, Level - 3

AWS - SNS/SQS, Level - 1

msExcel, Level - 4

About the role

The College Board, the national educational organization, is conducting a search for a Data Engineer for our Internal Business Intelligence team. This position is based in our Reston, Virginia office, but this team is remote.

Named by Fast Company as one of the most innovative education companies, the College Board is a mission-focused organization. This job requires a strong focus on improving educational opportunities and outcomes, particularly for disadvantaged students, in the context of a competitive business environment.

The Data Engineer will be responsible for building reporting products and standard datasets, using an array of diverse technologies, including Tableau and AWS technologies.

Responsibilities of the role:

• Gather, analyze, and interpret data to solve specific use cases. Develop and participate in the review of requirements, data mappings, database specifications documentation and other artifacts and clearly communicate to both the business and technical team members the interpretation of the data.
• Demonstrate the ability to access, trace, analyze, and remediate data issues leveraging SQL and applicable AWS tools such as Athena and Redshift.
• Good analytical skills and experience in handling large sets of data
• Expertise to understand complex queries, proof test, and tweak for the intended use. Critical analysis skills to extract data and analyze the data for inconsistencies and issues.
• Design and manage information systems, conduct analysis, and generate accurate and comprehensive reports on operational data.
• Very strong in documentation of data artifacts, design and reports details.
• Support Architects, Leads and product owners to ensure that all aspects of the information analysis and requirements gathering process are completed with the highest degree of accuracy and quality, including the development and socialization of key project artifacts.
• Support ad hoc data requests as required as part of DevOps team.
• Review, extract, and analyze data and information on system processes and procedures.
• Experience developing testing strategies and identifying comprehensive test scenarios based on business requirements.
• Demonstrated experience with AWS Lambda, NodeJS, SNS/SQS, S3, IAM, CloudWatch, RDS, DynamoDB, Redshift and Athena.
• Willingness and ability to perform in multiple roles on a team, including testing and production support in addition to data analysis.
• Strong ability to understand and internalize the big picture and broader implications.
• Communicate and understand business goals and requirements, and work to create data solutions that add value to the business.
• Support team with functional, regression and end to end testing efforts with a focus on flow of data ensuring that features deliver the expected functionality with high quality.
• Self-starter with ability to set priorities, work independently and attain goals.
• Develop data-driven reporting solutions from concept to deployment.
• Strong SQL skills and ability to work with different data sources.
• Focus on designing and developing effective user-friendly reporting assets including interfaces and outputs.
• Cultivate and maintain knowledge of College Board products, data systems and information assets.
• Work with a highly proficient team using Tableau/Tableau Server, SQL, Relational/Columnar Databases, Data Modeling, MS Office
• Develop scripts to extract data in Athena, Timestream and Redshift.
• Automate the data extract pull and able to visualize these on charts/graphs/Tableau
• Exhibit good communication and practical decision-making skills, a believer in good feedback and documentation.

Qualifications:

• BA/BS required (major in an analytical field desired)
• A minimum of 5 to 10+ years work-related experience.
• Experience in hands-on development of reporting applications for the Web in a professional environment
• The Ethos of continuous improvement and interest in learning new things.

Preferred Skills and attributes:

• Strong analytical thinking and structured problem-solving ability
• Ability to handle multiple projects and assignments simultaneously and effectively in a cross-functional team environment.
• Versed on the agile methodology and best practices.
• Excellent interpersonal and collaboration skill with the ability to work with a diverse set of colleagues, across functions, from different organizations, disciplines, etc.
• Self-starter, ability to set priorities, work independently and attain goals

About the College Board

We are a mission-focused, not-for-profit membership organization that believes in promoting innovation, equity, and excellence for generations of students. Our members include more than 6,000 of the world s leading colleges, schools, and other educational organizations. We have over 1,600 employees in offices across the continental U.S. and Puerto Rico.

We are advocates for children and parents; we empower teachers and educators, and we are a strong presence in thousands of schools and communities across the country through programs and services - the SAT, Advanced Placement (AP ) and Pre-AP are just a few. Our work falls broadly into four categories: College Readiness, College Connection & Success, Student Opportunities, and Advocacy.

Named by Fast Company as one of the most innovative education companies, the College Board is a mission-focused organization. This job requires a strong focus on improving educational opportunities and outcomes, particularly for disadvantaged students, in the context of a competitive business environment.

Mission

Our mission is to clear a path for all students to own their future.

Selected candidates will be employed as a contingent worker of nextSource which is College Board s Managed Staffing Solutions Provider unless role is listed as direct hire . nextSource is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status, marital status, parental status, cultural background, organizational level, work styles, tenure and life experiences. Or for any other reason. nextSource is committed to providing reasonable accommodations for qualified individuals with disabilities in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at or you may call us at +1 .