Engineer, Business Intelligence at Constellation Brands in Rochester, New York

Job Description:

Job Description

About Constellation Brands

 If you have taken a moment to toast with a glass of wine, celebrate with a cocktail, or relax with a bottle of beer, chances are that you’ve shared that moment with us. For more than 75 years, we’ve led the beer, wine, and spirits industry by building admired brands that delight our consumers. Our portfolio balances iconic brands, such as Corona and Modelo, with exciting gems, such as Prisoner Wine Company and High West.

About the Digital Business Acceleration (DBA) Team

Today, we continue to push boundaries by transforming our company through the Digital Business Acceleration (DBA) program. As a member of an agile team, using digital, data science and advanced analytics, you will build business-changing digital tools and capabilities with a state-of-the-art tech stack. As a member of DBA, are the architect of your career with support and mentorship to thrive. You will have the opportunity to dive headfirst into exciting opportunities that will enable you to learn new things and work on a variety of different projects. We value bold ideas, teamwork, and an entrepreneurial spirit. We like to have fun and truly embody a work hard, play hard mentality.  

About Our Team’s Culture

Culture is the lime to our Corona and represents who we are. It’s really simple. We follow our 3 C’s – Care, Community, and Curiosity in everything we do. We care about and support one another and the work we do, we fail fast and learn together, and we never stop pushing boundaries and asking questions.

Community – We fail, discover, and celebrate together. 

Curiosity – We are open minded and continue to test and learn as a team.

Care – We are genuine in our interactions and take pride in being authentic and supportive teammates.

About the Employee Experience

• Product Allowance so you can kick back and relax with Constellation’s awesome products.


• “Quiet Weeks” where there are no meetings scheduled as an opportunity to focus on individual development goals and have some heads-down time.


• Summer hours where we have half days on Fridays


• Tuition Reimbursement up to $10,000/year so you can continue feeding your brain


• $500 towards your home office set up


• Ongoing learning opportunities, development experiences, and mentorship programs


• Occasional team building meetups


• 160 hours of PTO with 13 paid holidays


• Life/Work Balance? We're all about it. We offer much more than just health care benefits. Our innovative programs and resources are designed to support physical, mental, and emotional well-being for you and your family.

About You

We’re not here to put you in a box, but- like our brands- we have found that a particular blend of attributes and mindsets successfully make up an “outstanding candidate cocktail” Recipe as follows:

• Equal parts willingness to put ambitious ideas forward and support your teammates pursuing their goals


• Strong pour of risk-taking, start-up mentality with a dash of sensitivity to navigating an enterprise size company


• 2 ounces High West Bourbon (optional)


• Garnish with a passion to develop yourself and those you work with 

About the Position

As a Business Intelligence Engineer within DBA, you will play a pivotal role in shaping the future of our Supply Chain operations. This position offers a unique opportunity to collaborate closely with our Senior BI Engineer in designing, developing, and delivering innovative BI reports that enhance the efficiency of data collection and evaluation. You will engage with cross-functional teams and stakeholders to understand and support critical Supply Chain BI goals and objectives, driving competitive research efforts. Your expertise in creating high-quality dashboards, reports, and visualizations will be instrumental in providing actionable insights and driving business decisions.

The ideal candidate thrives in an Agile environment, is curious and eager to explore new ideas, and works independently with full accountability. You are committed to sharing your knowledge with peers and embody the core values of Culture, Care, and Collaboration that define DBA. If you are passionate about innovation and teamwork, this opportunity is perfect for you.

Responsibilities:

• In collaboration with Sr BI Engineer and Supply Chain business, proactively identify areas in which business intelligence efforts can add business value and drive operational improvements.


• Collaborate with Sr BI Engineer and Product Owner and/or Product Analyst to understand BI needs, gather business requirements and deliver BI solutions that provide actionable insights


• Design and develops business intelligence dashboards, analytic reports and data visualizations using Power BI, as well as other reporting tools (as needed)


• Assist in the development of highly engaging dashboard visualizations and use innovative functions & features in dashboard design


• Ensure accuracy of reports and dashboards through quality assurance


• Write SQL queries to extract, manipulate, and validate data from various sources


• Promote self- service reporting across business users and provide coaching to teams and power users as needed


• Stay up to date with the latest Power BI features and best practices to Identify opportunities for process improvements, automation, enhanced data quality, and reporting capabilities

Domain Expertise:

• 3-5 years’ experience in BI development, data analysis, or a related role


• BS in Computer Science or equivalent education and/or experience


• Experience building reports within Power BI or another BI tool (Tableau and/or MicroStrategy). Proficient in building measures, calculated columns, and custom fields


• Experience in gathering business requirements and translating to technical details


• Experience in working with large datasets and relational databases (SQL)


• Understanding of dimensional data modeling


• Nice-To-Have: DAX, Power Query, and data modeling as well as understanding of Power BI workspaces, deployment pipelines, parameters, and deployment rules.

Agile/Digital Experience:

• Experience in Agile Development as a Data Visualization engineer (or similar) experience is a plus

Individual Skills:

• Able to understand and articulate business requirements effectively for developing business intelligence tools


• Detail-oriented with a focus on data accuracy and quality


• Strong communication skills to communicate complex ideas effectively

Physical Requirements/Work Environment

• Sitting, working at desk/personal computer for extended periods of time


• Must be at least 21 years of age

Don’t meet every requirement but still thinking about it? Take a shot! At Constellation Brands, we are dedicated to building a diverse, inclusive, and authentic workplace where differences are valued and celebrated. Excited about this role, but your qualifications are not perfectly aligned? We hope you will apply anyway- if it’s not this role, it could be the next one!

Location

Rochester, New York

Additional Locations

Virtual - US

Job Type

Full time

Job Area

Information Technology

The salary range for this role is:

$66,600.00 - $139,700.00

This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting.  We may ultimately pay more or less than the posted range, and the range may be modified in the future. An employee’s pay position within the salary range will be based on several factors including, but limited to, the prevailing minimum wage for the location, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, any collective bargaining agreements, and business or organizational needs. We offer comprehensive package of benefits including paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.

Equal Opportunity

Constellation Brands is committed to a continuing program of equal employment opportunity. All persons have equal employment opportunities with Constellation Brands, regardless of their sex, race, color, age, religion, creed, sexual orientation, national origin or citizenship, ancestry, physical or mental disability, medical condition (cancer or genetic characteristics), marital status, gender (including gender identity or gender expression), familial status, military or veteran status, genetic information, pregnancy, childbirth, breastfeeding, or related conditions (or any other group or category within the framework of the applicable discrimination laws and regulations).

Not sure you meet all qualifications? Research shows that women and members of other under-represented groups tend to not apply to jobs when they think they may not meet every qualification, when, in fact, they often do! We are committed to creating a diverse and inclusive environment and strongly encourage you to apply.

Apply Now