Department Analyst I (Two-Year, Fixed-Term)

County of Marin; San Rafael (CA); On-site; USD 65,000 - 88,000; Full time

Job summary

County of Marin seeks a Department Analyst I to gather Criminal Justice data from multiple information systems for use in legal proceedings, grant reporting, and Public Records Act requests. The role involves creating reports, dashboards, and visuals to support Deputy District Attorneys and supervisors.

Ideal candidates are highly organized, detail-oriented, and able to work both independently and in teams.

Qualifications

• Equivalent to graduation from a four-year college or university with a major in business or public administration, public policy, political science, social services, health care administration or a related field. Professional level experience may substitute for the education on a year-for-year basis.
• Professional level experience performing administrative, analytical, fiscal, legislative, operational, policy, program planning or research work may be substituted for the required education on a year-for-year basis.
• The selected candidate must pass a background investigation as required for employment in a law enforcement agency.

Responsibilities

• Gather Criminal Justice data from multiple information systems and specialized legal databases for use in legal proceedings and grant reporting.
• Prepare reports with pivot tables, dashboards, graphs and charts.
• Summarize findings and present reports to Deputy District Attorneys and other stakeholders.
• Develop data-based insights to support policy decisions and Public Records Act requests.

Skills

Excel proficiency

Power BI

Data analysis

Pivot tables

Report writing

Team collaboration

Education

Bachelor's degree in business or public administration or related field

Tools

Microsoft Power BI

Microsoft Excel

Job description

At the County of Marin, our employees overwhelmingly report feeling their work is meaningful, they like the work they do, and they are proud to tell people “I work for the County of Marin.” Discover more about us, our values and our organizational culture on the Department of Human Resources website. Read on to find out more about this opportunity.

There is currently one (1), two-year, fixed-term vacancy for a Department Analyst I (DA I) with the District Attorney's Office.

The Department Analyst I (DA I) is responsible for gathering Criminal Justice data from multiple information systems and specialized legal databases for use in legal proceedings, grant reporting, Public Information Requests, and internal process monitoring. Some reports consist of charts and graphs prepared for Deputy District Attorneys for use in criminal proceedings, others consist of specific tallies of case, defendant, or victim types for state and federal grant reporting. The DA I provides the full range of analytical support, and this entails (but is not limited to):

• Discuss and understand data requests from DA employees.
• Define and collect needed data for requested reports.
• Collect data from a variety of sources including the District Attorney's internal case management system.
• Research Criminal Justice Data from external sources to develop comparisons to Marin County data.
• Provide detailed requirements to appropriate individuals if available tools are insufficient for data pull, and a custom query is needed.
• Work with spreadsheets to prepare reports, including use of pivot tables, dashboards, graphs and charts.
• Recommend and prepare visualizations to present dense Criminal Justice information through counts, tallies, charts and graphs.
• Summarize reports, present findings to supervisor and Deputy District Attorney's requesting data.

Our highly qualified candidate is highly organized, has exceptional attention to detail, strong time management skills, possesses excellent written and oral communication skills, is an analytical thinker, proactive, flexible in their approach to their work, and can solve problems creatively. The ideal candidate must be highly proficient with Excel, and have some experience working with Microsoft Power BI. The candidate will need to have experience of working successfully in a team environment and will also need to work independently. This person must develop and maintain positive working relationships with everyone. Our ideal candidate knows what it takes to manage a successful project. We are looking for someone to support the Deputy District Attorneys in collecting and preparing specific statistics as needed, as well as supporting the office as a whole by developing detailed accurate data for use in responding to Public Record act requests. The ideal candidate will be an asset to divisions within the department by brainstorming solutions for data collection and reporting for data driven policy and procedure decision making, and progress tracking. The ability to identify and develop clear priorities, manage workload, and be able to work under short deadlines is critical.

QUALIFICATIONS

KNOWLEDGE OF

• Principles and practices of business and public administration.
• Principles and practices of work planning, data collection and analysis, project management and research methodology.
• Applicable laws, rules, and regulations.

ABILITY TO

• Plan, organize, and conduct research and analytical studies.
• Interpret, apply and explain laws, regulations and policies governing program operations.
• Prepare clear, concise and accurate reports, correspondence, policies, procedures and other written materials.
• Establish and maintain effective working relationships with those contacted in the course of work, including other departments, community members and organizations, public and private agencies, local, state and federal agencies.
• Effectively represent assigned programs, the department and County in meetings and presentations.
• Work under short, externally imposed deadlines.

MINIMUM QUALIFICATIONS

Equivalent to graduation from a four-year college or university with a major in business or public administration, public policy, political science, social services, health care administration or a field related to the work. Professional level experience performing administrative, analytical, fiscal, legislative, operational, policy, program planning or research work may be substituted for the required education on a year-for-year basis.

Special Requirements:

The selected candidate must pass a background investigation as required for employment in a law enforcement agency.

For any questions concerning this position announcement, please contact Colleen Beck at [e-mail].

All applicants will receive email notifications regarding their status in the recruitment process. Please be sure to check your spam settings to allow our emails to reach you. You may also log into your governmentjobs.com account to view these emails.

Testing and Eligible List:

Depending on the number of qualified applications received, the examination may consist of a highly qualified review, application screening, online assessment, written examination, oral examination, performance examination, or any combination to determine which candidates' names will be placed on the eligible list. The eligible list established from this recruitment may be used to fill the current vacancy and any future vacancies for open, fixed-term, full-time, or part-time positions which may occur while the list remains active.

Disaster Service Workers:

All County of Marin employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the County requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.

Equal Employment Opportunity Employer:

If you have questions regarding equal employment opportunities, please contact Roger Crawford, Equal Employment Opportunity Director, at 415-473-2095.