Data Analyst

Join our team at NCD, a top-tier insurance provider, consisting of a unique and eclectic group of winners, nerds, and gamers who balance a fun, kind, and thoughtful approach to life with an unwavering commitment to unparalleled member satisfaction. Our ecosystem is rooted in our five core values:
Relentless Positivity, Growth Obsessed, Getit Done, Helpful Spirit, and Solution Driven.

We are not just coworkers, but a community, working tirelessly towards 'Spreading the Smile' to our members, agents, and each other. NCD is at the forefront of dental and vision insurance, in partnership with our carrier partners Met Life, VSP, and Zurich. Our continuous growth is a testament to our commitment to delivering outstanding agent and customer satisfaction.

If you are ready to win each day, are eager to grow, and aspire to contribute to an organization that is setting the pace in the industry, then we are looking for you. Together, let’s drive change and take NCD to new heights. Join us and become a vital part of our success story as we continue to transform lives and 'Spread the Smile.

NCD is seeking a Data Analyst to join our growing Data team. This role is ideal for someone with strong SQL fundamentals, a sharp analytical mindset, and the desire to grow into a highly capable individual contributor across analytics, data modeling, BI reporting, and cross‑functional problem solving. You will help turn business questions into trusted data assets, dashboards, reporting workflows, and actionable insights.

You will work hands‑on in Big Query, dbt, Fivetran‑fed datasets, Omni and/or Power BI, and increasingly with Claude and other AI tools to accelerate SQL development, documentation, QA, and stakeholder support. This is not a passive reporting role. We are looking for someone who wants to learn quickly, communicate clearly, solve real business problems, and help the company make better decisions with better data.

• Build and maintain trusted reporting.
• Create, maintain, and improve dashboards, reports, and recurring data outputs in Omni and/or Power BI for teams across Operations, Sales, Finance, Product, Member Experience, and leadership.
• Write and validate SQL.
• Use SQL in Big Query to analyze data, investigate business questions, troubleshoot discrepancies, and create reliable datasets for reporting and decision‑making.
• Build, test, document, and maintain dbt models under the guidance of more senior team members, with a focus on accuracy, clarity, reusability, and business trust.
• Improve data quality and documentation.
• Help define metrics, document data sources, identify inconsistencies, perform QA, and improve confidence in dashboards, models, and recurring reports.
• Work with Fivetran‑fed data.
• Understand how source data flows into the warehouse, help monitor data freshness and completeness, and escalate or investigate pipeline‑related issues when needed.
• Partner with business teams.
• Work cross‑functionally to understand business needs, clarify requirements, translate questions into data tasks, and communicate findings in a way non‑technical stakeholders can use.
• Support operational analytics.
• Assist with analysis involving billing, eligibility, carrier files, commissions, agent/member data, CRM data, cancellations, payments, and other operational datasets.
• Use AI tools responsibly.
• Use Claude and other AI tools to accelerate SQL drafting, documentation, QA checklists, data exploration, and workflow automation while applying strong judgment, validation, and care with sensitive information.
• Identify process improvements.
• Look for opportunities to reduce manual work, improve recurring reporting, standardize definitions, and make data easier for business teams to use.
• Other duties as assigned.

• Approximately 1–3 years of experience in data analysis, business intelligence, operations analytics, data operations, or a related field; equivalent demonstrated capability will also be considered.
• Strong SQL fundamentals, including joins, aggregations, CTEs, window functions, and data validation techniques.
• Comfort working with business stakeholders to clarify…