Valera Health is a tech-enabled mental health company delivering inclusive and tailored care. They are seeking a Data Analyst to support their Analytics and Valera team by providing meaningful insights and improving clinical and operational practices through data analysis.

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.

Qualification

Required

• Bachelor in Computer Science, Finance, or a related field
• 1-3 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

Preferred

• 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