Job Description
We are seeking a highly skilled Business Intelligence Architect/Developer with 5+ years of experience to design, develop, and support enterprise BI solutions. The ideal candidate will have strong expertise in Power BI and Tableau , hands-on experience with modern data platforms, and solid insurance domain knowledge to deliver impactful analytics and reporting solutions.
Key Responsibilities
- Design, develop, and maintain BI reports, dashboards, and visualizations using Power BI and Tableau , with exposure to Microsoft Fabric (semantic models, Lakehouse/Warehouse concepts, and Fabric-enabled Power BI workloads).
- Partner with business stakeholders to gather requirements, analyze business needs, and translate them into scalable BI and analytics solutions, leveraging insurance domain expertise (policy, claims, underwriting, premiums, loss ratios).
- Build, optimize, and maintain data models, ETL/ELT processes, and semantic layers to support enterprise reporting and self-service analytics.
- Develop and optimize M (Power Query) and DAX for advanced data transformations, calculations, and performance tuning in Power BI.
- Create and maintain Python scripts for data processing, automation, and analytical workflows.
- Integrate and automate data and reporting workflows using Power Automate to improve efficiency and reliability.
- Collaborate with data engineering and platform teams to support reporting and analytics using Snowflake and other modern data warehouse platforms.
- Write and optimize complex SQL queries while adhering to relational database design principles and best practices.
- Troubleshoot issues, tune performance, and ensure the accuracy, consistency, security, and governance of BI solutions.
- Provide ad-hoc reporting and analytics support while enabling self-service BI for business users.
