3877033-Senior Executive

Job Description    Senior Programmer Analyst, SQL – A2/B1   Employment Type: Permanent   Location: Chennai  Basic Functions 3-6 Years of experience in enterprise application design, development & support. 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. Handling high volume SQL warehouse, Extensive knowledge on MS SQL, SSIS and Visual Report(SSRS, Power BI) Identify business reporting and analytic needs by collaborating with end users, stakeholders, and technology teams.  Design, develop, and maintain enterprise BI reports, visualizations, and dashboards in Power BI Work with the report team to design and implement a reporting user experience that is consistent and intuitive across environments and across report methods.  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 delivery Comprehend 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.      Good to have experience working on Azure Cloud Services such as Azure SQL, Data Factory and Data Bricks nice to have Synapse. 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 lifecycle Assessment 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.  Client Interactions to better understand expectations & streamline solutions. If required should be a bridge between the client and the technology teams. Skills Technical Skills Required Skills – Power BI Reports and Self-Service Power BI Reports building Data Analysis Tools – (Online analytical processing (OLAP), ETL frameworks) & ETL Data Load, SSIS SQL Server 20012 & above: SQL, Stored procedures, functions SSRS Report Builder Must have experience on cloud Azure hosted applications. Azure Cloud –Data Bricks, Azure SQL, Data Factory &  Skills Nice to Have Enterprise business intelligence platform (Tableau) Expertise in US Healthcare Insurance. Part of any open-source contributions Certifications in Agile & Waterfall Methodologies Certifications 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 within Good analytical skills. Strong communication skills - oral and verbal Ability to work with various stakeholders across various geography.  Excellent Team player, with the ability to build & sustain teams Should 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 – 11 AM to 8 PM Will 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 About the TeamEXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration – and we’ve been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers. We function as one team to make your goals our goals, whether that’s unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible. Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It’s our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients. Find out for yourself why clients, employees, and analysts think we’re some of the best in the business. Contact us to see how we can help you achieve your goals.