Senior Data Analyst

Areas of Responsibility: Fresno Madera Farm Credit is searching for a self-motivated, highly driven individual to join our fast-paced team environment.

The Senior Data Analyst will report directly to the Managing Director- Business Information and will provide timely and accurate financial and credit reporting for the Association, build datasets utilizing an array of technologies to produce extracts, reports and dashboards. Essential Responsibilities: Data Pull Abilities Prepares various financial information and analysis using in-house business intelligence tools Analyzes the data to verify accuracy and identify trends Builds reports and extracts using combination Microsoft Power BI Desktop, SQL Server Reporting studio (SSRS), Azure Data Studio, Power Automate, Salesforce SOQL and Azure Databricks Creates reports based on the needs of departments and interpreting what information might be useful in data mining query extracts Performs maintenance on standard, ongoing reports including clear data dictionary leveraging Collibra (Data Intelligence Platform) Leverage Python for automation of report deliveries to 3rd party Strong discipline with documentation for data evidencing Special Projects & Documentation of Results Executing and analyzing processes and recommending improvements Writing a narrative report that includes the scope of the project, a description of activities undertaken, findings and recommendations Documenting new procedures, data validation exercises and UAT testing (User Acceptance Testing) Report & Data Requirements Determines the requirements for new reports by asking questions of the requestor Identifies available information and determines what information makes sense to include in the report Backup Serves as back up to Business Information Team on process improvements and reporting Data Security & Confidentiality Appropriately protects the confidentiality, security, and integrity of the Association’s systems, data and clients’ data Knowledge, Skills, and Abilities:

Advanced knowledge of Excel, SQL, Microsoft Power BI, and Power Automate Strong technical experience and knowledge of SQL, Python and Microsoft Power BI capabilities, including DAX functions Advanced knowledge of various programs to efficiently pull information Advanced knowledge of SQL programming language Strong knowledge of data mining tools, including Azure Databricks, Python and Power BI Skill in analyzing complex technical data by using logic and quantitative reasoning Skill in utilizing time in an efficient and effective manner Skill in having perception of different dimensions of business and financial issues and making sense out of complex issues while being decisive and flexible to change Skill in taking complex tasks/datasets and distilling it to clear results Skill in reviewing multiple datasets, data dictionary and validating results for accuracy Skill in utilizing a systematic approach to problem solving Skill in recognizing the need for action and initiating activities to address the need Skill in differentiating significant and insignificant details Oral and written communication skills sufficient to discuss a variety of job-related topics, and to effectively communicate complex topics to a variety of audiences Supervisory Responsibility: N/A Minimum Qualifications: Bachelor’s or Master’s degree in Business Intelligence, Data Analysis, Finance or related field 5/ years of experience in pulling data utilizing various Business Intelligence tools for financial analysis, data development and reporting or an equivalent combination of education and experience sufficient to perform the essential functions of the job Microsoft certified:

Power BI Data Analyst preferred Physical Requirements: Positions in this class typically require keying, talking, hearing, seeing, and repetitive motions. Sedentary Work:

Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and other sedentary criteria are met.

The employee is required to have close visual acuity to perform an activity such as: preparing and analyzing data and figures; transcribing; viewing a computer screen; and/or extensive reading. Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time. ______________________________________________________________________________ ABOUT US Established in 1917, Fresno Madera Farm Credit, headquartered in Fresno, provides quality credit and financial services in California’s Central Valley.

Our mission is to provide access to credit and related services to farmers and ranchers in our region. As an efficient organization, FMFC delivers quality service with people that are passionate about creating the best possible customer experience for the generations of farmers and ranchers that we proudly serve. Fresno Madera Farm Credit offers competitive compensation packages and excellent benefit programs.

We have a team-driven, performance-focused culture, with a strong focus on customer service, and fulfilling our mission to agriculture. Salary: DOE Minimum $90,000 – Maximum $110,000 Visit www.fmfarmcredit.com for more information about the California Consumer Privacy Act. Submit resume for review by email to HRDeptfmfarmcredit.com.