Job Description
Job Description
Description : About the Role
Trevco Inc. is seeking an experienced Senior Data Engineer to lead our data integration and ETL processes in a fully remote capacity. You’ll build pipelines that collect, transform, and centralize data from platforms like Amazon Seller Central, NetSuite, and PostgreSQL into a secure warehouse, enabling reporting in Power BI. This role collaborates across teams (BI, Finance, Ops, Engineering) to drive data-informed decisions company-wide.
Key Responsibilities
- Design and maintain robust ETL / ELT pipelines across Amazon, NetSuite, PostgreSQL, and more
- Automate workflows using AWS Glue, Airflow, or similar orchestration tools
- Model scalable data warehouse schemas optimized for Power BI
- Ensure data quality through validation, alerting, and anomaly detection
- Develop integrations with external APIs (Amazon SP-API, NetSuite, etc.)
- Collaborate with BI to prepare clean datasets and performance-optimized views
- Implement data backup and governance policies
- Mentor team members and recommend improvements to the data stack
- Partner with stakeholders to refine data requirements and troubleshoot issues
Requirements :
Bachelor’s in Computer Science or equivalent experience5+ years of data engineering or BI engineering experienceHands-on experience with AWS Glue and PySpark / PythonProficiency in SQL and Python for data workflowsExperience with PostgreSQL, Redshift, or SnowflakeKnowledge of NetSuite APIs and Amazon Seller Central dataStrong understanding of data modeling and warehouse designExperience structuring data for Power BI and writing DAX queriesFamiliarity with orchestration tools (Airflow, Step Functions, etc.)Excellent remote communication and problem-solving skillsNice to Haves
Apache Airflow or DAG development experienceKnowledge of AWS Redshift, Athena, Lambda, DMSExperience with Spark, Hadoop, or DatabricksCI / CD for data jobs and infrastructure-as-code (Terraform, CloudFormation)Deep ERP knowledge (NetSuite, SAP, Oracle)Retail or e-commerce data experienceAWS certifications or relevant credentialsLeadership or mentoring experienceAbout Trevco
Trevco Inc. is a vertically-integrated, global print-on-demand licensee powering licensed merchandise across 1,200+ brands. From design to distribution, we provide turnkey e-commerce solutions with over 300 product types. Our core values – Think Differently, Execute with Urgency, Aspire for More, and Make Work a Great Place – define our team and remote-first culture. Join us to innovate and grow at the intersection of technology and retail.
Benefits
100% remote work with flexible hoursCompany paid life, STD / LTD insuranceOptional medical, dental, vision, and FSA401(k) planGenerous PTO and paid holidaysApply Now
If you're passionate about building scalable data systems and driving a data-first culture in a growing e-commerce company, we’d love to hear from you.