What are the responsibilities and job description for the Senior Database Engineer position at Constellation Brands?
Job Description
Position Summary:
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
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
This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. Our compensation is based on cost of labor. For remote locations or positions open to multiple locations, the pay range may reflect several US geographic markets, including the lowest geographic market minimum to the highest geographic market maximum. 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 not 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. At Constellation Brands, it is not typical for an individual to be hired at the high end of the range for their role, and compensation decisions are dependent upon the facts and circumstances of each position and candidate. 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.
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).
Position Summary:
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
- 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
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
This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. Our compensation is based on cost of labor. For remote locations or positions open to multiple locations, the pay range may reflect several US geographic markets, including the lowest geographic market minimum to the highest geographic market maximum. 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 not 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. At Constellation Brands, it is not typical for an individual to be hired at the high end of the range for their role, and compensation decisions are dependent upon the facts and circumstances of each position and candidate. 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.
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).
Salary : $113,500 - $177,600