Data Engineer

Title : Data Engineer

Location : Remote in SFO, CA

Duration : 6 Months contract ( Possibility of extension )

W2 Contract Only

About the Company

This is a hands-on role focused on data ownership, modeling, quality, and performance — enabling scalable automation and future AI-driven solutions across Customer Success.

About the Role

Design, build, and maintain ETL/ELT pipelines from Salesforce, Gainsight, and other operational systems into Snowflake.

Responsibilities

• Audit, normalize, and restructure existing Snowflake tables and views to improve clarity, consistency, and performance.
• Develop clean, analytics-ready data models that power Tableau dashboards, Gainsight workflows, and executive reporting.
• Translate business logic (ARR, renewals, churn, consumption, health scoring) into structured, documented data definitions.
• Investigate and resolve root causes of reported data discrepancies and implement durable fixes.
• Optimize query performance, warehouse utilization, and overall Snowflake efficiency.
• Implement data validation, monitoring, and quality controls to improve trust in reporting.
• Document data lineage, transformations, and definitions to improve transparency and governance.
• Partner closely with Senior Data Analysts, Customer Success, and Ops to ensure scalable, reusable datasets.
• Prepare structured datasets that support automation initiatives and future AI use cases.

Qualifications

• Bachelor's degree in Computer Science, Computer Engineering, Information Systems, or equivalent practical experience.

Required Skills

• 2+ years of experience with SQL, ETL, data modeling, and at least one programming language (e.g., Python, C++, C#, Scala or others).
• 2+ years of experience in designing, developing, and maintaining robust data models from structured and unstructured sources.
• Experience proactively identifying opportunities to improve ETL & dashboard performance and cost.
• 2+ years of experience where the primary responsibility involves working with data. This could include roles such as data analyst, data scientist, data engineer, analytics engineer, or similar positions.
• Experience with data warehouse technologies (Snowflake, BigQuery, Spark, etc) and data build tools such as DBT.
• Experience in Git/GitHub and branching methodologies, code review tools, CI tools, JIRA, Confluence.
• Strong understanding of data modeling principles (normalization, dimensional modeling, schema design).
• Strong analytical and problem-solving skills, including experience investigating and resolving data inconsistencies.

Preferred Skills

• Experience working with Salesforce data models (Accounts, Opportunities, Contracts, Subscriptions).
• Experience with Gainsight, Tableau, and SnapLogic.
• Experience supporting SaaS or subscription-based business models (ARR, renewals, consumption).
• Exposure to automation, predictive modeling, or AI-related data preparation.
• Experience implementing data governance, access controls, and documentation standards.
• Experience with server-side languages like TypeScript/Node.JS/Python/Kotlin.
• Experience with RESTful API design.