Farm Credit Mid-America is a financial services cooperative serving financial needs of farmers and rural residents in Arkansas, Indiana, Kentucky, Missouri, Ohio, and Tennessee. Our purpose is to secure the future of rural communities and agriculture. We are passionate about serving the needs of our rural communities and creating positive customer experiences.
Farm Credit Mid-America is a great place to work! We have been named as a Best Places to Work in Kentucky for the past 11 years. At Farm Credit Mid-America we put our customers and team members at the heart of all we do.
SCHEDULE: [[jobType]] TRAVEL REQUIRED: [[customString6]]
COMPENSATION: [[salaryMin]] to [[salaryMax]] base salary plus potential for variable compensation. Base pay is determined by your skills, qualifications, experience, and location. Farm Credit Mid-America/Rural 1st may compensate outside of the salary range for bona fide reasons not related to membership in a protected class.
About Our Opportunity
Our Database Analyst will gather, document, and analyze information requirements for implementation and integration into database environments. Respond to recurring and ad hoc reporting requests and data updates. Translate business requirements into actionable insights, collaborate with other team members to deliver data extracts, operational reports and dashboards. Ensure accuracy and integrity of operational data. Provide second level support to our business, database and application development teams.
How You Will Spend Your Time
Establish relationships with business units, solicit and gather requirements. Evaluate systems for efficiencies and continuously improve data delivery mechanisms.
Execute complex data extraction and integrate to create and supply data sets to allow users to perform analysis and data mining.
Develop, inspect, clean, and transform data and evaluate resulting data sets; Profile data, identify trends and patterns, find and understand anomalies and / or outliers; implement quality assurance procedures to ensure accuracy of data.
Partner with team members to develop custom software algorithms and programs related to data collection. Define and document all data sets and extraction and integration routines. Assist with creating training documents and videos.
Serve as point of contact for business regarding data inquiries and data modifications.
Develop, test, implement, maintain and document reports and reporting processes.
In coordination with the Database Architects, analyze requirements and develop data migration/conversion plans and objects. Work with Database Architects to derive solutions for data related issues.
Responsible for monitoring the day-to-day activities of corporate databases and ensure accuracy and integrity of operational data. Initiate and/or monitor corrective action, as necessary. Research and review current orchestrations to identify improvements and tuning.
Create and maintain testable scripts/business scenarios specifically for the purpose of good integration testing.
Actively participates on assigned projects fulfilling task assignments, meeting deadlines, and proactively seeking attainment of team goals to align with business needs.
Minimum Education & Experience
Bachelor’s degree in business, accounting or computer science or related field and 3 years direct experience working with data analytics, SQL, and visualization tools. Minimum three years’ experience in requirements gathering and analysis with the business and development teams.
Mental & Physical Requirements
Engage in telephone and face-to-face conversation to serve customers and give and receive information from customers, staff, vendors, outside consultants and the public.
Use a computer and similar office technology and tools. This involves reading the screen and keying/typing information.
Speak and make presentations to individuals or groups on technical subjects related to job.
Travel via auto or commercial transportation to carry out essential responsibilities of the job.
Successfully interact with and represent the organization to customers, staff, officers, board members, vendors, and/or the public at all levels.
Provide sound technical advice to customers and other staff in the subject field(s) related to this position.
Understand and explain various subject matter and consulting concepts, programs, terminology, and methods.
Reason, judge, compare, calculate, evaluate, decide, and critique such information as written material, numerical data, responses to customer needs, and/or other related work activities.
Farm Credit Mid-America provides a competitive total rewards package to our team members. This includes an award winning 401(k) Plan. Our Health and Financial wellness benefits provide safety, security and peace of mind for you and your family. Here is a highlight of our Total Rewards and Benefits (https://careers.fcma.com/content/Our-Benefits/?locale=en_US) .
Farm Credit Mid-America is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, veteran status, disability or any other category protected by law.
#LI-HYBRID #IND123