Data Engineer at BenchPrep

| Chicago
Sorry, this job was removed at 11:13 a.m. (CST) on Monday, December 20, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

As a  Data Engineer at BenchPrep, you will help develop our products to allow for informative and timely delivery of data insights, ultimately helping millions of students and professionals achieve success. On a day-to-day basis, the focus is understanding and translating business needs into effective data architecture, in-depth SQL queries, and ETL processes to connect multiple data sources for our cloud-based SaaS products. Our product roadmap includes a significant focus on data analytics providing you the opportunity to meaningfully impact on our business and customers.

In the role, you will: 

  • Design and develop the data pipeline architecture including extract, transform, and load (ETL) processes 
  • Develop and tune queries for accurate and performant reporting. Optimize data extract processes used by reporting tools (Domo). Monitor and report on ETL job performance and status. 
  • Design and build data sets (for warehousing or as data extracts) to efficiently serve large, complex analytic requirements
  • Build processes to support data transformation, metadata, dependency, and workload management.

Your proactive approach will be highly helpful as not only will you design and build BenchPrep’s most technically complex data storage and access methods, you will also advise and coach software engineers and data analysts on how to achieve optimal functionality, performance, and scalability in our data and reporting systems. In a similar vein, while performing ad-hoc reporting and data extraction for internal users and external client requests, you’ll constantly look for ways to develop tools and/or automation to streamline similar ad hoc reporting requests into standard reports.

**Skills and experiences we value:

  • Demonstrated success developing and tuning data pipelines and ETL processes
  • Strong SQL and relational database knowledge, ideally PostgreSQL
  • Analytical and problem-solving mindset
  • Ability to translate business questions and analytic requirements to specific data sets and query results that satisfy them
  • Familiarity with non-relational data storage technologies (NoSQL) 

**Note: We know that excellent candidates can have all sorts of backgrounds and experiences, so please don’t hesitate to apply even if you don’t meet 100% of the listed requirements! And check out our latest blog post to learn more about inclusion at BenchPrep in the Engineering team."

Nice to have and/or you’ll learn:

  • Experience developing and maintaining data warehouses in big data solutions e.g. Snowflake
  • Conceptual knowledge of data and analytics, such as dimensional modeling, ELT, reporting tools, data governance, data warehousing, structured and unstructured data.
  • BI Tools (Sisense)

About BenchPrep:  

We deliver the most advanced and flexible learning experience for certification, credentialing, test prep, continuing education, and training. Our cloud-based learning platform helps training organizations, associations and the extended enterprise deliver a highly engaging and effective learning experience for individuals who are trying to advance their careers. We incorporate the latest in learner-centered technology, including personalization, gamification, data science, usability and omni-channel delivery.  

We’re sitting in a pivotal time in the BenchPrep history. The number of learners on our cloud-based learning platform has almost reached 7 million in 2021. 

We’re committed to helping students learn better, and that starts with our own people. 

COVID-19:

Speaking of our people, in March 2020, we put safety first and quickly moved our people to working remotely. We’ve learned that our employees are really productive working at home and still (mostly) work remotely. Our first core value is “People First” and the pandemic has reinforced how true this value reigns to us. What is the future of BenchPrep’s plans for working in-office or remote?  We haven’t finalized that, but what we do know is that collaboration and connection are our top priorities. Remote, in-office (Chicago), or hybrid... employees know how they work best.  Let us know what your preferences or requirements are for being remote only, hybrid or in-office.

Life at BenchPrep:  

We work at BenchPrep because we’re dedicated to the mission and each day we have an opportunity to be challenged and learn. We work hard and have lots of fun. Culture is our lifeline at BenchPrep. We celebrate our people, both professionally and personally. We care about learning so much that we offer employees $1,200 annually to develop their skills so they can continue to operate everyday with new skills. It’s no wonder we were selected in Inc’s Best Workplaces of 2020 and Crain’s 2020 Best Places to Work in Chicago lists.  

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

We are looking for high performing and motivated professionals who are excited about the chance to leverage technology to impact the lives of millions of learners. Join us.

Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • RubyLanguages
    • SqlLanguages
    • SwiftLanguages
    • Backbone.jsFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • vue.jsFrameworks
    • PostgreSQLDatabases
    • RedisDatabases
    • Google AnalyticsAnalytics
    • ConfluenceManagement
    • JIRAManagement
    • HubSpotCRM
    • SalesforceCRM

