Senior 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 Sr. Data Analyst to join our Data team as a strong mid-level individual contributor. This role is built for someone who can own ambiguous business problems, partner directly with cross‑functional stakeholders, and turn raw or messy data into trusted models, dashboards, metrics, and insights. You will work across Big Query, Fivetran, dbt, Omni and/or Power BI, using strong SQL, business judgment, and data modeling skills to create scalable analytics solutions.

You will also use Claude and other AI tools to increase your leverage across SQL development, documentation, QA, analysis, and stakeholder enablement. This role is not a people‑management role. It is a hands‑on IC role for someone who wants to build, improve, troubleshoot, explain, and own the data assets that help NCD operate and grow.

• Own cross‑functional analytics projects.
• Partner with Operations, Sales, Finance, Product, Member Experience, leadership, and other teams to understand business problems, define requirements, analyze data, and deliver durable solutions.
• Build trusted data models.
• Design, build, test, document, and maintain dbt models that transform raw source data into reliable, reusable, analytics‑ready datasets.
• Work deeply in Big Query.
• Use advanced SQL in Big Query to investigate complex questions, optimise queries, validate data, create reusable logic, and support production‑grade reporting.
• Support and improve the BI layer.
• Build and maintain dashboards, reports, semantic definitions, and self‑service analytics experiences in Omni and/or Power BI.
• Improve metric consistency.
• Help define business metrics, reconcile conflicting numbers, document assumptions, and ensure stakeholders understand what data means and how to use it.
• Monitor and troubleshoot data quality.
• Work with Fivetran‑fed data and downstream dbt/BI assets to identify pipeline issues, data freshness problems, schema changes, source system inconsistencies, and reporting defects.
• Translate business ambiguity into data solutions.
• Lead stakeholder discovery, ask sharp questions, clarify trade‑offs, and convert business needs into practical data requirements and deliverables.
• Deliver insights and reporting that help teams improve operational performance, sales effectiveness, member experience, financial visibility, and leadership decision‑making.
• Use AI tools thoughtfully and safely.
• Use Claude and other AI tools to accelerate analysis, SQL iteration, documentation, test generation, workflow automation, and stakeholder support while validating outputs and protecting data quality.
• Raise the bar for the Data team.
• Contribute to naming conventions, documentation standards, QA practices, metric governance, dbt structure, BI usability, and overall trust in NCD’s data ecosystem.
• Other duties as assigned.

• Approximately 3–5 years of experience in analytics, business intelligence, data analysis, data engineering‑adjacent work, operations analytics, or a related field; equivalent demonstrated capability will also be…