What are the responsibilities and job description for the Data Analyst position at AgWest Farm Credit?
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 I or Data Analyst II, to join our Data Management department in 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.
After an initial in-office training period, this position is eligible for workplace flexibility and a one-time home office stipend. Employees are expected to continue working from their office location a minimum of 50% or 60% of the time depending on location.
Compensation Information
The base salary range for this position in Rocklin, California is:
Level I
Typical starting range: $67,700 - $90,400
Full base salary range: $67,700 - $111,800
Annual performance-based incentive target is 8% or 10% of base depending on experience.
Level II
Typical starting range: $81,100 - $111,900
Full base salary range: $81,100 - $127,200
Annual performance-based incentive target is 10% of base.
Job Requirements
Job level and starting annual salary will be based on a variety of factors including but not limited to experience, education, certifications/licensure, internal equity, location, business needs and market demands. The listed compensation and benefits information is accurate as of the posting date. AgWest reserves the right to adjust compensation for all positions and modify or discontinue benefits programs at its sole discretion, subject to applicable law.
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.
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 I or Data Analyst II, to join our Data Management department in 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.
After an initial in-office training period, this position is eligible for workplace flexibility and a one-time home office stipend. Employees are expected to continue working from their office location a minimum of 50% or 60% of the time depending on location.
Compensation Information
The base salary range for this position in Rocklin, California is:
Level I
Typical starting range: $67,700 - $90,400
Full base salary range: $67,700 - $111,800
Annual performance-based incentive target is 8% or 10% of base depending on experience.
Level II
Typical starting range: $81,100 - $111,900
Full base salary range: $81,100 - $127,200
Annual performance-based incentive target is 10% of base.
Job Requirements
- Work with the VP, Data Solutions and the Data leadership team to support the organization's data solutions needs.
- Support the company’s governance, business intelligence and risk management programs as they relate to data and analytics systems.
- Collaborate with risk management staff and external service providers to prioritize and deliver data initiatives.
- Provide support for future business enablement initiatives including GIS, advanced data visualization, and predictive analytics.
- Collaborate with team members to identify requirements, define successful outcomes, and deliver trusted results.
- Utilize data to assess future risk, opportunities and effectiveness. Translate results into meaningful solutions to enhance decision making.
- Monitor existing data models and help develop reports, analysis, and recommendations for Enterprise Risk Management leadership.
- Follow CI/CD best practices for data systems ensuring reliable development, deployment, and maintenance for built data solutions.
- Develop SQL and Python transformation code to process data for analytics.
- 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.
- 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, Python.
- Effective decision-making skills as well as strong interpersonal, communication, customer service and team skills.
- 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.
- 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, 12 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.
Job level and starting annual salary will be based on a variety of factors including but not limited to experience, education, certifications/licensure, internal equity, location, business needs and market demands. The listed compensation and benefits information is accurate as of the posting date. AgWest reserves the right to adjust compensation for all positions and modify or discontinue benefits programs at its sole discretion, subject to applicable law.
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.
Salary : $67,700 - $127,200
