Gold Coast Health Plan

Developer II

Gold Coast Health Plan

full-time

Posted on:

Origin:  • 🇺🇸 United States • California

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $92,531 - $154,219 per year

Job Level

Mid-LevelSenior

Tech Stack

AzureETLInformaticaJavaJavaScriptPythonSOAPSQLSSIS

About the role

  • Develops and supports reporting, ETL, data driven business decisions, and systems integration from technical specifications.
  • Works with Business Systems Analysts, Business Stakeholders, vendors, and solutions partners to develop solutions for operational and ad-hoc reporting, ETL, data driven business decisions support, and systems integration.
  • Design and develop SQL Server stored procedures, functions, views and triggers; implement processes and logic to extract, transform, and distribute data across data stores from a wide variety of sources.
  • Provides analysis and development support for initiatives, including business function support for system migrations and consolidations, business area process improvement projects, and product installations.
  • Develops and/or reviews departmental business system requirements and business systems design documents, customer acceptance test plans, and post-implementation plans.
  • Works directly with external customers or in collaboration with the Senior Developers in implementing new reporting capabilities, systems enhancements and technology.
  • Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.
  • Provides analysis of efficiencies related to system enhancements/automation.
  • Refine and automate regular processes, track issues, and document changes.
  • Review of use cases and test cases.
  • Developing use cases and test cases.
  • Executes system testing.
  • Facilitates and support user acceptance testing.
  • Perform and execute data extraction, transformation and loading using ETL tools.
  • Convert physical data integration models and other design specifications to source codes.
  • Managing data analysis and integration of disparate systems
  • Building intensive data acquisition and integration solutions in line with business requirements
  • Perform and execute data extraction, transformation and loading using ETL tools.

Requirements

  • Bachelor's Degree (four year college or technical school) Required, Field of Study: A degree in computer science, information systems, or software engineering Or any combination of academic education, professional training or work experience, which demonstrates the ability to perform the duties of the position.
  • 3+ years of experience in hands-on with SSIS, SSRS, SSAS design. Azure Data Factory.
  • 3+ years of experience in SQL development-developing and designing applications and/or reports on SQL server 2014+ and/or SQL DW aka dedicated SQL Pools in Azure Synapse.
  • Health Care or other applicable industry experience.
  • Possess a very high level of subject matter expertise in a functional area, which may require expertise in benefits, claims adjudication, provider or employer contract administration, member and provider demographic management, QI (HEDIS reporting), UM/CM.
  • Experience designing and developing applications on SQL Server 2014+ and/or SQL DW aka dedicated SQL Pools in Azure Synapse.
  • Hands-on experience with SSIS, SSRS, SSAS design and development including Azure Data Factory.
  • Hands on experience with DAX and M Query (Preferred Experience).
  • Modeling tools such as Toad Data Modeler, Erwin or Embarcadero (Preferred Experience).
  • Experience using ETL solutions/enterprise ETL tools (SSIS, Informatica, PilotFish).
  • Experience with healthcare-specific data exchange and integration formats, e.g. HIPAA EDI/X12, HL7, FHIR, NCPDP.
  • Experience using BI technologies (MS-SSRS and PowerBI, Milliman MedInsight).
  • Knowledge of integration concepts, patterns, and formats: XML Schemas, SOAP, WS Specifications, HIPAA EDI, JSON.
  • Other Requirements: Research, analytical, organization, and time/project management skills; ability to work in a self-directed manner with minimal direction and oversight.
  • Possess an understanding of health industry data elements, and understanding of how elements are used within departmental processes.
  • Strong written and verbal communication skills, especially the ability to explain system and technical topics to non-technical resources.
  • Strong business analysis, mathematical, statistical, and data analysis skills.