Job Description: 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
