Intern, Finance Analytics

Location: Rochester, New York

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

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