Data Systems Analyst

  • location: Sacramento, CA
  • type: Permanent
  • salary: $65,000 - $78,000 per year
easy apply

job description

Data Systems Analyst

job summary:
Our client is seeking a Data Systems Analyst for a Direct-Hire role with our client in Sacramento.

The Data Systems Analyst 3 is an experienced Information Technology Professional; responsible for investigating, designing, and implementing data systems in preparation for assigned projects and/or for use within clinical research. This position is responsible for the maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more. The Data Systems Analyst 3 also manages data source acquisition, ETL (extract, transform, and load) processes, and application development for a variety of projects. This position creates and supports reports for multiple clinical data systems including Epic/Clarity, Velos eResearch, REDCap, SQL, and Oracle databases. A degree in Health Informatics, Public Health, or Computer Science is preferred.

Incumbent interacts with operating systems and data management systems, and has independent responsibility for clinical data warehousing applications related t assigned projects and associated grants; developing and maintaining interfaces with separate data systems; and provides specification development for each component of the project infrastructure. This position will work with Health System and Clinical and Translation Science Center data management applications, which may include REDCap, J2EE, Java, Oracle, SQL Server, various open-source applications, and select vendor and custom interface engines. This position also serves as the lead project manager on specific projects.

  • Experience with the following is mandatory:

    • Maintenance and support of Clinical Trials Management Systems, Biorepositories , Faculty Profile Management Systems, Investigational Drug Management Systems, or other clinical system.
    • Analyzing and evaluating specifications; and then designing and creating custom SQL code to meet objectives.
    • SQL, PL/SQL, SAS, or MySQL
    • Data integration, data repository design, and management of enterprise data repository systems.
    • Extract, Transform, and Load (ETL)
    • Writing Stored Procedures.
    • Electronic health record systems, such as EPIC
    • Data management, data security and privacy within clinical systems
    • Developing and designing technical requirements appropriate to the business needs and objectives.
    • Experienced in developing reporting and analytics for internal and external use in a business unit.
    • View Creation /Report Writing
    • Writing skills needed to translate system processes and associated manual processes into clear instructions and explanations.
    • Demonstrated organizational skills and flexibility to manage multiple tasks and meet deadlines.
    • Developing innovative coding solutions and design requirements to resolve complex business issues.
    • Interpersonal, verbal and written communication skills to clearly and effectively interact with a diverse group of individuals to secure and/or provide information to clarify situations, resolve problems, and negotiate services and/or agreements.
  • Experience with the following is preferred:

    • Data interface engines in an enterprise environment
    • Clinical ontologies and semantics
    • Past experience developing, implementing and supporting data warehouses.
    • REDCap
    • LINUX / UNIX Operating System
    • Relational Database Design and Theory
    • Medical Terminologies
    • Working knowledge and application of HIPAA
    • Degree in Health Informatics, Bioinformatics, Public Health, or related field.
Application, Software, and System Analysis and Development:

  • Maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more.
  • Acquire, store, retrieve and curate healthcare data for interoperability between disparate systems and applications.
  • Extract, Transform, and Load (ETL) data to a large data repository from a variety of sources including Epic, Clarity, Meditech, REDCap, and other systems.
  • Identify, organize, implement, customize, harmonize, and maintain clinical data for reuse on specific projects.
  • Strengthen data management services, data mining, and reporting opportunities.
  • Design and build applications to fit project needs using available software products and tools, and recommending new software products or tools as required.
  • Perform database development including graphical user interface development, transaction processing, and communication protocols.
  • Assist in the development of security policies, standards and procedures, authorize access to protected data, and report and investigate security violations.
  • Document system flow using system analysis tools.
  • Specify major functions to be performed by the system and indicate how the system will be integrated with other systems.
  • Install, configure, test, and maintain application systems, operation systems, software packages, application suites, and communication software and methodologies in a heterogeneous environment.
  • Validate appropriateness of system features with users. Modify and rebuild system features as necessary.
  • Work closely with both vendor software support personnel and the open-source community to resolve software problems.
  • Create reports as necessary using appropriate reporting tools
  • Modify database and software code using a variety of programming tools, languages, and frameworks such as Oracle, J2EE, XML, SQL, Excel
  • Assist in application & system planning, procurement, installation, inventory control, and backup.