Location

We are located next to the Willis Tower, right in the heart of downtown Chicago.

What are BenchPrep Perks + Benefits

BenchPrep Benefits Overview

BenchPrep provides a full suite and wide variety of benefits and perks. We offer an incredibly competitive medical plan and insurance benefits, while also fostering a culture that allows employees to have fun in the office. Scroll down to learn more about those items and see what else BenchPrep has to offer.

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Highly diverse management team
Unconscious bias training
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Pre-tax dollars can be set aside for medical, dental, and vision ($2,750/yr) for employees or dependents with or w/o enrolling in our insurance program. Daycare & elder care allows for up to $5,000/yr
Disability Insurance
Our plan coverage offers employees Short Term Disability coverage at 60% of their weekly salary with a $2,500 weekly max. Long Term = 60% of their monthly salary with a $10,000 monthly max.
Dental Benefits
BenchPrep offer 3 dental plans.
Vision Benefits
BenchPrep’s vision insurance plans provide annual eye exams for a $10 copay and a $130 allowance toward frames and/or contacts.
Health Insurance Benefits
BenchPrep’s health insurance plan with BCBS of IL has a low deductible and BenchPrep pays 90% of the monthly premium for employees AND their dependents.
Life Insurance
Up to 3x annual salary, $750K max of voluntary life insurance & accidental death & dismemberment insurance. Spouse & dependent children plans available too.
Pet Insurance
Wellness Programs
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
BenchPrep’s 401k retirement plan offers a a cost effective employee retirement plan. The plan offers Roth and Pre-tax Investment options.
401(K) Matching
BenchPrep contributes 3% of an employee’s annual base salary, regardless of how much the employee contributes, which is immediately vested.
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
BenchPrep offers generous paid parental leave for new parents with at least 1 month of service, including a paid leave policy for foster parents.
Flexible Work Schedule
BenchPrep offers flexible work schedules as needed for employees.
Remote Work Program
BenchPrep offers Remote Work as an option for employees.
Family Medical Leave
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
BenchPrep closes its office for all major holidays, including MLK day, Presidents' Day, Memorial Day, 4th of July, Labor Day, Thanksgiving, and Christmas THROUGH New Years Day.
Paid Sick Days
BenchPrep employees receive 5 sick days per year.
Perks & Discounts
Beer on Tap
We've got 2 beers on tap regularly, and a refrigerator stocked with bottled brews and liquor as well that is frequently "tapped" into.
Casual Dress
BenchPrep does not have a formal dress code and encourages employees to wear whatever makes them comfortable.
Commuter Benefits
Transit and Parking benefits: Employees may elect up to $260/month for pre-tax allocation for mass transit & parking expenses for commuting to BenchPrep, including Metra, Ventra and parking facilities
Company Outings
BenchPrep has regular outings that include Cubs rooftops, boat trips on Lake Michigan, off-site happy hours, poker nights, game nights, foodie dinners, and a holiday party, among other events.
Free Daily Meals
We provide a $12.50 daily stipend for employees every day via Fooda (https://www.fooda.com/resources/case-study/how-tech-startup-benchprep-made-lunch-powerful-part-its-culture).
Game Room
Stocked Kitchen
FULLY stocked! Beverages = Soda, Coffee, Tea, RedBull, Juice, Vitamin Water, etc. Food = if you can think of the snack, we probably have it or some variation. Employees will never go hungry here.
Fitness Subsidies
Employees have access to the FFC gym located within our building, free of charge!
Professional Development Benefits
Job Training & Conferences
Employees are provided an annual stipend to attend external training events or conferences.
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications

Additional Perks + Benefits

Competitive salary, valuable stock options, and company-sponsored 401(k) • Fun, meritocratic, mission-driven, dynamic work culture • Commitment to fostering positive office culture (included, but not limited to, quarterly outings, an in-office ping pong table, cocktail hours, poker nights, etc.)

More Jobs at BenchPrep15 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Marketing
Product
Sales
Content
HR + Recruiting
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
HR + Recruiting
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView BenchPrep's full profileSee more BenchPrep jobs