Business Intelligence Developer

CNA Insurance • Scottsdale, AZ

2d • $93,000 - $113,000

About The Position

The Business Intelligence Developer supports Business Intelligence solutions that enable data-informed decision-making for assigned stakeholders. The role partners with internal business partners to translate business needs into dashboards, reports, and insights while ensuring data accuracy, usability, and consistency. It combines technical expertise, analytical thinking, collaboration, and continuous improvement to deliver reliable and actionable reporting solutions.

The position creates Tableau visualizations and reporting, performs exploratory data analysis, traces and validates data across source systems, and designs aggregates and semantic layers for high-performance reporting. It collaborates with data engineers and senior Business Intelligence engineers on data models and pipelines, supports the migration from legacy reporting software to Tableau, and documents and validates reporting assets. The role also guides business users on reporting capabilities and best practices.

Requirements

• Bachelor’s degree in computer science, data science, statistics, mathematics, information systems, or a related field, or an equivalent combination of education and experience.
• At least three years of experience in business intelligence, analytics, or data-reporting roles.
• Proficiency in SQL, including analyzing, aggregating, and troubleshooting data across multiple dialects.
• Knowledge of Tableau for dashboard creation, data storytelling, and embedded visualization.
• Working understanding of data warehouse, data lake, and lakehouse architecture and their support for analytics.
• Experience creating aggregates, semantic layers, and optimized schemas for reporting performance.
• Familiarity with cloud-based data platforms such as AWS, Azure, or GCP and integrating reporting workloads within them.
• Understanding of dashboard performance optimization, data-model best practices, and visualization standards.
• Strong communication and presentation skills to translate data insights into business recommendations.

Responsibilities

• Create compelling and actionable Tableau visualizations and data stories to support business insights.
• Partner with business stakeholders to understand requirements, uncover insights, and answer data questions.
• Perform exploratory data analysis to identify trends, outliers, and opportunities in datasets.
• Use multiple SQL dialects to trace reporting data to source systems, validate data lineage, and ensure the integrity of reported information.
• Design and build aggregates and semantic layers for high-performance reporting.
• Apply dashboard design, performance-tuning, and user-experience best practices in Tableau.
• Collaborate with data engineers and senior Business Intelligence engineers to optimize data models and pipelines for reporting.
• Support migration from legacy reporting software to Tableau, maintaining consistency and data accuracy while modernizing reporting standards.
• Validate data quality, reconcile reporting outputs with source data, and troubleshoot discrepancies.
• Document data flows, metric definitions, and dashboards to support governance and scalability.
• Provide training or guidance to business users on reporting capabilities and best practices.
• Perform additional duties as assigned.

Benefits

• Comprehensive and competitive benefits package intended to support employees’ and family members’ physical, financial, emotional, and social wellbeing.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level