Data Warehouse ETL Developer and Administrator

4 weeks ago

San Jose, United States Compu-Vision Consulting Full time
Job Title: Data Warehouse ETL Developer and Administrator (Epic)
Location: Remote
Duration: 6 months

Job Description:
Resource will provide medical claims and payor data (eligibility, medical, vision, lab, pharmacy) Extract, Transform and Load (ETL) services using Structured Query Language (SQL) to: (1) migrate Claims processing from the County's custom schema to Epic standard Caboodle schemas; (2) combine custom SQL Server Integration Services (SSIS) packages for Quality Incentive Program (QIP) Payor Data into one QIP master package; and (3) standardize and optimize QIP Claims eligibility processing. The role requires consultant-level communication skills, the ability to coalesce related requests and offer solutions that satisfy multiple requirements, and Software Development Life Cycle discipline: gathering & documenting and confirming requirements gathering, designing solution, obtaining SME signoff, coding, testing/validation, UAT, & documentation.

Typical Tasks:
  • Resource will assess the feasibility of Epic standard Caboodle schemas for QIP eligible Claims processing migration.
  • Resource will assess solutions for combining custom SSIS packages for QIP Payor Data into one QIP master package.
  • Resource will do an initial assessment of how the QIP metric tables are currently used by the County for processing QIP eligible Claims and investigate improvements to
  • the processing of Claims including how indexes, partitions, and other SQL bestpractice constructs can improve QIP eligible Claims processing by the County.
  • Resource will do County designated, ongoing assessments of additional improvements to the processing of Claims and Resource will provide Resource's assessment no later than 5 business days from the date of County's additional request(s).
  • Resource will recommend a migration plan to the County to the Epic standard Caboodle schemas for QIP eligible Claims.
  • Resource will recommend a solution to the County for combining custom SSIS packages for QIP Payor Data into one QIP master package.
  • Resource will recommend to the County the initial Claims Processing Update
  • Resource will recommend to the County the Claims Processing Update for Ongoing
  • Assessments no later than 10 business days following the Resource's assessment.
  • Resource will develop and test the solution to combine custom SSIS packages for QIP payor data into one QIP master package.
  • Resource will develop test and migrate the QIP eligible Claims processing to Epic standard Caboodle schemas.
  • Resource will develop and test the initial Claims Processing Update.
  • Throughout the Term, Resource will develop and test the Claims Processing Updates arising from the Ongoing Assessments no later than 30 business days following the County approving the Resource's recommendation.
  • On an ongoing basis during the term of the Work Order, Resource will collate source documents and prepare the documentation for each solution and save in the
  • County's Software Development Lifecycle repository for future reference by the County.
  • On an ongoing basis during the term of the Work Order, Resource will update reports, dashboards, and other outputs when workflow or application build changes occur to preserve the development history

Required Skills & Abilities:
  • Minimum 3 years of ETL development, at least one of which in the Epic domain a plus
  • Strong SQL development using best practice industry standards
  • Working knowledge of healthcare related financial and transactional files (including
  • billing, eligibility, claims)
  • Experience in building scalable data architecture
  • Experience in full data integration solutions with existing data architectures
  • Experience in importing from and to 3rd party agency or vendor data:
  • Experience designing, implementing, and maintaining sustainable, scalable ETL processes
  • Must be a self-starter comfortable working under general direction (opposed to active
  • supervision)
  • Ability to follow Enterprise Software Development Life Cycle standards for Unit Test, Peer
  • Test/Review, SME Validation and production migration and publishing.

Desired Skills & Abilities:
  • Strong Microsoft SSIS experience
  • Strong Microsoft SQL experience
  • Strong Caboodle development experience for both Epic and Non-Epic data
  • Strong Epic Clarity and Caboodle data model knowledge, including all financial aspects
  • as well as relevant clinical aspects that drive coding and billing
  • Healthcare financial data acumen

