Gold Coast Health Plan will not sponsor applicants for work visas.
The pay range above represents the minimum and maximum rate for this position in California. Factors that may be used to determine where newly hired employees will be placed in the pay range include the employee specific skills and qualifications, relevant years of experience and comparison to other employees already in this role. Most often, a newly hired employee will be placed below the midpoint of the range. Salary range will vary for remote positions outside of California and future increases will be based on the pay band for the city and state you reside in.

POSITION SUMMARY

Reporting to the Manager, Business Solutions (IT), under general supervision, the Developer II will work with various business unit and IT resources to develop solutions for operational and ad-hoc reporting, ETL, data driven business decisions, and systems integration from technical specifications based on customer and business needs, industry best practices and available technology.
The Developer II performs assigned tasks and duties of average complexity and scope; supporting designated software package(s), business solution(s), or program(s) of work independently or under the general direction of a Senior Developer. The Developer II through identification, analysis, synthesis, technical specifications, and solution development based on customer and business needs, industry best practices and available technology. The Developer II will work across multiple departments and functions to develop technical solutions based on functional, usability, reliability, performance and support requirements of a system, serving as a technical expert, providing the technical knowledge in their area of expertise of the system or under the guidance of the Senior Developer to ensure the solutions being developed will satisfy the needs of the business.

POSITION QUALIFICATIONS

Competency Statements

• Technical Aptitude - Ability to comprehend complex technical topics and specialized information.
• Systems Analysis - Ability to determine how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
• Business Acumen - Ability to grasp and understand business concepts and issues.
• Communication, Oral - Ability to communicate effectively with others using the spoken word.
• Communication, Written - Ability to communicate in writing clearly and concisely.
• Customer Oriented - Ability to take care of the customers’ needs while following company procedures.
• Diversity Oriented - Ability to work effectively with people regardless of their age, gender, race, ethnicity, religion, or job type.

SKILLS & ABILITIES

Education: 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.

Experience:

• 3 plus years of experience in hands-on with SSIS, SSRS, SSAS design. Azure Data Factory.
• 3 plus 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

Computer Skills:

• Experience designing and developing applications on SQL Server 2014+ and/or SQL DW aka dedicated SQL Pools in Azure Synapse.
• Hands-on experience in writing T-SQL queries, Stored Procedures, User Defined Functions, Jobs, Cursors, Views and Triggers, optimized for database efficiency.
• Hands-on experience with SSIS, SSRS, SSAS design and development including Azure Data Factory
• Hands on experience with DAX and M Query

Preferred Experience

• Experience with various programming and scripting languages (JAVA, RPG, C, XSLT, various. NET languages, python, javascript, shell script…)
• Modeling tools such as Toad Data Modeler, Erwin or Embarcadero
• 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 (preferably 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 required. 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.

Reasonable Accommodations Statement
To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions.

Essential Functions Statements

• Primary function: Uses analytical, data and SQL development skills to produce reports to support the Business in making data driven business decisions. Includes producing both ad-hoc and regularly scheduled reports. Reviews data to ensure validity.
• 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 to be used during the development lifecycle and ETL process. Implement processes and logic to extract, transform, and distribute data across one or more 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.