Senior Data Engineer – Commerce Data Pipelines

City: Seattle, WA/ Santa Monica, CA or NYC Onsite/ Hybrid/ Remote: Hybrid (4 days a week onsite, Friday - Remote) Duration: 10 months Rate Range: Up to$92.5/hr on W2 depending on experience (no C2C or 1099 or sub-contract) Work Authorization: GC, USC, All valid EADs except OPT, CPT, H1B Must Have: • SQL • ETL design and development • Data modeling (dimensional and normalization) • ETL orchestration tools (Airflow or similar) • Data Quality frameworks • Performance tuning for SQL and ETL • Python or PySpark • Snowflake or Redshift Responsibilities: • Partner with business, analytics, and infrastructure teams to define data and reporting requirements. • Collect data from internal and external systems and design table structures for scalable data solutions. • Build, enhance, and maintain ETL pipelines with strong performance and reliability. • Develop automated Data Quality checks and support ongoing pipeline monitoring. • Implement database deployments using tools such as Schema Change. • Conduct SQL and ETL tuning and deliver ad hoc analysis as needed. • Support Agile ceremonies and collaborate in a fast-paced environment. Qualifications: • 3+ years of data engineering experience. • Strong grounding in data modeling, including dimensional models and normalization. • Deep SQL expertise with advanced tuning skills. • Experience with relational or distributed data systems such as Snowflake or Redshift. • Familiarity with ETL/orchestration platforms like Airflow or Nifi. • Programming experience with Python or PySpark. • Strong analytical reasoning, communication skills, and ability to work cross-functionally. • Bachelor’s degree required.