The Technical Data Analyst is a key member of the Health Analytics team, reporting to the Manager of Health Analytics.
Responsible for managing multiple core data functions in support of the Medical Economics, Financial Planning and Analysis, and Actuarial departments.
Provides technical expertise in the development and maintenance of key models, including underwriting and forecasting.
Prepares reports, supports special projects, and delivers ad-hoc analyses.
Provides clear and accurate insights that inform business strategy and decision-making.
Creates and maintains SQL scripts and stored procedures to support underwriting, pricing, and ad-hoc analyses.
Analyzes structured and unstructured data models to provide actionable insights.
Develops, implements, and maintains automated and scheduled data processes and workflows.
Conducts data reconciliation to ensure accuracy, consistency, and integrity across systems.
Builds, maintains, and enhances Tableau dashboards and models to support business reporting and decision-making.
Analyzes client performance metrics and provides recommendations to drive business outcomes.
Performs data extraction, transformation, and loading (ETL) processes to support analytical and operational needs.
Requirements
Bachelor’s degree in Management Information Systems or related discipline
Skilled in writing SQL queries and interpreting results to drive data-informed decisions.
Experienced across the full data analysis lifecycle, including extraction, pre-processing, cleaning, mining, and visualization to deliver actionable insights.
Solid understanding of ETL concepts with hands-on experience in implementing ETL workflows.
Advanced knowledge of Microsoft Excel for data analysis, reporting, and visualization.
Excellent logical reasoning and organizational skills
Strong ability to capture, organize, and document complex and detailed information.
Comfortable managing multiple tasks and priorities simultaneously.
Proactive, self-driven learner who seeks clarity and asks insightful questions to deepen understanding.
Adept at identifying patterns and extracting actionable insights from complex, multi-dimensional data.
Strong communicator and collaborative team player, able to engage effectively within small teams and across departments.
Excels at connecting diverse concepts and rapidly synthesizing complex information to support effective decision-making.
Fast learner with the ability to adapt quickly to new tools, technologies, and evolving workflows.
Tech Stack
ETL
SQL
Tableau
Benefits
Avalon Healthcare Solutions is an Equal Opportunity Employer