Data and Reporting Analyst

Farm Credit East•Enfield, CT

2d•Hybrid

About The Position

Join Farm Credit East’s Data team to support the Association’s data reporting and management needs. The analyst will develop a strong understanding of the Association’s data assets and make them useful to stakeholders through appropriate reporting and modern tools. The role requires collaboration and clear communication, including explaining complex concepts to management and facilitating development and knowledge transfer across the organization. Its central goal is to meet the reporting needs of internal and external stakeholders, including senior management and business leaders. The analyst gathers stakeholder requirements, delivers management reports and recommendations, and ensures that reporting is appropriate to the request and complies with regulatory requirements. The role supports improvements to reporting capabilities as legacy systems are phased out, helps advance Power BI adoption, and works with Finance and Accounting on reporting controls, testing, validation, and data mapping. In collaboration with Data Governance and Data Management Offices, the analyst supports data quality, security, maintenance, and governance initiatives. This includes querying Association data, performing ETL, developing and monitoring data quality rules, and supporting the transition from on-premises data storage to Microsoft Azure cloud storage. The role also supports an analytics catalogue tool and operates according to defined change-control and ICFR procedures. Farm Credit East offers hybrid work options after two weeks of employment. Hybrid arrangements depend on the job role and the needs of customers, the team, and individual performance, and are subject to manager discretion.

Requirements

Bachelor’s degree in computer science, information management, statistics, finance, business intelligence, or a related field.
Strong collaboration and communication skills, including the ability to explain complex concepts clearly to management.
The position requires a technical skillset applicable to data reporting and management, including data analysis and data visualization.

Nice To Haves

One to five years of experience in reporting services such as Business Objects, Salesforce, Power BI, or SSRS, and databases such as SQL; or experience in a related field within banking or financial services.
Experience with Business Objects.
Experience with Power BI Desktop, Power BI Service, and DAX.
Experience with SQL querying through SSMS and Databricks.
Experience with SSRS and/or Power BI Paginated Report Builder.
Experience with Azure Data Lake and related cloud environments.
Experience with Salesforce reporting and dashboarding.
Experience with automation tools.

Responsibilities

Work with stakeholders to understand business requirements and deliverables and set appropriate expectations.
Complete management reporting requests efficiently and provide insight and process-improvement recommendations where applicable.
Meet the reporting needs of internal and external stakeholder groups, including senior management and branch managers.
Ensure reports are appropriate to the request and comply with regulatory requirements.
Enhance and streamline reporting capabilities around core systems, including AgWorx, Salesforce, and nCino, as legacy systems are phased out.
Work with Finance and Accounting to ensure management reports comply with Internal Controls over Financial Reporting, including following change-control procedures, completing report testing and validation, and mapping data elements to source systems.
Help drive adoption of Power BI and Power BI Paginated Reports as reporting tools within the Association.
Collaborate with internal and external stakeholders to scope projects, define requirements, and evaluate deliverables.
Address internal and external customer inquiries and issues to maintain strong customer relationships.
Support data management and governance policies that promote data quality, security, and maintenance; help define data elements, improve data reliability, and minimize redundancies.
Support data quality initiatives through reporting and analysis, including developing and monitoring data quality rules and creating reports or dashboards.
Develop proficiency in querying Association data and performing ETL to prepare data for reporting, analytics, and modeling.
Participate in the transition from on-premises data storage to cloud storage and develop the skills needed to support data management, reporting, and governance in Microsoft Azure.
Follow defined change-control and ICFR procedures and guidelines.
Support implementation of an analytics catalogue tool that provides a centralized report location and helps ensure one version of the truth.
Build and maintain the technical skills needed to perform the role.

Benefits

Short-term incentive to reward business results.
401(k) match up to 6% of salary; verified student loan payments may qualify for an employer match in the 401(k) up to 6% for those unable to take full advantage of the match.
Defined Contribution retirement plan funded at 2–9% of salary depending on years of service.
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 the first year and 12 days per year thereafter, with unlimited rollover of unused sick leave.
Comprehensive medical, dental, and vision plans, including preventive care and wellness programs.
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.
Tuition reimbursement.
Continuing education and training.
Employee Assistance Program offering tools and resources.
Hybrid work options after two weeks of employment, subject to role, business needs, performance, and manager discretion.