Data Integration Specialist (SQL) at Quartet Health

| Greater NYC Area
Sorry, this job was removed at 11:39 a.m. (EST) on Tuesday, April 7, 2020
Find out who's hiring in NYC.
See all Data + Analytics jobs in NYC
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Company Description:

Quartet is a pioneering healthcare technology company striving to improve the lives of people with mental health conditions. We connect people to a personalized care team to get them the right care at the right time. Our collaborative technology platform and range of services brings together physicians, mental health providers, and insurance companies to effectively improve patient outcomes and drive down healthcare costs. Backed by $153MM in venture funding from top investors like Oak HC/FT, GV (formerly Google Ventures), F-Prime Capital Partners, Polaris Partners and Centene Corporation, Quartet is headquartered in NYC and is currently operating in several markets across the United States — Pennsylvania, Washington, Northern California, New Jersey, North Carolina, Louisiana, and Illinois.

About the team & Opportunity:

Quartet is looking for a Data Integration Specialist to manage relationships with our health care customers and vendors in order to integrate their data sources into our data ecosystem.

This position requires outstanding communication and project management skills, a deep understanding of the healthcare data landscape, technical stack for data munging and quality assurance, and the tenacity to execute against competing deliverables in a timely, high-quality fashion.

The Data Integration Specialist will collaborate with numerous teams - both internal and external - to source data Quartet needs to operate, helping to ensure that the scope and direction of each procurement and processing is on schedule. You’ll interact primarily with Quartet's data engineers, partnering with them to develop our data pipeline and transform our partners data into standard models, Quartet’s data science and business intelligence teams to communicate or update new issues in ongoing feeds, as well as Quartet’s implementation and client success teams to effectively share progress and priorities and negotiate the exchange of healthcare data with our partners.

You'll represent the Quartet data teams during customer meetings, where you will collaborate with our data partners to extract the right data elements from their internal systems and ensure they map to the data points needed for Quartet's standard operating processes. You'll be responsible for high-level data validation and owning internal and external communications when data quality expectations aren't fully met. As we grow as a company and department, we regularly make process refinements and you'll be tasked with enhancing data on-boarding playbooks as we learn more from each new engagement.

Accountabilities

  • Manage relationships with various partners, including Medical Insurers, Health Systems, 3rd Party Data Vendors, and open data sources
  • Understand and represent Quartet's data interests in discussions with customers
  • Translate requested extracts into Quartet's standard models
  • Provide quality assurance to data sources
  • Communicate and mitigate updates or issues within Quartet’s data pipeline

Minimum Qualifications

  • Strong communication and relationship management skills to develop partnerships with key customer stakeholders
  • Experience and understanding of healthcare claims data
  • Ability to write SQL queries to validate and explore data
  • Experience working with both highly technical teams and non-technical teams; ability to communicate effectively to both

Preferred Qualifications

  • Familiarity with electronic health records data, or other healthcare data sources
  • Conversational understanding of data science activities and technologies (ETL, predictive models, etc...)
  • Python (nice to have)
  • Experience with integration of data from multiple data sources

Employee Benefits for Quartet include: Unlimited vacation, volunteer opportunities, catered lunches, snacks, team events and outings, mental healthcare coverage of 15 free therapy sessions + unlimited copay reimbursements, medical, dental + vision coverage, generous parental leave, commuter benefits, 401K, stock option grants, gym benefits.

Want to know what Quartet life is like? Click here to meet our team.

Quartet is committed to building a diverse team and fostering an inclusive culture, and is proud to be an equal opportunity employer. We embrace and encourage our employees' differences in race, religion, color, national origin, gender, family status, sexual orientation, gender identity, gender expression, age, veteran status, disability, pregnancy, medical conditions, and other characteristics. Headhunters and recruitment agencies may not submit resumes/CVs through this Web site or directly to managers. Quartet does not accept unsolicited headhunter and agency resumes. Quartet will not pay fees to any third-party agency or company that does not have a signed agreement with Quartet.

Please note: Quartet interview requests and job offers only originate from quartethealth.com email addresses (e.g. [email protected]). Quartet will also never ask for bank information (e.g. account and routing number), social security numbers, passwords, or other sensitive information to be delivered via email. If you receive a scam email or wish to report a security issue involving Quartet, please notify us at: [email protected].

