Data Analyst

AgWest Farm Credit; Spokane (WA); Hybrid; USD 70,000 - 111,000; Full time

Job summary

Join a forward-thinking financial cooperative as a Data Analyst, where you will play a crucial role in enhancing data governance and quality. This full-time position offers the opportunity to work in a hybrid environment, contributing to innovative data solutions that empower decision-making across various business initiatives. If you are passionate about data and eager to make a significant impact in the agricultural finance sector, this role is perfect for you. Enjoy a supportive workplace culture with competitive compensation and comprehensive benefits.

Benefits

Medical, dental, and vision insurance

401(k) plan with employer contribution

Paid time off (15 vacation, 15 sick, 11 holidays)

Wellness Program

Employee Assistance Program

Qualifications

• 3+ years of experience in data management, ideally in financial institutions.
• Strong SQL skills with knowledge of DML and DDL techniques.

Responsibilities

• Support data governance processes and ensure data quality.
• Collaborate with teams to identify and resolve data quality issues.

Skills

SQL

Python

Data Management

Data Quality

Data Modeling

Communication Skills

Education

Bachelor's degree in Computer Science

Equivalent combination of education and experience

Tools

Microsoft Power BI

Azure Data Factory

Git

Job description

AgWest Farm Credit is a member-owned 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 100+ year-old Farm Credit System - the leading provider of credit to American agriculture.

AgWest champions the growth and advancement of agriculture, the value of rural communities, and the vital contribution our customers make to the economy and society. We serve customers in 59 locations throughout the West.

We are in search of a Data Analyst II or Data Analyst III to join our Data Management department in Spokane, Washington or Rocklin California. This full-time position reports to the VP, Data Solutions and supports the organization's data governance process, with an emphasis on data validation, data modeling and data quality.

This position is eligible for a hybrid work schedule and one-time home office stipend after initial training period.

Compensation Information

The base salary range for this position in Spokane, Washington is:

Level II: $70,800 - $110,800; bonus at target is 10% of salary.

Level III: $78,000 - $122,100; bonus at target is 12-15% of salary.

The base salary range for this position in Rocklin, California is:

Level II: $81,100 - $127,200; bonus at target is 10% of salary.

Level III: $89,300 - $140,600; bonus at target is 12-15% of salary.

Job Requirements

• Work with the VP, Data Solutions and the Data Management team to support the organization's data governance process.
• Work closely with other department 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.
• Collaborate 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. translate results into meaningful solutions to enhance decision making.
• Monitor existing data models and develop reports, analysis, and recommendations for Enterprise Risk Management leadership.
• Conduct risk analysis, 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.
• Perform all duties and maintain all standards in accordance with company policies, procedures, and internal controls.
• Other duties as assigned.

Minimum Requirements

• Bachelor's degree in computer science information technology, business, or related field, or an equivalent combination of education and experience
• Generally, requires at least three years' experience in data management or related field, ideally in financial institution operations
• 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 of 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

Benefits Offered by AgWest

• Medical, dental, and vision insurance
• Basic term life and AD&D insurance (fully paid for by the company)
• Paid days off annually: 15 vacation*, 15 sick, 11 holidays and 3 volunteer
• 401(k) plan (6% match plus 3% employer contribution)
• Employee Assistance Program
• Wellness Program
• Jeans are welcome at work every day at AgWest!

*Vacation accrual rates increase with tenure.

Details about insurance and retirement benefits are available at: https://www.farmcreditfoundations.com/fcfbenefits

#LI-Hybrid

Qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender orientation, national origin, marital status, age, disability, protected veteran status, or any other classification protected by law.

When you apply for a position with AgWest Farm Credit, we collect personal identifiers (from your resume and other application information you submit), such as your name, email address, mailing address, telephone number(s) and employment and education related information. This helps us evaluate job applicants for hiring opportunities, and, communicate with them.

To comply with federal regulations for equal employment opportunity and affirmative action (EEO/AA), we track our applicants by gender, race/ethnicity, veteran status, disability status, and the position for which they applied. You will be presented with a voluntary self-identification form as part of this application; we wanted you to know why we collect this information and what we do with it. Please be aware that this information is kept separate from your application, and not utilized in the selection process.

For more information about the information AgWest Farm Credit collects, please see the AgWest Farm Credit California Privacy Policy.