Data Solutions Consultant - Data Vault, ODI, Snowflake Specialist
Remote
Not Specified
Time and material
$ 15-20/Hr
Description
**About the Role**
We are seeking an experienced Data Solutions Consultant with strong expertise in Data Vault, Oracle Data Integrator (ODI), and Snowflake. The role involves transforming complex data models and optimizing performance in a demanding and dynamic environment. This position focuses on the execution of large-scale data solutions for business intelligence and analytics applications, providing strategic insights to enhance business operations.
**Key Responsibilities**
- Develop and maintain Data Vault models and integrate them using Oracle Data Integrator 12c and Snowflake.
- Perform expert-level SQL programming and Oracle performance tuning, including reading explain plans, indexing, and using set-based processing.
- Triage and resolve issues within ODI 12c, utilizing operator and session logs effectively.
- Execute and manage batch-controlled data load processes, ensuring accuracy and efficiency in Data Vault executions.
- Utilize advanced ODI 12c navigation and concepts, working with knowledge modules, load plans, and reusable mappings.
- Collaborate with stakeholders to understand data requirements and drive complex problem-solving initiatives.
- Facilitate seamless data flows between systems while optimizing for performance and scalability.
- Ensure the security and integrity of data systems, advising on best practices across platforms.
**Must-Have Qualifications**
- At least 5 years of experience in data engineering or a similar field with a focus on SQL and Oracle.
- Strong practical experience with ODI 12c, including advanced user capabilities and problem-solving.
- Proficiency in Snowflake operations and integration with other data tools.
- In-depth knowledge of Data Vault 2.0 principles and implementation.
- Excellent communication and stakeholder management skills.
- Full legal right to live and work in the [Country] without restrictions.
**Nice-to-Have**
- Familiarity with data streaming or CDC tools like Kafka.
- Hands-on experience with Data Vault implementations in production environments.
- Exposure to CDC, data replication, or GoldenGate-style pipeline management.