About You:

We are seeking a hybrid New York City based Data Analyst to join our rapidly growing organization in a strategic capacity. This is a hybrid role working from both our coworking office space in Williamsburg, Brooklyn and from home. Be part of a compassionate care team dedicated to elevating mental health care. We provide the technology and systems you need to work efficiently and effectively.

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 further leverage claims and other business measure data
• 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 repeating the above steps as needed to ensure continuous improvement
• Ad hoc projects as requested by the manager

Qualifications:

Required:

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

Preferred:

• Experience working with EHR, claims, 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, keen eye for details and innate problem-solving skills
• Understanding of version control processes using GitHub in a shared codebase
• Interest in developing & implementing of advanced analytical models
• Experience working with Google Ads
• Familiarity with Atlassian services (Confluence, JIRA) and/or Agile-based methods

Fair work deserves fair wages. At Valera, we value this role at between 85k-120k with the potential for an annual performance bonus based on experience.