Senior Database Engineer

Senior Database Engineer

Senior Database Engineer will work closely with a multidisciplinary Agile team to build high quality data pipelines driving analytic solutions. These solutions will generate insights from the organization's connected data, enabling the organization to advance the data-driven decision-making capabilities of the organization's enterprise. This role requires deep understanding of data architecture, data engineering, data analysis, reporting, and a basic understanding of data science techniques and workflows. The ideal candidate is a skilled data / software engineer with experience creating data products supporting analytic solutions. They are an Agile learner, possess strong problem-solving skills, work as part of a technical, cross functional analytics team, and want to solve complex data problems and deliver the insights to enable analytics strategy.

Duties, Responsibilities & Essential Functions

• Design, develop, optimize, and maintain data architecture and pipelines that adhere to data engineering principles and business goals
• Solve complex data problems to deliver insights that helps the organization's business to achieve their goals
• Create data products for analytics and data scientist team members to improve their productivity
• Advise, consult, mentor and coach other data and analytic professionals on data standards and practices
• Foster a culture of sharing, re-use, design for scale, stability, and operational efficiency of data and analytical solutions
• Lead the evaluation, implementation and deployment of emerging tools and processes for analytic data engineering in order to improve the organization's productivity as a team
• Develop and deliver communication and education plans on data engineering capabilities, standards, and processes
• Partner with Product Analysts, Product Owners, and Solutions Architects to develop technical architectures for strategic enterprise projects and initiatives.
• Learn about machine learning, data science, computer vision, artificial intelligence, statistics, and/or applied mathematics

Required Qualifications / Skills:

• Bachelor's degree required; Computer Science, MIS, or Engineering preferred
• 5 years of experience working in data engineering or architecture role, 7+ preferred
• Hands-on Snowflake experience, particularly in designing and optimizing data models and pipelines with a focus on performance and cost optimization.
• Proficiency in at least one programming language commonly used within Data Engineering, such as Python, Scala, or Java.
• Experience in AWS, hands-on work building and operating data pipelines using services such as S3, IAM, EC2/ECS, Lambda, or Glue
• Experience with dbt (models, tests, documentation) is preferred
• Expertise with an orchestration platform such as Airflow
• Proficiency in Software Development & CI/CD
• Conceptual knowledge of data and analytics, such as dimensional modeling, ETL, reporting tools, data governance, data warehousing, structured and unstructured data.
• Exposure to machine learning, data science, computer vision, artificial intelligence, statistics, and/or applied mathematics

Location: Rochester, New York

Additional Locations: Chicago, Illinois, San Antonio, Texas

Job Type: Full time

Job Area: Information Technology

The salary range for this role is: $113,500.00 - $177,600.00

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