Business Intelligence (BI) Analyst

Company: Upstate Niagara Cooperative, Inc.
Location: Lancaster
Posted on: May 27, 2023

Job Description:

Owned by 250+ family farms, Upstate Niagara Cooperative, Inc. is a food and beverage company that has offered innovative, award-winning, high-quality dairy products since 1965. Our progressive cooperative's success is based on a commitment to quality in everything we do that extends to every stage of operations, from our farms to the consumer. Our product offerings include milk, flavored milk, yogurt, dip, sour cream, cottage cheese, Italian cheese, and ice cream mix marketed under the Upstate Farms -, Bison -, Milk for Life -, and Intense Milk - brands.The Business Intelligence (BI) Analyst position is responsible for examining information using data analysis tools to help teams develop insights and business strategies. Develop reports for clients using multiple data sources and analysis. Monitor and audit data quality. Troubleshoot data issues. This is a highly technical, client-facing role.PRIMARY AND 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 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. Other duties as required.
EDUCATION:
Bachelor's degree or equivalent experience
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)
May be required to work outside normal business hours on an as needed basis.
SKILLS and ABILITIES:
Proficient in prototyping, designing, and requirement analysis. Must be capable of handling project documentation and design methodology. Should be capable of developing multidimensional models that are compatible with data warehouse standards. Extracting data from various data sources and connecting, importing, and transforming data Adept in scheduling, developing, and publishing reports as per requirements. Experience translating user requirements into solutions, including communicating designs through wireframes, defining Minimum Viable Product and managing change requirements.
Exceptional communication skills, both written and verbal at all levels within the organization
Upstate Niagara Cooperative, Inc. is committed to equal employment opportunity for all, without regard to race, religion, color, national origin, citizenship, sex, sexual orientation, gender identity, age, veteran status, disability, genetic information, or any other protected characteristic.

Keywords: Upstate Niagara Cooperative, Inc., Buffalo , Business Intelligence (BI) Analyst, Professions , Lancaster, New York