2067748-Lead Assistant Manager

EXL; Gurugram District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

EXL Analytics in India seeks a Power BI Analytics Specialist to design dashboards, write advanced SQL, and manage ETL processes across diverse data sources. You will implement security rules, publish reports, and collaborate with teams to deliver insights that drive business decisions.

The role requires strong communication, problem-solving, and the ability to work in a fast-paced analytics environment. Prior experience with insurance analytics is a plus, with opportunities to grow within a

Qualifications

• Experience in analytics, preferably in insurance.
• Must have experience in reporting tools like Power BI and SSRS and strong SQL skills.
• Experience with ETL tools like SSIS or Azure.

Responsibilities

• Design interactive Power BI reports and dashboards.
• Write complex DAX expressions for measures and calculations.
• Configure data refresh and Power BI Gateways, implement Row Level Security.
• Publish and share content through Power BI Service.
• Connect to data sources (SQL Server, Excel, APIs).
• Create, modify and test SQL queries, stored procedures, views.
• Develop SQL/SSIS code for ETL to support reporting.
• Develop MDX cubes for SSAS where required.
• Automate report refresh using T-SQL/SQL.
• Maintain clear, professional communication with stakeholders.

Skills

Power BI

SQL

SSRS

ETL

Azure

Communication

MDX

SSAS

Teamwork

Education

Bachelor's/Master's degree in analytics related field

Tools

SSIS

SSAS

SSRS

Power BI

SQL Server

Job description

;EXL (NASDAQ:EXLS) is a leading operations management and analytics company that helps businesses enhance growth and profitability in the face of relentless competition and continuous disruption. Using our proprietary, award-winning Business EXLerator Framework™, which integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation and logistics industries. Headquartered in New York, New York, EXL has more than 24,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia and South Africa. EXL Analytics provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, EXL Analytics takes an industry-specific approach to transform our clients’ decision making and embed analytics more deeply into their business processes. Our global footprint of nearly 2,000 data scientists and analysts assist client organizations with complex risk minimization methods, advanced marketing, pricing and CRM strategies, internal cost analysis, and cost and resource optimization within the organization. ;EXL Analytics serves the insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation and logistics industries. ;Please visit ;www.exlservice.com ;for more information about EXL Analytics.

Role & Responsibilities Overview:

• 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 PowerBISupport 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

Candidate Profile:

Bachelor’s/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areascandidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply

• 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

What we offer:

EXL Analytics offers an exciting, fast paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world class analytics consultants.You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth

Analytics requires different skill sets at different levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques.

We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors.Sky is the limit for our team members. The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond.