Senior Data Engineer

| Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Senior Data Engineer

We all depend on healthcare throughout our lifetimes, for ourselves, and our families and friends, but it is notoriously difficult to navigate and understand. As an industry that comprises 20% of the US economy we think healthcare should work better for all of us. At Collective Health we believe it’s time for a new day in healthcare where as members we are informed and empowered to make the right care choices when the decisions are urgent and critical. 

We deliver a connected healthcare experience for over 200,000 members and 45+ companies across the nation who want the best for their employees. We've got a ton of interesting problems to solve around data pipeline design and implementation, data architecture and modeling, distributed systems, and more. If you're passionate about tackling hard problems while making a real difference in the world, we'd love to talk!

What you'll do: 
  • Data Pipelines - Create new pipelines and improve/maintain existing pipelines using Spark (Scala, Pyspark, Spark SQL)
  • Data Modeling - Partner with analytic consumers to design logical and physical schemas, improve existing data models and build new ones
  • Cross-functional Collaboration - Interface with Product, Engineering, Data Science, Analytics/BI, and Operations to understand their data needs, providing both consultative and data engineering solutions for consumers
  • Build data expertise and own data quality across various business domains including healthcare claims and member experience
Your skills and qualifications include:
  • BS degree in Computer Science or related technical field, or equivalent practical experience
  • 6+ years proven work experience as a data engineering, working with at least one programming language (e.g. Scala, Python/PySpark) plus SQL expertise
  • 6+ years experience with schema design, dimensional data modeling, and large-scale data warehousing architecture
  • Expertise in building data pipelines through efficient ETL design, implementation and maintenance 
  • Background working with distributed data systems such as Spark, Presto, Hive, and Redshift. Experience with schedulers/workflow management tools (e.g. Airflow) a plus
  • Excellent communication skills to collaborate with stakeholders in Engineering, Product, Data Science, Analytics/BI, and Operations

Collective Health is a technology company simplifying employer healthcare to make health insurance work for everyone. With more than 200,000 members and over 45 enterprise clients—including Pinterest, Red Bull, Restoration Hardware, Activision Blizzard, and more—our technical and customer experience teams are reinventing the healthcare experience for forward-thinking employers and their people across the U.S.

Collective Health is headquartered in San Francisco, CA, with additional offices in Chicago, IL, and Lehi, UT. Founded in 2013, Collective Health is backed by the SoftBank Vision Fund, DFJ Growth, PSP Investments, NEA, GV, G Squared, Founders Fund, Maverick Ventures, Mubadala Ventures, Sun Life, and other leading investors. For more information, visit us at https://www.collectivehealth.com

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.

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
    • GolangLanguages
    • JavaLanguages
    • PythonLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • PostgreSQLDatabases
    • Google AnalyticsAnalytics
    • PiwikAnalytics
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement

Location

Located right in the heart of River North by the Red, Brown, and Purple CTA lines, with countless nearby restaurants and entertainment options.

An Insider's view of Collective Health

What’s the vibe like in the office?

The vibe here in the Chicago office is one of chill focus. For the most part, you'll hear the tapping of keys and some soft conversation, with the occasional bubbling over of laughter. We like to get our work done here, but we love getting to know one-another. We're always happy to step away for a chat over coffee or a game of foosball.

Marc

Software Engineer

What does your typical day look like?

Daily work as an SRE includes anything that increases the reliability and stability of the Collective Health platform to make sure our customers have the best experience possible. Everything from huge cross-team initiatives like migrating to Kubernetes to really deep dives troubleshooting issues is possible - and I choose projects that interest me!

Katie

Site Reliability Engineer

How does the company support your career growth?

People here really root for each other’s growth professionally and personally, and they show it by working alongside you to help you do more than you thought you could. We make sure there is space to learn as you work and try new things, and when you do well with them, you get concretely recognized for it.

Hannah

Software Engineer

How do you empower your team to be more creative?

We strive to foster a psychologically safe culture in order to feel free to share all our ideas, allowing even crazy whims and hunches to be molded and shaped by in-depth discussion and collaboration until they reach their full potential. No question is a stupid one, and we all have valuable input.

Matt

Software Engineer

What are some social events your company does?

From the vaguely familiar whirlyball to the always-embarrassing karaoke happy hour, we like to keep things fun and not take ourselves too seriously. We’ve even subjected ourselves to a hot sauce eating challenge, just for fun. Our team also has a regular “game night” where we play anything from Settlers of Catan to Mario Kart.

Patrick

Senior Product Manager

What are Collective Health Perks + Benefits

Collective Health Benefits Overview

We pay 100% of employee premiums for medical, dental, and vision plans. We also offer a wellness stipend, flexible time off, help with your commute, life insurance, a retirement plan, and plenty of perks to keep you happy, healthy, and engaged.

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Daily stand up
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Company sponsored family events
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Happy Hours
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
More Jobs at Collective Health28 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Internships
Marketing
Product
Sales
Content
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Content
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
HR + Recruiting
new
Chicago
Design + UX
new
Chicago
Internships
new
Chicago
Internships
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Sales
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Collective Health's full profileSee more Collective Health jobs