Sr. Data Analyst

Description

Summary: Seeking a Senior Data Analyst with strong SQL expertise to provide analytical support, develop dashboards, and automate reporting in a BI environment. Highlights: 1. Focus on reporting, automation, and leading key analytic projects 2. Utilize BI tools to visualize financial and operational data 3. Collaborate with key business partners to improve profitability Apply Now Company Overview:  InterDent Service Corporion provides comprehensive dental support and administrive services to over 165 dental practices, employing more than 400 dentists across eight stes. These practices, including the Gentle Dental® and Blue Oak Dental® brands, offer high-quality, pient-centered dental care. Additionally, InterDent operes Capitol Dental Care (CDC), a capited, value-based care program in Oregon. CDC partners with coordined care organizions to deliver dental services under the Oregon Health Plan, focusing on preventive care and improving both oral and systemic health for children and low-income pients since 1994.  We are seeking a Senior Da Analyst with strong SQL expertise to join our team. In this role, you will focus on providing analytical support, developing and maintaining marketing, mid funnel, and key financial dashboards while leveraging opportunities to autome reporting in our BI environment.  Role Summary  As a Senior Da Analyst, your initial focus will be on reporting to build a strong understanding of the business. As you progress in the role, you will shift to spending 75% of your time using SQL and Power BI to autome reports, build dashboards and lead other key analytic projects.  Key Responsibilities  Marketing and Mid-Funnel Reporting: Assess, analyze, develop and maintain reporting and dashboards for marketing and mid funnel da to measure and optimize business operions.  Financial & Operional Reporting: Develop, maintain, and enhance marketing, mid funnel and financial dashboards, KPIs, and ad-hoc reports to support decision-making across InterDent.  Process Improvement: Identify opportunities to autome reporting, streamline da processes, and enhance accuracy.  Da Analysis & Insights: Analyze lead generion, revenue, expenses, pient volume, and operional efficiency to identify trends, cost-saving opportunities, and revenue optimizion stregies.  Business Intelligence Tools: Utilize BI tools (Power BI strongly preferred, Looker, or similar) to visualize financial and operional da, ensuring accuracy and clarity for stakeholders.  Da Integrity & Governance: Ensure the accuracy and reliability of marketing da, conversion, pient engagement, financial and operional da by maintaining robust da validion processes and documention to ensure operional continuity.  Collaborion with Key Business Partners : Work closely with key business partners to develop actionable insights th improve profitability and efficiency.  Predictive Analytics & Forecasting: Develop predictive models to support marketing spend, conversion, budgeting, financial forecasting, and business growth stregies.  Ad-hoc Analysis & Special Projects: Support executive leadership with da-driven recommendions on stregic initiives and business expansion opportunities.  Qualificions & Experience  Educion: Bachelor’s degree in Da Science, Business Analytics, Finance, or a reled field.  Experience: 5+ years of experience in business intelligence, financial analysis, or da analytics, preferably in healthcare, dental, or multi-site organizions.  Technical Skills:  Advanced SQL skills for querying and analyzing large dasets.  Proficiency in BI tools , with a strong preference toward Power BI or similar.  Advanced proficiency in Excel (Power Query, Macros, VBA a plus).  Familiarity with marketing tribution, mid funnel metrics, financial modeling, forecasting, and scenario analysis.  Familiarity with building AI agents using AI tools (such as Claude or ChGPT) to assist with writing queries and code.  Analytical & Problem-Solving Skills: Ability to transle complex da into clear insights and actionable recommendions.  Business Analysis: Required business analysis skillset to QA and valide dasets and insights to build sustainable and replicable analysis.  Vendor Management: Have experience working or directing third party vendors to drive development or analysis.  Business Acumen: Strong understanding of healthcare to include marketing, conversion, finance and establishing KPIs.  Communicion & Presention: Ability to convey da-driven insights to both technical and non-technical stakeholders.  Attention to Detail: High level of accuracy and commitment to da integrity.  Compension Range:  $110,000 - $140,000    Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further informion, please review the Know Your Rights notice from the Department of Labor. Apply Now