Order to Cash Data Engineer
: Job Details :

Looking For: Order to Cash Data Engineer

Job Type: Long Term Contract

Location: San Jose, California (Hybrid)

Description: Looking for Data Engineer with functional knowledge of oracle fusion and order to cash expertise. Experience with Salesforce and CRM expertise is needed as well.

Position Overview

We are searching for a talented and experienced Modern Data Stack Data Engineer to join our growing team. You will be responsible for designing, building, and maintaining data pipelines using technologies like Fivetran, Azure Data Factory and Python into our Snowflake data warehouse and transforming the data using tools like dbt and Coalesce. You will also be responsible for ensuring data quality, security, and performance of the data pipelines.

Essential Job Functions

• Design, develop, and maintain data pipelines using Fivetran, Python, dbt/coalesce and Airflow from varied sources.

• Primary sources include Oracle Fusion Cloud, Salesforce, among many others.

• Write efficient SQL queries to transform and clean data for optimal consumption in Snowflake.

• Implement data quality checks and monitoring processes to ensure data accuracy and consistency.

• Collaborate with data analysts and business stakeholders to understand data requirements and design data models.

• Document data pipelines and processes for maintainability and knowledge sharing.

• Monitor and optimize data pipeline performance for efficiency and scalability.

• Troubleshoot and resolve data pipeline issues to ensure data availability.

• Create dashboards and advanced visualizations in Power BI

• Implement data observability tools like Monte Carlo

• Stay up to date on the latest trends and technologies in the modern data stack (Snowflake, Fivetran, dbt, etc.).

Requirements

• 5+ years of experience as a Data Engineer or similar role.

• Proven experience with designing and building data pipelines.

• Must have skills – Snowflake, dbt, and Python

• Advanced knowledge of Snowflake, Fivetran, Airflow and dbt

• Monte Carlo or other data observability tools experience a plus

• Strong knowledge of SQL and experience with data transformation techniques.

• Excellent problem-solving and analytical skills.

• Proficiency in extracting and loading data from the following two source applications - Oracle Fusion Cloud (Finance, Supply Chain, Manufacturing), Salesforce a huge plus

• Strong communication and collaboration skills.

• Ability to work independently and as part of a team.

• Excellent project management and team leadership skills.

• Strong interpersonal and communication skills to collaborate effectively with business partners cross-functional teams.

• Strong strategic mindset with the ability to align analytics initiatives with overall business goals and proactively identify opportunities for leveraging data to drive business value.