Senior ETL Developer

| Chicago

About The Role

Yello is looking for a Sr. ETL Developer to join its Data Services team. As an ETL Developer, you will work cross-functionally with our Product and Front End Feature development teams to design and implement end-to-end data pipelines to support the reporting needs of our Enterprise clients. You will have the opportunity to mentor other engineers on proper ETL design, dimensional modeling, and BI practices all while shaping the direction of a robust, multi-tenant, embedded reporting solution. 

How You'll Make An Impact

You will play a pivotal role on a newly formed data team focused on building analytics and reporting for our client-partners.

  • Design, architect, implement, and document new, scalable data pipelines for data warehousing
  • Conduct ETL/ELT and ad hoc query performance tuning, monitoring, and troubleshooting
  • Build unit tests, audit, and QA data and processes to ensure data quality and integrity throughout the data pipeline
  • Design and implement interactive client-facing dashboards and reports

What We're Looking For

  • 5 years of professional ETL/ELT development experience
  • Proficiency in dimensional data modeling (Data Marts/Data Warehouses) 
  • Proficiency with distributed data processing (Spark highly preferred)
  • Advanced knowledge of SQL (PostgreSQL preferred)
  • Experience working with BI Tools & Advanced Analytics (Tableau, SiSense, etc)
  • Experience working on an end-to-end reporting solution
  • Experience using columnar store database a plus
  • A desire to share knowledge and help others on your team grow
  • Experience leading technical initiatives
  • Experience with Amazon Web Services Ecosystem (EC2, S3, RDS, etc)
  • Understanding of Data Security and Privacy
  • Experience using Agile methodologies

Additional Information

We are the trailblazers in our space and we continually strive to learn and grow, but there is always time to celebrate a colleague's birthday or a recent success. We dress casually, have one of the best views in the city and the whole team sports Apple laptops. Our CEO Jason Weingarten and President Dan Bartfield always have their office doors open. And with opportunities for professional advancement, medical, dental and vision insurance, and a 401K match – Yello has you covered.

  • 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.
  • Must be able to sit or stand for continuous periods of time
  • This role frequently communicates/interacts with individuals, must have strong written and oral communication skills
  • Yello reserves the right to assign or reassign the responsibilities and requirements to this job at any time
Read Full Job Description
Apply now
loading ...
Emailed

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 Yello15 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Marketing
Operations
Project Mgmt
Sales
Operations
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago