Systems Architect Development Lead SQL Snowflake Azure NET TELECOMMUTE OAS presystem

100% telecommute.

Project:

• IFP MDE enhancement for Individual Family Plans (Phase I 4/23; Phase 2 10/23) - Suspect Conditions
• Data Feed Enhancements for Improved Member Matching
• Shifting responsibility to Membership SME on Finance side - Pharmacy Claims and Provider match New data feed - EIPRO Taking ownership of Provider Group Rollup/ Provider Attribution integration - General PCOR Involvement
• End to end ysis of E&I Solution Enhancements; Feasibility
• HEDIS Measure and spec ysis, solution integration Ops Work - Maintain and own E&I LOB relationship with EIPRO
  • Data quality issues
  • Integration
  • Enhancements
• Requests - Maintain Snowflake source queries and process to Landing
• Gaps In Care, Med Claims, RX Claims, RX Providers (TBD)
• SSIS and SQL Agent Jobs - Monitor, Support, Solution, Issue and Defect Resolution - Provide direction to E&I Team Members
• Troubleing direction
• Development approach
• Security and access (where relevant)
• ist with Data Profiling Results/ Runbook ysis
  • Year over Year
  • Month over Month

Required Ss:

• Database: SQL, jobs, database design, application integration, Snowflake, ETL/ ELT
• Application and Integration: SSIS, SSRS, C#/ .Net familiarity, Azure, Azure Data Factory Application design
• Performance tuning
• Strong problem solving ss
• Team-oriented, good interpersonal and communication ss
• Proactive involvement with business initiated requests, proof of concept approach, translate business spec to technical
• Familiarity with Member, Provider, Claims, Quality data