Description

- Designing interactive reports and dashboards using PowerBI or leverage SSRS or Report Builder
- Writing complex DAX expressions for custom measures and calculations
- Configuring scheduled data refresh and Power BI Gateways, Implementing Row Level Security
- Publishing and sharing content through Power BI Service
- Connecting to various data sources (SQL Server, Excel, APIs, etc.)
- Data extraction from relational databases and external sources
- Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms
- Design and develop new SQL/SSIS code as part of an ETL process to support report development on PowerBI
- Support multi-dimensional cube development using MDX in SSAS for select use cases or run existing assets
- Develop stored procedures functions using T-SQL/SQL to automate report refresh or data views
- Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people

Responsibilities

- Designing interactive reports and dashboards using PowerBI or leverage SSRS or Report Builder
- Writing complex DAX expressions for custom measures and calculations
- Configuring scheduled data refresh and Power BI Gateways, Implementing Row Level Security
- Publishing and sharing content through Power BI Service
- Connecting to various data sources (SQL Server, Excel, APIs, etc.)
- Data extraction from relational databases and external sources
- Create, modify and test various SQL queries,



stored procedures and views for obtaining data from diverse source systems and platforms
- Design and develop new SQL/SSIS code as part of an ETL process to support report development on PowerBI
- Support multi-dimensional cube development using MDX in SSAS for select use cases or run existing assets
- Develop stored procedures functions using T-SQL/SQL to automate report refresh or data views
- Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people

Qualifications

- Bachelor’s/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply
- 5+ years in analytics (Preferably with Insurance)
- Must have experience in reporting tools like PBI,SSRS and valuable advance SQL skills
- Must have experience in using ETL tools like SSIS or Azure etc.
- Good to have experience in MS Access, Excel, VBA, SSAS
- Good critical thinking and problem solving skills
- Strong record of achievement, solid analytical ability, and an entrepreneurial hands-on approach to work
- Outstanding written and verbal communication skills, and presentation skills
- Able to work in fast pace continuously evolving environment and ready to take up uphill challenges
- Is able to understand cross cultural differences and can work with clients across the globe

📌 BI Developer (Gurugram)
🏢 EXL
📍 Gurugram