AWS Data Architect (Redshift)
Background:
The Organization is currently implementing Oracle Cloud fusion Cloud Enterprise Resource Planning (ERP) and Human Resource Management System (HRMS) system.
This new system will replace the current system for processing, tracking and managing data for critical human resources, finance, and procurement transactions.
Objective:
The Organization is seeking an experienced data architect with expertise in the integration of Oracle Cloud ERP/HCM data to the existing Data Warehouse (AWS redshift).
Serve as a key interface between the Department of Technology and other departments and must have demonstrated the ability to communicate and discuss business issues with technical and non-technical audiences at all organizational levels.
Work closely with the technical manager and key stakeholders to implement data strategies and promote data management best practices for use across the organization.
Position
Responsibilities:
Develop database solutions to securely store and retrieve County information utilizing the Amazon Web Services, (AWS) data warehouse and data lake architecture.
Analyze structural requirements for new software and database systems.
Integrate data from Oracle Cloud Fusion (SaaS) to new cloud-based solutions in Perform ETL tasks to integrate data from multiple heterogeneous sources using Microsoft SQL Server and AWS Redshift.
Write stored procedures and queries to customize extraction procedures using Microsoft SQL Server and AWS Redshift.
Design conceptual and logical data models and flowcharts Establish and maintain data standards and data dictionary to promote consistent data exchange across various systems.
Optimize new and current database systems (distribution, relational, object-oriented, cloud, centralized databases) Position Requirements:
Proven work experience as a Data Architect, Data Scientist, Data Analyst, Data Engineer or similar role In-depth understanding of database structure principles (Entity database design, relational database, standard structure, database normalization) Experience gathering and analyzing system requirements.
Prior experience working in a software development team/environment.
Experience in cloud technologies, specifically AWS suite of services; specifically - Redshift, Glue, s3 Experience with FiveTran and DBT Experience in Machine Learning models a plus (AWS Sagemaker, Azure Machine Learning) Expertise in SQL is required.
Proficiency in MS Excel Familiarity with data visualization tools Microsoft PowerBI and required application security.
Proven analytical skills.
Self-starter with problem-solving skills ______________________________________________No Phone Calls PleasePlease send us your resume in a word file with contact details AWS Data Architect (Redshift) Recommended Skills Analytical Application Security Architecture Azure Machine Learning Cloud Technologies Data Dictionary Estimated Salary: $20 to $28 per hour based on qualifications.
The Organization is currently implementing Oracle Cloud fusion Cloud Enterprise Resource Planning (ERP) and Human Resource Management System (HRMS) system.
This new system will replace the current system for processing, tracking and managing data for critical human resources, finance, and procurement transactions.
Objective:
The Organization is seeking an experienced data architect with expertise in the integration of Oracle Cloud ERP/HCM data to the existing Data Warehouse (AWS redshift).
Serve as a key interface between the Department of Technology and other departments and must have demonstrated the ability to communicate and discuss business issues with technical and non-technical audiences at all organizational levels.
Work closely with the technical manager and key stakeholders to implement data strategies and promote data management best practices for use across the organization.
Position
Responsibilities:
Develop database solutions to securely store and retrieve County information utilizing the Amazon Web Services, (AWS) data warehouse and data lake architecture.
Analyze structural requirements for new software and database systems.
Integrate data from Oracle Cloud Fusion (SaaS) to new cloud-based solutions in Perform ETL tasks to integrate data from multiple heterogeneous sources using Microsoft SQL Server and AWS Redshift.
Write stored procedures and queries to customize extraction procedures using Microsoft SQL Server and AWS Redshift.
Design conceptual and logical data models and flowcharts Establish and maintain data standards and data dictionary to promote consistent data exchange across various systems.
Optimize new and current database systems (distribution, relational, object-oriented, cloud, centralized databases) Position Requirements:
Proven work experience as a Data Architect, Data Scientist, Data Analyst, Data Engineer or similar role In-depth understanding of database structure principles (Entity database design, relational database, standard structure, database normalization) Experience gathering and analyzing system requirements.
Prior experience working in a software development team/environment.
Experience in cloud technologies, specifically AWS suite of services; specifically - Redshift, Glue, s3 Experience with FiveTran and DBT Experience in Machine Learning models a plus (AWS Sagemaker, Azure Machine Learning) Expertise in SQL is required.
Proficiency in MS Excel Familiarity with data visualization tools Microsoft PowerBI and required application security.
Proven analytical skills.
Self-starter with problem-solving skills ______________________________________________No Phone Calls PleasePlease send us your resume in a word file with contact details AWS Data Architect (Redshift) Recommended Skills Analytical Application Security Architecture Azure Machine Learning Cloud Technologies Data Dictionary Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
