Data Modeler (Oracle, Teradata, Data Warehouse, AWS/Azure)
Posted 1 day ago by 1763547291
Negotiable
Outside
Remote
USA
Summary: The Data Modeler role focuses on designing, developing, and maintaining data-driven systems that support customer and loyalty data across cloud-based platforms. The position requires extensive experience in data modeling, SQL tuning, and integrating security practices to ensure scalable solutions. The role is remote, specifically for candidates located in the USA, and involves collaboration with a technical team on various applications and services. Candidates should have a strong background in data warehousing and cloud technologies, particularly AWS and Azure.
Key Responsibilities:
- Design, develop, and maintain data-driven systems for customer and loyalty data.
- Perform data modeling and SQL tuning to optimize performance.
- Integrate security practices into data solutions to ensure scalability and alignment with business needs.
- Collaborate with analysts, engineers, and technical leaders on applications and services.
- Utilize technologies such as Restful APIs, AWS Cloud, React, Oracle, and Teradata.
Key Skills:
- 5+ years of experience in Data Modeling design.
- Proficiency in Teradata and data warehousing environments.
- Strong SQL development skills, including complex SQL tuning and analysis (Oracle - PL/SQL).
- Experience with AWS/Azure for data integration and deployment.
- Java API development experience.
- Knowledge of NoSQL databases and Big Data tools.
- Excellent communication and collaboration skills.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Data Modeler (Oracle, Teradata, Data Warehouse, AWS/Azure)
|
Client |
Enterprise Rent A Car |
|
Work |
REMOTE - work from home (must be in the USA) |
|
Client Location |
St. Louis, MO (working hours are CST - Central time) |
|
Term |
1 year |
|
Work Status |
(no other status allowed) |
|
|
Required
- 5+ years of experience in Data Modeling design
- Teradata, DDL statements, data warehousing environments
- SQL development, complex SQL tuning and analysis (Oracle - PL/SQL)
- AWS / Azure, for data integration and deployment.
- integrating security practices to ensure high-performance, scalable solutions aligned with business needs.
- Java API development
Preferred
- build automation tools (Git and Jenkins)
- NoSQL databases and Big Data tools
The Renter Solutions department has an exciting opportunity for an Engineer 2 to be part of our Product Health technical team. The Product Health Team is responsible for the retention and maintenance of driver and loyalty profile information for EM customers, and making this data securely available to other services, solutions, and third-party vendors. You will be part of a technical team consisting of analysts, engineers, and other technical leaders responsible for a suite of applications and services, supporting Renter and Loyalty capabilities, using technologies such as Restful APIs, AWS Cloud, React, Oracle and Teradata.
- Executive Summary
The role of Engineer 2 in the Product Health team involves designing, developing, and maintaining data-driven systems supporting customer and loyalty data across cloud-based platforms. This position focuses on data modeling, SQL tuning, and integrating security practices to ensure high-performance, scalable solutions aligned with business needs.
- Required Skills and Experience
- Minimum of 6 years of experience in Data Model design and SQL development, including complex tuning and analysis.
- Proficiency with Teradata, including familiarity with DDL statements, and experience in data warehousing environments.
- Strong data analysis and data modeling skills, with knowledge of methodologies and best practices.
- Experience in data software engineering, preferably with Java, and familiarity with Big Data technologies.
- Hands-on experience with relational databases such as Oracle SQL.
- Understanding of cloud platforms, ideally AWS or Azure, for data integration and deployment.
- Excellent communication skills and ability to collaborate within a team to deliver complex data solutions.
- Desired Skills and Experience
- Experience with API development and familiarity with build automation tools like Git and Jenkins.
- Knowledge of NoSQL databases and Big Data tools beyond traditional RDBMS.
- Prior experience in the vehicle or rental industry, particularly in IT rental domains.
- Experience working within Agile development methodologies.
- Certifications in cloud platforms, data engineering, or security are a plus.
- Preferred Qualifications
- Bachelor's degree in Computer Science, Information Systems, or related fields.
- Additional expertise in Java development for backend data processing.
- Familiarity with EHI IT rental or vehicle domain knowledge, though not mandatory.
- Required Education
- Bachelor's degree in Computer Science, Information Systems, Management Information Systems, or equivalent (preferred but not mandatory).