State of Washington · 1 week ago
IT Data Management - Journey (Olympia) ETL Developer
United States
Full-time
Remote
Mid, Senior Level
$731/mo - $9,900/mo
4+ years expThe State of Washington is committed to ensuring that children and youth grow up safe and healthy. They are seeking a Journey ETL Developer to lead the design, development, and integration of data systems using SSIS solutions, ensuring data integrity and supporting the agency's mission-critical systems.
AssociationCommunitiesEducationEmploymentEventsGovernmentInformation TechnologyNewsNon Profit
No H1B
Responsibilities
Ensures confidentiality, availability, integrity and quality of DCYF interfaces and data systems
Work regularly with .NET developers, DBAs, and DevOps to ensure regular, controlled data deployments of existing and new database driven applications across various platforms
Develop plan and roadmap for cloud migration and modernization of legacy databases
Perform design, development, quality assurance, verification, testing, optimization, and maintenance tasks
Perform data scrubbing tasks to prepare for system modernization efforts
Create and maintain data models, data dictionaries, and provides entity diagrams when requested
Coach and mentor team members on best practices, new technologies, and data architecture
Meet regularly with product team, project teams, and management to perform requirement gathering, iterations, best practices, design, deployment and on-going enhancements
Qualification
Required
Six (6) years of progressively more complex responsibility for Data Architecture, Solution Architecture, Database Management, analyzing, designing, or programming data systems, applications or databases in a large organization with 24/7 mission critical systems and complex regulatory, privacy and security requirements
OR
Bachelor's degree or higher in computer science, data management, information systems or related field AND four (4) years of progressively more complex responsibility for Data Architecture, Solution Architecture, Database Management, analyzing, designing, or programming data systems, applications or databases in a large organization with 24/7 mission-critical systems and complex regulatory, privacy and security requirements
Commitment to equity, inclusion, and respectful workplace principles
Experience working in a highly regulated environment
Experience making presentations and developing documentation for a large, diverse audience
Ability to understand relational databases, data modeling, database schema's, SQL Server Information Services(SSIS) packages, Extract, Transform, Load (ETL) processes and SQL Server Reporting Services (SSRS)
Preferred
SQL certification or knowledge of SQL Server TSQL
Experience maintaining and supporting Databases in a 24/7 availability situation
Agile Training or Certification
Experience in SCRUM, Agile, and iterative development processes
Experience using a source code versioning management tool
Benefits
Medical (including vision), dental and basic life insurance
Medical flexible spending account
Basic life and long-term disability insurance
Dependent care assistance
Auto, boat, home, and renter insurance
Washington State Employee Assistance Program
Washington Public Employees' Retirement System (PERS)
Deferred Compensation Program (DCP)
Public Service Loan Forgiveness
Paid holidays and one paid personal holiday per calendar year
Sick leave
Vacation leave
Military leave
Bereavement leave
Leave Sharing
Parental Leave
Family and Medical Leave Act (FMLA)
Leave Without Pay
Company
State of Washington
Washington state public employees help to create a working Washington built on education and innovation, where all Washingtonians thrive.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Matt Manweller
State Representative
Company data provided by crunchbase