- 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
Skills Required
- Bachelor's or Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics field
- 5+ years in analytics
- Experience with Power BI, SSRS, Report Builder and writing complex DAX expressions
- Advanced SQL skills including T-SQL, writing SQL queries, stored procedures, and views
- Experience using ETL tools such as SSIS or Azure data tooling
- Experience configuring Power BI Gateways, scheduled refresh, Power BI Service publishing, and implementing Row Level Security
- Ability to connect to various data sources (SQL Server, Excel, APIs) and extract data from relational/external sources
- Good critical thinking, problem solving, verbal and written communication, and presentation skills
- Insurance industry experience
- Experience with MS Access, Excel, VBA, and SSAS (including MDX)
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
