Senior Data Analyst

Senior Data Analyst
Senior Data Analyst acts as a HealthCare data SME to bridge the gap among Professional Services, Customer Success, External Healthcare Payer/Carrier, Customers, Product and Engineering teams.
Conducts thorough data 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 Senior 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 Senior Data Analyst should have a 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 include 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. Candidates 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, Third Party Partners, 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.

• Performs thorough data testing 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:

• 5-7 years experience as a Data Analyst or in a similar role working directly with clinical healthcare data (e.g. medical claims, pharmacy claims, population-health data, EMR etc.)

• 5-7 years of SQL experience

• Experience in at least one coding language such as Python, SQL, R, Stata, or other data processing and analytics environment

• 2+ years of working in Agile Scrum, working with product teams to define user stories and acceptance criteria.

• 5-7 years of creating data specifications from gathering data requirements and working with external and internal stakeholders

• 2+ years of experience with reporting tools like Tableau

• 2+ years of experience with healthcare outcome performance reporting metrics like HEDIS, Value Based Care/Population Health

• Excellent verbal and written communication skills, direct customer-facing consultative experience

• Self-sufficient, fast learner, takes initiative, and eager to own projects Strong passion for learning and making things better, particularly in healthcare

• Master’s degree preferred in Data Management/Analysis/Science, Engineering, Statistics, Analytics, Mathematics or related field