Experience Inc. Jobs

Job Information

Washington State DCYF Reports Design/Developer - Two Positions in Olympia, Washington

Description The Department of Children, Youth, and Families (DCYF) was created to be a comprehensive agency exclusively dedicated to the social, emotional, and physical well-being of children, youth, and families regardless of race, ethnicity, sexual orientation, or other socioeconomic factors. We believe our workforce should reflect the communities we serve and are actively searching for candidates that reflect that diversity. We're looking for two Reports Developer/Designers (IT Data Management – Journey) *to support the Early Learning and Juvenile Rehabilitation Divisions by designing, developing, implementing, maintaining, and supporting new and existing application software. If you have experience with SQL and designing/developing databases, and want to join an organization that is working toward the common goal of eliminating child and youth outcome disparities based on race and ethnicity, apply today! Our vision is that "All Washington's children and youth grow up safe and healthy-thriving physically, emotionally, and educationally, nurtured by family and community." *The Opportunity: Do you seek a better work-life balance? Do you have strong technical skills in application/database development? As the Reports Developer/Designer you will be responsible for report application and database development with a focus on either the Early Learning/Professional Development Grant or Juvenile Rehabilitation data and products. This includes design, documentation, development, modification, testing, installation, implementation, maintenance, and support of new or existing application software. You will be relied on to apply analytical and engineering processes to the planning, design, and implementation of IT systems to meet the business requirements of customer organizations. This includes the work of translating business needs to technical requirements. The Reports Developer/Designer is a member of the Reporting Team, part of the Data & Reporting unit, within the Office of Innovation, Alignment, and Accountability (OIAA). OIAA was created to align, integrate, and ensure accountability of state services for children, youth, and their families across state agencies so that there is a seamless, effective, prevention, and early intervention-based service system regardless of which state agency is responsible for particular services. The Reporting Team is responsible for DCYF's online reporting application portal, reports and report builders hosted in the portal, the automated data-driven report delivery system, and ad hoc reporting for DCYF. The Reporting Team designs develops and implements data marts for increasing reporting efficiency and creates analysis products shared with researchers of child welfare information. These positions are eligible to continue working remotely, but your in-person presence will be required for meetings and/or training once we return to the workplace. This announcement will remain open until both positions are filled, it is to your advantage to apply early! What you will get to do: Create and maintain automated reports and report builders. * Conduct requirements gathering sessions with customers. * Provide technical consultation to the customer on potential reporting solutions that can meet their need identifying the pros and cons of each solution. * Document functional and technical report designs. * Design Extract Transform and Load (ETL) transformation logic specific to reporting needs. * Tests ETL specific to transformations designed. * Design report layout(s), define parameters that allow users to build their own custom report and develop data reporting systems using tools like Visual Studio, SQL Server Reporting Services, and SQL Server. * Write computer code and stored procedures in report development process * Create data structures to integrate reports into DCYF’s report navigation application * Debug and maintain code for existing reports; which can involve reverse engineering of existing SQL code as needed. * Deploys code in development environment and prepares deployment instructions for configuration management staff to follow when deploying the code to test and production environments. * Work with DevOps to ensure regular, controlled deployment of updates to existing data reporting systems and BI solutions across various platforms including but not limited to development, QA, and production environments – including cloud-based resources. * Use version control software to maintain change history. * Perform functional unit testing of reports. * Ensure compliance with security and privacy requirements. * Participate in peer code reviews and inspections. Database Design and Development * Facilitate IT team and business client meetings to collect functional requirements in order to design solutions that meet business data consumption needs * Analyze and define data requirements and specifications to design, normalize, develop and implement multi-user reporting databases * Plan, develop, implement, test, and maintain data structures using Transact SQL, Microsoft SQL Server Management Studio, and/or Visual Studio * Implement data systems, continuously analyze, monitor, and address data quality issues in reporting solutions. * Design and develop databases, tables, and stored procedures that achieve consistent and reliable access to, and delivery of data across a wide range of program areas. * Maintain the data dictionary for the data warehouse and reporting layer schemas. Serve as the system specialist for Early Learning or Juvenile Rehabilitation. * Maintain data reporting systems and business intelligence solutions for Early Learning and ACT data. * Work closely with program staff to ensure solutions meet the business needs of DCYF’s programs as well as federal reporting requirements. * Troubleshoot and resolve complex data-related issues. * Create ad-hoc queries in response to data requests from stakeholders and management on an as-needed basis Report Application Testing * Develops test scripts for different types of data validation activities that cover business and technical requirements. * Reviews existing or developed code for an understanding of the technical implementation of the requirements. * Collaborates with technical staff to resolve issues not clarified in design documentation. * Writes up incidents in bug tracking software to report problems for the developer to fix. * Tests to ensure report business rules met, such as target population and appropriate region, office & worker have been associated with the data reported. A successful IT Data Manager has the following knowledge, skills, abilities, and behaviors: Knowledge of: * Data modeling theory and methods, including relational and data warehouse models. * Commonly used reporting development tools, databases, and operating systems. * Software development methodologies and life cycles. * Applications development and structured analysis methods. * DCYF software systems and data in order to develop reporting solutions. Skilled in: * The use of Integrated Development Environments and plugins * Visual Studio * SQL Server Management System (SSMS) * SOL Server Report Services (SSRS) * SQL Server Integration Services (SSIS) * Writing and maintaining complex computer code - T-SQL Scripts, views, stored procedures, Python, PowerShell, C#/VB.net, HTML, CSS, and JavaScript * Source code debugging and problem-solving. * Time-management * Customer service Ability to: * Communicate effectively orally and in writing. * Ability to translate information from both a technical and business perspective * Use of Versioning software (such as SVN, git or TFS). * Use of Microsoft Office products * Work on a team. * Troubleshoot and fix, or identify and report problems resulting from possible errors in ETL processes, the data warehouse, report source code, stored procedures, user and data-driven subscriptions such as: * User-defined SSRS subscription problems * Developer designed data-driven SSRS subscription problems * Broken Reports both SSRS configuration errors and logical errors * Broken links * Data quality * Missing data * Data currency * Data Inconsistencies Required Qualifications: * At least four years of information technology experience such as consulting, analyzing, designing, coding and/or maintaining software applications and/or databases, and providing technical support in Information Technology. * At least three years of recent experience developing reports using a Business Intelligence reporting tool preferably SQL Server Reporting Services, including Report Designer, Report Builder, and implementing Report Models. * At least three years of recent experience with relational databases. SOL Server preferable. * At least two years of recent experience working with star schema Data Warehouse databases. * At least three years of experience writing T-SQL. * Experience using a source code versioning management tool. * Good communication skills both orally and written. Ability to communicate from a technical and business perspective. * Demonstrated and verifiable customer service skills. * Ability to work in a team environment Desired Qualifications: * Demonstrated knowledge and understanding of the business of Early Learning or Juvenile Rehabilitation. * Experience with Early Learning, Corrections, or Juvenile Rehabilitation datasets, models, and topics. * Experience testing complex reports and reporting systems. * Experience using an automated flowcharting tool such as MS Visio. How do I apply? Complete your applicant profile and attach the following documents: * Letter of interest describing how you meet the specific qualifications for this position * Current resume detailing experience and education To take advantage of Veteran's preference please attach your DD-214, member 4 long-form, or your NGB-22. Please black out your social security number prior to attaching. Supplemental Information: Applicants selected for an interview will be required to pass a criminal history and national fingerprint background check, and complete a questionnaire mandated by the Prison Rape Elimination Act (PREA) inquiring about any sexual misconduct. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant's suitability and competence to perform in the position. This position is covered by a collective bargaining agreement. The initial screening will be based on the content and completeness of your application and the materials submitted. All information may be verified and documentation may be required. Applications with comments such as "see attachments" or "N/A" in the work history responses will be considered incomplete. DCYF is an equal opportunity employer and supports equity, diversity, inclusion, and respect. Need accommodation throughout the application/interview process? Unable to apply online? Contact the Recruitment team at dcyf.jobs@dcyf.wa.gov or (360) 628-0114 or the Telecommunications Device for the Deaf at 800-833-6388 Experiencing technical difficulties creating, accessing, or completing your application? Call NEOGOV toll-free at (855)524-5627 or email support@neogov.com. General suggestions for creating a good application packet: * Read the job posting very carefully. Find out as much as you can about the position. * Make sure you are very diligent in following all the application instructions. Include all requested documentation. * Make sure your application and supplemental question responses address how you meet each of the required and desired qualifications. * Carefully read each of the supplemental questions and respond completely to each one. Pay careful attention to each component of the question, providing examples, and thoroughly describing when and where you achieved the proficiency level, and detail the types of work you performed, the work products, etc., to demonstrate 'how'. * Specifically include all of your work experiences doing the same or similar work, especially if you reference work in these jobs in describing when/where you gained proficiency level skills. * Make sure your application reflects your best writing. 03279 #ITjobs #Statecareer #reportsdeveloper #devops #wastatejob #diversity #equity #inclusion Salary: $6,462.00 - $8,479.00 Monthly Location: Thurston County – Olympia, WA Job Type: Full Time - Permanent Department: Dept of Children, Youth, and Families Job Number: 2021-03279 Closing: Continuous Agency: State of Washington Address: View Job Posting for Agency Information View Job Posting for Location, Washington, 98504 Phone: View Posting for Agency Contact Website: http://www.careers.wa.gov