Business Intelligence (BI) Analyst

As employees of a farmer-owned cooperative, we come to work every day trying to honor the tireless effort and care these farming families put in every day, all day, 365 days a year. Our farmer-owners tend to think in generations, with some of our farms being run by the same families for over a century. We carry this approach into our business, knowing that each and every one of us makes a difference in allowing these generational traditions to continue, taking pride in knowing that we nourish our friends, neighbors, nation, and even the world with healthy and delicious dairy products. Our products 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

Pay:

$82,000-$102,000 a year*

• The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position’s qualifications, in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)