Lead Assistant Manager/Manager - SAS SQL Power Bi

Role Overview:

- Emphasis is on managing end to end project delivery.

- Structure analytical solution to address business objectives and problem solving.

- Translate stated or implied client needs into researchable hypotheses.

- Develop sophisticated dashboards and solutions to incorporate complex client requirements and enhance UX.

- Facilitate client working sessions and lead recurring project status meetings

- Develop long-lasting, trusted advisor relationships with clients

- Able to work in dual shore engagement across multiple time zones

- Manage business uncertainty

- Secure new opportunities within existing account relationship

- Assess customer needs, pain points, behaviors, activation levers, headroom for growth, value propositions, etc.

- Manage day-to-day project operations, serve as the functional and domain expert on the project team to ensure that they meet client expectations

- Provide quality oversight on deliverables prepared by the project team before submitting to client EXL Service

- 10 Exchange Place, Suite 2200, Jersey City, NJ T: +1.201.748.4700 www.exlservice.com

Responsibilities:

- Develop visual reports, dashboards and KPI scorecards using Power BI desktop

- Connect Power BI to different data sources, import data and transform data per project requirements

- Should be able to create data flows

- Should be able to write SQL queries and understand database fundamentals such as multidimensional database design, relational database design, and more

- Proficient in creating complex DAX queries, Power Query, bookmarks and SQL

- Implement row level security on data and understand application security layer models in Power BI, develop tabular/multidimensional models that are compatible with warehouse standards using M-Query

- Adept in developing, publishing, and scheduling Power BI reports and to visualize various trends as per the business requirements

- Be able to troubleshoot, do enhancements on existing reports and create new dashboards

Candidate Profile:

- Bachelor's/Master's degree in 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 welcomed to apply

- 5-9 years' relevant experience preferably in analytics

- Expertise in model development for reports, data transformations and Modelling using Power BI

Query Editor:

- Develop and integrate with various data sources. Experience in use of varied data connectors to in house or cloud data stores with ability to quickly stage & shape data from sources into reporting and analytics solutions

- Create relationships between data and develop tabular and other multidimensional data models.

- Manage a team of 5-6 people.

- Should be able to handle complex data queries/client requirements with hands on experienced on tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, Power Query, Power Pivot and DAX for successfully designing, modelling, and implementing end to end power bi solutions

- Experience in data gateway for data refresh

- Investigate & troubleshoot Power BI reports and data models including investigation of data issues, data validation and balancing, fix developed automated reports and dashboards.

- Monitor performance and optimize power bi solutions for scalability and efficiency

- Experience with Power Services and Power Apps. Good to have Power Automate knowledge.

- Maintain and create Power BI dashboards from scratch with enhanced customer/end-user experience with inclusion of story boards, smooth navigation and best in class visuals.

- Insurance Industry knowledge preferred

- Outstanding written and verbal communication 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

- Preferred Notice Period: 15-30 Days