Upstate Niagara Cooperative logo

Business Intelligence (BI) Analyst

Upstate Niagara Cooperative

Lancaster, NY
Full Time
Mid Level
82k-102k
20 days ago

Job Description

About the Role

The Business Intelligence (BI) Analyst position is responsible for examining information using data analysis tools to help teams develop insights and business strategies. This highly technical, client-facing role involves developing reports, dashboards, and visual reports from multiple data sources, monitoring data quality, troubleshooting data issues, and providing technical expertise in data storage, mining, and cleansing. The company is a farmer-owned cooperative committed to supporting farming families and producing dairy products under various brands, emphasizing tradition, community, and quality.

Key Responsibilities

  • Developing reports for clients using multiple data sources and analysis. Monitor and audit data quality. Troubleshooting data issues.
  • Managing and designing the reporting environment, including data sources, security, and metadata.
  • Designs and builds dashboards, visual reports, and key performance indicators for various levels of the organization.
  • Providing training for clients or end-users on new reports, dashboards (i.e., PowerBI, Qlik, Tableau, Excel).
  • Providing technical expertise in data storage structures, data mining, and data cleansing (ETL and ELT processes).
  • Develop develop policies and procedures for the collection and analysis of data and document them.
  • Monitor analytics and metrics results and frequently build reports to advise upper management on critical business decisions.
  • Perform other duties as required.

Requirements

  • Bachelor's degree or equivalent experience.
  • 1-3 years of experience in the analytics field with a focus on delivery of analytical offerings including dashboards, on-demand reporting, business analysis, etc.
  • Understanding of analytical process automation.
  • Working knowledge of SQL, Power BI, Qlik.
  • Working Knowledge of Microsoft SQL Server Integration Services (SSIS).
  • Proficient in prototyping, designing, and requirement analysis.
  • Capable of handling project documentation and design methodology.
  • Ability to develop multidimensional models compatible with data warehouse standards.
  • Experience extracting data from various data sources and connecting, importing, and transforming data.
  • Adept in scheduling, developing, and publishing reports as per requirements.
  • Excellent communication skills, both written and verbal at all organizational levels.

Nice to Have

  • Experience translating user requirements into solutions, including communicating designs through wireframes, defining Minimum Viable Product, and managing change requirements.

Qualifications

  • Bachelor's degree or equivalent experience.

Benefits & Perks

  • Salary range of $82,000-$102,000 per year, depending on experience and qualifications.
  • Participation in group health and/or dental insurance.
  • Retirement plan.
  • Wellness program.
  • Paid time off and holidays.

Working at Upstate Niagara Cooperative

The company is a farmer-owned cooperative that values tradition, community, and quality. It is committed to supporting farming families and producing healthy, delicious dairy products, fostering a work environment that honors hard work, care, and generational continuity.

Apply Now

Job Details

Posted AtJun 1, 2025
Salary82k-102k
Job TypeFull Time
ExperienceMid Level

About Upstate Niagara Cooperative

Website

upstateniagara.com

Company Size

1001-5000 employees

Location

Lancaster, NY

Industry

Dairy Cattle and Milk Production

Get job alerts

Set up personalized alerts for your job search and get tailored job digests for close matches