Intern, Finance Analytics

cbrands; City of Rochester (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 to develop automated solutions for a global organization. You will analyze, develop, support, implement and scale dashboards in a fast-paced enterprise environment.

The role involves collaborating with BI engineers and stakeholders to gather requirements, building data pipelines, and delivering reliable analytic data products while maintaining high data quality and documentation across projects.

Qualifications

• Pursuing education in Computer Science, Math, Physics, or equivalent.
• Team player with strong communication.
• Willingness to own projects and tasks.
• Excellent written and oral communication.
• Able to operate in a dynamic environment.

Responsibilities

• Collaborates with BI Engineer and stakeholders to understand BI needs and deliver analytic data products.
• Develop and maintain data quality checks to ensure data timeliness and accuracy.
• Produce and maintain end-to-end data pipelines aligned with data engineering principles.
• Create and maintain project documentation using Jira, Confluence, Git, etc.
• Investigate and remediate issues as required.
• Propose simple, impactful solutions and challenge the status quo.

Skills

SQL

Data analysis

Python

Education

Pursuing Computer Science/Math/Physics

Tools

Git

Jira

Confluence

Tableau

Power BI

MicroStrategy

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

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