AgWest Farm Credit is looking to enhance its data solutions and governance processes to support the organization's data validation, data modeling, and data quality initiatives, ultimately aiming to improve decision-making and process efficiencies.
Requirements
- 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.
- 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.
Responsibilities
- Support the company’s governance, business intelligence and risk management programs as they relate to data and analytics systems.
- Provide support for future business enablement initiatives including GIS, advanced data visualization, and predictive analytics.
- 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.
- Collaborate with risk management staff and external service providers to prioritize and deliver data initiatives.
Other
- Generally, requires at least three years' experience in data management or related field, ideally in financial institution operations.
- Effective decision-making skills as well as strong interpersonal, communication, customer service and team skills.
- A working knowledge of financial industry business processes and data infrastructure.
- Employees are expected to continue working from their office location a minimum of 50% or 60% of the time depending on location.
- After an initial in-office training period, this position is eligible for workplace flexibility and a one-time home office stipend.
