Employment Type : Full-Time
Description As a member of the Data Management Services (DMS) team, responsible for designing, coding, unit testing and implementing high quality data pipelines for CHPW’s Enterprise Data Warehouse and other data repositories on Snowflake and SQL Server. Enterprise Req Skills data warehouse,ssis,snowflake Job Title Snowflake Developer Additional Information Drug Test Required true Workplace Type 100% Remote EVP This is a non-profit healthcare system that supports Medicaid patients across Washington State. The people that work here are mission oriented, and believe in the services that they are providing. there is also a great deal of work-life balance. Work Environment Core hours are 9:00 AM- 3:00PM PST. This resource is expected to support their core working hours. Collaborative team environment. Additional Skills & Qualifications Community Health Plan of Washington is an equal opportunity employer committed to a diverse and inclusive workforce. All qualified applicants will receive consideration for employment without regard to any actual or perceived protected characteristic or other unlawful consideration.
Essential Functions
•Applies approved application development practices for the analysis, design, prototyping, development and unit testing of CHPW data pipelines ingesting data and metadata into Enterprise Data Warehouse and other data repositories.
•Manages the data extract processes from the data warehouse environments to meet any regulatory requirements and business needs.
•Develops and tunes existing data pipelines to ensure optimal performance.
•Follows defined processes, leads and/or participates in project planning, design, code, development, and post-production reviews and discussions.
•Works closely with QA team and other team members on unit and integration testing of application programs, identifies errors in program logic and verifies functionality and compliance with user specifications.
•Works with project managers to prepare estimates on design and development efforts.
•Leads and/or participates in design and code reviews.
•Documents development work for participated projects and tasks, such as design, coding, test, processes, and instructions. Keeps the documentation up to date.
•Communicates project status, design and other related issues to the appropriate management.
Experience
1) 2 – 5 years Snowflake development experience (it must be development experience on Snowflake, not use experiences on Snowflake)
2) SSIS development experience
3) Full data warehouse development experience
Education
•Bachelor’s degree in Computer Science, Management Information Systems or an equivalent combination of education and highly relevant experience required