Data Visualization Engineer

Keystone; United States; Remote; USD 110,000 - 160,000; Full time

Benefits offered by this job

Vision Insurance

Company Paid Disability Insurance

Supplemental Insurance (Critical Ill./

Job summary

Keystone is seeking a Data Visualization Engineer to build enterprise-grade BI solutions with Power BI and AI-assisted analytics. You will partner with stakeholders to translate complex data into intuitive insights and scalable self-service analytics across the organization in a remote-ready US environment.

The role emphasizes data modeling, DAX development, and advanced visualization techniques to empower business users with actionable dashboards and reports.

Qualifications

• Bachelor's degree in CS/IS or related field.
• 3+ years in BI, Data Analytics, or Data Visualization.
• Hands-on experience with Microsoft Power BI.
• Strong SQL skills; write and optimize complex queries.
• Experience with Databricks or Snowflake.
• Design dimensional data models and enterprise semantic models.
• Optimize Power BI reports for performance and scale.
• Proficient in data quality, validation, and reconciliation.
• Translate ambiguous requirements into analytical solutions.
• Proficiency with Generative AI in analytics workflows.
• Evaluate AI outputs for accuracy and context.
• Strong analytical, problem-solving, and communication skills.
• Able to pass criminal background checks.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, scorecards, and analytics apps for business/executive audiences.
• Translate complex requirements into intuitive analytical experiences.
• Develop scalable semantic models, measures, and calculated columns using DAX.
• Apply dimensional modeling techniques (star schema, fact/dimension tables).
• Create dashboards with strong data visualization, UX, and information hierarchy.
• Optimize BI solutions for performance, scalability, usability.
• Implement drill-through, bookmarks, tooltips, dynamic measures, and advanced capabilities when appropriate.

Skills

Power BI

SQL

DAX

Data visualization

Education

Bachelor's degree in Computer Science/IS or related field

Tools

Power BI

Databricks

Snowflake

Job description

Keystone is one of the largest and fastest-growing insurance brokerages in the country — ranked #26 among U.S. retail brokers and #4 fastest-growing in the Top 50 by Business Insurance. Our platform spans 33+ states, 180+ agency partners, and more than $500 million in revenue — uniting some of the country's most respected independent agencies with the scale, tools, and resources of a national brokerage. Through operational support in finance, HR, marketing, technology, producer development, and M&A, we empower agencies to grow while preserving what makes them who they are — their client relationships and their role in the communities they serve. Guided by our trademarked commitment, "Trust, our most important policy," Keystone is building the insurance solution every family and business can count on. For more information, visit https://mykeystone.com/.

Data Visualization Engineer

Position Summary

We are seeking an experienced Data Visualization Engineer with hands-on experience building enterprise-grade business intelligence solutions and a strong passion for applying AI and Generative AI capabilities to analytics, visualization, dashboards, and reporting. The ideal candidate is highly proficient in Power BI, data modeling, DAX, Power Query, and data visualization, while also being comfortable using AI-assisted capabilities to improve developer productivity, identify insights, enhance user experiences, and enable business users to interact with data more naturally.

This individual reports to the VP of Data & Analytics and will partner closely with business stakeholders, data engineers, analysts, and analytics leaders to transform complex data into intuitive, actionable insights and scalable self-service analytics solutions.

Key Responsibilities

• Design, develop, and maintain sophisticated Power BI dashboards, reports, scorecards, and analytical applications for business and executive audiences.
• Translate complex business requirements into intuitive and actionable analytical experiences.
• Develop scalable semantic models, measures, calculated columns, and business logic using DAX.
• Apply appropriate dimensional modeling techniques, including star schema, fact and dimension design, hierarchies, and reusable semantic models.
• Design dashboards using strong principles of data visualization, UX/UI, information hierarchy, and data storytelling.
• Optimize Power BI solutions for performance, scalability, usability, and maintainability.
• Implement drill-through, bookmarks, tooltips, dynamic measures, field parameters, conditional formatting, and other advanced Power BI capabilities where appropriate.

AI-Enabled Business Intelligence

• Use AI and Generative AI tools to accelerate dashboard and report development, requirements interpretation, DAX development, documentation, testing, and troubleshooting.
• Leverage AI-assisted analytical capabilities to help identify patterns, anomalies, trends, correlations, and business insights within enterprise data.
• Create intuitive analytical experiences that allow users to move beyond static reporting toward conversational and AI-assisted data exploration.
• Understand how to formulate effective prompts and business questions to obtain reliable analytical results from AI-powered tools.
• Explore appropriate use of natural-language querying, AI-generated narratives, automated summaries, anomaly detection, forecasting, and intelligent visualization recommendations.
• Identify opportunities where AI can reduce manual reporting effort and improve analyst and business-user productivity.
• Help establish reusable patterns and best practices for responsible AI adoption within BI and analytics.
• Stay current with advancements in AI-enabled analytics and recommend capabilities that can provide measurable business value.
• Connect Power BI to data from cloud platforms, databases, APIs, data warehouses, lakehouses, Excel/SharePoint sources, and other enterprise applications.
• Collaborate with data engineering teams to define appropriate datasets and data models for analytics consumption.
• Perform data profiling, validation, reconciliation, and troubleshooting to ensure dashboard accuracy.
• Develop efficient incremental refresh and data refresh strategies.
• Understand upstream/downstream data dependencies and assist with root-cause analysis of data-quality issues.

Governance, Security & Deployment

• Implement appropriate Row-Level Security (RLS) and data-access controls.
• Follow organizational standards for workspace management, deployment, naming conventions, documentation, and governance.
• Participate in development, testing, deployment, and production-support processes.
• Promote reusable datasets and governed semantic models rather than creating unnecessary duplicate data models.
• Partner with data governance and security teams to ensure appropriate handling of sensitive or confidential information.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field required
• Minimum of 3 years of experience in Business Intelligence, Data Analytics, or Data Visualization
• Proven hands-on experience developing and maintaining solutions using Microsoft Power BI
• Strong SQL skills, with the ability to write, optimize, and troubleshoot complex queries
• Experience working with modern cloud data platforms such as Databricks, Snowflake, or similar technologies
• Experience designing dimensional data models and enterprise semantic models
• Demonstrated ability to optimize Power BI reports and datasets for performance
• Strong understanding of data quality, validation, and reconciliation
• Experience translating ambiguous business requirements into effective analytical solutions
• Demonstrated proficiency using Generative AI or AI-assisted tools in analytics and BI workflows
• Ability to critically evaluate AI-generated output for accuracy and business context
• Strong analytical, problem-solving, and critical reasoning skills
• Excellent written and verbal communication skills, including the ability to present technical concepts and data-driven insights to non-technical stakeholders
• Ability to pass a criminal background check, as permitted by law

Remote Work Environment

Preference given to candidates in Eastern or Central U.S. time zones

Salary Transparency Statement

In accordance with state and local pay transparency laws, we will provide the applicable salary range upon request to candidates who reside in jurisdictions where such disclosure is required.

• Vision Insurance
• Company Paid Disability Insurance
• Supplemental Insurance including Critical Illness, Accident, Legal, Pet Insurance
• 401(k) with Safe Harbor Match
• Paid Time Off
• Paid Holidays

No Solicitation Notification to Agencies

Please note that Keystone and our Partner Agencies do not accept unsolicited resumes or calls from third-party recruiters or employment agencies. In the absence of a signed Master Service Agreement and approval from HR to submit resumes for a specific requisition, Keystone will not consider or approve payment to any third parties for hires made.