Req #201161

Data Analyst

San Francisco, CA
Apply Today

JOB TITLE:  Data Analyst
JOB LOCATION:  San Francisco

Data Analyst acts as liaison among Professional Services, Customer Success, External Healthcare Payer/Carrier, Customers, Product and Engineering teams.
 

Conducts data architecture analysis and develops data flows aligned to enterprise architecture vision. Understands and considers the business implications of data, and communicates with impacted groups as necessary. Implements appropriate processes for defining data requirements with external and internal partners. Coordinates internally & externally to define, document, and execute the setup, quality, cadence, and method of delivery of data files.

Operationalizes data onboarding and data maintenance related to the functional area of healthcare payer/carrier data or other customer datasets. Understands the custom Castlight data models, products, and internal tools that support the data onboarding and maintenance processes. Completes assigned customer launch projects and its related activities including but not limited to setting up configurations, troubleshooting and fixing data issues and web services integrations, and acting as technical contact with third party vendors, carriers/payers or customers.

Troubleshoots and problem-solves technical/data-related issues identified through requirements gathering, testing, and/or user-reported escalations. Supports post-production implementations, coordinates or implement data fixes.

As a Data Analyst, you are responsible for gathering systems data requirements and drawing out the objectives and scope of systems solutions through systematic analysis of business needs. The Data Analyst should have solid understanding of system development methodologies, familiarity with web services integrations and an excellent grasp of database concepts, data specification, data rules and data quality metrics. You should have strong SQL experience to analyze the issue thoroughly.

You will also be expected to complete tasks and activities related to Customer launches, maintenance efforts, production supports to ensure alignment with projects, departments and overall organizational goals. Customer launches includes coordination and facilitation of technical discussions with vendors and external partners in setting up and configuring Single-Sign-On (SSO), bank integrations, data file exchange specifications and other Castlight-specific system integration with external entities.

The ideal candidate is someone who is excited to develop partner relationships, with a keen focus on operational excellence. Wearing a customer hat is paramount, as is having and developing technical fluency around data requirements. This person will have strong communication skills and the ability to lead projects from beginning to end. The responsibilities of this position may change over time—this role requires flexibility and the ability to adapt to the evolving needs of the organization.

The candidate should be familiar with healthcare, insurance, provider and benefits data; should bring insights and best practices in managing data acquisition and data cleansing routines. Project management, leadership, initiative and technical skills including some software development experience are integral. Candidate will be required to work non-standard hours at times and will partner with all technology disciplines.

RESPONSIBILITIES:

  • Acts as the liaison among Professional Services, Customer Success, External Healthcare Payer/Carrier, Customers, Product and Engineering teams) to thoroughly understand data quality requirements and the impact of high/low data quality and get customers launched on time and troubleshoot any open issues.
  • Serves as an operational point of contact when onboarding new data partners.
  • Performs functional testing on assigned modules/tasks to ensure it meets data specifications.
  • Conducts data architecture analysis and develops data flows aligned to enterprise data architecture vision.
  • Understands and considers the business implications of data, and communicates with impacted groups as necessary.
  • Implements appropriate processes for defining data requirements with external and internal partners.
  • Coordinates internally & externally to define, document, and execute the setup, quality, cadence, and method of delivery of data files.
  • Operationalizes data onboarding and data maintenance related to the functional area of healthcare payer/carrier data or other customer datasets.
  • Understands the custom Castlight data models, products, and internal tools that support the data onboarding and maintenance processes.
  • Completes assigned Customer launch projects and its related activities including but not limited to setting up configurations, troubleshooting and fixing data issues and web services integrations, and acting as technical contact with third party vendors, carriers/payers or customers.
  • Troubleshoots and problem-solves technical/data-related issues identified through requirements gathering, testing, and/or user-reported escalations. Supports post-production implementations, coordinates or implement data fixes.
  • Communicates with internal stakeholders regularly to provide status updates and ensures project timelines and scopes are being managed appropriately.
  • Escalates as appropriate to the Data Management Managers, Engineering and Product Managers, Implementation Managers, Account Executives, and/or Directors on any critical risks or issues that may negatively impact delivery of client requirements and/or client expectations.
  • Enforces and adheres to organizational processes and standards.
  • Strong SQL, Python or Shell Script (or R) experience is a must.

QUALIFICATIONS:

  • 2-4 years of SQL experience.
  • 2-4 years of experience as a Data Analyst or in a similar role.
  • Minimum of 2 years experience with Python, Shell Script or other programming languages
  • 2+ years of creating data specifications from gathering data requirements and working with external and internal stakeholders
  • 2 years of working in Agile Scrum, working with product teams to define user stories and acceptance criteria..
  • Experience with reporting tools like TABLEAU.
  • Experience in secure file transfer protocol (sFTP), web services integrations and JIRA is preferred.
  • Bachelor’s Degree is required. Degree in Mathematics, Computer Science, Information Technology or Data Science preferred, or equivalent job experience.

 

 

Castlight Health provides equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, pregnancy, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, Castlight Health will provide reasonable accommodations for qualified individuals with disabilities.

Castlight Health does not accept unsolicited assistance from recruitment search firms for employment opportunities. All resumes submitted by search firms to any employee at Castlight Health via email, the Internet or in any form and/or method without a signed search agreement on Castlight’s form in place ahead of time will be deemed the sole property of Castlight Health. In such cases, no fee will be paid or payable in the event the candidate is hired by Castlight as a result of the submission.