Job Location: Olympia, WA
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.
The Opportunity:
We are looking for an IT Data Management – Journey – BI Analyst that is responsible for the design, documentation, development, modification, testing, installation, implementation, maintenance, and support of new or existing application software for the Juvenile Rehabilitation team. You will be applying analytical processes to the planning, design and implementation of complex analytic data products to meet the business requirements of customers within and outside DCYF. This includes the work of translating business needs to technical requirements.
This position will serve as the designated technical resource on the BI Analytics team for specific assigned dashboard types, as well as serve as the primary analyst in the area of Juvenile Rehabilitation (JR), and works in collaboration with other OIAA staff on other OIAA teams to provide analytics support for Juvenile Rehabilitation as well as other subject areas that touches upon JR. The analyst’s work will contribute towards larger strategies to ensure the agency can meet its outcome goals for children, youth, and families.
Some of what you will get to do:
- Design, develop, and maintain complex BI analytic data solutions systems and business intelligence solutions for Juvenile Rehabilitation data.
- Develop a programmatic understanding of Washington’s Juvenile Rehabilitation business processes in order to effectively serve the business customers.
- Work closely with the program staff across OIAA to ensure solutions meet the business needs of DCYF’s implementation.
- Troubleshoot and resolve complex data related issues
- Provide expertise on relevant data as well as present case outcomes.
- Serve as a resource for designated program Evaluators (internal and/or external to DCYF) as to analytic data used in BI analytic products developed.
- Analyze data, build data sets, and create data visualizations for presentation to the relevant primary business team, as well as internal stakeholders and external partners relevant to the program.
- Contribute to presentations by the identified primary business partners and/or program Evaluators that they use for presenting to external stakeholders, DCYF staff, and public groups as necessary and directed.
- Work collaboratively with OIAA Product Team and business (program) customers within DCYF to conduct requirements gathering sessions.
- Provide technical consultation to the customer on potential analytic and dashboard solutions that can meet their need identifying the pros and cons of each solution.
- Write, update, and maintain complex SQL queries and stored procedures to produce complex automated data products and dashboards.
- Design dashboard layout(s), define parameters that allow users to build their own custom report, and develop data reporting systems using tools such as Tableau, Power BI, R (Markdown, Shiny), Python.
- Debug and maintain code for existing analytic products; which can involve reverse engineering of existing SQL code as needed.
- Participate and engage in peer code reviews in order to ensure data integrity/quality of the analytics team.
Required Qualifications:
At least three years of recent experience developing analytic data solutions using a Business Intelligence reporting tool preferably SQL Server Reporting Services, including Visual Studio and SQL Server Management Studio, and implementing Report Models.
AND
At least four years of IT experience such as consulting, analyzing, designing, coding and/or maintaining technical data products (i.e. reports/dashboards), and providing technical support.
In addition to those required qualifications, our ideal applicant will also have the following:
- At least three years of recent experience working with relational databases. SQL 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.
Additional Desired Skills
- Experience using a source code versioning management tool.
- Good communication skills both orally and written.
- Ability to communicate from a technical and business perspective.
- Ability to work in a team environment.
- Demonstrated and verifiable customer service skills.
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:
Per Governor Inslee’s Proclamation 21-14 (Download PDF reader), state employees must be fully vaccinated no later than October 18, 2021. Being fully vaccinated against COVID-19 is a condition of employment. Being fully vaccinated means that an individual is at least two weeks past their final dose of an authorized COVID-19 vaccine regimen. If you are a selected candidate, you will be required to provide proof of vaccination in order to become/remain a DCYF employee. You may request an accommodation if you are unable to meet the requirement due to a medical or religious necessity.
This recruitment may be used to fill multiple vacancies.
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 supplemental question 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) 798-3369 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.
15185
Submit CV To All Data Science Job Consultants Across United States For Free