dev3lopcom, llc, official logo 12/8/2022

Connect Now

Lever.co

Custom SQL Queries

Developed, tested, tuned, and implemented SQL Queries.

Tableau Workbooks Built

Designed, developed, and implemented based on Lever.co client requests.

Hours Saved

Per year integrating client SQL into data products.

Lever.co Empowers companies and redefines Recruiting

Lever.co has 22k customers, 4M active jobs available, 600M candidates, 1.6 avg annual hires, and 700 employees strong. Lever.co is a leader in recruiting software. If you’ve applied to jobs online, you’ve likely used Lever.co’s software to do it.

Lever.co, a leader in recruiting software, sought full-time Tableau consulting services, data warehousing services, Python development, & data engineering consulting services, on multiple engagements, to advance their HR-focused data analytics capabilities and streamline client onboarding processes. 

Custom SQL Query Development

To meet these goals, they partnered with Tyler to develop, model, and productionize 282 custom SQL queries (tuned, tested, supported and implemented), 186 tableau workbooks created, and 11 python applications. Minimum 5 dashboards per client, 1-3 products (workbooks) per client and minimum 6 SQL sources per workbook. After three months full-time with Lever, decision makers asked DEV3LOP to create Lever Talent Intelligence version 5!

Tyler provided Tier 0 support for advanced SQL and Tableau requests, mentoring Lever.co’s analytics consultants and training them in best practices for Tableau and SQL. He also leveraged KNIME to prototype data architectures that were later hardened into Lever.co’s production SQL environment.

Tableau Workbooks Built

Working alongside Lever.co’s design, product, and consulting teams, Tyler played a pivotal role in enhancing and re-architecting SQL workflows for Tableau dashboards. His efforts resulted in scalable, custom data products tailored specifically for HR teams, supported the LTI v3, v4, and v5 high priority escalations, and delivered to over 30 high-profile clients, including Spotify, Lucid Motors, Talend, Eventbrite, Ancestry, Coupa, and CrossCountry.

During our time helping Lever.co, we were given multiple projects, like the creation of net new data products in Tableau desktop.

Hours Saved!

One of Tyler’s contributions was eliminating hours of SQL per new client. By creating reusable Tableau dashboard templates and automating core processes, Tyler enabled Lever.co to transition away from manually crafting new data products for each customer, enabling 22,000 hours saved per year. This innovation significantly reduced onboarding time and operational overhead, allowing the company to scale its offerings more efficiently.

Conclusion of Lever.co Engagement

By the end of the engagement, Tyler had established a robust foundation for scalable analytics and empowered Lever.co’s team to iterate on and deploy new Tableau dashboards independently, solidifying their ability to deliver cutting-edge recruiting insights to their diverse client base.

Eager to learn more? Contact us to talk to an advanced analytics consultant, today.

Images from Tyler Garrett‘s time onsite.

LEVER.CO

Industry:
Recruiting

Headquarters:
San Francisco, CA

Data Stacks:
MySQL, Tableau

Tyler from Dev3lop provided strong technical expertise during our time working with Lever, a recruiting software company. He was a pivotal team member by showcasing his expert-level SQL, Tableau Consulting, and analytical thought-leadership. His easy-going attitude made it very enjoyable to work along. The resulting dashboard project was a game-changer for our organization. I highly recommend Tyler and Dev3lop!

Eric Pham

AI/ML Consultant, SAP, Ex Google, Amazon, Lever

Ready to explore dev3lop solutions?