Business Analyst

The County of Yuba is currently recruiting for the position of Business Analyst in the District Attorney's Office. Under general direction, ensures a department’s technical needs are met by analyzing and documenting business processes and providing related application configuration and support; concentrates on the technical needs of the business and the implementation, maintenance, and optimization of various solutions using a combination of business and technical knowledge; utilizes computer analytics and data mining strategies to provide valuable and accurate trends that lead to system optimization and strategically guided decision making; and performs related work as assigned.  

This is a stand-alone exempt classification.   

Examples of Duties:

• Consult with department management to identify, define, and document business needs and objectives, current operational procedures, problems, and input and output requirements; participate in discussions of departmental goals and objectives with executive management.
• Evaluate existing County business process models to identify potential areas for automation and streamlining.
• Seek ways to continuously improve the policies, procedures, and standards to enhance the delivery and security of County services.
• Plan, organize, and conduct research, analytical, and evaluation studies of department operations, functionality, and management systems; collect, tabulate and analyze a wide variety of data to determine trends, cycles, and underlying factors.
• Design and develop solution testing plans, strategies and quality management tools to ensure appropriate results prior to final implementation; review solution defects and make strategy adjustments as needed; plan implementation timeline.
• Prepare complex analytical reports outlining study findings as well as process improvement solutions and analyses; prepare charts, graphs, tables, and other visual tools to summarize results; make graphic and oral presentations to individuals and groups.
• Design complex data tools and system queries; develop intermediate/advanced queries, macros and applications. Examples may include MySQL and SQL queries .NET application development as required, VBA (Visual Basic for Applications) macro and application development within Microsoft Office Suite applications.
• Design, implement, and maintain system set-up tables and parameters to ensure compliance with state and federal requirements; interpret and analyze new or updated regulations to identify needed system changes.
• Utilize advanced spreadsheet functionality, business intelligence, and other data analysis platforms to generate reports and dashboards for both internal management use and external transparency efforts. Examples may include Excel, Power Query, Power Pivot, Power BI.