Senior Data Analyst at CIC Insurance

PURPOSE:

The Senior Data Analyst will leverage Power BI to analyze, visualize, and interpret complex datasets, providing actionable insights to support strategic decision-making. This role involves designing and developing dashboards, ensuring data accuracy, and collaborating with cross-functional teams to drive data-driven initiatives. The successful candidate will work closely with business stakeholders to understand their data needs and translate them into actionable insights.

PRIMARY RESPONSIBILITIES:

• Analyze large, complex datasets to uncover trends, patterns, and insights.
• Design and implement robust data models, visualizations and dashboards to support complex business requirements.
• Cleanse, transform, and integrate data from various sources (e.g., SQL Server, Azure Data Lake, Excel) into a unified data model.
• Work with business leaders to understand reporting needs and translate them into technical solutions.
• Provide clear, actionable insights and recommendations to stakeholders across departments.
• Act as a liaison between technical teams and business units to ensure alignment.
• Ensure the accuracy and reliability of data used for analysis and reporting.
• Implement data governance practices, including security and access control.
• Ensure data integrity, security, and compliance with industry standards and regulations.
• Optimize Power BI performance by implementing best data modelling and report design practices.
• Stay up-to-date with Power BI updates and integrate new features to enhance reporting capabilities.
• Automate repetitive reporting tasks to improve efficiency.
• Mentor junior data analysts on best practices and advanced techniques.
• Lead efforts to standardize Power BI usage and reporting frameworks across the organization.
• Champion data-driven decision-making within the company

Key Skills, Knowledge, Experience and Behavioural Competencies
Academic and Professional Requirements

• Education    Master’s/Bachelor’s Degree    Degree in Data Science, Computer Science, Business Analytics, or a related field.

Experience Required

 Description    Required years of experience     Need Type

• Relevant experience    7+    E

Qualifications, Skills and Competencies:

• Expertise in Power BI, including DAX (Data Analysis Expressions), Power Query, and data modelling.
• Proficiency in SQL and experience working with relational databases.
• Familiarity with ETL (Extract, Transform, Load) processes and tools, e.g., SSIS, Alteryx.
• Strong understanding of business intelligence and analytics concepts.
• Excellent communication and presentation skills to convey technical findings to non-technical stakeholders.
• Strong project management and organizational skills.
• Experience with predictive analytics or machine learning tools is a plus.
• Familiarity with Microsoft Azure services (e.g., Azure Data Factory, Synapse) is desirable.