Demo

Senior Jiva ETL Developer

Impresiv Health
Fairfield, CA Full Time
POSTED ON 3/3/2025
AVAILABLE BEFORE 5/13/2025

Title : Senior Jiva ETL Developer

Duration : 1 year

Location : Remote

Summary

The Senior Data Warehouse ETL Developer is responsible for the development of all processes necessary to complete all phases of the Enterprise Data Warehouse (EDW). This includes source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution, schema mapping, data enrichment, and data governance.

You Will Be Successful If :

  • Lead ETL resource on new ETL development for the Data Warehouse.
  • Responsible for the entire flow of the data into the Data Warehouse.
  • Develops and maintains in-depth understanding of SQL Server, Oracle, BusinessObjects, Access databases, and Analysis Services.
  • Responsible for developing SSIS packages used in the Extract, Transform, and Load (ETL) processes for EDW.
  • Provides guidance for all Master Data Management (MDM) aspects involved in the development of the EDW.
  • Responsible for understanding all development in the area of MDM and ETL.
  • Responsible for the transition of documentation, security, development, and testing of all procedures in the EDW.
  • Responsible for coordination with other departments regarding consistency and accuracy of data.
  • Works with Web Team on development and coordination of ETL and other processes.
  • Uses sound technical judgment and makes appropriate systems decisions in absence of the Associate Director, Data Warehouse and Architecture.
  • Responsible for training new staff on ETL architecture, ETL standards, and ETL documentation.
  • Responsible for the coordination of the production, development, and sandbox environments.
  • Designs, develops, tests, and supports client server applications using C# and ASP.NET
  • Experience in working with .NET Web Services, WCF framework and Web API using WSDL, SOAP and UDDI.
  • Performs other tasks necessary to ensure integrity of eCommerce / AMYSIS databases and the accuracy of reporting data.
  • Leads and participates in special projects as needed and assigned.

You Will Be Successful If :

  • Ability to quickly acquire in-depth knowledge of new systems and software configuration at PHC. Strong written and oral communication skills with ability to interpret and understand technical requirements.
  • Excellent analytical skills to troubleshoot and resolve systems problems.
  • Able to develop procedures to automate jobs and to document extensively and clearly. Good client relations skills.
  • More than 50% of work time is spent in front of a computer monitor.
  • May be required to bend, stoop, kneel, crawl, or work in other nonstanding and non-sitting positions to install cabling, systems hardware, and other related equipment.
  • Provide the highest possible level of service to clients.
  • Promote teamwork and cooperative effort among employees.
  • Maintain safe practices.
  • Abide by the HealthPlan's policies and procedures, as they may from time to time be updated.
  • What You Will Bring :

  • Bachelor's degree in Computer Science, Business, or related field required.
  • Minimum four (4) years of systems analysis experience with experience in medical information systems; or equivalent combination of education and experience.
  • Extensive experience working with Jiva required.
  • Previous experience working with HealthRules Payer (HRP) is a plus.
  • Knowledge of databases (SQL Server, BusinessObjects, Access, SSIS, normalization, queries, views).
  • Some knowledge of Oracle and Oracle programming methodologies. Knowledge of data warehousing, data marts, OLAP, ROLAP, MOLAP, etc. Ability to move data between systems as needed, effortlessly.
  • High standards for data presentation.
  • Significant knowledge of PCs, Windows 2000, and related applications.

  • Understanding of systems and related systems interfaces and how changes impact various systems.
  • About Impresiv Health :

    Impresiv Health is a healthcare consulting partner specializing in clinical & operations management, enterprise project management, professional services, and software consulting services. We help our clients increase operational efficiency by delivering innovative solutions to solve their most complex business challenges.

    Our approach is and has always been simple. First, think and act like the customers who need us, and most importantly, deliver what larger organizations cannot do – provide tangible results that add immediate About Impresiv Health value, at a rate that cannot be beaten. Your success matters, and we know it.

    That's Impresiv!

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior Jiva ETL Developer?

    Sign up to receive alerts about other jobs on the Senior Jiva ETL Developer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Impresiv Health

    Impresiv Health
    Hired Organization Address Fairfield, CA Full Time
    Job Title : Manager of IT Change Control Location : Hybrid, must live in or around Fairfield, CA Job Type : Full-time, A...
    Impresiv Health
    Hired Organization Address Orange, CA Full Time
    Title : Data Warehouse Reporting Analyst Senior (Power BI Developer) Duration : up to 6 months Compensation : $48.03-$76...
    Impresiv Health
    Hired Organization Address Fairfield, CA Full Time
    Job Title: HealthRules Payor Project Manager Location: Remote Job Type: Contract Duration: until 12/31/25 Job Summary: W...
    Impresiv Health
    Hired Organization Address Mountlake Terrace, WA Full Time
    Title : Jiva Configuration Analyst Location : Remote, must work PST standard business hours Description : The Jiva Confi...

    Not the job you're looking for? Here are some other Senior Jiva ETL Developer jobs in the Fairfield, CA area that may be a better fit.

    Senior Jiva Project Manager

    Impresiv Health, Fairfield, CA

    Senior Data Warehouse ETL Developer

    Impresiv Health, Fairfield, CA

    AI Assistant is available now!

    Feel free to start your new journey!