Data Warehouse Engineer
Data Warehouse Engineer
Bellevue, WA
From .life to .solutions to .news, Donuts is the global leader in high-quality, top-level domains. Our fresh, relevant new domain names provide variety and choice to easily manage and amplify your digital identity. Donuts Inc. is also the parent company of Name.com a leading domain name registrar. Donuts Inc. is headquartered in Bellevue, Washington with offices in Denver, Austin, Dublin, Los Angeles and Beijing.
The Data Tools team at Donuts is seeking a data-oriented software engineer to build and maintain a variety of ETLs, background processes, and internal websites. Our code is Python, our warehouse is BigQuery, and our Cloud is AWS. We fly with Windows or MacOS. We are the hub for several teams that all need quality work, clear communication, and timely deliveries.
Our ideal candidate is comfortable with code and designs creative solutions through data structures. This person visualizes the solution like Tetris blocks falling into place with a passion to expand their knowledge and then share it with teammates. The right person is capable of translating highly technical information into succinct explanations and documentation.
Qualifications:
- 5+ years of professional experience in database management within a data-driven development
- Strong understanding of SQL fundamentals for data analysis, investigation, and design
- Mastery of at least one database software: Postgres (preferred), MySQL, or SQL Server
- 3+ years of Python programming experience in a CI/CD environment with PEP8/linting
- Participation in open source projects, online forums, technical blogs, and/or answer sites
- Experience with AWS or Google Cloud APIs. BigQuery is a huge plus. git, SSH, and bash/PowerShell skills are a must.
- Strong troubleshooting and problem solving skills.
Responsibilities:
- Create deploy, and automate ETL and data integration processes into an Enterprise Data Warehouse using Python and BigQuery
- Act as a key Data Warehouse SME within the data services team to drive successful adoption of best practices, standardization of data provision to the data warehouse, and proactive management of data refresh and accuracy
- Develop and Engineer under a full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operational management. This will include participating on on-call rotation.
- Design and implement formal data warehouse testing strategies and plans including unit testing, functional testing, integration testing, performance testing, and validation testing.
- Participate in data warehouse health monitoring and performance optimizations as well as quality documentation.
Education:
Bachelor's Degree in Computer Science or equivalent relevant work experience.
A Few Things to Know About us:
Donuts offers a competitive compensation/benefits package in a friendly, collaborative culture that values employee engagement and ongoing career development. Donuts provides some great perks such as a generous stock option plan, a weekly catered lunch, a fully stocked kitchen and frequent social events.
Donuts is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex, age, national origin, veteran status, marital status, sexual orientation, gender identity, disability or any other category prohibited by local, state or federal law. This policy applies to all aspects of employment, including recruitment, placement, promotion, transfer, demotion, compensation, benefits, social and recreational activities and termination.
Find out more about us at www.donuts.domains and www.name.com.