Senior Data Warehouse Engineer
5808 Lake Washington Blvd NE Kirkland, WA 98033
Position Title: Senior Data Warehouse Engineer
Position Description: Protingent Staffing has an exciting direct hire opportunity with our client in Kirkland, Washington for an experienced Data Warehouse Engineer:
- 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.
- 5+ years of professional experience in software development and data warehouse management
- Strong understanding of SQL fundamentals, including warehousing contexts and/or other complex environments, relational or NoSQL databases engines such as SQL Server, MySQL, Postgres
- Deep expertise in data warehousing, dimensional modeling and the ability to bring best practices with regard to data management, ETL, API integrations, and data governance
- 3+ years of Python programming experience
- Knowledge and experience working with networking, business intelligence, and data visualization are a plus
- Strong problem-solving and analytical skills
- Experience with AWS or GCP is preferred
- Bachelor' s Degree in Computer Science or equivalent preferred
- Work in an agile work environment experience including working from a ticket system like Jira or similar, and collaborating through a distributed version control system like Github or similar.
About Protingent: Protingent is a niche provider of top Engineering and IT talent to Software, Electronics, Medical Device, Telecom and Aerospace companies nationwide. Protingent exists to make a positive impact and contribution to the lives of others as well as our community by providing relevant, rewarding and exciting work opportunities for our candidates.