Job Description
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.
EXL Health is looking for a Data Analyst Intern. This is a remote opportunity.
Responsibility
- Contribute to scalable and flexible, high-quality code that satisfies both functional and non-functional requirements
- Develop, deploy, test and maintain technical assets in a highly secure and integrated enterprise computing environment & Support functional testing
- Analyze and translate business requirements to technical design with security and data protection settings.
- Work with development teams and product managers to ideate software solutions.
- Manage expectation regarding road blocks, proactively, in the critical path to help ensure successful delivery of the solution
- Comprehend the fundamental solution being developed/deployed – its business value, blueprint, how it fits with the overall architecture, risks, and more.
- Collaborates on solution and design effort to build scalable features /functionality.
- Provides development and analytical support for SQL Server databases, SSIS packages, and SQL stored procedures
- Ability to analyze design, code, test, and deploy simple to intermediate level Microsoft SQL Server 2005/2008 solutions using T-SQL and SSIS with assistance
- Collaborates on database and SSIS designs & solutions
- Related work activities and responsibilities including the following: data analysis, develop coding solutions using SQL stored procedures SSIS for loading databases, data migration, and application interfaces
- Ability to convert EXL business requirements to logical data mapping.
- Ability to work in high paced production environment
- Ability to adhere to EXL standard process for data quality and data security for protecting PHI information.
- Ability to program in Python to read and process raw data files, data mapping and data cleansing
Technical Skills
- Working Knowledge of SQL /Running SQL queries to validate data
- Working Knowledge on Enterprise modeling tool and data integration platform – (SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS))
- Data Analysis Tools – (Online analytical processing (OLAP), ETL frameworks) & ETL DataLoad
- SQL Server 2008 & above : Basic SQL , T-SQL, Stored procedures, functions
- Enterprise business intelligence platform (Tableau, PowerBI)
- Knowledge of BI Tools, Advanced Microsoft office (work, excel, project, visio)
- Expertise in Python scripting & Automation.
Education Requirements
- Currently seeking a Bachelor’s degree in Computer science or related fields.
- Prefer some experience in Data Modeling, Data Integration, Reporting & Analytics, Reference Data, ETL & BI Tools, Data Quality concepts, Data Governance & Security
What We Offer:
- EXL Health 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 Healthcare 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
- 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 Health sets the stage for further growth and development in our company and beyond.