SQL ETL Developer

Cayzen Technologies immediately has a need for at least one SQL ETL Developer to complete work for one SaaS solution supporting Foster Care Parent Applications with a WA State government agency. This initial engagement is expected to last 12 months.Technical milestones for this work include prototyping the technical approach of using ETL to manipulate the legacy application data; developing ETL processes to perform bi-directional synchronization for data elements that exist in both repositories; integrating data that exists only in the interim database with the legacy data; testing related downstream processes across the legacy FamLink application that use this data to confirm no bugs were introduced by this work.The work to synchronize data for the SaaS solution. We anticipate the work during the remainder of the engagement involving stabilization and testing of any required changes as full integration of the SaaS solution is completed.Assigned work activities include the following duties and tasks:•Working with application developers and DevOps to ensure regular, controlled deployment of updates to existing database-driven applications across various platforms including but not limited to development, QA, and production environments - including cloud-based resources. •Performs design, development, quality assurance, verification, testing, performance profiling, optimization, migration and maintenance tasks for mission-critical database, business intelligence, API, data integrations, SSIS packages, ETL processes and reporting solutions.•Perform data translation, transformation, and data cleansing procedures.•Assist in the preparation of data migration plans including migration risks and project milestones.•Develop and maintain business metadata.•Define, capture, and maintain technical metadata.•Use established change management practices.•Resolve data quality issues, which may include cross-system dependencies.•Assist in determining enterprise data distribution and reporting requirements and priorities.•Perform quality assurance review, data migration audit, reconciliation and exception reporting.•Creates and maintains data models and data dictionaries.•Work collaboratively with subject matter experts and project team to define, organize, document, and communicate requirements.Why work for Cayzen TechnologiesWe have a great crew of incredible professionals from different walks of life performing at the highest level. Our staff is enjoyable to work with, and there is quite often a bunch of laughter in the office, not yelling or mean-spirited folks that don't want to be bothered. Those type of people won't be tolerated here. We only work with good-natured, kind-hearted people that strive for excellence.We have fun! If you are hired, you will soon learn about outings to painted plates, baseball games, running/biking clubs, Sci-Fri, potlucks and other fun things to enjoy as well! We want our employees to enjoy working here and get to know the people they work with.We believe that every single employee is incredibly important to our success as a company, and we understand that. Come work where you are genuinely appreciated.As a small agile company, we pride ourselves on providing not only exceptional technical solutions but a team-oriented, responsive & innovative approach toward sustainable solutions in solving today's development challenges. We recognize communication as a key factor in the success of any project.We recognize that our employees (The Team) are what makes us so successful in providing exceptional services and satisfied clients. As such we offer competitive compensation and full medical benefits package, educational opportunities, and fun in the office as well as out of the office.EEO StatementCayzen Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, veteran status, disability, sexual orientation, gender identity, or any other protected status.