Data Engineer/Database Administrator_ (W2 Only)
Position: Data Engineer/Database AdministratorDuration: 6+ Months ContractLocation: Bellevue, WA _ Onsite _ Local About the Role We’re looking for a mid-level Data Engineer & DBA to join our data platform team. You’ll build and maintain scalable data pipelines while ensuring our databases are reliable, secure, and high-performing. You’ll work closely with analysts, engineers, and product teams to deliver clean and timely data. What You’ll DoDesign, build and maintain ETL/ELT pipelines across multiple systemsDesign and optimize data models in PostgreSQL, MongoDB, and Amazon RedshiftDevelop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)Administer and maintain database environments across development, staging, and productionMonitor data pipelines and databases, troubleshoot issues, and implement alertsOptimize query performance, indexes, and configurations across relational and NoSQL systemsManage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, Redshift)Ensure database security, including access control, encryption, and role managementPlan capacity and scale systems to support growing data needsDefine and enforce data retention and archival policiesCollaborate with analytics and product teams to support reporting and data needsDocument data pipelines, database processes, and operational proceduresParticipate in code reviews and follow engineering best practices Core Skills & Experience:3–7 years of experience in data engineering, database administration, or similar roleStrong experience with PostgreSQL, MongoDB, and Amazon RedshiftSolid SQL skills for both transactional and analytical workloadsExperience with AWS data and database services (S3, Glue, Lambda, RDS, Redshift, etc.)Proficiency in Python or another scripting languageExperience with workflow orchestration tools (Airflow, Step Functions, etc.)Hands-on database administration experience, including:MongoDB (replica sets, sharding, indexing, backups)Redshift (cluster management, query tuning, WLM, snapshots)PostgreSQL (replication, performance tuning, connection pooling)Familiarity with monitoring tools (CloudWatch, pgBadger, MongoDB Atlas, etc.)