Database Administration:

  • Knowledge of data system design, monitoring techniques, and approaches to fine-tuning data systems to assure optimal performance.
  • Investigate, document, and implement application, data interchange, and data interaction processes to ensure efficiency and effectiveness of clinical data storage, access, and utilization
  • Knowledge of data repository installation and upgrade procedures on production and development servers
  • Import and export data to and from external and internal systems using appropriate tools and methodology.
Project Manager:

  • Manage vendor installations of application software/hardware.
  • Define requirements for performing system testing and installation.
  • Develop validation, performance, and acceptance criteria.
  • Identify the process for code design and program testing.
  • Identify and list project objectives and development phases.
  • Identify activity dependencies and develop project activity schedule.
  • Estimate hours needed to complete phased system development.
  • List major activities to be performed during each phase of the project development cycle
  • Consult with various users (clinician, educator, and administrator) to determine the best methods for providing required information relevant to data storage systems.
User Support, Training:

  • Assist users in mining and conversion of data to and from foreign computer systems and between different media types or data formats.
  • Identify methods and processes needed for documenting system and programs.
  • Assist in documentation, management, and inventory of technical equipment, shipping and receiving, coordination of equipment moves, etc.
  • Provide end user training
  • Other duties as assigned
 
location: Sacramento, California
job type: Permanent
salary: $65,000 - 78,000 per year
work hours: 8am to 5pm
education: Bachelors
 
responsibilities:
Our client is seeking a Data Systems Analyst for a Direct-Hire role with our client in Sacramento.

The Data Systems Analyst 3 is an experienced Information Technology Professional; responsible for investigating, designing, and implementing data systems in preparation for assigned projects and/or for use within clinical research. This position is responsible for the maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more. The Data Systems Analyst 3 also manages data source acquisition, ETL (extract, transform, and load) processes, and application development for a variety of projects. This position creates and supports reports for multiple clinical data systems including Epic/Clarity, Velos eResearch, REDCap, SQL, and Oracle databases. A degree in Health Informatics, Public Health, or Computer Science is preferred.

Incumbent interacts with operating systems and data management systems, and has independent responsibility for clinical data warehousing applications related t assigned projects and associated grants; developing and maintaining interfaces with separate data systems; and provides specification development for each component of the project infrastructure. This position will work with Health System and Clinical and Translation Science Center data management applications, which may include REDCap, J2EE, Java, Oracle, SQL Server, various open-source applications, and select vendor and custom interface engines. This position also serves as the lead project manager on specific projects.

  • Experience with the following is mandatory:

    • Maintenance and support of Clinical Trials Management Systems, Biorepositories , Faculty Profile Management Systems, Investigational Drug Management Systems, or other clinical system.
    • Analyzing and evaluating specifications; and then designing and creating custom SQL code to meet objectives.
    • SQL, PL/SQL, SAS, or MySQL
    • Data integration, data repository design, and management of enterprise data repository systems.
    • Extract, Transform, and Load (ETL)
    • Writing Stored Procedures.
    • Electronic health record systems, such as EPIC
    • Data management, data security and privacy within clinical systems
    • Developing and designing technical requirements appropriate to the business needs and objectives.
    • Experienced in developing reporting and analytics for internal and external use in a business unit.
    • View Creation /Report Writing
    • Writing skills needed to translate system processes and associated manual processes into clear instructions and explanations.
    • Demonstrated organizational skills and flexibility to manage multiple tasks and meet deadlines.
    • Developing innovative coding solutions and design requirements to resolve complex business issues.
    • Interpersonal, verbal and written communication skills to clearly and effectively interact with a diverse group of individuals to secure and/or provide information to clarify situations, resolve problems, and negotiate services and/or agreements.
  • Experience with the following is preferred:

    • Data interface engines in an enterprise environment
    • Clinical ontologies and semantics
    • Past experience developing, implementing and supporting data warehouses.
    • REDCap
    • LINUX / UNIX Operating System
    • Relational Database Design and Theory
    • Medical Terminologies
    • Working knowledge and application of HIPAA
    • Degree in Health Informatics, Bioinformatics, Public Health, or related field.
