Technology

BI Developer

EXLGurugram🇮🇳India

Quick overview

SeniorityMid Senior

Work modeHybrid

LocationGurugram, India

SQLT-SQLMicrosoft ExcelETLVBAAzurePower BISQL Server

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

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

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 good 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