Job Description
The Intern, Finance Analytics position requires a creative problem solver to develop automated solutions for a global organization. Responsibilities include analysis, development, support, implementation, and scaling of dashboard development in a high paced enterprise environment.
Responsibilities
- 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.
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 YorkAdditional Locations
Job Type
Full timeJob Area
InternshipsEqual 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).
Skills Required
- Currently pursuing education in Computer Science, Mathematics, Physics, or an equivalent field.
- Ability to work collaboratively as a flexible, outcome-focused team player.
- Strong self-direction and initiative, with willingness to take ownership of projects and tasks.
- Effective oral and written communication skills.
- Creative problem-solving mindset and commitment to finding solutions.
- Strong organizational skills and ability to manage multiple activities in a dynamic environment.
- Excellent interpersonal skills and ability to influence across levels and geographic locations.
- Experience gathering business requirements and translating them into technical details.
- Knowledge of SQL and data analysis, plus experience with at least one programming language, preferably Python.
- Experience with Git, Jira, and Confluence.
- Conceptual knowledge of dimensional modeling, ETL, reporting tools, data governance, data warehousing, and structured and unstructured data.
- Experience with data pipelines supporting front-end BI tools such as Tableau, Power BI, or MicroStrategy.
- Experience managing exceptions and providing support in fast-paced transaction-processing environments.
Constellation Brands Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Constellation Brands and has not been reviewed or approved by Constellation Brands.
-
Healthcare Strength — Healthcare coverage is described as comprehensive, spanning medical, dental, and vision offerings alongside wellness resources. Additional supports such as telemedicine and mental-health programs are positioned as part of the overall package.
-
Retirement Support — Retirement benefits appear comparatively strong, with a 401(k) match structure and an added non-elective contribution described in the materials. Profit sharing and employee stock purchase access are also included in the broader financial-security toolkit.
-
Leave & Time Off Breadth — Paid time off is framed as generous, covering vacation, holidays, and sick time, with some roles citing substantial starting PTO. Work–life supports such as flexible or hybrid arrangements and summer hours are also part of the offering for eligible roles.
Constellation Brands Insights
What We Do
Constellation Brands (NYSE: STZ) 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 more 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 our high-end, iconic imported beer brands such as those in the Corona brand family like the flagship Corona Extra, Modelo Especial and the flavorful lineup of Modelo Cheladas, Pacifico, and Victoria; our fine wine and craft spirits brands, including The Prisoner Wine Company, Robert Mondavi Winery, Casa Noble Tequila, and High West Whiskey; and our premium wine brands such as Kim Crawford and Meiomi. As an agriculture-based company, we have a long history of operating sustainably and responsibly. Our ESG strategy is embedded into our business and our work focuses on serving as good stewards of the environment, enhancing social equity within our industry and communities, and promoting responsible beverage alcohol consumption. These commitments ground our aspirations beyond driving the bottom line as we work to create a future that is truly Worth Reaching For. To learn more, visit www.cbrands.com and follow us on Twitter, Instagram, and LinkedIn








