<p><span style="color: #000000;">The Data Analyst supports the data and evaluation related functions of the agency. The Analyst is involved in many different aspects of performance improvement and program evaluation, including creating interactive reports, dashboards, and data visualizations, manipulating and deriving insights from datasets, producing summary reports for stakeholders, and engaging with agency leaders and staff to promote and facilitate the effective use of data to improve services. The person in this role assists with the management and completion of projects and consults with program staff and management. Tasks may involve individual or independent work as well as significant collaboration with other team members and Seneca staff. This position offers a remote work model with some need for occasional (a few times a year) travel to the San Francisco Bay Area paid for by Seneca.</span></p>
<p><span style="color: #000000;"><strong>Responsibilities</strong><strong>:</strong></span></p>
<ul>
<li aria-setsize="-1" data-list-defn-props="{" 335552541":1,"335559685":360,"335559991":360,"469769226":"symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridmultilevel"}"="" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Develop interactive data reports and dashboards using Microsoft Power BI and Excel based on user requirements (30%) </span></li>
<li><span style="color: #000000;">Manipulate and extract meaning from complex datasets, including development and implementation of automated Extract, Transform, and Load (ETL) functions in Power BI as well as use of Excel spreadsheets and Pivot Tables and writing SQL queries/views to extract and manipulate data from relational databases (30%) </span></li>
<li aria-setsize="-1" data-list-defn-props="{" 335552541":1,"335559685":360,"335559991":360,"469769226":"symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridmultilevel"}"="" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Advise and consult with program leaders and staff on matters related to program evaluation, data collection and reporting, and performance improvement efforts (15%) </span></li>
<li><span style="color: #000000;">Participate in intra- and inter-departmental meetings and represent Data team on relevant agency committees and workgroups (15%) </span></li>
<li aria-setsize="-1" data-list-defn-props="{" 335552541":1,"335559685":360,"335559991":360,"469769226":"symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridmultilevel"}"="" data-aria-posinset="5" data-aria-level="1"><span style="color: #000000;">Actively contribute to team knowledge-sharing through peer review, collaborative problem-solving, and a positive, supportive team culture (10%) </span></li>
<li><span style="color: #000000;">Engage in individual and collaborative work to advance team values related to diversity, equity, and inclusion </span></li>
<li aria-setsize="-1" data-list-defn-props="{" 335552541":1,"335559685":360,"335559991":360,"469769226":"symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridmultilevel"}"="" data-aria-posinset="7" data-aria-level="1"><span style="color: #000000;">Manage and coordinate complex, time-sensitive projects with many different stakeholders </span></li>
</ul>
<p><span style="color: #000000;"><strong>Qualifications:</strong></span></p>
<p><span style="color: #000000;"><strong>Required:</strong></span></p>
<ul>
<li><span style="color: #000000;"><strong>Education/experience requirements</strong>:</span>
<ul>
<li><span style="color: #000000;">Bachelor’s degree OR</span></li>
<li><span style="color: #000000;">Associate degree + 1 year of applicable experience OR</span></li>
<li><span style="color: #000000;">High school diploma + 2 years of applicable experience.</span></li>
<li><span style="color: #000000;">Applicable experience includes work experience in data/business analytics, manipulation, and visualization.</span></li>
</ul>
</li>
<li><span style="color: #000000;">At least 21 years of age.</span></li>
<li><span style="color: #000000;">TB test clearance, fingerprinting clearance, and any other state/federal licensing or certification requirements.</span><span style="color: #000000;"><span> </span></span></li>
<li><span style="color: #000000;"><span>A collaborative, team-first orientation — sharing knowledge, supporting colleagues' work, and contributing to group success.</span><span data-ccp-props="{}"> </span></span></li>
<li><span style="color: #000000;"><span data-ccp-props="{}">Commitment to working to advance team values related to diversity, equity, and inclusion. (See <a href="https://www.senecafoa.org/diversity/" target="_blank" rel="noreferrer noopener">https://www.senecafoa.org/diversity/</a>) </span></span></li>
</ul>
<p><span style="color: #000000;"><em><strong>Knowledge of and skill in</strong></em>:</span></p>
<ul>
<li><span style="color: #000000;" data-olk-copy-source="MessageBody">Writing SQL queries against relational databases, transforming and modeling data using Power Query, building interactive reports and dashboards in Power BI with DAX and data extraction/pivot tables in Excel.</span></li>
<li><span style="color: #000000;">Applying basic statistical concepts and data visualization best practices in presenting data to different audiences </span></li>
<li aria-setsize="-1" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769226":"courier="" new","469769242":[9675],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="3" data-aria-level="2"><span style="color: #000000;">Modeling/structuring data for reporting purposes and/or navigating data warehouse or relational database structures </span></li>
<li><span style="color: #000000;">Planning and managing complex projects, communicating across multiple stakeholders, and meeting deadlines </span></li>
</ul>
<p><strong><span style="color: #000000;">Preferred:</span></strong></p>
<ul>
<li><span style="color: #000000;">Experience designing and conducting surveys and deriving insights from survey response data.</span></li>
<li><span style="color: #000000;"><span>Experience with Git review workflows.</span></span></li>
<li><span style="color: #000000;">Experience and/or education in one or more of the following:</span>
<ul>
<li><span style="color: #000000;">Data and business analytics.</span></li>
<li><span style="color: #000000;">Performance improvement/continuous quality improvement methods.</span></li>
<li><span style="color: #000000;">Data visualization.</span></li>
<li><span style="color: #000000;">Program evaluation.</span></li>
<li><span style="color: #000000;">Public health, data science, information science, math, mental health, social work, or other field(s) related to Seneca’s work.</span></li>
</ul>
</li>
</ul>
<p><span style="color: #000000;"><strong>Schedule:</strong></span></p>
<ul>
<li><span style="color: #000000;">Full time; fully remote</span></li>
<li><span style="color: #000000;">Monday-Friday; 9am-5:30pm PST</span></li>
</ul>
<p><span style="color: #000000;"><strong>Benefits:</strong></span></p>
<ul>
<li><span style="color: #000000;">Starting at <strong>$87,418 - $101,418 </strong>per year</span>
<ul>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Actual salary is dependent on creditable experience above the minimum qualifications for the role</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Salary increases each year</span></li>
</ul>
</li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">5 weeks of Paid Time off and 11 Paid Holidays</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Comprehensive benefits package: </span>
<ul>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Medical, dental, vision, chiropractic, acupuncture, and fertility coverage</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">50% paid premiums for dependents</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Long-term disability, family leave, and life insurance</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">403b Retirement Plan</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Employer-paid Employee Assistance Plan</span></li>
</ul>
</li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Seneca is a <a style="color: #000000;" href="https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service" target="_blank" rel="noopener">Public Service Loan Forgiveness</a> certified employer</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Scholarship opportunities, ongoing training, and professional development opportunities</span></li>
<li style="vertical-align: middle; color: black;"><span style="color: #000000;">Promotional opportunities across the agency in California and Washington</span></li>
</ul>
