Role:
- The Business Intelligence Analyst will design, develop, and maintain BI solutions that transform raw data into meaningful insights to support business decision-making. The role requires hands-on expertise in data visualization tools such as Grafana, Tableau, and Power BI, along with solid experience in data warehousing concepts and ETL processes using tools like Alteryx or similar platforms.
- The BI Analyst will collaborate with business stakeholders and IT teams to understand data requirements, build analytical dashboards, and deliver actionable intelligence across insurance operations, financial performance, and customer analytics.
Challenges:
- Data Complexity: Integrating and harmonizing data from multiple heterogeneous source systems across insurance operations.
- Data Quality: Ensuring accuracy, consistency, and completeness of data flowing through ETL pipelines and data warehouses.
- Performance at Scale: Building dashboards and reports that perform efficiently against large datasets under concurrent usage.
- Regulatory Reportin: Producing compliant analytical outputs aligned with SAMA, ZATCA, and other Saudi regulatory frameworks.
Responsibilities
Data Visualization & Dashboard Development:
-* Dashboard Design:* Design and develop interactive dashboards and reports using Power BI, Tableau, and/or Grafana tailored to business stakeholder needs.
- KPI Monitoring: Build and maintain KPI scorecards, trend analysis, and performance dashboards for executive and operational audiences.
- Self-Service BI: Enable self-service analytics by creating reusable data models, templates, and guided analytics for business users.
- Visualization Standards: Establish and enforce data visualization best practices, including consistent branding, accessibility, and layout standards.
- Report Automation: Automate scheduled reports and alerts to reduce manual reporting overhead.
Data Warehousing & Analytics:
- Data Warehouse Management: Support the design, development, and maintenance of the enterprise data warehouse (EDW) including dimensional modelling (star/snowflake schemas).
- Data Modelling: Create and maintain semantic data models, calculated measures, and hierarchies optimized for analytical consumption.
- Query Optimization: Write and optimize complex SQL queries to extract, aggregate, and transform data for reporting and analytics use cases.
- Data Governance: Ensure data definitions, lineage, and cataloguing are maintained for all BI assets.
- Ad Hoc Analysis: Respond to ad hoc data analysis requests from business teams, delivering insights in a timely and accurate manner.
ETL & Data Integration:
- ETL Development: Design, build, and maintain ETL/ELT workflows using Alteryx, SSIS, or similar platforms to ingest and transform data from source systems.
- Data Pipeline Monitoring: Monitor ETL job execution, handle failures, and ensure data loads complete within defined SLAs.
- Source System Integration: Integrate data from core insurance platforms, CRM, financial systems, and external regulatory feeds.
- Data Quality Management: Implement data validation rules and quality checks within pipelines to ensure data integrity.
- Change Management: Manage impact of source system changes on downstream ETL pipelines and BI reports.
Collaboration & Stakeholder Engagement:
- Requirements Gathering: Work closely with business owners, finance, operations, and compliance teams to translate analytical requirements into BI solutions.
- Documentation: Maintain thorough documentation of data models, dashboard designs, ETL logic, and data dictionaries.
- Training & Support: Provide training and ongoing support to business users on BI tools and self-service capabilities.
Technical – Functional Requirements
Data Visualization Tools: Power BI (Desktop, Service, Embedded), Tableau (Desktop, Server), Grafana, or equivalent BI platforms
- ETL / Data Integration Tools: Alteryx Designer, SSIS (SQL Server Integration Services), Azure Data Factory, Informatica, or similar
- Data Warehousing: Dimensional modelling, star/snowflake schemas, Azure Synapse Analytics, AWS Redshift, Snowflake, Oracle Data Warehouse Cloud Services, or on-premises DWH platforms
- Query Languages: Advanced SQL (T-SQL, PL/SQL), DAX (Power BI), MDX, and familiarity with Python or R for data analysis
- Databases: SQL Server, Oracle, PostgreSQL, or equivalent RDBMS, No SQL, document base, and schemaless DBs
- Cloud Platforms (preferred): OCI, Microsoft Azure (Azure Data Factory, Synapse, Azure Analysis Services), AWS, or Google Cloud
- Scripting & Automation: PowerShell, Python, or Bash for task automation and data pipeline scripting
- Version Control: Git-based version control for BI assets and ETL scripts
Education and Certifications
- Education: Bachelor's degree in Computer Science, Information Technology, Statistics, Data Science, or a related field, or equivalent work experience
- Certifications (preferred): Microsoft Certified: Data Analyst Associate (Power BI), Tableau Desktop Specialist/Certified Associate, Alteryx Designer Core/Advanced, or equivalent BI/analytics certification, OCI Certification
Behaviors – Values Requirements
- Strong analytical and problem-solving skills with the ability to translate complex data into clear business insights
- Excellent communication and data storytelling skills to present findings to both technical and non-technical audiences
- High attention to detail and commitment to data accuracy and quality
- Ability to manage multiple projects and analytical requests in a fast-paced, deadline-driven environment
- Collaborative team player with the ability to work independently and cross-functionally
- Proactive mindset in identifying data opportunities and proposing improvements to BI capabilities
Experiences Required
- Minimum of 5 years of experience in a Business Intelligence, Data Analytics, or related role
- Proven hands-on experience developing dashboards and reports in Power BI, Tableau, or Grafana
- Solid experience designing and developing ETL workflows using Alteryx, SSIS, or similar tools
- Demonstrated experience working with data warehouses, dimensional models, and large datasets
- Strong SQL skills with experience writing complex queries for data extraction and transformation
- Experience in the insurance, financial services, or a regulated industry is highly preferred
- Familiarity with Saudi regulatory reporting requirements (SAMA, ZATCA) is an advantage
Pay: ₹702,976.74 - ₹1,762,869.14 per year
Work Location: In person