Application, Software, and System Analysis and Development:

  • Maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more.
  • Acquire, store, retrieve and curate healthcare data for interoperability between disparate systems and applications.
  • Extract, Transform, and Load (ETL) data to a large data repository from a variety of sources including Epic, Clarity, Meditech, REDCap, and other systems.
  • Identify, organize, implement, customize, harmonize, and maintain clinical data for reuse on specific projects.
  • Strengthen data management services, data mining, and reporting opportunities.
  • Design and build applications to fit project needs using available software products and tools, and recommending new software products or tools as required.
  • Perform database development including graphical user interface development, transaction processing, and communication protocols.
  • Assist in the development of security policies, standards and procedures, authorize access to protected data, and report and investigate security violations.
  • Document system flow using system analysis tools.
  • Specify major functions to be performed by the system and indicate how the system will be integrated with other systems.
  • Install, configure, test, and maintain application systems, operation systems, software packages, application suites, and communication software and methodologies in a heterogeneous environment.
  • Validate appropriateness of system features with users. Modify and rebuild system features as necessary.
  • Work closely with both vendor software support personnel and the open-source community to resolve software problems.
  • Create reports as necessary using appropriate reporting tools
  • Modify database and software code using a variety of programming tools, languages, and frameworks such as Oracle, J2EE, XML, SQL, Excel
  • Assist in application & system planning, procurement, installation, inventory control, and backup.
Database Administration:

  • Knowledge of data system design, monitoring techniques, and approaches to fine-tuning data systems to assure optimal performance.
  • Investigate, document, and implement application, data interchange, and data interaction processes to ensure efficiency and effectiveness of clinical data storage, access, and utilization
  • Knowledge of data repository installation and upgrade procedures on production and development servers
  • Import and export data to and from external and internal systems using appropriate tools and methodology.
Project Manager:

  • Manage vendor installations of application software/hardware.
  • Define requirements for performing system testing and installation.
  • Develop validation, performance, and acceptance criteria.
  • Identify the process for code design and program testing.
  • Identify and list project objectives and development phases.
  • Identify activity dependencies and develop project activity schedule.
  • Estimate hours needed to complete phased system development.
  • List major activities to be performed during each phase of the project development cycle
  • Consult with various users (clinician, educator, and administrator) to determine the best methods for providing required information relevant to data storage systems.
User Support, Training:

  • Assist users in mining and conversion of data to and from foreign computer systems and between different media types or data formats.
  • Identify methods and processes needed for documenting system and programs.
  • Assist in documentation, management, and inventory of technical equipment, shipping and receiving, coordination of equipment moves, etc.
  • Provide end user training
  • Other duties as assigned
 
qualifications:
Our client is seeking a Data Systems Analyst for a Direct-Hire role with our client in Sacramento.

The Data Systems Analyst 3 is an experienced Information Technology Professional; responsible for investigating, designing, and implementing data systems in preparation for assigned projects and/or for use within clinical research. This position is responsible for the maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more. The Data Systems Analyst 3 also manages data source acquisition, ETL (extract, transform, and load) processes, and application development for a variety of projects. This position creates and supports reports for multiple clinical data systems including Epic/Clarity, Velos eResearch, REDCap, SQL, and Oracle databases. A degree in Health Informatics, Public Health, or Computer Science is preferred.

Incumbent interacts with operating systems and data management systems, and has independent responsibility for clinical data warehousing applications related t assigned projects and associated grants; developing and maintaining interfaces with separate data systems; and provides specification development for each component of the project infrastructure. This position will work with Health System and Clinical and Translation Science Center data management applications, which may include REDCap, J2EE, Java, Oracle, SQL Server, various open-source applications, and select vendor and custom interface engines. This position also serves as the lead project manager on specific projects.

  • Experience with the following is mandatory:

    • Maintenance and support of Clinical Trials Management Systems, Biorepositories , Faculty Profile Management Systems, Investigational Drug Management Systems, or other clinical system.
    • Analyzing and evaluating specifications; and then designing and creating custom SQL code to meet objectives.
    • SQL, PL/SQL, SAS, or MySQL
    • Data integration, data repository design, and management of enterprise data repository systems.
    • Extract, Transform, and Load (ETL)
    • Writing Stored Procedures.
    • Electronic health record systems, such as EPIC
    • Data management, data security and privacy within clinical systems
    • Developing and designing technical requirements appropriate to the business needs and objectives.
    • Experienced in developing reporting and analytics for internal and external use in a business unit.
    • View Creation /Report Writing
    • Writing skills needed to translate system processes and associated manual processes into clear instructions and explanations.
    • Demonstrated organizational skills and flexibility to manage multiple tasks and meet deadlines.
    • Developing innovative coding solutions and design requirements to resolve complex business issues.
    • Interpersonal, verbal and written communication skills to clearly and effectively interact with a diverse group of individuals to secure and/or provide information to clarify situations, resolve problems, and negotiate services and/or agreements.
  • Experience with the following is preferred:

    • Data interface engines in an enterprise environment
    • Clinical ontologies and semantics
    • Past experience developing, implementing and supporting data warehouses.
    • REDCap
    • LINUX / UNIX Operating System
    • Relational Database Design and Theory
    • Medical Terminologies
    • Working knowledge and application of HIPAA
    • Degree in Health Informatics, Bioinformatics, Public Health, or related field.
