MI Analyst

Overview Lockton's continued investment in Data and MI fuels the appetite for data professionals, and these roles are highly valued by senior management. We are looking to recruit a data individual to join the team. Culture & Values

• Client first
• Results and impact driven
• Self-motivated
• Continuous improvement
Role Responsibilities
• Partner with business stakeholders to gather, challenge, and translate reporting and analytics requirements.
• Extract, transform, analyse, and interpret data from multiple sources to support business decision-making.
• Design, develop, and maintain Power BI reports and semantic models.
• Write efficient, scalable SQL queries to support reporting.
• Deliver insights and recommendations that help stakeholders understand trends, performance, risks, and opportunities.
• Collaborate with technical and non-technical teams to promote a data-driven culture across the organisation.
Qualifications We are seeking a proactive and analytical individual who enjoys solving complex data challenges and turning information into valuable business insight. You will be comfortable working in a fast-paced environment where priorities can evolve quickly and will demonstrate the ability to manage multiple stakeholders and competing demands. A strong desire to learn, develop, and continuously improve is essential. Must Have Skills Power BI
• End-to-end development of Power BI solutions, including:
• Data ingestion and transformation (Power Query)
• Data modelling
• DAX development and optimisation
SQL & Data Analysis
• Strong SQL development skills, including query optimisation and troubleshooting.
• Solid understanding of relational database design and data modelling principles.
• Experience analysing large and complex datasets to identify trends and business opportunities.
Excel
• Advanced Excel skills, including:
• Power Query
• Power Pivot
• Complex formulas and modelling techniques
Preferred Skills
• Experience working with Databricks in a modern data platform environment.
• Knowledge of dbt (Data Build Tool) for data transformation and modelling.
• Familiarity with cloud-based data platforms, particularly Microsoft Azure.
• Experience working with data engineering or ETL pipelines.
• Exposure to version control and collaborative development practices (e.g., Git/GitHub).
• Experience working within financial services, insurance, or other highly regulated industries.
  
  We are seeking a proactive and analytical individual who enjoys solving complex data challenges and turning information into valuable business insight. You will be comfortable working in a fast-paced environment where priorities can evolve quickly and will demonstrate the ability to manage multiple stakeholders and competing demands. A strong desire to learn, develop, and continuously improve is essential., End-to-end development of Power BI solutions, including:
• Data ingestion and transformation (Power Query)
• Data modelling
• DAX development and optimisation
SQL & Data Analysis
• Strong SQL development skills, including query optimisation and troubleshooting.
• Solid understanding of relational database design and data modelling principles.
• Experience analysing large and complex datasets to identify trends and business opportunities.
Excel
• Advanced Excel skills, including:
• Power Query
• Power Pivot
• Complex formulas and modelling techniques
Preferred Skills
• Experience working with Databricks in a modern data platform environment.
• Knowledge of dbt (Data Build Tool) for data transformation and modelling.
• Familiarity with cloud-based data platforms, particularly Microsoft Azure.
• Experience working with data engineering or ETL pipelines.
• Exposure to version control and collaborative development practices (e.g., Git/GitHub).
• Experience working within financial services, insurance, or other highly regulated industries.