3877036-Assistant Manager

EXL Talent Acquisition Team; Chennai; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

EXL is seeking an experienced BI Developer to design, develop, and maintain enterprise BI reports and dashboards using Power BI. You will work with Azure SQL, Data Factory, and Databricks to build scalable data warehouses and visualizations.

Collaboration with onshore/offshore teams and mentoring junior members are part of this role. Ideal candidates have 6-8 years in enterprise data environments, strong SQL skills, and experience with cloud-based analytics platforms.

Qualifications

• 6-8 years of experience in enterprise application design, development & support.
• Experience with high-volume SQL warehouses and MS SQL, SSIS and Visual Reports.
• Proficient in developing Power BI dashboards and data visualization.
• Experience with Azure cloud services including Azure SQL, Data Factory and Data Bricks.
• Produce scalable, high-quality code in secure enterprise environments.

Responsibilities

• Design, develop, and maintain enterprise BI reports and dashboards in Power BI.
• Collaborate with end users and stakeholders to translate requirements into technical designs.
• Mentor team members and ensure end-to-end solution delivery across environments.

Skills

SQL Server

Power BI

SSIS

Azure SQL

Azure Data Factory

Azure Databricks

Python

PySpark

Data Warehousing

Data Modeling

Education

Master’s or Bachelor’s Degree

Tools

Tableau

Job description

Basic Functions

6-8 ;Years of experience in enterprise application design, development & support.Handling high volume SQL warehouse, Extensive knowledge on MS SQL, SSIS and Visual ReportExperienced in designing and building data warehouses/marts using Microsoft SQL.Proficient in developing engaging and insightful visual dashboards with Power BI.Possesses a strong understanding of data modelling and visualization principles.Design, develop, and maintain enterprise BI reports, visualizations, and dashboards in Power BIWork with the report team to design and implement a reporting user experience that is consistent and intuitive across environments and across report methods. ;Must have at least 1+ years of experience working on Azure Cloud Services such as Azure SQL, Data Factory and Data Bricks nice to have Synapse. ;Produce 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.Identify business reporting and analytic needs by collaborating with end users, stakeholders, and technology teams. ;Provide report testing support and execute report and analytics unit testing. ;Document report design and test case documentation as well as assist with end user documentation. ;Cross train & mentor team members for complete knowledge of technologies. ;Analyze and translate business requirements to technical design with security and data protection settings. ; ;Collaborate/communicate with on-site project team and business users as required. ;Work with development teams and product managers to ideate software solutions. ;Own all projects deliverables and ensure proper communication between teams and quality levels; responsible for end to end solution deliveryComprehend the fundamental solution being developed/deployed – its business value, blueprint, how it fits with the overall architecture, risks, and more.Would be required to provide inputs on solution and design effort to build scalable features /functionality.

Essential Functions

Multi-disciplinary technologist who enjoys designing and executing Healthcare solutions.Understanding of the US Healthcare value chain and key impact drivers [Payer and/or Provider]Strong problem solving and analytical skills and the ability to “roll up your sleeves” and work with a client to create timely solutions and resolutions.Ability to work on multiple product features simultaneously. ;Quick learner with ability to understand product’s functionality end to end.Experience with Strong knowledge of algorithms, design patterns and fundamental computer science concepts ;Would be responsible for tuning queries for performance, security and stability of the reports. ;Need to understand the functional aspects of the reports being developed & perform deployment. ;Detailing and analysis required in Data creation and tableau Reporting. ;

Primary Internal Interactions

Review with the Overall Product Manager & AVP for improvements in the product development lifecycleAssessment meeting with VP & above for additional product development features.Train & Mentor, the juniors in the team

Primary External Interactions

Communicate with onshore stakeholders & Executive Team Members. ; Help the Product Management Group set up the product roadmap & help in identifying future sellable ; product features. ;

Skills

Technical SkillsRequired Skills – SQL Server 2008 & above: ; SQL, Stored procedures, functionsPower BI Reports and Self-Service Power BI Reports buildingETL Data Load, SSISAzure SQL, Azure Data Factory, Data BricksMust have experience on cloud Azure hosted applications. ; ;Skills Nice to HaveProgramming Languages: Python, PySparKData Analysis Tools – (Online analytical processing (OLAP), ETL frameworks) & ;Azure Synapse ;Enterprise business intelligence platform (Tableau)Expertise in US Healthcare Insurance.Part of any open-source contributionsCertifications in Agile & Waterfall MethodologiesCertifications in Azure ;Process Specific Skills ;Business Domain;-;US Healthcare Insurance & Payer Analytics ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Care Coordination & Care Optimization ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Population Health Analytics & Risk Management ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Member 360 View & Analytics ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Gaps & Compliance Measures ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Payer Management & Code Classification Management ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Utilization & Cost Management ; ; ; ; ; ; ; ; ; ; ; ;

Soft Skills

Understanding of Healthcare business vertical and the business terms withinGood analytical skills.Strong communication skills - oral and verbalAbility to work with various stakeholders across various geography. ;Excellent Team player, with the ability to build & sustain teamsShould be able to function as an Individual Contributor as well if required.Mentor people and create a high performing organization (foster relationships, resolve conflicts and so on while delivering performance feedback

Working Hours

General Shift – 12 PM to 9 PMWill be required to extend as per project release needs

Education Requirements

Master’s or Bachelor’s degree from top tier colleges with good grades, preferably from an Engineering Background