Application, Software, and System Analysis and Development:

  • Maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more.
  • Acquire, store, retrieve and curate healthcare data for interoperability between disparate systems and applications.
  • Extract, Transform, and Load (ETL) data to a large data repository from a variety of sources including Epic, Clarity, Meditech, REDCap, and other systems.
  • Identify, organize, implement, customize, harmonize, and maintain clinical data for reuse on specific projects.
  • Strengthen data management services, data mining, and reporting opportunities.
  • Design and build applications to fit project needs using available software products and tools, and recommending new software products or tools as required.
  • Perform database development including graphical user interface development, transaction processing, and communication protocols.
  • Assist in the development of security policies, standards and procedures, authorize access to protected data, and report and investigate security violations.
  • Document system flow using system analysis tools.
  • Specify major functions to be performed by the system and indicate how the system will be integrated with other systems.
  • Install, configure, test, and maintain application systems, operation systems, software packages, application suites, and communication software and methodologies in a heterogeneous environment.
  • Validate appropriateness of system features with users. Modify and rebuild system features as necessary.
  • Work closely with both vendor software support personnel and the open-source community to resolve software problems.
  • Create reports as necessary using appropriate reporting tools
  • Modify database and software code using a variety of programming tools, languages, and frameworks such as Oracle, J2EE, XML, SQL, Excel
  • Assist in application & system planning, procurement, installation, inventory control, and backup.
Database Administration:

  • Knowledge of data system design, monitoring techniques, and approaches to fine-tuning data systems to assure optimal performance.
  • Investigate, document, and implement application, data interchange, and data interaction processes to ensure efficiency and effectiveness of clinical data storage, access, and utilization
  • Knowledge of data repository installation and upgrade procedures on production and development servers
  • Import and export data to and from external and internal systems using appropriate tools and methodology.
Project Manager:

  • Manage vendor installations of application software/hardware.
  • Define requirements for performing system testing and installation.
  • Develop validation, performance, and acceptance criteria.
  • Identify the process for code design and program testing.
  • Identify and list project objectives and development phases.
  • Identify activity dependencies and develop project activity schedule.
  • Estimate hours needed to complete phased system development.
  • List major activities to be performed during each phase of the project development cycle
  • Consult with various users (clinician, educator, and administrator) to determine the best methods for providing required information relevant to data storage systems.
User Support, Training:

  • Assist users in mining and conversion of data to and from foreign computer systems and between different media types or data formats.
  • Identify methods and processes needed for documenting system and programs.
  • Assist in documentation, management, and inventory of technical equipment, shipping and receiving, coordination of equipment moves, etc.
  • Provide end user training
  • Other duties as assigned
 
skills: Our client is seeking a Data Systems Analyst for a Direct-Hire role with our client in Sacramento.

The Data Systems Analyst 3 is an experienced Information Technology Professional; responsible for investigating, designing, and implementing data systems in preparation for assigned projects and/or for use within clinical research. This position is responsible for the maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more. The Data Systems Analyst 3 also manages data source acquisition, ETL (extract, transform, and load) processes, and application development for a variety of projects. This position creates and supports reports for multiple clinical data systems including Epic/Clarity, Velos eResearch, REDCap, SQL, and Oracle databases. A degree in Health Informatics, Public Health, or Computer Science is preferred.

