Senior Data Warehouse Engineer/Architect
10500 NE 8th St Bellevue, WA 98004
Job Title: Senior Data Warehouse Engineer/Architect
Position Description: Protingent Staffing has an exciting direct hire opportunity with our client in Bellevue, Washington for an experienced Senior Data Warehouse Engineer/Architect:
- 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.
- A minimum of 10 years of professional experience in software development and data warehouse management
- Solid expertise or exposure to financial transactions, accounting principals with be strongly preferred
- 7+ years of Python programming experience (architect level)
- 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
- Knowledge and experience working with networking, business intelligence, and data visualization are a plus
- Bachelor' s Degree in Computer Science or equivalent preferred
- Strong problem-solving and analytical skills
- Experience working with Cloud services ie. AWS or GCP is required
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.