Senior Data Engineer ( USC only)

Sophus IT Solutions; Redmond (WA); On-site; USD 120,000 - 180,000; Full time

Job summary

Sophus IT Solutions is seeking a Data Engineer in Redmond, WA to design and deliver scalable data pipelines for AI/ML initiatives. The role emphasizes constructing robust data flows from Salesforce, D365, Coupa, Workday, and Concur, using modern tooling.

You will collaborate with the AI/Data Science team to produce clean, feature-ready datasets, ensure quality, governance, and cost-efficient performance across Databricks, DBT, and Snowflake environments.

Qualifications

• Experience integrating data from Salesforce, D365, Coupa, Workday and Concur.
• Building pipelines with Databricks, DBT, and Snowflake.
• Strong SQL and Python skills; data quality frameworks.

Responsibilities

• Ingest and process data from multiple enterprise systems.
• Develop and maintain data pipelines in Databricks, DBT, and Snowflake.
• Design simple, reusable data models for training and inference.
• Implement data quality tests, documentation, and lineage.
• Ensure performance, cost efficiency, and governance compliance.
• Collaborate with AI/Data Science teams to provide feature ready datasets.

Skills

Databricks

PySpark

SQL

Python

ETL/ELT

Data quality

Governance

Tools

Unity Catalog

DBT

Snowflake

Salesforce

Dynamics 365

Coupa

Workday

Concur

Job description

Looking for Data Engineer in Redmond, WA . US Citizen only .

Responsibilities

1. Ingest and process data from Salesforce (Investments), Dynamics 365 & Coupa (Finance), Workday (HR), Concur (Operations), and external program/partner data (e.g., Health, Education).
2. Build and maintain pipelines in Databricks, DBT, and Snowflake to deliver curated datasets for AI/ML.
3. Design simple, reusable data models to support training and inference.
4. Implement data quality tests, documentation, and lineage in DBT
5. Ensure performance optimization, cost efficiency, and compliance with governance standards.
6. Collaborate with Knowledge Management (AI/Data Science) team to provide feature ready datasets.

Requirements

1. Hands-on experience with Databricks (PySpark/SQL, Unity Catalog), DBT (models, tests, docs), and Snowflake (SQL, performance tuning).
2. Strong background in ETL/ELT pipeline development.
3. Experience with enterprise SaaS systems (Salesforce, D365, Coupa, Workday, Concur).
4. Solid SQL and Python skills; knowledge of data quality frameworks.