Note: The job is a remote job and is open to candidates in USA. ArenaNet is the developer and publisher of the Guild Wars game series, creating online worlds for players worldwide. The company is seeking a contract Data Engineer to build, maintain, test, and document database views supporting analytics and reporting across Amazon Redshift and Databricks. The role also involves SQL refactoring, troubleshooting, data validation, and collaboration with analysts and engineering teams.
Responsibilities
- Create, update, test, and document database views in Amazon Redshift and Databricks
- Use DELOS to define and maintain database logic that can be deployed consistently across platforms
- Review existing SQL and simplify or refactor complex queries while preserving intended business logic
- Troubleshoot query failures, unexpected results, schema differences, and platform-specific SQL behavior
- Validate data outputs by comparing results and partnering with analysts to confirm downstream usability
- Follow established development, code review, version control, testing, naming, and deployment practices
- Communicate progress, blockers, assumptions, and data-quality concerns
- Support other related data engineering needs as they arise
Skills
- Bachelor's degree in Computer Science or a related field, or equivalent professional experience
- 2+ years of hands-on experience as a Data Engineer or in a similar data-focused role
- Strong SQL skills, including joins, common table expressions (CTEs), aggregations, subqueries, and window functions
- Ability to read unfamiliar SQL, trace business logic, identify unnecessary complexity, and refactor queries
- Working knowledge of relational data modeling, schemas, views, data types, and null handling
- Comfort using Git or another version-control system in a collaborative development workflow
- Ability to learn internal frameworks, follow established patterns, and clarify requirements
- Good communication skills, including the ability to explain query logic to non-technical audience
- Self-management skills and the ability to balance multiple assigned priorities in a contract environment
- Experience with a cloud data warehouse or Lakehouse platform; Redshift or Databricks experience a plus
- This is a 6-month remote-friendly contract, but we are currently prioritizing candidates who are local to the Bellevue, WA area and open to occasional onsite collaboration
- Basic Python familiarity for reading utilities, tests, or supporting data-engineering code a plus
- Previous experience in the game industry
Benefits
- Training and guidance on DELOS will be provided
- A 6-month remote-friendly contract
- Overtime pay when applicable
- Medical, dental, and vision benefits through the third-party employer
- 401(k) through the third-party employer
- Flexible/dependent care accounts through the third-party employer
Company Overview
Company H1B Sponsorship