Reports Developer - Looker at Yello

| Chicago
!Sorry, this job was removed at 4:19 p.m. (CST) on Friday, March 20, 2020
Apply now

Company Description

We’ve all had a recruiting experience that stands out, either because it was magical or ‘oh so horrible.’ 

The technology that recruiting teams use to find, connect with, and advance talent often shapes a candidate’s experience. Yello’s software enables employers to recruit effectively and efficiently. If it excites you to be a part of a team that helps some of the world’s largest brands connect with their talent, then come grow your career with Yello. 

Founded in 2008, Yello is a venture-backed talent acquisition software company that empowers Fortune 500 and fast-growing enterprise companies to  find the best talent for their organizations. Our solutions helps recruiters love their work — and helps people early in their careers find their dream job. 

~We believe in bringing our authentic selves to work. 

~We are hungry to learn and are forever curious.

~We do what’s right for our customers, leading with our expertise.

~We are proactive.

~And last but not least, we strive to start with empathy in all of our interactions.

About The Role

This role will define and drive best practices and standards for Yello’s reporting suite. This role will join an existing data services team charged with ensuring the delivery of business insights from data that Yello collects. This role works closely with the architects, data engineers and data stewards to produce reporting solutions that are performant and maintainable. This role will have the opportunity to work with machine learning to drive the business insights to the next level.

How You'll Make An Impact

  • Translate business requirements into technical specifications to design, build and deploy BI dashboards and business analytics.  
  • Build complex SQL queries to transform, cleanse, and validate data for the data warehouse based on business rules and requirements. 
  • Ensure Yello’s platform can continue to meet the needs of our fast-growing customer base and enable new product development opportunities.

What We're Looking For

Minimum

  • Computer Science, Computer Engineering or related degree or equivalent experience required
  • 3 to 5 years of experience working in business intelligence (BI) reporting.
  • 1-3 years working experience with Looker reporting tool, building complex visualizations, LookML code, and leveraging advanced Looker techniques is a must.
  • Proficient in SQL - must be able to build and performance tune complex transformation, reporting, and validation queries, preferably in PostgreSQL, to ensure accuracy, scalability, and maintainability of code.
  • Analytical and problem-solving skills to take complex business requests and transform them into clean, simple, data driven solutions
  • Strong verbal and written communication skills and the ability to effectively collaborate with other engineers as well as internal/external stakeholders.

Preferred

  • Experience with ETL technologies, in particular pySpark/python.
  • Understanding of cloud infrastructure (AWS, Google Cloud, etc), especially utilizing serverless technologies such as AWS Glue, AWS Lambda, etc.
  • Experience with dimensional data modeling.
  • Experience with Agile methodologies.

Additional Information

  • Yello is an Equal Opportunity Employer. All applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
  • Candidates local to Chicago are preferred.
  • You must be authorized to work in the United States.
Read Full Job Description
Apply now

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • RubyLanguages
    • SqlLanguages
    • SwiftLanguages
    • ReactLibraries
    • ReduxLibraries
    • Ruby on RailsFrameworks
    • MySQLDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • ElasticsearchDatabases
    • Google AnalyticsAnalytics
    • MixpanelAnalytics
    • FigmaDesign
    • Aha!Management
    • ConfluenceManagement
    • JIRAManagement
    • WrikeManagement
    • WordpressCMS
    • SalesforceCRM
    • MarketoLead Gen

Location

We're located in the Loop, a block from the Art Institute and Millennium Park. Our office offers panoramic 360 degree views of Chicago.

What are Yello Perks + Benefits

Yello Benefits Overview

Health
Wellness
Financial
Giving
We've got you covered!

Culture
Volunteer in local community
Partners with Nonprofits
Eat lunch together
Intracompany committees
Yello has a number of committees and groups including the Flair committee as well as [email protected] and [email protected] (to name a few)
Open door policy
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Company sponsored short-term disability insurance covers 100% of annual salary for up to 13 weeks.
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Company sponsored life insurance is equal to 1 times an employee's annual salary.
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Yello provides employees with a 401(k) matching plan managed by John Hancock. We match 3% of contributions with a 4-year vesting schedule.
Company Equity
Yello offers equity to employees at their 1 year anniversary.
Performance Bonus
Yello's performance bonus is an annual bonus of up to 10% of an employee's base salary. Payout is based on company and individual performance.
Match charitable contributions
While we don't match yet, we value giving back to causes that create a positive social impact. Through Percent Pledge, we help employees seamlessly give monthly to their favorite causes
Child Care & Parental Leave Benefits
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Yello offers employees professional development opportunities like the ability to attend job-related conferences and seminars.
Tuition Reimbursement
Lunch and learns
Yello hosts lunch and learn meetings twice per month.
Cross functional training encouraged
Promote from within
Time allotted for learning
Yello has a 'Learning Day' every 2 weeks on Friday to allow employees to set aside half a day for learning of any kind.

Additional Perks + Benefits

Yello sponsors office sports leagues and offers discounted memberships to Chicago Athletic Clubs. • Yello is dedicated to supporting career progression through professional development opportunities, mentorship and continued education • Yello offers the benefit of a student loan repayment plan and a 529 plan through BenefitEd with an annual company match to help you or your family continue your financial health. Yello offers healthy catered lunches each week and 2 fully stocked kitchens with fresh fruit and snacks to keep you nourished.

More Jobs at Yello5 open jobs
All Jobs
Finance
Dev + Engineer
Operations
Product
Developer
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Apply now
Save jobView Yello's full profileSee more Yello jobs