Intern, Finance Analytics

Constellation Brands; United States; On-site; USD 26,000 - 41,000; Full time

Benefits offered by this job

Paid time off

Medical/dental/vision insurance

401(k)

Other benefits to eligible employees

Job summary

Constellation Brands is seeking an Intern, Finance Analytics in Rochester, NY to help develop automated dashboards and analytic data products for a global organization. You will work with a BI Engineer to translate business requirements into scalable data solutions.

The role emphasizes data quality, end-to-end pipelines, and clear technical documentation. Strong problem-solving and communication skills are essential for success.

Qualifications

• Pursuing education in one of the following areas: Computer Science, Math, Physics, or equivalent.
• Team player, flexible, and outcome focused.
• Strong self-direction and initiative; willingness to take complete ownership over projects and tasks.
• Effective communication skills both oral and written.
• Committed to finding solutions to challenges and enjoys creative problem solving.
• Strong organizational skills and ability to handle multiple activities in a dynamic environment.
• Excellent interpersonal skills, ability to influence at all levels and geographic locations.

Responsibilities

• Analyze, develop, support, implement, and scale dashboard development in a high paced enterprise environment.
• Collaborate with BI Engineer and stakeholders to understand BI needs and deliver analytic data products.
• Develop and maintain data quality checks to ensure timeliness and consistency of data.
• Produce and maintain data architecture and end-to-end pipelines aligned with business goals.
• Create and deliver technical documentation using Jira, Confluence, Git, etc.
• Participate in investigation and remediation of issues as required.
• Challenge the status quo with simple, high-impact solutions.

Skills

SQL

Python

Data analysis

Git

Jira

Confluence

Tableau/Power BI

Education

Computer Science

Mathematics

Physics

Tools

Git

Jira

Confluence

Job description

The Intern, Finance Analytics position requires a creative problem solver to develop automated solutions for a global organization.

Responsibilities

• analysis, development, support, implementation, and scaling of dashboard development in a high paced enterprise environment.
• Collaborates with BI Engineer and Stakeholders to understand BI needs, gather business requirements, and deliver analytic data products.
• Develop and maintain data quality checks to prevent incomplete/inaccurate data and ensure timeliness and consistency.
• Produce and maintain data architecture and end-to-end pipelines that adhere to data engineering principles and business goals.
• Create and deliver technical and project documentation as required using Jira, Confluence, Git, etc.
• Participates in investigation and remediation of issues as required.
• Challenges the status quo, favoring simple and highly impactful solutions.

Minimum Qualifications

• Pursuing education in one of the following areas: Computer Science, Math, Physics, or equivalent.
• Team player, flexible, and outcome focused.
• Strong self-direction and initiative; willingness to take complete ownership over projects and tasks.
• Effective communication skills both oral and written.
• Committed to finding solutions to challenges and enjoys creative problem solving.
• Strong organizational skills and ability to handle multiple activities in a very dynamic, changing environment.
• Excellent interpersonal skills, ability to influence at all levels and geographic locations; awareness of cultural differences.

Preferred Qualifications

• Experience in gathering business requirements and translating to technical details.
• Knowledge of SQL and data analysis and experience with at least one programming language (Python preferred).
• Experience with Git, Jira, Confluence.
• Conceptual knowledge of data and analytics, such as dimensional modeling, ETL, reporting tools, data governance, data warehousing, structured and unstructured data.
• Experience working with data pipelines as they relate to a front-end BI tool such as Tableau, Power BI, or MicroStrategy.
• Demonstrated experience managing exceptions and providing support in fast-paced transaction processing environments.

Physical Requirements/Work Environment

• Occasional lifting up to 25 lbs.
• Sitting, working at desk/personal computer for extended periods of time.
• Primary work environment is professional corporate office.
• Ability to travel commercially to domestic and international locations.

The salary range for this role is: $19.00- $29.50 an hour

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.

• paid time off
• medical/dental/vision insurance
• 401(k)
• 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.

Location Rochester, New York Additional Locations

Job Type Full time

Job Area Internships

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). Constellation Brands (NYSE: STZ), a U.S.-based company, is a leading international producer and marketer of beer, wine, and spirits with operations in the U.S., Mexico, New Zealand, and Italy. Our mission is to build brands that people love because we believe elevating human connections is Worth Reaching For. It's worth our dedication, hard work, and calculated risks to anticipate market trends and deliver for our consumers, shareholders, employees, and industry. This dedication is what has driven us to become one of the fastest-growing, large CPG companies in the U.S. at retail, and it drives our pursuit to deliver what's next. Every day, people reach for brands from our high-end, imported beer portfolio anchored by the iconic Corona Extra and Modelo Especial, a flavorful lineup of Modelo Cheladas, and favorites like Pacifico, and Victoria; our exceptional wine brands including The Prisoner Wine Company, Robert Mondavi Winery, Kim Crawford, Schrader Cellars, and Lingua Franca; and our craft spirits brands such as Mi CAMPO Tequila and High West Whiskey. As an agriculture-based company, we strive to operate in a way that is sustainable and responsible. Our ESG strategy is embedded into our business and we focus on serving as good stewards of the environment, investing in our communities, and promoting responsible beverage alcohol consumption. We believe these aspirations in support of our longer-term business strategy allow us to contribute to a future that is truly Worth Reaching For. To learn more, visit www.cbrands.com and follow us on LinkedIn and Instagram.

Our company participates in the E-Verify program to confirm the employment eligibility of all new hires. For more information, please refer to the required postings linked here: E-Verify Participation Poster IER Right to Work Poster.