Job Closed
This listing is no longer active.
Transforming behavioral health through technology with a human touch
Senior Data Analyst
Location
United States
Posted
57 days ago
Salary
$114K - $157K / year
Seniority
Senior
Job Description
Senior Data Analyst
Lyra Health
• Collaborate closely with Lyra’s Technology, Operations, Product, and other associated teams to provide critical business insights that enable strategic planning and improve operational processes, resulting in high-quality care for clients. • Become an expert in the diverse data sources at Lyra, working with Data Engineers, Data Scientists, and fellow Data Analysts to build and enhance Lyra’s data models. • Partner with Data Engineering to build a scalable and flexible analytics metrics database using the standard development process involving Snowflake, dbt, Github, and peer reviews. • Conduct quantitative analyses to identify meaningful trends in care experience and utilization that uncover new opportunity areas and drive stakeholder decision-making. • Provide internal stakeholders with ongoing visibility into key metrics by creating and maintaining Tableau dashboards and reports. • Complete time-sensitive ad hoc data requests that inform high-priority business objectives while ensuring high data quality and reporting accuracy. • Using domain knowledge and technical expertise, guide and advise stakeholders on reporting logic, metric development, and data limitations/caveats to ensure rigorous methodology and accuracy. • Build automation and self service analytics solutions for stakeholders, leveraging data tools and resources such as python, BI tools and automation platforms.
Job Requirements
- 5+ years of data analysis in an industry setting with a preference for individuals who have experience in product / operations analytics and have partnered with engineering, operations and product teams in prior roles.
- Bachelor’s Degree, preferably in Engineering, Math, Statistics, Analytics/Data Science or other related field.
- Strong SQL proficiency. Experience writing complex queries with multiple schemas and tables. Preference for candidates who have experience creating views.
- Experience in working with a cloud data warehouse and modeling analytic views with dbt.
- Strong experience with defining metrics and developing dashboards and visualizations that provide clear, actionable insights to stakeholders.
- Experience with developing self-serve automated analytic solutions that involve scripting, data cleansing, data extraction pipelines, and / or process automation.
- Excellent at cross-functional collaboration with non-technical business stakeholders, especially in translating technical concepts, scoping reporting requests, and working together to create high-quality deliverables.
- Demonstrated experience in project ownership; capable of independently managing and meeting project milestones.
Benefits
- Comprehensive healthcare coverage (including medical, dental, vision, FSA/HSA, life and disability insurances)
- Lyra for Lyrians; coaching and therapy services
- Equity in the company through discretionary restricted stock units
- Competitive time off with pay policies including vacation, sick days, and company holidays
- Paid parental leave
- 401K retirement benefits
- Monthly tech allowance
- Well-being perks and activities, surprise swag, regular community celebration…and more!
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
Financial & Data Analyst
PavagoPavago specializes in connecting businesses with top-tier offshore talent in operations, sales, and marketing, offering a comprehensive recruitment solution designed to reduce cost
Job Title: Financial Analyst / Data Analyst Position Type: Full-Time, Remote Working Hours: U.S. client business hours (with flexibility for reporting deadlines and project cycles) About the Role: Our client is seeking a Financial Analyst / Data Analyst to build models, analyze performance data, and deliver insights that guide strategy and decision-making. This role requires strong analytical skills, financial acumen, and proficiency with modern data tools. The Analyst serves as a bridge between raw numbers and executive decisions, ensuring reporting is accurate, timely, and actionable. Responsibilities: Financial Modeling: - Build and maintain 3-statement models (P&L, balance sheet, cash flow). - Create scenario and sensitivity analyses to evaluate risks and opportunities. - Model ROI, IRR, break-even, and valuation scenarios for projects or investments. Data Analysis: - Query SQL databases and work with large datasets. - Clean and transform data using Python, R, or Excel advanced functions. - Conduct variance analyses to compare actuals vs. budgets/forecasts. Reporting & Dashboards: - Prepare monthly management reporting packages and board decks. - Build KPI dashboards using Tableau, Power BI, or Looker. - Ensure consistent reporting definitions across finance and operations. Forecasting & Budget Support: - Collaborate with FP&A teams to refine budgets and forecasts. - Incorporate real-time business performance into rolling forecasts. Data Quality & Governance: - Validate data sources for accuracy and consistency. - Document methodologies for transparency and repeatability. Collaboration: - Partner with finance, sales, operations, and leadership to align metrics with goals. - Translate data into clear, actionable insights for non-technical stakeholders. What Makes You a Perfect Fit: - Analytical thinker who can turn complex data into simple insights. - Detail-oriented, with high standards for accuracy. - Strong communicator — equally comfortable with spreadsheets and executive presentations. - Proactive in identifying trends, risks, and improvement opportunities. Required Experience & Skills (Minimum): - 2+ years in financial analysis, FP&A, or data analytics. - Advanced Excel/Google Sheets (pivot tables, INDEX/MATCH, macros). - Proficiency in SQL for querying and joining datasets. - Experience preparing variance analyses and management reports. Ideal Experience & Skills: - Python or R for advanced analytics and data modeling. - Experience with BI tools (Tableau, Power BI, Looker). - Industry background in SaaS, finance, healthcare, or professional services. - Familiarity with ERP systems (NetSuite, SAP, Oracle) for data extraction. What Does a Typical Day Look Like? A Financial Analyst / Data Analyst’s day revolves around turning raw financial and operational data into meaningful insights. You will: - Pull and clean data from ERP or SQL sources to prepare daily/weekly reports. - Update financial models with the latest actuals and run scenario analyses. - Prepare variance analyses to explain deviations from budget or forecast. - Build dashboards in BI tools to give leadership real-time visibility into KPIs. - Collaborate with stakeholders, presenting findings in clear, actionable terms. - Document assumptions and methodologies so models and analyses are transparent and repeatable. In essence: you ensure decision-makers always have accurate, data-driven insights to guide strategy. Key Metrics for Success (KPIs): - Accuracy of forecasts and financial models (variance within ±5–10%). - Timeliness of monthly/quarterly reporting. - Reliability and clarity of dashboards delivered to stakeholders. - Positive feedback from leadership on insights and recommendations. - Reduced errors and improved data quality across reports. Interview Process: - Initial Phone Screen - Video Interview with Pavago Recruiter - Practical Task (e.g., build a simple financial model or create a sample dashboard from dataset) - Client Interview with Finance/Operations Leadership - Offer & Background Verification
Financial & Data Analyst
PavagoPavago specializes in connecting businesses with top-tier offshore talent in operations, sales, and marketing, offering a comprehensive recruitment solution designed to reduce cost
Job Title: Financial Analyst / Data Analyst Position Type: Full-Time, Remote Working Hours: U.S. client business hours (with flexibility for reporting deadlines and project cycles) About the Role: Our client is seeking a Financial Analyst / Data Analyst to build models, analyze performance data, and deliver insights that guide strategy and decision-making. This role requires strong analytical skills, financial acumen, and proficiency with modern data tools. The Analyst serves as a bridge between raw numbers and executive decisions, ensuring reporting is accurate, timely, and actionable. Responsibilities: Financial Modeling: - Build and maintain 3-statement models (P&L, balance sheet, cash flow). - Create scenario and sensitivity analyses to evaluate risks and opportunities. - Model ROI, IRR, break-even, and valuation scenarios for projects or investments. Data Analysis: - Query SQL databases and work with large datasets. - Clean and transform data using Python, R, or Excel advanced functions. - Conduct variance analyses to compare actuals vs. budgets/forecasts. Reporting & Dashboards: - Prepare monthly management reporting packages and board decks. - Build KPI dashboards using Tableau, Power BI, or Looker. - Ensure consistent reporting definitions across finance and operations. Forecasting & Budget Support: - Collaborate with FP&A teams to refine budgets and forecasts. - Incorporate real-time business performance into rolling forecasts. Data Quality & Governance: - Validate data sources for accuracy and consistency. - Document methodologies for transparency and repeatability. Collaboration: - Partner with finance, sales, operations, and leadership to align metrics with goals. - Translate data into clear, actionable insights for non-technical stakeholders. What Makes You a Perfect Fit: - Analytical thinker who can turn complex data into simple insights. - Detail-oriented, with high standards for accuracy. - Strong communicator — equally comfortable with spreadsheets and executive presentations. - Proactive in identifying trends, risks, and improvement opportunities. Required Experience & Skills (Minimum): - 2+ years in financial analysis, FP&A, or data analytics. - Advanced Excel/Google Sheets (pivot tables, INDEX/MATCH, macros). - Proficiency in SQL for querying and joining datasets. - Experience preparing variance analyses and management reports. Ideal Experience & Skills: - Python or R for advanced analytics and data modeling. - Experience with BI tools (Tableau, Power BI, Looker). - Industry background in SaaS, finance, healthcare, or professional services. - Familiarity with ERP systems (NetSuite, SAP, Oracle) for data extraction. What Does a Typical Day Look Like? A Financial Analyst / Data Analyst’s day revolves around turning raw financial and operational data into meaningful insights. You will: - Pull and clean data from ERP or SQL sources to prepare daily/weekly reports. - Update financial models with the latest actuals and run scenario analyses. - Prepare variance analyses to explain deviations from budget or forecast. - Build dashboards in BI tools to give leadership real-time visibility into KPIs. - Collaborate with stakeholders, presenting findings in clear, actionable terms. - Document assumptions and methodologies so models and analyses are transparent and repeatable. In essence: you ensure decision-makers always have accurate, data-driven insights to guide strategy. Key Metrics for Success (KPIs): - Accuracy of forecasts and financial models (variance within ±5–10%). - Timeliness of monthly/quarterly reporting. - Reliability and clarity of dashboards delivered to stakeholders. - Positive feedback from leadership on insights and recommendations. - Reduced errors and improved data quality across reports. Interview Process: - Initial Phone Screen - Video Interview with Pavago Recruiter - Practical Task (e.g., build a simple financial model or create a sample dashboard from dataset) - Client Interview with Finance/Operations Leadership - Offer & Background Verification
Financial & Data Analyst
PavagoPavago specializes in connecting businesses with top-tier offshore talent in operations, sales, and marketing, offering a comprehensive recruitment solution designed to reduce cost
Job Title: Financial Analyst / Data Analyst Position Type: Full-Time, Remote Working Hours: U.S. client business hours (with flexibility for reporting deadlines and project cycles) About the Role: Our client is seeking a Financial Analyst / Data Analyst to build models, analyze performance data, and deliver insights that guide strategy and decision-making. This role requires strong analytical skills, financial acumen, and proficiency with modern data tools. The Analyst serves as a bridge between raw numbers and executive decisions, ensuring reporting is accurate, timely, and actionable. Responsibilities: Financial Modeling: - Build and maintain 3-statement models (P&L, balance sheet, cash flow). - Create scenario and sensitivity analyses to evaluate risks and opportunities. - Model ROI, IRR, break-even, and valuation scenarios for projects or investments. Data Analysis: - Query SQL databases and work with large datasets. - Clean and transform data using Python, R, or Excel advanced functions. - Conduct variance analyses to compare actuals vs. budgets/forecasts. Reporting & Dashboards: - Prepare monthly management reporting packages and board decks. - Build KPI dashboards using Tableau, Power BI, or Looker. - Ensure consistent reporting definitions across finance and operations. Forecasting & Budget Support: - Collaborate with FP&A teams to refine budgets and forecasts. - Incorporate real-time business performance into rolling forecasts. Data Quality & Governance: - Validate data sources for accuracy and consistency. - Document methodologies for transparency and repeatability. Collaboration: - Partner with finance, sales, operations, and leadership to align metrics with goals. - Translate data into clear, actionable insights for non-technical stakeholders. What Makes You a Perfect Fit: - Analytical thinker who can turn complex data into simple insights. - Detail-oriented, with high standards for accuracy. - Strong communicator — equally comfortable with spreadsheets and executive presentations. - Proactive in identifying trends, risks, and improvement opportunities. Required Experience & Skills (Minimum): - 2+ years in financial analysis, FP&A, or data analytics. - Advanced Excel/Google Sheets (pivot tables, INDEX/MATCH, macros). - Proficiency in SQL for querying and joining datasets. - Experience preparing variance analyses and management reports. Ideal Experience & Skills: - Python or R for advanced analytics and data modeling. - Experience with BI tools (Tableau, Power BI, Looker). - Industry background in SaaS, finance, healthcare, or professional services. - Familiarity with ERP systems (NetSuite, SAP, Oracle) for data extraction. What Does a Typical Day Look Like? A Financial Analyst / Data Analyst’s day revolves around turning raw financial and operational data into meaningful insights. You will: - Pull and clean data from ERP or SQL sources to prepare daily/weekly reports. - Update financial models with the latest actuals and run scenario analyses. - Prepare variance analyses to explain deviations from budget or forecast. - Build dashboards in BI tools to give leadership real-time visibility into KPIs. - Collaborate with stakeholders, presenting findings in clear, actionable terms. - Document assumptions and methodologies so models and analyses are transparent and repeatable. In essence: you ensure decision-makers always have accurate, data-driven insights to guide strategy. Key Metrics for Success (KPIs): - Accuracy of forecasts and financial models (variance within ±5–10%). - Timeliness of monthly/quarterly reporting. - Reliability and clarity of dashboards delivered to stakeholders. - Positive feedback from leadership on insights and recommendations. - Reduced errors and improved data quality across reports. Interview Process: - Initial Phone Screen - Video Interview with Pavago Recruiter - Practical Task (e.g., build a simple financial model or create a sample dashboard from dataset) - Client Interview with Finance/Operations Leadership - Offer & Background Verification
Financial & Data Analyst
PavagoPavago specializes in connecting businesses with top-tier offshore talent in operations, sales, and marketing, offering a comprehensive recruitment solution designed to reduce cost
Job Title: Financial Analyst / Data Analyst Position Type: Full-Time, Remote Working Hours: U.S. client business hours (with flexibility for reporting deadlines and project cycles) About the Role: Our client is seeking a Financial Analyst / Data Analyst to build models, analyze performance data, and deliver insights that guide strategy and decision-making. This role requires strong analytical skills, financial acumen, and proficiency with modern data tools. The Analyst serves as a bridge between raw numbers and executive decisions, ensuring reporting is accurate, timely, and actionable. Responsibilities: Financial Modeling: - Build and maintain 3-statement models (P&L, balance sheet, cash flow). - Create scenario and sensitivity analyses to evaluate risks and opportunities. - Model ROI, IRR, break-even, and valuation scenarios for projects or investments. Data Analysis: - Query SQL databases and work with large datasets. - Clean and transform data using Python, R, or Excel advanced functions. - Conduct variance analyses to compare actuals vs. budgets/forecasts. Reporting & Dashboards: - Prepare monthly management reporting packages and board decks. - Build KPI dashboards using Tableau, Power BI, or Looker. - Ensure consistent reporting definitions across finance and operations. Forecasting & Budget Support: - Collaborate with FP&A teams to refine budgets and forecasts. - Incorporate real-time business performance into rolling forecasts. Data Quality & Governance: - Validate data sources for accuracy and consistency. - Document methodologies for transparency and repeatability. Collaboration: - Partner with finance, sales, operations, and leadership to align metrics with goals. - Translate data into clear, actionable insights for non-technical stakeholders. What Makes You a Perfect Fit: - Analytical thinker who can turn complex data into simple insights. - Detail-oriented, with high standards for accuracy. - Strong communicator — equally comfortable with spreadsheets and executive presentations. - Proactive in identifying trends, risks, and improvement opportunities. Required Experience & Skills (Minimum): - 2+ years in financial analysis, FP&A, or data analytics. - Advanced Excel/Google Sheets (pivot tables, INDEX/MATCH, macros). - Proficiency in SQL for querying and joining datasets. - Experience preparing variance analyses and management reports. Ideal Experience & Skills: - Python or R for advanced analytics and data modeling. - Experience with BI tools (Tableau, Power BI, Looker). - Industry background in SaaS, finance, healthcare, or professional services. - Familiarity with ERP systems (NetSuite, SAP, Oracle) for data extraction. What Does a Typical Day Look Like? A Financial Analyst / Data Analyst’s day revolves around turning raw financial and operational data into meaningful insights. You will: - Pull and clean data from ERP or SQL sources to prepare daily/weekly reports. - Update financial models with the latest actuals and run scenario analyses. - Prepare variance analyses to explain deviations from budget or forecast. - Build dashboards in BI tools to give leadership real-time visibility into KPIs. - Collaborate with stakeholders, presenting findings in clear, actionable terms. - Document assumptions and methodologies so models and analyses are transparent and repeatable. In essence: you ensure decision-makers always have accurate, data-driven insights to guide strategy. Key Metrics for Success (KPIs): - Accuracy of forecasts and financial models (variance within ±5–10%). - Timeliness of monthly/quarterly reporting. - Reliability and clarity of dashboards delivered to stakeholders. - Positive feedback from leadership on insights and recommendations. - Reduced errors and improved data quality across reports. Interview Process: - Initial Phone Screen - Video Interview with Pavago Recruiter - Practical Task (e.g., build a simple financial model or create a sample dashboard from dataset) - Client Interview with Finance/Operations Leadership - Offer & Background Verification
