\- 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.
- *\- 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.
- *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
\- 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