Certifications
  • Epic Clarity / Caboodle Data Model and Development Certification(s)Model/Clinical or Financial
  • (or legacy equivalents)

  • Data Warehouse ETL Developer and Administrator

    1 month ago

    San Jose, United States Impresiv Health Full time

    Title: Data Warehouse ETL Developer and Administrator (EPIC) Duration: 6 months Location: Remote Summary Resource will provide medical claims and payor data (eligibility, medical, vision, lab, pharmacy) Extract, Transform and Load (ETL) services using Structured Query Language (SQL) to: (1) migrate Claims processing from the County's custom schema to...

  • Data Warehouse ETL Architect

    2 weeks ago

    San Jose, California, United States Compu-Vision Consulting Full time

    Job Title: Senior ETL Developer and Administrator (Epic)About the Role:Compu-Vision Consulting is seeking an experienced ETL Developer and Administrator to join our team. As a key member of our consulting team, you will be responsible for designing, implementing, and maintaining scalable data architecture solutions using Epic standard Caboodle schemas.Key...

  • ETL Developer I

    6 months ago

    San Jose, United States ACL Digital Full time

    Title: ETL Developer I Location: San Jose, CA, Austin, TX, Salt Lake City, CA (Remote is fine) Job Description: The ETL Developer designs, codes, tests, documents and implements the data extraction, transformation, and loading of source data into innovative enterprise and clinical data warehouse solutions that support the business intelligence and...

  • Data Warehouse Specialist

    3 weeks ago

    San Jose, California, United States ACL Digital Full time

    Job Description:The ETL Developer designs, codes, tests, documents and implements the data extraction, transformation, and loading of source data into innovative enterprise and clinical data warehouse solutions that support the business intelligence and decision support systems needs. This role will work with written program specifications and requirements...

  • Senior ETL Developer and Administrator

    2 weeks ago

    San Jose, California, United States Compu-Vision Consulting Full time

    Epic ETL Developer and AdministratorAbout Compu-Vision Consulting:We are a leading consulting firm specializing in data warehousing and analytics. Our team of experts has extensive experience working with Epic systems and is passionate about delivering innovative solutions to our clients.Job Description:This role involves designing, implementing, and...

  • Epic Data Warehouse Developer

    2 weeks ago

    San Jose, California, United States Cystems Logic Full time

    OverviewCystems Logic is seeking an experienced Epic Data Warehouse Developer to join our team. This position requires a strong understanding of data modeling and extraction, transformation, and loading (ETL) processes.

  • Enterprise Data Warehouse Developer

    2 weeks ago

    San Francisco, California, United States ShiftCode Analytics Full time

    **Job Title:** Enterprise Data Warehouse Developer**Estimated Salary:** $120,000 - $150,000 per year based on experience and location.At ShiftCode Analytics, we are seeking a highly skilled Enterprise Data Warehouse Developer to join our team. In this role, you will be responsible for designing, developing, and implementing database architectures, data...

  • ETL/ELT developer

    2 weeks ago

    San Mateo, United States NR Consulting Full time

    Job Role: ETL/ELT developer Location: San Mateo, California Job type: Contract Duration: Long Term Tentative start date: ASAP Must have skills : Data Warehouse Design - General Experience, SQL (Strong), Snowflake Good to have skills: Informatica Job Description : 8+ years of ETL/ELT developer experience. Experience in SQL and manipulating large data sets...

  • ETL/ELT Developer

    7 days ago

    San Mateo, United States American Unit, Inc Full time

    ETL/ELT developerDay one Onsite -- San Mateo, CaliforniaContract - Long TermMust have skills: Data Warehouse Design - General Experience, SQL (Strong), Snowflake Good to have skills: Informatica Job Description : 8+ years of ETL/ELT developer experience.Experience in SQL and manipulating large data sets in a database.Experience with ELT development in...

  • ETL/ELT Developer

    7 days ago

    San Mateo, United States American Unit, Inc Full time

    ETL/ELT developerDay one Onsite -- San Mateo, CaliforniaContract - Long TermMust have skills: Data Warehouse Design - General Experience, SQL (Strong), Snowflake Good to have skills: Informatica Job Description : 8+ years of ETL/ELT developer experience.Experience in SQL and manipulating large data sets in a database.Experience with ELT development in...

  • Senior ETL Developer

    2 weeks ago

    San Francisco, California, United States Presidio Consulting Full time

    About the RoleWe are looking for a Senior ETL Developer to join our team at Presidio Consulting. As a Senior ETL Developer, you will be responsible for designing, implementing, and maintaining ETL processes using Azure Data Factory and Snowflake.The successful candidate will have extensive experience in ETL development, data integration, and migration. They...

  • Senior ETL Developer

    3 days ago

    San Mateo, United States Voto Consulting LLC Full time

    We are not accepting H1B for this role. Candidates Only Local to California are eligible to apply.Job Role - ETL/ELT developerExperience Range - 10-15 yrs expr.Location - San Mateo, California (Day One Onsite )Job type: Contract Duration: 6+ MonthsWork Status (Visa): (No 3rd party candidates, Candidate should be on your w2 and No OPT/CPT)Tentative start...

  • Senior ETL Developer

    3 days ago

    San Mateo, United States Voto Consulting LLC Full time

    We are not accepting H1B for this role. Candidates Only Local to California are eligible to apply.Job Role - ETL/ELT developerExperience Range - 10-15 yrs expr.Location - San Mateo, California (Day One Onsite )Job type: Contract Duration: 6+ MonthsWork Status (Visa): (No 3rd party candidates, Candidate should be on your w2 and No OPT/CPT)Tentative start...

  • ETL Developer

    4 weeks ago

    San Antonio, United States Diverse Lynx Full time

    Position: ETL Developer Location: San Antonio, TX (Onsite) Hire Type: Contract Experience: 5-12 years (min 5 years in Informatica Power Center + DWH Development ) IICS basic development/mig skills is a plus. ETL Development project for Data Warehouse program with a strong Sql and data analysis skills in either of ANSI db (Teradata, Oracle, Sql server etc)...

  • Enterprise Data Warehouse Specialist

    2 weeks ago

    San Francisco, California, United States ShiftCode Analytics Full time

    We are looking for a talented Enterprise Data Warehouse Specialist to join our team in Los Angeles, CA. As a Senior BI Engineer, you will be responsible for designing, developing, and implementing business intelligence solutions using Oracle Business Intelligence Publisher (BIP), OBIEE, and Tableau.The ideal candidate will have at least 5-7 years of...

  • Informatica ETL Developer

    2 weeks ago

    San Francisco, California, United States HexaQuEST Global, Inc. Full time

    At HexaQuEST Global, Inc., we are seeking a highly skilled Informatica ETL Developer to join our team. * The estimated salary for this role is around $110,000 - $130,000 per year, depending on experience and location. * As an ETL Developer, you will design, develop, and implement data integration processes using Informatica PowerCenter. * You will...

  • Cloud Database Developer and ETL Expert

    3 weeks ago

    San Antonio, Texas, United States SysMind Tech Full time

    Key ResponsibilitiesThe Data Engineer with Snowflake will be responsible for developing and enhancing software applications that support business units or supporting functions using IBM Infosphere Data Stage ETL or any other cloud-based ETL tool.This includes designing and implementing ETL processes for data transactions related to Enterprise Data Warehouse,...

  • Enterprise Data Integration Engineer

    2 weeks ago

    San Jose, California, United States ACL Digital Full time

    About the Role:We are seeking an experienced ETL Developer to join our team at ACL Digital. In this role, you will be responsible for designing, implementing, and maintaining complex ETL processes.Average Salary: $120,000 - $180,000 per yearThe successful candidate will have a strong background in data integration, experience with ETL tools, and excellent...

  • Senior ETL/ELT Developer

    2 weeks ago

    San Mateo, California, United States NR Consulting Full time

    About the Role:NR Consulting is seeking a highly skilled Senior ETL/ELT Developer to join our team in San Mateo, California. As a key member of our team, you will be responsible for designing, developing, and implementing ETL processes using Snowflake managed service. This is a long-term contract position with an ASAP start date, offering a competitive...

  • Cloud-Based ETL Development Expert

    2 weeks ago

    San Mateo, California, United States NR Consulting Full time

    Job Summary:NR Consulting is looking for a skilled Cloud-Based ETL Development Expert to join our team in San Mateo, California. As a critical member of our team, you will be responsible for designing, developing, and implementing ETL processes using Snowflake managed service. This is a long-term contract position with an ASAP start date, offering a...