Data and Reporting Analyst

Farm Credit East; Enfield (CT); Hybrid; USD 65,000 - 85,000; Full time

Benefits offered by this job

401k match

Tuition reimbursement

Health, dental, vision

Employee Assistance Program

Job summary

Farm Credit East is seeking a data analyst within the Data team to support data reporting and management needs for customers and communities in the northeast. You will gather understanding of data assets and translate them into consumable formats using state-of-the-art tools.

You will drive visualization and reporting initiatives, including Power BI adoption, SQL querying, data governance, and ETL enhancements.

Qualifications

• Bachelor's degree in a relevant field (CS/IM/Stats/Finance/BI)
• 1–5 years in reporting, BI, or banking/financial services
• Hybrid work options after two weeks of employment, depending on role

Responsibilities

• Understand business requirements and deliverables.
• Carry out management reporting requests and provide insights for process improvements.
• Ensure reporting meets regulatory requirements and stakeholder needs.
• Enhance reporting around core systems (e.g., AgWorx, Salesforce, nCino).
• Work with Finance/Accounting to ensure ICFR compliance and data mapping.
• Support Power BI adoption and Paginated Reports as chosen tooling.
• Collaborate with stakeholders to scope projects and define requirements.
• Provide excellent service to internal and external customers.

Skills

Power BI

SQL querying

Data analysis

Communication

Team collaboration

Data governance

Azure Data Lake

Salesforce Reporting

Education

Bachelor's degree or related field

Tools

Power BI Desktop

Power BI Service

DAX

SSMS

Databricks

SSRS

Azure Data Lake

Salesforce Reporting

Job description

Select how often (in days) to receive an alert:

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
• 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 Benefits

• Salary Range: $65,000 to $85,000 commensurate with experience
• Short-Term Incentive to reward business results
• Retirement Contributions:
  • 401k match up to 6% of salary;or for those unable to take full advantage of the 401(k) match, verified student loan payments may qualify for an employer match in your 401(k) up to 6% of salary
  • Defined Contribution retirement plan funded at 2-9% of salary depending on years of service
• Time Off:
  • 15-25 days of vacation leave per year, depending on years of service
  • 12 days of holiday leave per year
  • 7.5 days of sick leave in your first year, followed by 12 days of sick leave per year thereafter; unlimited rollover of unused sick leave year to year
• Health and Insurance:
  • Comprehensive medical, dental, and vision plans, including preventive care and wellness programs to support your overall health and well-being
  • Health Savings Account
  • Life insurance at 2x base pay
  • Accidental Death and Dismemberment insurance at 2x base pay
  • Long-term disability insurance at 2/3 base pay
• Additional Benefits:
  • Tuition reimbursement
  • Continuing education and training
  • Employee Assistance Program offering a wide variety of tools and resources

Farm Credit East is an Equal Opportunity Employer. As an Equal Opportunity Employer, we do not discriminate on the basis of race, color, religion, national origin, sex, sexual orientation, gender identity or expression, age, marital status, parental status, political affiliation, disability status, protected veteran status, genetic information or any other status protected by federal, state or local law. It is our goal to make employment decisions that further the principle of equal employment opportunity by utilizing objective standards based upon an individual's qualifications for a specific job opening. In compliance with the Americans with Disabilities Act ("ADA"), if you have a disability and would like a reasonable accommodation in order to apply for a position with Farm Credit East, please call 1-800-562-2235 or e-mail [e-mail]