BI Analyst

Job Description

The Business Intelligence Analyst will be involved in designing, developing and maintaining business intelligence solutions (dashboards, reports). Gather business requirements from users and work closely with the Group technical data engineering team.
Key responsibilities include translating business needs into technical specs, support building data warehouses, optimizing queries, ensuring completeness of data and collaborating with analysts, data engineers, and stakeholders to support strategic planning and performance monitoring. 
**Responsibilities:**
Developing, testing, and documenting complex pipelines from a design specification into the enterprise data warehouse.
Knowledge of Facts and Dimensions within the enterprise data warehouse.
Design and implement database structures to meet application requirements.
Develop, test, and deploy SQL queries and stored procedures where necessary.
Optimize and tune SQL queries for performance.
Use data models to represent business processes and information requirements.
Collaborate with stakeholders to understand data needs and design appropriate reports / dashboards
Ensure the security model based on privacy requirements, confirm safeguards are followed.
Participate in reviews of work to ensure developments are standardised, reliable, and maintainable.
Run / participate in Business Intelligence monthly working group for data users
Communicate well with stakeholders at all levels
Efficiently manage workload priorities based on the needs of multiple business units
 

Desirable selection criteria

**Skills and Experience:**
·       Minimum of 10+ -year experience as a business intelligence analyst
·       Experience in SQL, ADF and Azure Analysis Services
·       Experience in using all Microsoft applications
·       Familiarity with software management tools such as DevOps, Azure, and JIRA for project maintenance and user story documentation.
·       Experience with three or more of the following: data processing automation, data quality, data warehousing, data governance, business intelligence, data visualization, data privacy
·       Experience of full cycle development, designing, coding, testing, and correcting complex SQL models and scripts
·       Knowledge of data analysis, data modelling and quality assurance techniques
·       Knowledge of version control systems (e.g., Git)
·       Certifications in relevant database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate).
·       Possess the ability to work autonomously and with others.
·       Previous experience of working in an insurance environment
·       Strong Power BI experience to create custom dashboards and visualisations
·       Strong experience with DAX to develop complex measures
·       Strong experience working with Semantic models
·       Excellent problem-solving and communication skills.
 

About Employer