Have someone to refer? Email [email protected] to submit their details to us.

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
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • ReactLibraries
    • ReduxLibraries
    • Sci-KitLibraries
    • Node.jsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • PySparkFrameworks
    • PostgreSQLDatabases
    • RedisDatabases
    • OptimizelyAnalytics
    • LookerAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • TrelloManagement
    • WordpressCMS
    • SalesforceCRM
    • MandrillEmail
    • MarketoLead Gen

Location

Being next to Bryant Park allows us to take meetings while taking a walk. Plus, lunch spots galore (priorities) and easy access to trains.

An Insider's view of Quartet Health

What’s the vibe like in the office?

Quartet’s office vibe creates a space that balances productivity, creativity, and collaboration. No matter if you are in scheduled meetings with team members, focusing in a phone-booth style cubicle, having an impromptu meeting with someone across the company on the couches, or grabbing a bite to eat and cold brew in the kitchen

Katie

Lead Operations Coordinator

What does your typical day look like?

I take calls from our patients, in our different markets across the country and my goal is to connect them to the right provider to ensure they get the care that they need. It feels great to make a difference at that moment, for another human being that is going through difficulty. My job makes a difference in someone's life; it feels rewarding.

Subomi

Patient Inbound Specialist

How has your career grown since starting at the company?

Quartet has given me opportunities to discover what I enjoy and excel at professionally, and what I’m eager to grow in, even if it doesn’t come naturally. Prior to Quartet, I had viewed my career linearly, but after 3 roles in Business Development, BD Ops and now Strategic Partnerships, I’m grateful for each leadership and learning experience!

Charissa

Strategic Partnerships

How do you make yourself accessible to the rest of the team?

I am proud of Quartet's open culture. Our whole team can reach out at anytime; I meet with teams many times a week, and often have 'skip levels' too. We have 'Free Form Food Fights' twice a month - a time where I meet with any and all Quartetian's without an agenda except to be available to answer any questions they have, live or anonymously

David

Chief Executive Officer

How do you collaborate with other teams in the company?

I work cross functionally with teams to help assess the current state of our markets and understand where there are areas for improvement and expansion. By analyzing data & communicating findings to teammates across the organization, we are able to refer more patients to care while increasing the speed to which they arrive at their 1st appointment

Jake

Strategy Analyst, Customer Success

What are Quartet Health Perks + Benefits

Quartet Health Benefits Overview

Quartetians receive unlimited vacation, volunteer opportunities, catered lunches, snacks, team events and outings, mental healthcare coverage of 15 free therapy sessions + unlimited copay reimbursements, medical, dental + vision coverage, generous parental & military leave, employee resource groups, professional development, 401K, stock option grants.

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Diversity manifesto
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Our dental plan includes orthodontia too.
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Our pet insurance policy entitles Quartet Employees to receive 10% discount on premiums.
Wellness Programs
Team workouts
Quartet's team workouts include onsite yoga sessions and bi-weekly group meditations. We also offer subsidies for ClassPass workouts too.
Retirement & Stock Options Benefits
401(K)
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
We reimburse up to 15000 for eligible adoption expenses and 16 weeks of paid leave.
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
We provide free breakfast on Monday, Tuesday, Wednesday, Thursday, Friday. Employees get free lunch on Tuesday, and Thursday.
Game Room
Our game room includes Ping Pong, Video Games, Board Games and a regular games night hosted by our own engineers.
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Quartet hosts lunch and learn meetings once per month, minimum and they cover topics from technology related issues through to mental healthcare and wellbeing.
Cross functional training encouraged
Promote from within

Additional Perks + Benefits

Enhanced mental health benefits. Paid membership to One Medical. Pre-tax health, transit and dependent care flexible spending accounts. True work life balance. Unlimited vacation, competitive family leave policy with return to work assistance. Generous paid military leave. Game nights. Book club. Amazing office, stocked kitchen with kombucha. Regular company and departmental offsites, holiday celebrations, and monthly distinguished speakers.

More Jobs at Quartet Health9 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Internships
Legal
Operations
Internships
new
New York
Developer
new
New York
Developer
new
New York
Internships
new
New York
Operations
new
New York
Internships
new
New York
Data + Analytics
new
New York
Operations
new
New York
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Quartet Health's full profileSee more Quartet Health jobs