Incumbent interacts with operating systems and data management systems, and has independent responsibility for clinical data warehousing applications related t assigned projects and associated grants; developing and maintaining interfaces with separate data systems; and provides specification development for each component of the project infrastructure. This position will work with Health System and Clinical and Translation Science Center data management applications, which may include REDCap, J2EE, Java, Oracle, SQL Server, various open-source applications, and select vendor and custom interface engines. This position also serves as the lead project manager on specific projects.

  • Experience with the following is mandatory:

    • Maintenance and support of Clinical Trials Management Systems, Biorepositories , Faculty Profile Management Systems, Investigational Drug Management Systems, or other clinical system.
    • Analyzing and evaluating specifications; and then designing and creating custom SQL code to meet objectives.
    • SQL, PL/SQL, SAS, or MySQL
    • Data integration, data repository design, and management of enterprise data repository systems.
    • Extract, Transform, and Load (ETL)
    • Writing Stored Procedures.
    • Electronic health record systems, such as EPIC
    • Data management, data security and privacy within clinical systems
    • Developing and designing technical requirements appropriate to the business needs and objectives.
    • Experienced in developing reporting and analytics for internal and external use in a business unit.
    • View Creation /Report Writing
    • Writing skills needed to translate system processes and associated manual processes into clear instructions and explanations.
    • Demonstrated organizational skills and flexibility to manage multiple tasks and meet deadlines.
    • Developing innovative coding solutions and design requirements to resolve complex business issues.
    • Interpersonal, verbal and written communication skills to clearly and effectively interact with a diverse group of individuals to secure and/or provide information to clarify situations, resolve problems, and negotiate services and/or agreements.
  • Experience with the following is preferred:

    • Data interface engines in an enterprise environment
    • Clinical ontologies and semantics
    • Past experience developing, implementing and supporting data warehouses.
    • REDCap
    • LINUX / UNIX Operating System
    • Relational Database Design and Theory
    • Medical Terminologies
    • Working knowledge and application of HIPAA
    • Degree in Health Informatics, Bioinformatics, Public Health, or related field.
Application, Software, and System Analysis and Development:

  • Maintenance and support of applications and tools such as Clinical Trials Management Systems (Velos eResearch, REDCap), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more.
  • Acquire, store, retrieve and curate healthcare data for interoperability between disparate systems and applications.
  • Extract, Transform, and Load (ETL) data to a large data repository from a variety of sources including Epic, Clarity, Meditech, REDCap, and other systems.
  • Identify, organize, implement, customize, harmonize, and maintain clinical data for reuse on specific projects.
  • Strengthen data management services, data mining, and reporting opportunities.
  • Design and build applications to fit project needs using available software products and tools, and recommending new software products or tools as required.
  • Perform database development including graphical user interface development, transaction processing, and communication protocols.
  • Assist in the development of security policies, standards and procedures, authorize access to protected data, and report and investigate security violations.
  • Document system flow using system analysis tools.
  • Specify major functions to be performed by the system and indicate how the system will be integrated with other systems.
  • Install, configure, test, and maintain application systems, operation systems, software packages, application suites, and communication software and methodologies in a heterogeneous environment.
  • Validate appropriateness of system features with users. Modify and rebuild system features as necessary.
  • Work closely with both vendor software support personnel and the open-source community to resolve software problems.
  • Create reports as necessary using appropriate reporting tools
  • Modify database and software code using a variety of programming tools, languages, and frameworks such as Oracle, J2EE, XML, SQL, Excel
  • Assist in application & system planning, procurement, installation, inventory control, and backup.
Database Administration:

  • Knowledge of data system design, monitoring techniques, and approaches to fine-tuning data systems to assure optimal performance.
  • Investigate, document, and implement application, data interchange, and data interaction processes to ensure efficiency and effectiveness of clinical data storage, access, and utilization
  • Knowledge of data repository installation and upgrade procedures on production and development servers
  • Import and export data to and from external and internal systems using appropriate tools and methodology.
Project Manager:

  • Manage vendor installations of application software/hardware.
  • Define requirements for performing system testing and installation.
  • Develop validation, performance, and acceptance criteria.
  • Identify the process for code design and program testing.
  • Identify and list project objectives and development phases.
  • Identify activity dependencies and develop project activity schedule.
  • Estimate hours needed to complete phased system development.
  • List major activities to be performed during each phase of the project development cycle
  • Consult with various users (clinician, educator, and administrator) to determine the best methods for providing required information relevant to data storage systems.
User Support, Training:

  • Assist users in mining and conversion of data to and from foreign computer systems and between different media types or data formats.
  • Identify methods and processes needed for documenting system and programs.
  • Assist in documentation, management, and inventory of technical equipment, shipping and receiving, coordination of equipment moves, etc.
  • Provide end user training
  • Other duties as assigned

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Data Entry Operator

  • location: Rancho Cordova, CA
  • job type: Temp to Perm
  • salary: $11 - $12 per hour
  • date posted: 1/24/2019