Pricing and Market Intelligence Analyst

Description

Job Summary: We are seeking a data analysis expert to provide comprehensive competitive insights in the insurance sector, participating in strategy definition and decision-making, with experience in pricing and leadership of innovative projects. Key Responsibilities: 1. Design and prepare benchmarks of competitor pricing and offerings 2. End-to-end management of acquisition and analysis of market research studies 3. Lead projects with a high degree of innovation/technology MISSION Provide a comprehensive, continuous, and up-to-date view of Santalucía’s entire competitive environment—primarily regarding price positioning—and complementarily across other dimensions (trends, market, socioeconomic context, etc.), enabling the Department to access sufficient information for strategy definition and decision-making. JOB RESPONSIBILITIES Design and prepare benchmarks of competitor pricing, rates, discounts, products, and offerings within the insurance sector. Collaborate and participate in the development and continuous improvement of technical and commercial pricing. Monitor and prepare reports related to competitive positioning, systematic discounts, and campaigns. End-to-end management of acquisition and analysis of market research studies related to pricing. REQUIREMENTS **Required Experience:** Experience analyzing information related to insurance product pricing. Knowledge of commercial pricing, profitability calculation, etc. Experience leading projects with a high degree of innovation/technology. **Power BI Expert:** Advanced Reporting, Visuals, and Parameterization Expert-level Power BI proficiency, including design of optimized semantic models, creation of interactive reports with advanced visuals, use of dynamic parameters, and analytical navigation and UX techniques. Ability to build comprehensive analytical tools addressing diverse business area needs. Advanced DAX and Delegation Criteria between Data Engine and BI Layer Advanced DAX expertise for building complex and dynamic measures. Technical judgment to decide which logic to pre-calculate in the data engine versus which to resolve dynamically in DAX, balancing performance and analytical flexibility. ETL/ELT Development with PySpark on Databricks Experience designing and implementing data pipelines using PySpark and Python in Databricks environments. Ability to implement complex calculations and transformations via multi\-table joins, conditional aggregations, and chained business logic—ensuring data quality control at every process stage and building generic, parameterized, and scalable flows. Dimensional Modeling and Analytical Data Architecture Design Ability to design and maintain data models with fact and dimension tables, ensuring referential integrity, cross-source consistency, and standardized naming conventions. Experience with incremental loading strategies, schema management, and temporal partitioning to optimize query performance and reporting tool consumption. Advanced SQL and Complex Data Extraction Generation Mastery of analytical SQL applied to data extraction generation, conditional aggregations, and complex business logic. Deep understanding of the structure and composition of various tables across the data ecosystem, enabling resolution of ad\-hoc queries and autonomous, efficient derivation of datasets. Insurance Sector Knowledge and Pricing Experience Functional knowledge of the insurance business and experience in pricing analysis, competitive positioning, and exploitation of multi-source market data. Ability to translate technical and commercial requirements into actionable data and reporting solutions. **Required Qualifications:** University Degree Specialized training in database management, advanced analytics, and data visualization and exploitation tools (e.g., Excel, SAS, Power BI...). Advanced knowledge of the insurance market and its products. **Desirable Experience and Knowledge:** Specialized training in market techniques and studies, project management, and/or product design and launch. **Study Types:** Qualitative (in-depth interviews, focus groups, etc.) and quantitative (concept testing, product testing, customer testing, conjoint analysis, etc.). Knowledge of agile methodologies, design thinking, etc. **Skills:** Dynamic, open-minded individual. Accustomed to decision-making. Quality- and accuracy-oriented; organized and planned. Proactive and autonomous. Strong interpersonal and teamwork skills, collaborating across departments on cross-functional tasks. Strong communication skills to appropriately explain data/information. Analytical capability, with rigor to review large volumes of data and detect inconsistencies. Synthesis ability to transform complex information into clear, relevant conclusions. Critical thinking to question data and develop conclusions based upon it. Results- and objective-oriented, maintaining focus on internal and regulatory deadlines. Autonomy, proactivity, initiative, and solution-oriented mindset. Planned, structured, organized, and methodical. Change management, versatility, and continuous adaptation. At SANTA LUCIA S.A., Cª SEGUROS, we work to ensure real and effective equal opportunities, promoting professional development and workforce diversity, aligned with our commitment to UN Agenda 2030 Sustainable Development Goal 5 (Gender Equality). **Province:** Madrid **Company:** SANTALUCIA SEGUROS **Date:** 8 Apr 2026