Data and Reporting Analyst

Farm Credit East•Enfield, CT

4d•$65,000 - $85,000•Hybrid

About The Position

As part of Farm Credit East’s Data team, the Data and Reporting Analyst supports the Association’s data reporting and management needs. The role develops an understanding of the Association’s data assets and turns them into usable reporting through modern tools. It requires collaboration and clear communication to explain complex information to management and support development and knowledge transfer across the organization. The role’s central value is meeting the reporting needs of internal and external stakeholders, including senior management and business leaders. The analyst works with stakeholders to define requirements, deliver management reporting, improve reporting processes, and ensure information is appropriate to its purpose and regulatory requirements. The position supports reporting enhancements as legacy systems are phased out, helps establish Power BI and related reporting tools, and works with Finance and Accounting on financial reporting controls, testing, validation, and data traceability. The role also supports data management and governance by helping maintain data quality, security, and reliability; developing data quality rules and reports; querying and transforming data for reporting and analytics; and participating in the transition from on-premises storage to Microsoft Azure cloud storage. The analyst also supports implementation of an analytics catalogue to centralize reports and promote a consistent source of information. A bachelor’s degree in a relevant field is required. One to five years of experience in reporting services, databases, or a related banking or financial services field is preferred. Hybrid work options may be available after two weeks of employment, subject to role requirements and 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.
Ability to understand stakeholder requirements and produce appropriate reporting deliverables.
Ability to develop technical skills in reporting, data analysis, data visualization, communication, and relevant systems and tools.

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.
Experience in a related field within the banking or financial services industry.
Experience or developing proficiency with Business Objects; Power BI Desktop, Power BI Service, and DAX; SQL using SSMS and Databricks; SSRS and/or Power BI Paginated Report Builder; Azure Data Lake and related cloud services; Salesforce reporting and dashboards; and automation tools.

Responsibilities

Work with stakeholders to understand business requirements and deliverables and set appropriate expectations.
Respond efficiently to management reporting requests and provide insights and process-improvement recommendations where applicable.
Meet reporting needs of internal and external stakeholders, including senior management and branch managers.
Ensure reported information is appropriate for the request and meets applicable regulatory requirements.
Enhance and streamline reporting capabilities around core systems, including AgWorx, Salesforce, and nCino, as legacy systems are phased out.
Partner with Finance and Accounting to ensure management reports comply with Internal Controls over Financial Reporting, including change control, report testing and validation, and mapping data elements to source systems.
Help drive Association implementation and adoption of Power BI and either Power BI Paginated Reports as reporting tools.
Collaborate with internal and external stakeholders to scope projects, define requirements, and evaluate deliverables.
Provide service and address internal and external customer inquiries and issues.
Support data governance and data management policies that promote data quality, security, and maintenance; help define data elements, improve reliability, and minimize redundancies.
Support data quality initiatives through reporting and analysis, including developing and monitoring data quality rules and creating reports and dashboards.
Build knowledge of the Association’s databases, query data, and perform ETL to prepare raw data for reporting, analytics, and modeling.
Participate in the transition from on-premises data storage to cloud storage and develop skills for 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 centralizes reports and supports information governance and a consistent source of truth.
Build and maintain the technical and communication skills necessary to perform the role.

Benefits

Short-term incentive to reward business results.
401(k) match of up to 6% of salary; verified student loan payments may qualify for an employer 401(k) match of up to 6% for those unable to take full advantage of the 401(k) 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.