Business Intelligence Analyst / Data Engineer

GEICO is hiring a Business Intelligence Analyst III / IV to design, build, and support enterprise business intelligence and visual analytics solutions that help drive data-driven decision-making. This onsite role in Bethesda, MD focuses primarily on Microsoft Power BI, with collaboration across stakeholders and data engineering partners to deliver scalable reporting, semantic models, and analytical recommendations.

What you’ll do

• Design end-to-end BI solutions, including semantic and metric layers, dimensional data models, and visual analytics products such as reports, dashboards, and scorecards.
• Develop, maintain, and optimize Power BI semantic models and reporting assets using DAX, Power Query, and enterprise reporting standards.
• Apply advanced analytical and statistical techniques to identify trends, performance drivers, customer behaviors, and improvement opportunities.
• Turn descriptive reporting into diagnostic insight and introduce predictive approaches when appropriate to the business question and available data.
• Partner with stakeholders to frame analytical questions, evaluate findings, and communicate clear recommendations.
• Establish and promote semantic modeling standards, reusable design patterns, visualization standards, and reporting best practices.
• Support report certification by validating quality, consistency, usability, maintainability, performance, documentation, and adherence to standards.
• Publish and maintain Power BI solutions through Power BI Service, including Workspaces, Apps, Deployment Pipelines, and semantic model refresh processes.
• Optimize report and semantic model performance, refresh reliability, storage-mode selection, and the overall user experience across BI platforms.
• Assess downstream impacts of Import, DirectQuery, composite models, Row-Level Security (RLS), refresh strategies, and available Power BI capacity.
• Evaluate visualization technologies and select between Power BI, Apache Superset, or other tools based on business needs, scalability, maintainability, and user experience.
• Use Snowflake and other approved enterprise sources to deliver reliable, scalable reporting and analytics.
• Coordinate with data engineering and technology partners to ensure source data is available, reliable, understandable, and usable for reporting.
• Document report definitions, calculations, assumptions, semantic models, technical designs, and support procedures.
• Lead improvements to reporting processes by automating recurring outputs and reducing manual effort.
• Support reporting migration and modernization, including converting legacy solutions to modern BI platforms using reusable semantic model architectures.
• Perform testing, validation, deployment, troubleshooting, root cause analysis, performance tuning, and post-implementation support.
• Participate in agile planning, backlog refinement, estimation, status reporting, and cross-functional coordination.
• Provide technical guidance through DAX, query, and solution reviews.

What you bring

• Advanced experience designing, developing, deploying, and supporting BI solutions using Microsoft Power BI or comparable enterprise visualization platforms.
• Strong proficiency with DAX, semantic modeling, dimensional modeling, Power Query, data visualization, and enterprise BI architecture.
• Experience publishing and supporting Power BI via Workspaces, Apps, Deployment Pipelines, and semantic model refresh processes.
• Advanced SQL skills, including writing, troubleshooting, and optimizing complex queries for reporting and analytics.
• Ability to translate complex technical and analytical concepts for both technical and non-technical audiences.
• Strong analytical, quantitative, problem-solving, organizational, communication, and interpersonal skills.
• Ability to work independently and collaboratively in an agile delivery environment.
• Ability to manage multiple priorities and deliver reliable solutions with minimal guidance.
• Business Intelligence Analyst III: 4-7 years of relevant experience in business intelligence, analytics, reporting, semantic modeling, or data visualization.
• Business Intelligence Analyst IV: 7-10 years of relevant experience in business intelligence, analytics, reporting, semantic modeling, or data visualization.
• Experience developing enterprise dashboards, reports, semantic models, and visual analytics solutions.
• Experience partnering with stakeholders to define business questions, gather requirements, assess findings, and deliver actionable reporting solutions.
• Experience working with enterprise data platforms and large-scale datasets.

Tools and technologies

• Microsoft Power BI, Apache Superset, DAX, Power Query, Power BI Service
• Workspaces, Apps, Deployment Pipelines, Snowflake, SQL
• Import, DirectQuery, composite models, Row-Level Security
• Semantic modeling, dimensional modeling, Incremental refresh, Git

GEICO benefits

• Competitive pay, benefits, and flexibility to support your well-being and future.
• Personalized development programs, mentorship, and certification assistance.

Level expectations

• Business Intelligence Analyst III: Designs end-to-end BI solutions including semantic and metric layers, data models, reports, and dashboards.
• Business Intelligence Analyst III: Applies advanced analytics to move from descriptive reporting toward diagnostic analysis of performance drivers and customer behavior, introducing predictive approaches where appropriate.
• Business Intelligence Analyst III: Works independently with minimal guidance, leads solution components, partners with stakeholders, and provides technical guidance to peers.
• Business Intelligence Analyst IV: Leads design of complex reusable BI solutions and serves as a technical lead for reporting and analytics initiatives.
• Business Intelligence Analyst IV: Balances delivery with cross-functional leadership, establishes standards, reviews technical designs, influences BI architecture and tooling decisions, and mentors analysts and developers across levels.

Preferred qualifications

• Microsoft Certified: Power BI Data Analyst Associate (PL-300).
• Microsoft Power BI administration certification or equivalent demonstrated knowledge of Power BI administration concepts.
• Strongly preferred experience with Microsoft Fabric features such as Lakehouses, Warehouses, Dataflows Gen2, Data Pipelines, Notebooks, Real-Time Intelligence, and related capabilities.
• Strongly preferred experience using Snowflake as a primary enterprise data source for reporting and analytics.
• Experience with Apache Superset or other visualization platforms, including selecting the right tool for the use case.
• Experience developing or supporting Apache Airflow workflows.
• Experience with Power BI Project (PBIP) formats and collaborative development of Power BI assets.
• Experience using Git-based version control, including branching, pull requests, code reviews, and collaborative workflows.
• Knowledge of Power BI administration and architecture concepts such as capacity management, storage modes, licensing, workspaces, tenant considerations, governance, and performance optimization.
• Understanding performance and capacity considerations involving DirectQuery, Import mode, composite models, incremental refresh, and RLS.
• Experience using AI-assisted development tools such as Cursor, Claude, GitHub Copilot, or similar tools to generate or refine scripts, troubleshoot solutions, create documentation, support testing, and accelerate delivery.
• Working knowledge of Python, scripting, or related programming concepts, with emphasis on reviewing, validating, and applying AI-generated code.
• Experience supporting report certification, semantic modeling standards, and reporting modernization initiatives.
• Experience with Azure DevOps or a comparable agile work management and delivery platform.
• Property and Casualty insurance, claims analytics, finance analytics, or enterprise reporting experience.

Salary range: USD 91,225 - 172,200 per year. Minimum experience: 4 years. Location: Bethesda, MD (onsite).