Job Description
Job Title: Data Warehouse Engineer
Responsibilities
Integrate data from external operational systems such as Navusoft, Samsara, Salesforce, and ADP
Develop and maintain REST API integrations, including authentication, pagination, retries, and error handling
Build and manage data ingestion pipelines (Postman → Python → Fivetran → Snowflake)
Implement incremental data loads, watermarks, and idempotent processes
Ensure reliable data flow across layers: raw → staging → marts in Snowflake
Design and maintain fact and dimension tables using star schemas
Develop and manage dbt models for transformation and testing
Debug and resolve API errors (e.g., 401, 400 responses)
Apply business logic for revenue, cost, and profit calculations
Ensure data is accurate, consistent, and business-ready for analytics and reporting
Collaborate with stakeholders to make data clear, accessible, and actionable
Required Tools & Technologies
dbt
Snowflake
Fivetran
...
Responsibilities
Integrate data from external operational systems such as Navusoft, Samsara, Salesforce, and ADP
Develop and maintain REST API integrations, including authentication, pagination, retries, and error handling
Build and manage data ingestion pipelines (Postman → Python → Fivetran → Snowflake)
Implement incremental data loads, watermarks, and idempotent processes
Ensure reliable data flow across layers: raw → staging → marts in Snowflake
Design and maintain fact and dimension tables using star schemas
Develop and manage dbt models for transformation and testing
Debug and resolve API errors (e.g., 401, 400 responses)
Apply business logic for revenue, cost, and profit calculations
Ensure data is accurate, consistent, and business-ready for analytics and reporting
Collaborate with stakeholders to make data clear, accessible, and actionable
Required Tools & Technologies
dbt
Snowflake
Fivetran
...
Ready to Apply?
Take the next step in your AI career. Submit your application to Hire Smart Solutions today.
Submit Application