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
