Assistant Manager

Assistant Manager

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 Report
• Experienced 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 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.
• 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 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.

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 –

• SQL Server 2008 & above: SQL, Stored procedures, functions
• Power BI Reports and Self-Service Power BI Reports building
• ETL Data Load, SSIS
• Azure SQL, Azure Data Factory, Data Bricks
• Must have experience on cloud Azure hosted applications.

Skills Nice to Have

• Programming Languages: Python, PySparK
• Data 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 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 – 12 PM to 9 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

---