Data Warehouse Engineer

| Greater Boston Area
 
Data Warehouse Engineer
 
Company Overview
Inspired by the Moneyball concept popularized by the Oakland A’s in baseball, Graham Gardner, MD and Julie Yoo founded Kyruus in 2010 to bring a data-driven approach to matching patients with healthcare providers. The company focuses on solving the “patient access paradox”: patients being told to wait weeks (if not months) for appointments while appointment slots simultaneously go unutilized – even at leading health systems. Helping to solve this supply-demand mismatch and solve truly unmet needs in healthcare, Kyruus is now the leader in patient access technology. The company works with top health systems across the country to help them match patients with the right providers, at the right time, through a suite of cloud-based provider search and scheduling solutions.
Funded by top-tier venture firms (e.g., Venrock, Highland, Leerink, New Leaf), Kyruus is growing rapidly. The company doubled its revenue in 2017 and its platform now includes close to 100,000 providers across over 400 hospitals in the US. The Kyruus team includes driven and talented individuals who are passionate about removing barriers to patient access and making a difference in healthcare.

About the Role
People join Kyruus to make a meaningful impact in improving healthcare, and you will play a critical role in helping to build out our ProviderMatch Analytics product offering. Reporting to the Director of Data Warehousing, you will be a key member of our Analytics team, which is dedicated to providing ground-breaking insights to Kyruus’ customers. You’ll work collaboratively with Kyruus team members throughout the company (Product, Engineering, Delivery, Sales) to build a best-in-class, cloud based analytics platform. You’ll have a strong technical background in data warehousing, analytics, and data processing and be comfortable sharing insights with internal team. You’ll be active in maintaining and growing your professional and technical knowledge, while providing thought leadership internally. 

Responsibilities:

  • Identify and implement business and technical requirements for data warehouse
  • Automate, optimize, and maintain ETL mappings in a repeatable, scalable fashion
  • Administer all data to ensure compliance with standards, policies, and all applicable laws and regulations
  • Provide guidance to all database architecture
  • Build and maintain our data integrations with 3rd party analytics vendors
  • Implement dimensional model to support GoodData
  • Requirements:
    • Bachelor’s degree in computer science or related discipline required
    • A minimum of 5 years related experience required, with a minimum of 3-5 years experience in Data Warehousing and ETL development
    • Experience in Unix shell scripting and Python coding required
    • Strong understanding of relational database concepts & technology – data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture preferred
    • Experience with AWS data management (S3, Redshift, PostgreSQL, RDS) and related tools (Athena, EMR, Glue) in an enterprise environment
    • Experience developing ETL specifications and mappings to support data conversion and integration
    • Experience with web crawlers or scrapers
    • Strong advocate of software engineering principles, deep understanding of the Software Development Life Cycle, and experience in an agile environment
    • Deep understanding of implementation of file based ingestion/data extraction/job scheduling
    • Hands-on technology service delivery experience including web, cloud infrastructure, and complex healthcare data architectures
    • Well organized and able to manage multiple projects in a fast-paced demanding environment
    • Ability and willingness to learn new tools and applications
    • Effective written and verbal communication skills with ability to convey complex technical concepts to business users and management
    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

    Technology we use

    • Engineering
    • Product
    • Sales & Marketing
      • JavascriptLanguages
      • PythonLanguages
      • ReactLibraries
      • ReduxLibraries
      • FlaskFrameworks
      • PostgreSQLDatabases
      • RedisDatabases
      • GoodDataAnalytics
      • InVisionDesign
      • SalesforceCRM

    Location

    222 Berkeley Street, Boston, MA 02116
    222 Berkeley Street, Boston, MA 02116

    Insider's spotlight

    What's something quirky about your company?

    We Kyruuvians add k’s and “:u”s to commonly used words, tools, APIs, pretty much anything that contributes to our own growing lingo. For example, we have an employee recognition program that’s called Ku:udos, Kamunda is Kyruus API wrapper for Camunda (a workflow engine), Downloadu:ur is a tool to deliver reports to clients, and you get the idea!

    Nausheen

    Senior Director of Engineering

    What's the biggest problem your team is solving?

    Our platform ingests, parses and organizes data from health systems' provider and scheduling data, providing customers with a platform to make finding a doctor and booking an appointment as easy as booking a seat on a flight. Scaling our match capabilities with new sources of data, algorithms and presenting it simply are current areas of focus.

    Chris

    SVP - Product + Engineering

    What is your vision for the company?

    Our vision is to enable patients to get matched to the right provider the first time, in such a way that solves "The Patient Access Paradox", wherein patients are told to wait months for doctors appointments, despite the fact that 20-40% of the capacity in the healthcare system goes under-utilized.

    Julie

    Co-Founder / Chief Strategy Officer

    What projects are you most excited about?

    I'm most excited about the potential for chatbots to provide better matching between patients & doctors. With a chatbot, we can provide a rich user interaction that provides a better experience & better match than the existing "search and filter for doctors" paradigm, and also allows for a seamless handoff to a person in a doctor's office if needed

    Will

    Director of Engineering

    What are Kyruus Perks + Benefits

    Kyruus Benefits Overview

    We have free snacks/food/drinks, awesome health/dental/vision benefits, Wellness + Commuter reimbursement, performance bonus, unlimited vacation, and more.

    Health Insurance & Wellness Benefits
    Dental Benefits
    Health Insurance Benefits
    Wellness Programs
    You betcha! Healthy = Happy. 300$ a quarter to spend on things that make you a better you!
    Retirement & Stock Options Benefits
    401(K)
    Company Equity
    Share in our success!
    Performance Bonus
    Child Care & Parental Leave Benefits
    Generous Parental Leave
    Flexible Work Schedule
    Vacation & Time Off Benefits
    Unlimited Vacation Policy
    Perks & Discounts
    Casual Dress
    Commuter Benefits
    Company Outings
    Annual/Quarterly Launch Parties, Trivia/Game/Movie Nights, Ice Cream Socials, Scavenger Hunts just to name a few and, of course, just good ol' fashions drinks and/or food after work.
    Game Room
    More boardgames than you'll ever be able to play in a lifetime! Videogames too. Favorites - SmashBro's, RocketLeague, Halo 1 (pistols), MarioKart / Diddy Kong, 007, Conquers BFD, any N64 game really.
    Stocked Kitchen
    Of course. Seltzers (salsa?), candy, snacks, chips, all the things.
    Some Meals Provided
    Catered lunch on Fridays.
    Happy Hours
    Recreational Clubs
    Professional Development Benefits
    Job Training & Conferences

    Additional Perks + Benefits

    We have all the standard tech company perks (perhaps minus some of the "google-level" stuff like volleyball courts/sleeping pods/trips to the real Hogwarts/personal helicopters, tame+alive helper dinosaurs/etc) but what sets us apart is our people. We care about our mission - making healthcare better - and it comes through in our culture. Not only are Kyruuvians the smartest folk on the block (you wont hear us say that btw) we are also some of the most kind, caring, and helpful humans one could hope to meet.

    Working here, and being part of this team is truly awesome.

    More Jobs at Kyruus8 open jobs
    All Jobs
    Dev + Engineer
    Operations
    Developer
    new
    Kyruus
    Operations
    new
    Kyruus
    Developer
    new
    Kyruus
    Operations
    new
    Kyruus