Develop and maintain Power BI dashboards, reports, DAX measures, KPIs, and dimensional data models for insurance stakeholders. Write complex SQL for data extraction, transformation, reconciliation, and analysis. Investigate data-quality issues, validate reporting accuracy, optimize performance, and translate insurance business requirements into actionable analytics solutions. Collaborate with engineering, business, and analytics teams across multiple data sources.
Power BI
- Strong hands-on experience with Power BI Desktop and Power BI Service.
- Strong knowledge of DAX, Power Query, data modeling, relationships, drill-through, bookmarks, filters, and visualization best practices.
- Experience building complex dashboards and executive or business reporting solutions.
- Understanding of Power BI performance optimization and data model design.
- Strong SQL skills, including joins, CTEs, subqueries, window functions, aggregations, and complex transformations.
- Experience analyzing and reconciling data across multiple tables and data sources.
- Good understanding of relational databases, dimensional modeling, and data warehousing concepts.
- Ability to investigate data-quality issues and independently perform root-cause analysis.
- Good understanding of insurance data and business processes, preferably within Property & Casualty insurance.
- Familiarity with policy, coverage, exposure, premium, claims, losses, reserves, limits, deductibles, brokers or agents, and underwriting.
- Ability to understand insurance KPIs and translate business questions into analytical reports and dashboards.
- Experience working with policy, claims, underwriting, or premium-related datasets is preferred.
- Design, develop, and maintain interactive Power BI dashboards and reports for insurance business users.
- Develop efficient DAX measures, calculated columns, KPIs, and data models to support analytical and reporting requirements.
- Write and optimize complex SQL queries for data extraction, transformation, reconciliation, and analysis.
- Analyze large datasets to identify business trends, data issues, and actionable insights.
- Work with business stakeholders to understand requirements and translate them into reporting and analytical solutions.
- Perform data validation, reconciliation, and root-cause analysis to ensure reporting accuracy and consistency.
- Develop and maintain dimensional data models supporting reporting and analytics use cases.
- Collaborate with data engineering, business, and analytics teams to integrate data from multiple source systems.
- Apply insurance domain knowledge to interpret business data and develop meaningful KPIs and reporting solutions.
- Support report performance optimization, production issues, enhancements, and ongoing reporting needs.
- 4-6 years of overall experience in business intelligence, reporting, or data analytics.
- Hands-on experience with Power BI and SQL in enterprise reporting environments.
- Prior experience with an insurance carrier, broker, MGA, or insurance analytics organization is highly desirable.
- Exposure to Azure, Snowflake, Databricks, or SQL Server would be an advantage.
- Strong analytical thinking, problem-solving, and communication skills.
- Ability to interact with business stakeholders and independently convert requirements into technical solutions.
Similar Jobs
.png)
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Leads and develops an enterprise sales team responsible for strategic seller acquisition, pipeline generation, complex deal execution, forecasting, and revenue outcomes. Builds repeatable sales motions, coaches Enterprise Account Executives, manages territory and account strategies, leads high-value negotiations, and partners cross-functionally with product, legal, finance, marketing, implementation, and customer success teams. Uses market insight to influence product, pricing, partnerships, and go-to-market strategy.
Top Skills:
AIAPIsAutomationDataFintechIntegrationsPaymentsSaaS
Artificial Intelligence • Information Technology • Machine Learning • Natural Language Processing • Productivity • Software • Generative AI
Build and operate high-throughput backend services for AI agent orchestration, calendar systems, real-time infrastructure, APIs, and data pipelines. Design scalable platform services, infrastructure as code, and highly available production systems using Go, PostgreSQL, Kubernetes, and cloud platforms. Collaborate with AI, product, and frontend teams to deliver AI-powered features, contribute to reliability and testing practices, and mentor junior engineers.
Top Skills:
AWSAzureCi/CdClaude CodeCursorGCPGithub CopilotGoInfrastructure As CodeKubernetesPostgres
.png){kind=logo}
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Leads the vision, strategy, roadmap, and lifecycle of NBCUniversal’s mobile product experience. Partners with design, engineering, analytics, production, and business teams to prioritize features, improve engagement, retention, onboarding, monetization, and product health. Drives research-informed decisions, launch readiness, stakeholder alignment, and continuous improvement while helping build the mobile product organization.
Top Skills:
A/B TestingConsole PlatformsCross-Platform Product DevelopmentMobile PlatformsPc PlatformsProduct Analytics
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
