Job Description

:



Manager, SQL \xe2\x80\x93 C1

Function

Venkatesh M

Employment Type

Permanent

Span of Control

TBD

Location

W223 - SCIO - Center 52 (Tower 2) Chennai

Basic Functions

• 8-12 Years of experience in enterprise application design, development & support.
• Must have at least 2+ 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.
• Handling high volume SQL warehouse, Extensive knowledge on MS SQL, SSIS and Visual Report
• 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 \xe2\x80\x93 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 \xe2\x80\x9croll up your sleeves\xe2\x80\x9d 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\xe2\x80\x99s 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.

Organizational Relationships

Reports To : Venkatesh M Supervises : To Be Decided

Skills

Technical Skills

Required Skills \xe2\x80\x93

• Azure Cloud \xe2\x80\x93 Azure SQL, Data Factory, Synapse & Data Bricks
• Power BI Reports and Self-Service Power BI Reports building
• Data Analysis Tools \xe2\x80\x93 (Online analytical processing (OLAP), ETL frameworks) & ETL Data Load, SSIS
• SQL Server 2008 & above: SQL, Stored procedures, functions
• Must have experience on cloud Azure hosted applications.

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 \xe2\x80\x93 12 PM to 9 PM

Will be required to extend as per project release needs

Education Requirements

• Master\xe2\x80\x99s or Bachelor\xe2\x80\x99s degree from top tier colleges with good grades, preferably from an Engineering Background

EXL Service