Business Intelligence Analyst / Data Engineer

GEICO is hiring a Business Intelligence Analyst III/IV to design and deliver enterprise business intelligence and visual analytics solutions, primarily with Microsoft Power BI.

Responsibilities

• Design end-to-end BI solutions, including semantic and metric layers, dimensional data models, reports, dashboards, scorecards, and visual analytics products.
• Develop, maintain, and optimize Power BI semantic models, reports, and dashboards using DAX and Power Query, following enterprise reporting standards.
• Apply advanced analytical and statistical techniques to uncover trends, performance drivers, customer behaviors, and opportunities for operational improvement.
• Convert descriptive reporting into diagnostic insight, and introduce predictive approaches when aligned to the business question and available data.
• Partner with stakeholders to frame analytical questions, evaluate findings, and translate complex analysis into clear recommendations.
• Establish and document semantic modeling standards, reusable design patterns, visualization standards, and reporting best practices.
• Support report certification by validating solution quality, consistency, usability, maintainability, performance, documentation, and adherence to standards.
• Publish and support Power BI solutions via Power BI Service using Workspaces, Apps, Deployment Pipelines, and semantic model refresh processes.
• Optimize report and semantic model performance, refresh reliability, storage-mode selection, and end-user experience across BI platforms.
• Assess downstream impacts of design choices involving Import, DirectQuery, composite models, Row-Level Security, refresh strategies, and Power BI capacity.
• Evaluate visualization technologies and select appropriate tooling such as Power BI or Apache Superset based on business need, scalability, maintainability, and user experience.
• Use Snowflake and other approved enterprise data sources to deliver reliable, scalable reporting and analytics.
• Coordinate with data engineering and technology partners to ensure data sources are available, reliable, understandable, and usable for reporting.
• Document report definitions, calculations, assumptions, semantic models, technical designs, and support procedures.
• Lead improvements to reporting processes, including automation of recurring outputs and reduction of manual effort.
• Support report migration and modernization, including converting legacy reporting solutions to modern BI platforms and 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 delivery coordination.
• Provide technical guidance through design, DAX, query, and solution reviews.

Requirements

• Advanced experience designing, developing, deploying, and supporting business intelligence 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 solutions through Workspaces, Apps, Deployment Pipelines, and semantic model refresh processes.
• Advanced SQL knowledge, 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 business intelligence, analytics, reporting, semantic modeling, or data visualization experience.
• Business Intelligence Analyst IV: 7-10 years of relevant business intelligence, analytics, reporting, semantic modeling, or data visualization experience.
• 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.

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

Benefits

• Competitive pay, benefits, and flexibility to support 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 analytical and statistical techniques to move from descriptive reporting toward diagnostic analysis of performance drivers and customer behavior, introducing predictive approaches when appropriate.
• Business Intelligence Analyst III: Works independently with minimal guidance, leads solution components, partners with stakeholders to frame analytical questions, and provides technical guidance to peers.
• Business Intelligence Analyst IV: Leads the design of complex, reusable BI solutions and serves as a technical lead for reporting and analytics initiatives.
• Business Intelligence Analyst IV: Balances delivery with leadership of cross-functional projects, establishes semantic modeling and reporting 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 BI and visualization platforms, including selecting the right tool for the business 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 development workflows.
• Knowledge of Power BI administration and architecture concepts, including 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 Row-Level Security (RLS).
• Experience using AI-assisted development tools such as Cursor, Claude, GitHub Copilot, or similar platforms to generate and refine scripts, troubleshoot solutions, create documentation, support testing, and accelerate analytics delivery.
• Working knowledge of Python, scripting, or related programming concepts, with an 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.

Location: Bethesda, MD (onsite)
Salary: USD 91,225 - 172,200 per year
Experience: 4+ years