Intern, Finance Analytics

Constellation Brands; New York (NY); On-site; USD 26,000 - 41,000; Full time

Benefits offered by this job

Paid time off

Medical/dental/vision insurance

401(k)

Job summary

Constellation Brands is seeking an Intern in Finance Analytics in Rochester, NY. The role focuses on developing automated analytics solutions for a global organization, delivering dashboards, data products, and scalable processes.

Typical duties include collaborating with BI engineers, ensuring data quality, and documenting technical work using Jira, Confluence, and Git. The position emphasizes ownership and proactive problem solving in a fast-paced environment.

Qualifications

• Pursuing a degree in CS, math, physics, or equivalent.
• Strong teamwork and collaboration.
• Proactive ownership of projects and tasks.
• Excellent verbal and written communication.
• Ability to thrive in a dynamic, fast-paced environment.
• Interest in analytics and data quality practices.

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.

Skills

Team player

Self-directed

Communication skills

Creative problem solving

Attention to detail

Education

Pursuing CS/Math/Physics

Tools

SQL

Python

Git

Jira

Confluence

Job description

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

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 York

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).