About Keystone 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:
Data Visualization & Analytics
- 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.
- Build efficient data transformations using Power Query.
- 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.
Data Integration & Engineering
- 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.
Benefits:
- Competitive Salary
- Health Insurance Plans (PPO, HSA, Copay Options)
- Dental Insurance
- 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.