Senior Data Analyst

Summary

Join Valera Health, a leader in tele-mental health, as a Sr. Data Analyst! Work remotely on a dedicated team committed to improving mental health care. You will build metrics, dashboards, and processes using large datasets. Leverage your skills in SQL, AWS tools, and Python to provide insights to leadership. Contribute to continuous improvement through data analysis and process optimization. This role offers a competitive salary and benefits package.

Requirements

• Bachelor in Computer Science, Finance, or a related field
• 3-5 years of Analytics experience at a technology-focused organization, high-growth startup, healthcare company, or similar background
• Hands-on experience working with non-technical end-business users, not limited to crafting requirements, designing dashboards, and communicating technical terms and limitations
• Advanced in SQL (AWS Athena, Presto, PostgreSQL, or other SQL)
• Python experience, specifically relating to external API integrations and simple data processing using AWS Lambda or other serverless cloud platforms
• Proficient in Excel (data manipulation, VLOOKUP, index match)
• Experience building impactful BI dashboards (Quicksight, Tableau, Looker, Excel, etc.)
• Experience working in full end-to-end analytics cycle - data management, cleaning/processing, analysis, visualization

Responsibilities

• Work with large data sets and build metrics to provide meaningful insights to leadership around Clinical Outcomes, Revenue Cycle Management, Finance, Business Development, and Marketing
• Identify key insights to leverage claims and other business measure data further
• Build and maintain internal-facing, self-service dashboards to support day-to-day decisions for department leads
• Develop end-to-end processes around the collection, integration, and reporting of data from new and existing vendors and partnerships
• Partner with department leads to understand and improve current clinical and operational practices and workflows
• Communicate technical information in an accessible executive and partner-facing manner in both verbal presentations to an organization’s leadership to communicate key findings and updates on business process adjustments
• Perform technical tasks such as creating business requirements documents, user training manuals and guides, and requirements traceability
• Conduct in-depth data analysis using SQL, AWS tools, Python, and spreadsheets
• Periodically review the progress of any recommended and implemented changes to see if they’re still on track, and repeat the above steps as needed to ensure continuous improvement
• Ad hoc projects as requested by the manager

Preferred Qualifications

• Experience working with EHR, claims, and marketing data from both tabular and JSON data structures
• Familiarity with clinical coding (ICD-10, CPT), medication (NDC, RxNorm), and health insurance components
• Prior experience or eagerness to learn Amazon Web Service tools (S3, Athena, Lambda, and Cloudwatch, among others)
• Collaborative working style with the ability to work independently in a remote environment
• Interested in exploring and implementing new approaches or tools, and is highly adaptable
• Brings a forward-thinking, self-service, and automation-first mindset to improve reporting capabilities
• Strong organizational skills, a keen eye for detail, and innate problem-solving skills
• Understanding of version control processes using GitHub in a shared codebase
• Interest in developing & implementing advanced analytical models
• Experience working with Google Ads
• Familiarity with Atlassian services (Confluence, JIRA) and/or Agile-based methods

Benefits

• Health, Vision & Dental Insurance
• 401k through the Standard
• Paid Time Off
• Short Term Disability
• Life Insurance
• Office Equipment