Job Description

Data Warehouse Analyst, Remote CA

Location:

REMOTECalifornia

Date Posted:

7/11/2024

Employment Type:

Consulting

Recruiter:

Mara Liwag

Recruiter Email:

mara.liwag@avidtr.com

Job ID:

JN -072024-16014

Job Description

Requirements 
Developer Support
  • Works with developers to deploy Extract, Transform, Load (ETL) jobs in our enterprise data warehouse from Development to Test and from Test to Production environments. 
  • Acts as an MS Integration Services administrator, ensuring ETL standards and guidelines are enforced. 
  • Troubleshoots issues with developers during deployment. 
  • Administers data replication tools e.g. AWS Data Migration Service (DMS) to create/sync and maintain new assets in the enterprise data warehouse.
Systems Administration 
  • Responsible for Database administration duties, day to day monitoring of backups/CPU/storage growth. 
  • Capacity planning and forecasting the future growth in AWS and on-premises systems. 
  • Automates administration tasks
  • Coordinates with client Secure Enterprise Cloud (SEC) team to incorporate services from Amazon Web Services into the suite of tools available for SEC hosted environments for client.
User Support and Team Collaboration
  • Manages user provisioning and maintaining the ServiceNow queue of access requests. 
  • Creates new databases and implements security in accordance with data compliance standards. 
  • Designs solutions which are scalable
  • Implements frameworks which are flexible to adapt for future changes. 
Pay rate is based on experience-open to market rates
Apply for this job