Data Warehouse Operations Analyst

Location: Philadelphia, PA, United States
Date Posted: 12-13-2017
Position Role/Tile:Data Warehouse Operations Analyst
Location: Philadelphia, PA.

  • Performs technical administration duties for Data Warehouse (DW) development and maintenance.
  • Provides technical support and coordination during warehouse design, testing and movement to production.
  • Develops and implement scripts to automate end-to-end DW/Data Mart system processes; involves in systems and databases automation, optimization, scheduling and access provisioning.
  • Acts as a liaison between data engineers, data architects, ETL developers, IT infrastructure leads, DBA's, BI developers and business analysts. Implements and enforces standards and procedures to ensure data is managed consistently and properly integrated within the warehouse.
  • Implements business rules via stored procedures, middleware, or other technologies. Involved in the design, implementation and maintenance of data access and control processes. Responsible for the management of end-to-end data inbound and outbound file generation and access control.

  • Responsibilities:
  • Design, implement and operate comprehensive data warehouse systems to optimize data access and data load. Ensure our data repositories are optimized to support business needs.
  • Automate and build reliable and reusable scripts to integration DW operations including source data management, ETL and data transfer.
  • Maintain data warehouse operational processes and frameworks.
  • Involved in execution of DW project plan and scripts for data warehouse testing, from unit to integration testing.
  • Create and maintain supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Maintain warehouse database structures and access control.
  • Work with system administrators, DBA's to ensure proper security design, integration and support of the DW and Data Mart environments.
  • Work with Data modelers, DBA's, Data Governance and Production support teams to perform data and system check out after data or system refreshes.
  • Qualifications:
  • 2 to 4 years of related experience in Data Warehouse or systems operations.
  • Understanding of healthcare data and EMR system (EPIC) is a plus.

Central Business Solutions, Inc,
37600 Central Ct.
Suite #214
Newark, CA 94560.
Central Business Solutions, Inc(A Certified Minority Owned Organization)
Checkout our excellent assessment tool:
Checkout our job board :
Central Business Solutions, Inc
37600 Central Court Suite 214 Newark CA, 94560
Phone: (510)-713-9900, 510-573-5500 Fax: (510)-740-3677
this job portal is powered by CATS