Data Analyst - SAS/SQL/Power BI - Consulting Firm

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

EXL Service

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

- Is able to understand cross cultural differences and can work with clients across the globe

- Preferred Notice Period: 15-30 Days