AgWest (formerly Northwest Farm Credit and Farm Credit West) is a $30 billion financial cooperative that provides financing and related services to farmers, ranchers, agribusinesses, commercial fishermen, timber producers, rural homeowners and crop insurance customers in a seven-state territory in the Western United States. AgWest is part of the 106-year-old Farm Credit System – the leading provider of credit to American agriculture. AgWest serves customers in 59 locations throughout the West. For more information, go to agwestfc.com.

We are in search of a Data Analyst I or Data Analyst II to join our Data Management department in Rocklin, California. This full-time position reports to the SVP Data Management and supports AgWest’s data governance process, with an emphasis on data validation, data modeling, and data quality.

The Data Analyst performs a variety of functions including, but not limited to:

• Work with the SVP Data Management to support AgWest’s data governance process.
• Work closely with other AgWest departments to identify and remove any data quality issues.
• Provide metrics to measure data accuracy along with reports outlining recurring quality issues as basis of training needs.
• Work with Enterprise Risk Management staff and external service providers to prioritize and deliver on data governance initiatives.
• Provide support for future business enablement initiatives including GIS, advanced data visualization, and predictive analytics.
• Enhance, modify, and maintain existing reporting library and build new reporting solutions.
• Utilize data to assess future risk, opportunities, and effectiveness, then translate results into meaningful solutions to enhance decision making.
• Monitor existing data models and develop management level reports, analysis, and recommendations for enterprise risk management leadership.
• Conduct risk analyses, including efficient extraction, manipulation, and analysis of complex datasets.
• Analyze data and information in innovative ways to provided support for decisions and enhance process efficiencies.

Note: This is not a remote role and will require on-site work at the Rocklin, California office. This role is eligible for a hybrid schedule after an initial training period.

AgWest Farm Credit does not provide visa sponsorships.

Minimum Requirements

• Bachelor’s degree, preferably in information technology, computer science or related field (Relevant experience may be substituted for education).
• At least 5 years of progressive experience in data management.
• Advanced computer skills including MS Office applications and other related industry applications.
• Strong SQL skills, with detailed knowledge of DML and DDL techniques and best practices in one or more relational database platforms.
• Strong development skills in one or more C-family of languages: Python (preferred), C#, R, or Java.
• Understanding of Software Development Lifecycle (SDLC), source control systems (Git, etc.), process flowcharts, Entity-Relationship diagrams, and data management environments.
• Knowledgeable of Azure environment for data projects, including one of the following: Azure Data Factory (ADF), SSIS, Databricks, SparkSQL, Jupyter, Anaconda.
• Effective decision-making skills as well as strong interpersonal, communication, customer service and team skills.

Preferred Requirements

• Experience in one the following reporting/business intelligence technologies: Microsoft Power BI Paginated/SSRS, SSAS, SAP Business Objects, Crystal Reports, MicroStrategy, Cognos, OBIEE, Hyperion, etc.
• Understanding of container runtimes (Docker, Rocket Kubernetes, etc.).
• Experience contributing to Business Requirements Documents, High-Level Design Documents, Functional Design Documents, and other development documentation.
• A working knowledge of financial industry business processes and data infrastructure.