Remote Job For Enterprise Data Warehouse (EDW) Architect

01 Dec 2024

Vacancy expired!

Remote Job For Enterprise Data Warehouse (EDW) Architect

Los Angeles, CA- Remote

Required Qualifications:
  • Experience in building at least one particular domain, vertical or platform: DevOps, Big Data, Machine Learning, Serverless computing on AWS
  • Creating, architecting, dimensioning, maintaining and managing Hadoop clusters
  • Active knowledge of ETL processes using highly parallel technologies and implementing ETL/data pipelines
  • Expertise with data and information architecture patterns and implementation approaches for Operational Data Stores, Data Warehouses, Data Marts and Data Lakes
  • Relational DBA experience, preferably with experience in SQLServer and/or Oracle, including Data modeling
  • REMEMBER: The ideal candidate will have experience with Big Data, ETL Development (Talend preferred) over SQL DBA support experience. This roll is a true cross-over of Big Data platform support and DBA duties. DBA experience secondary to Big Data / ETL development experience!

Minimum Education:

Bachelor’s degree required

Job Summary:The key responsibility of this role is to create architecture, processes, procedures & protocols to support the full life cycle of the data of Keck’s Analytics platform leveraging appropriate technologies. Design the Implementation of Keck’s Data governance processes and protocols to secure and provision data at rest and in motion.
  • 11 -15 years of relevant experience including programming in data modeling, OLAP, Hadoop, Cloudera, Talend, RDBMS, NoSQL, enterprise data warehouse projects.
  • 2+ years of experience with detailed knowledge of Enterprise Information architectures & Data Governance implementation
  • 2+ years in Design of data infrastructure components for the complete data life cycle
  • Experience with Structured Query Language (MS SQL Server, Oracle) required
  • Requires a maturing level of analytical ability to find solutions to increasingly difficult technical or to determine economic feasibility or options available, and to nothing related to supervisory or leads assess time involved in system changes.
  • Must be able to demonstrate experience with RDBMS, NoSQL, Hadoop
  • Requires hands-on expertise in programming with database services.

Duties:
  • Provide production support, solutions, and expertise for Cloud Database Platforms
  • Partner with engineering teams, business units to design, develop and deploy AWS Relational, NoSQL, and Data Lake solutions
  • Ability to troubleshoot difficult issues quickly, deliver RCA and resolve in a 24x7 production environment
  • Support performance testing and application benchmarking activities
  • Provide recommendations and guidance for improvements of our design
  • Collect, monitor and alert on system health metrics
  • Covid Vaccination is required

  • ID: #23702724
  • State: California Los angeles 90001 Los angeles USA
  • City: Los angeles
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-12-01
  • Deadline: 2022-01-23
  • Category: Et cetera