Business Intelligence

Ex; Gurugram District; On-site; INR 1,100,000 - 1,600,000; Full time

Job summary

Ex in Gurugram is seeking an experienced BI Developer to analyze data and build interactive dashboards using SQL, Power BI, SAS, Redshift and Azure SQL for stakeholders. You will translate business requirements into data models, optimize data pipelines, and ensure accuracy and availability of insights across teams.

Collaborate with business users and IT to understand analytics needs, monitor KPIs and reports, and continuously improve BI solutions, driving data-driven decisions and scalable

Qualifications

• Proficient in SQL-based data extraction, transformation and loading.
• Experience in creating interactive dashboards with Power BI.
• Familiarity with SAS and data warehousing concepts.

Responsibilities

• Analyze insurance-related data and develop interactive dashboards for stakeholders.
• Build and maintain dashboards using Power BI to provide actionable insights.
• Integrate data from multiple sources ensuring data accuracy and availability.
• Improve BI solutions by optimizing data pipelines and adopting new techniques.
• Model datasuch as facts and dimensions for scalable reporting.
• Collaborate with stakeholders to deliver data-driven insights.
• Monitor KPIs and provide regular performance and audit metrics.
• Optimize queries and reports for performance and timely delivery of insights.

Skills

SQL

Power BI

SAS

Redshift

Azure SQL

Job description

Roles and Responsibilities for BI Developer

• Leverage SQL, Power BI, and SAS, Redshift , Azure SQL to analyze insurance data and develop interactive reports and dashboards for stakeholders
• Develop and maintain interactive dashboards using Power BI to provide actionable insights
• Integrate data from multiple sources, ensuring accuracy and availability for analysis
• Continuously improve BI solutions and processes by incorporating feedback, optimizing data pipelines, and adopting new technologies and technique
• Possess data management skills ,develop data models, facts ,dimensions, and optimized queries for efficient reporting and scalable BI solutions
• Collaborate with business stakeholders to understand analytics needs and deliver data-driven insights
• Monitor KPIs and provide regular reports on performance, claims trends, and audit metrics
• Optimize queries and reports for performance, ensuring the timely delivery of data insights

  Candidate Profile:

  • Experienced BI developer with 3-7 years of expertise in Leverage SQL, Power BI, and SAS, Redshift , Azure SQL and data analysis
  • Strong problem-solving abilities with an emphasis on data-driven decision-making
  • Excellent communication skills, with the ability to present complex data insights to non-technical stakeholders
  • Ability to work effectively within cross-functional teams and manage relationships with business users and technical teams
  • Strong proficiency in SQL for data extraction, transformation, and reporting
  • Experienced in PowerBI development for creating interactive, user-friendly dashboards, reports, and data visualizations
  • Basic knowledge of data warehousing, ETL processes, and data integration techniques
  • Experience using SQL, Power BI, and SAS, Redshift , Azure SQL for data manipulation, statistical analysis, and reporting is a plus
  • Familiarity with insurance business processes, such as claims management is a plus