Human Resource Services
Alameda Skyline

Information Systems Specialist

Data Analyst

Recruitment #19-9999-04

Go Back

Introduction

At the Alameda County District Attorney's Office, we review and prosecute criminal violations committed in Alameda County, bring criminal and civil actions for environmental, consumer and other violations, protect and uphold the rights of victims, and serve our community in various innovative ways (such as restorative justice projects). Read more about our mandated services.


The Alameda County District Attorney’s Office is comprised of approximately 150 attorneys, 60 inspectors, 30 Victim-Witness advocates and claim specialists, as well as a variety of administrative, finance, and communications professionals. Our jurisdiction covers over 800 square miles and our staff work in 9 offices located throughout the County.


We have six specialized divisions within the office:


Within the Criminal Prosecution Division, we have numerous specialized units dedicated to specific areas. Some of the units include: domestic violence, gangs, sexual assault, human trafficking, DNA/unsolved cases, truancy, identity theft, sexually violent predators, child abduction and more. These units are staffed by experienced, highly skilled prosecutors who are experts in their individual fields.

 

DESCRIPTION

Systems Environment


The District Attorney Office has approximately 450 computers, 200 standalone printers, 18 physical and virtual servers, and 50 network printers. Operating systems and application software include: Windows 7, 8.1, and 10; Windows 2003R2, 2008R2, 2012R2, and 2016 servers; SQL 2000, 2005, 2012 and 2016; IIS Web Servers; Office 2010, 2013, 2016, and Office 365; and Case Management Systems.


The Position


The District Attorney’s Office is recruiting for positions within our internal Information Technology Unit.  We are looking for a Data Analyst with solid organization and analytical skills as well as SQL Server, T-SQL, SSRS, Access, Excel, Visual Basic (VBA) and Power BI experience.  The candidate will gather information from various large datasets, write queries and create frequent reports and ad hoc reports for senior management. The candidate will also provide support for a case management system.

 

Hours: 8:30 am – 5:00 pm.   Monday through Friday

       

Work Location: René C. Davidson Courthouse, 1225 Fallon Street, Oakland.

MINIMUM QUALIFICATIONS

Qualifications

  • Bachelor of Science in Computer Science, Management Information Systems, or related field, or equivalent experience
  • Minimum three years of previous employment in related field
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Proficient in business intelligence, and data visualization techniques using large datasets
  • Ability to analyze large datasets using SQL
  • Ability to write comprehensive reports
  • Ability to work well with others in a team environment
  • Strong oral and written communication skills

License: Possession of a valid California driver’s license is required.

KNOWLEDGE AND SKILLS

Responsibilities

  • Support and maintain SQL Server databases
  • Collect data by using a scripting language such as T-SQL
  • Explore and analyze datasets with tools like Excel
  • Visualize data insights and communicate findings to teams across the organization
  • Use statistical methods to analyze data and generate useful business reports
  • Support 30+ Microsoft Access databases
  • Present data analysis to different teams and groups of all levels

Conclusion

To Apply: Submit completed job application (using the link below) to Alameda County District Attorney Human Resource Department: dajobs@acgov.org. Please attach your resume and cover letter.


DA Employee Application

All applications must be submitted no later than 5:00 p.m. on April 12, 2019.

The District Attorney Office is an Equal Opportunity Employer. All qualified candidates, regardless of race, ethnicity, gender or physical ability are encouraged to apply.