Senior Analytics Engineer building cloud data pipelines, analytical models, and BI dashboards for Valtech, an experience innovation company. Translating client business questions into reliable, governed data solutions.
About the role
- Power BI developer building insurance dashboards and SQL reporting solutions. Translating insurance data into KPIs and actionable business insights.
Responsibilities
- 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.
Requirements
- 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 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.
- Strong analytical thinking, problem-solving, and communication skills.
- Ability to interact with business stakeholders and independently convert requirements into technical solutions.
- Bachelor's Degree.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Intermediate ETL Developer migrating customer data into Pandell - ESG’s energy software. Writing conversion scripts, adapting ETL frameworks, and leading technical implementation projects.
Analytics Engineer transforming data for Lightspeed’s commerce and financial services platform. Building pipelines, models, quality checks, and Looker reporting for cross - functional teams.
Senior Analytics Engineer building trusted financial data products for Kraken, a global crypto platform. Automating reconciliations, pipelines, dashboards and finance close processes.
Marketing Data Analytics Engineer building Salesforce, Marketo, and warehouse pipelines for PointClickCare’s healthcare analytics platform. Automating campaign reporting and supporting marketing - sourced pipeline insights.
Senior Analytics Engineer designing Lime’s finance - grade data warehouse and semantic layer. Ensuring governed, audit - ready reporting for the global shared micromobility business.
Analytics Engineer building Snowflake and dbt data platforms for Tucows’ Internet businesses. Applying AI, SQL, Looker, and Python to drive data - informed decisions.
Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.
Senior Analytics Engineer shaping Fleetio’s fleet - management data platform. Building dbt models, semantic layers, dashboards, and AI - enabled analytics solutions.