Power BI Developer

Company Overview and Culture

EXL (NASDAQ: EXLS) is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth. Bringing together deep domain expertise with robust data, powerful analytics, cloud, and AI, we create agile, scalable solutions and execute complex operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media, and retail, among others. Focused on creating value from data for driving faster decision-making and transforming operating models, EXL was founded on the core values of innovation, collaboration, excellence, integrity and respect. Headquartered in New York, our team is over 40,000 strong, with more than 50 offices spanning six continents. For information, visit www.exlservice.com.

For the past 20 years, EXL has worked as a strategic partner and won awards in its approach to helping its clients solve business challenges such as digital transformation, improving customer experience, streamlining business operations, taking products to market faster, improving corporate finance, building models to become compliant more quickly with new regulations, turning volumes of data into business opportunities, creating new channels for growth and better adapting to change. The business operates within four business units: Insurance, Health, Analytics, and Emerging businesses.

About EXL Health

We leverage Human Ingenuity and domain expertise to help clients improve outcomes, optimize revenue and maximize profitability across the healthcare ecosystem. Technology, data and analytics are at the heart of our solutions. We collaborate closely with clients to transform how care is delivered, managed and paid.

EXL Health combines deep domain expertise with analytic insights and technology-enabled services to transform how care is delivered, managed, and paid. Leveraging Human Ingenuity, we collaborate with our clients to solve complex problems and enhance their performance with nimble, scalable solutions. With data on more than 260 million lives, we work with hundreds of organizations across the healthcare ecosystem.

We help payers improve member care quality and network performance, manage population risk, and optimize revenue while decreasing administrative waste and reducing health claim expenditures. We help Pharmacy Benefit Managers (PBMs) manage member drug benefits and reduce drug spending while maintaining quality. We help provider organizations proactively manage risk, improve outcomes, and optimize network performance. We provide Life Sciences companies with enriched data, insights through advanced analytics and data visualization tools to get the right treatment to the right patient at the right time.

At EXL, we look and go deeper. What others may see as impossible; we welcome as a challenge. And we don’t rest until we find a better way. EXL uses Human Ingenuity as a catalyst to look and go deeper for improved outcomes. We combine deep domain expertise with analytic insights and technology-enabled services to transform how care is delivered, managed, and paid. Leveraging Human Ingenuity, we collaborate with our clients to solve complex problems and enhance their performance with nimble, scalable solutions.

Job Description:

· Identify and drive process improvements, including the creation of standard and ad-hoc reports, queries, tools, and BI dashboards.

· Increase productivity by developing automated reporting/BI tools

· Understand business requirements to Analytical thinking for translating data into informative reports and visuals.

· Used DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions to create business Calculations based on requirements.

· Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.

· Having good skills in trouble shooting On-Premises Gateway to refresh the dashboards and reports

· Analyze past results, perform variance analysis, identify trends, and make recommendations for improvements

· Writing DAX queries to create measures and calculated columns in Power BI desktop

· Hands on experience in the implementation of Common Table Expressions (CTE), implementation of Rank functions, Temporary Tables, Table variables and String functions.

· Responsible for design methodology and project documentaries.

· Must be able to discuss the requirements effectively with the client teams, and with internal teams.

Eligibility Criteria:

· Must hold a degree for Bachelors of engineering or equivalent at minimum.

· Must have 2+ years of experience in data-specific roles.

· Must have good experience on MS SQL Server.

· Can independently manage tasks and responsibilities as assigned by the Team/ Project Manager

· Timely and accurate reporting to the stakeholders

· Knowledge in Microsoft BI Stack

· Grip over data analytics

Competencies Required:

· Working knowledge of Power BI or any other visualization tool.

· Working knowledge of SQL server Management Studio

· Business knowledge for Healthcare Analytics

· Self-initiated and zeal for continuous improvement