Data and Reporting Analyst

Description/Job Summary

Join a team focused on the success of our customers, the success of our communities, and the success of each other. Farm Credit East (FCE) is the leading provider of loans and farm advisory services to farm, forest product, fishing, and other agricultural business owners across the northeast with nearly $15 billion in total loan volume and $29 million in annual financial services revenue from 18,000 customers across our 8-state territory. We are One Team Working Together with a focus on our five pillars: Outstanding Customer and Employee Experience, Quality Growth, Operational Excellence, Commitment to our Communities, and Protecting Customer Information.

As part of the Data team, the position will entail supporting Farm Credit East's data reporting and management needs. The successful candidate will gather a critical understanding of the Associations data assets and compile that into consumable formats utilizing state of the art tools. Strong collaboration and communication skills are essential both to communicating complex concepts to management in a way that is easy to understand, and to facilitating development and knowledge transfer across the Associations management team.

The value driver for this role is as follows:

• Ensure the reporting needs of various internal and external stakeholder groups (senior management, business unit leaders, regional leaders, etc.) are met

Come join a collaborative, customer-focused team at Farm Credit East!

Duties and Responsibilities

Data Analysis & Reporting

• Works with stakeholders to understand business requirements and deliverables, and sets appropriate expectations.
• Effectively and efficiently carry out management reporting requests, provide insight and recommendations for process improvements where applicable.
• Ensure the reporting needs of various internal and external stakeholder groups (senior management, branch managers, etc.) are met.
• Data / information presented is appropriate for the request and meets any regulatory requirements.
• Assist in enhancing and streamlining reporting capabilities around core systems (i.e. AgWorx – Salesforce/nCino) as legacy systems are phased out.
• Work with Finance and Accounting to ensure management reports are in compliance with Internal Controls over Financial Reporting, including but not limited to following change control procedures, completing key report testing and validation, and mapping data elements back to source systems.
• Help drive Association implementation and adoption of Power BI and either Power BI Paginated Reports as the reporting tool(s) of choice within the Association.
• Work collaboratively with key stakeholders both internally and externally to scope projects, define requirements, and evaluate deliverables.
• Provide outstanding service and effectively address customer (both internal and external) inquiries and issues in order to maintain strong customer relationships.

Data Management and Data Governance

In collaboration with the Data Governance & Data Management Offices:

• Maintain a sound understanding of data management and data governance’s role in guiding the collection, management, and use of Association data; including the Association’s data governance framework, approach, and vision.
• Support the data needs from across the organization by helping to carry out, enhance, and reinforce policies that ensure quality, security, and maintenance of data. This may include helping to define data elements, enhance data reliability, and minimize redundancies.
• Support data quality initiatives through reporting and data analysis. This may include activities such as developing and monitoring data quality rules and creating reports/dashboards for management and staff use.
• Develop a sound understanding of the Association’s vast database and become proficient in querying the Association’s data and performing ETL to ensure the raw data is transformed appropriately for use in management reporting, analytics, and modeling.
• Actively participate in the Association’s transition from on-premises data storage to cloud storage, including developing the core technical skills necessary to carry out data management, reporting, and data governance within the Microsoft Azure platform.
• Operate within defined change control / ICFR procedures and guidelines.
• Support and facilitate the implementation of an analytics catalogue tool to support overall information governance, provide a centralized report location for staff, and ensure "one version of the truth."

Skills Development

The analyst should build and maintain a technical skillset that enables execution of all aspects of the job function. Skills development is inclusive of both methodology and tools. Skills necessary to execute the function include, but are not limited to:

• Core FCE Systems
• Business Objects
• Power BI Desktop, Power BI Service, and DAX for Power BI
• SQL querying though SSMS and Databricks
• SSRS and/or Power BI Paginated Report Builder
• Azure Data Lake and related cloud environment
• Salesforce Reporting and Dashboarding
• Automation Tools
• Data Analysis
• Data Visualization
• Communication

Job Qualifications and Requirements:

• This position requires a Bachelor's degree in computer science, information management, statistics, finance, business intelligence or related field required.
• 1 - 5 years of experience in any of the following areas preferred: strong knowledge of and experience with reporting services (Business Objects, Salesforce, Power BI, SSRS) and databases (i.e. SQL) or experience in a related field within the banking / financial services industry.
• We offer hybrid work options after two weeks of employment with Farm Credit East. Hybrid work options are determined based on job role and balancing the needs of the customers, the team, and individual work performance. This will be reviewed based on manager discretion.

Compensation and Benefit