Data Engineer

Posted:
10/24/2024, 5:00:00 PM

Experience Level(s):
Junior ⋅ Mid Level

Field(s):
Data & Analytics

Workplace Type:
Remote

College Board – Technology

100% Remote US based, working core EST hours

About the Team

College Board offers a dynamic suite of tools and programs designed to streamline and expedite the Higher Education recruitment and admission process. Our Higher Ed Elevate team is a passionate, close-knit, group of professionals responsibly experimenting with AI to make informed decisions that give institutions unparalleled reach, connecting them with millions of high school students each year. We pride ourselves on being innovative in our industry by continuously improving our products and services. Our team consists of 3 architects and 3+ engineers, a blend of full-time staff and contractors, collaborating across various time zones to deliver multiple services and tools.

About the Opportunity

As a Data Engineer on our Higher Ed Elevate team, you possess an unwavering passion for excellence in Software Engineering and a drive to transform that passion into consistent excellence in product development. You are customer-obsessed, have strong analytical and communication skills, enjoy working with native AWS services, and thrive on solving challenging business problems. You will partner with Product Owners, Architects, Developers, and other Software Engineers to help design, define, implement functional features, conduct system level validation and verify features of product development. You have an aptitude for learning and will apply this to implement advanced software engineering practices in Data Analytics within our AWS, Microservices environment to solve complex problems with a mission to release high quality software that is resilient and optimally performing. You will engage in both data and analytics reports development and quality engineering, testing and automation as a data engineer.

In this role, you will:

Design & Implementation (70%)

  • Build, test, deploy and maintain production code for complex transactional applications using event driven microservices, node.js, Python languages in Agile teams within an AWS technology environment

  • Incorporate Cloud technologies on new application development to include 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 our test automation suite to support security features and technical scoping, ensuring that features deliver the expected functionality with high quality

  • Ensure that continuous integration is performed on the application source code and constantly seek to enhance the continuous integration methods of the development team to ensure extremely high quality of code

  • Support and coordinate with other Engineers, Architects and teams such as User Experience and/or infrastructure teams

Strategy & Communication (20%)

  • Implement cloud-first architectural solutions and best practices

  • Participate in agile scrum ceremonies (Sprint Planning, Grooming, Daily SCRUM, Demo) and contribute to team deliverables

  • Participate in peer reviews of software engineering artifacts

Team Coordination (10%)

  • Mentor team members by designing and developing training materials to communicate the current and future product architecture

  • Mentor technical staff by providing feedback of code and other design artifacts

About You

You have:

  • Ideally 4+ years of software development experience in a production environment, including 18+ months experience incorporating AI technology solutions

  • Expertise writing and optimizing complex SQL queries for data extraction, transformation, and reporting (e.g., SELECT, JOIN, GROUP BY, HAVING, WINDOW functions)

  • Expertise integrating Redshift Serverless with AWS services such as S3, Glue, Lambda, Athena, DynamoDB and Kinesis 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

  • Experience with Python required; React and Node.js 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

  • Able to prioritize and execute tasks in a high-pressure environment

  • 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 $132,000 to $143,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 these 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 high-performing engineers work with the latest technologies, so you will be constantly learning and sharpening your skills

  • 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 value learning and growth; we offer formal and informal ways to lead through your superpowers, sharpen your strengths, and meet your development goals 

  • We offer a transparent approach to promotions and merit raises, annual performance-based bonuses, and how to grow your career here over time

#LI-MS1

#LI-REMOTE