Tired of looking at the same jobs in the high-tech industry?Â Have you ever considered working in the wine, beer & spirits industry â well now is your chance!Â Constellation Brands (NYSE: STZ and STZ.B), a Fortune 500Â® company, is a leading international producer and marketer of beer, wine, and spirits with operations in the U.S., Canada, Mexico, New Zealand, and Italy.
Constellation is the No. 3 beer company in the U.S. with high-end, iconic imported brands such as Corona Extra, Corona Light, Modelo Especial, Modelo Negra and Pacifico. The companyâs beer portfolio also includes Funky Buddha, one of the most awarded craft brewers in the U.S. In addition, Constellation is the worldâs leader in premium wine, selling great brands that people love, including Robert Mondavi, Kim Crawford, Meiomi and The Prisoner. The companyâs premium spirits brands include SVEDKA Vodka, Casa Noble Tequila, and High West Whiskey.Â We express our company vision: to build brands worth reaching for, and to learn more, visit https://companyprofile.cbrands.com/.
Constellation Brands has a flexible work environment that includes the ability to work remotely a few days a week!
We are building the modern data platform of tomorrow to solve complex, high scale data challenges. The data platform will be the foundation to enable self-service capabilities for data publishing, processing, and consumption in a distributed data mesh environment. This role is an engineering role that will design, implement, continuously evolve, and run the highly available data engineering platform and enterprise cloud data warehouse.Â This role will leverage a product mindset in adopting the Data Mesh and services capabilities and run the platform as a product in an agile, Dev/Ops model.
This engineer will also implement the designs to ensure compliance with data governance and data security requirements while creating, improving, and operationalizing integrated and reusable data pipelines. This will enable faster data access, integrated data reuse and vastly improved time-to-solution for data and analytics initiatives.
This role requires a highly collaborative individual working with IT product teams. It will also involve evangelizing effective data engineering practices and promoting better understanding of data and analytics.
Build the distributed data mesh platform, enabling the product teams to build and run data pipelines in self-service manner. The data platform will provide capabilities via APIs (or CLI) to enable any domain data product team to publish, process and consume data supporting event-driven, streaming, batch patterns.
Design, deploy and run data services on shared data platform with CI/CD automation to enable automated data pipelines at scale.
Migrate legacy data warehouse to the cloud and re-design the data pipelines using cloud-native patterns.
Enable effective metadata management using innovative and modern tools, techniques, and architectures to automate the most-common, repeatable, and tedious data preparation and integration activities.
Collaborate across domains, working in close relationship with the product and data science teams in supporting their data requirements for various data and analytics initiatives.
Provide platform administration responsibilities for Data Engineering and Product teams.
Perform Level 3 support duties as required
Participate in design, code and testing reviews before implementation occurs:
Focus on developing domain knowledge across all the organization to become a true business technologist for the company.
Perform other duties as assigned by Manager.
Bachelorâs Degree in Information Systems, Computer Science or equivalent knowledge/experience is required
2+ years of experience with Snowflake Data Platform.
7+ years of experience with relational databases (Oracle, SQL Server, DB2, Teradata, etc)
5+ years working on BI/DW Projects
5+ years of hands-on experience as an ETL Architect/Developer well versed in ETL tool usage, architecture, design and development.
Substantial ETL architecture design experience within data warehousing environments governed by applying appropriate methodologies and standards
Must have in depth knowledge of Software development and testing methodologies and models (Waterfall, Spiral, RAD, Agile, etc)
Must have experience with one or more ETL tools (ODI, DBT, Informatica, WMB)
Must have hands on experience in SQL
Experience working with SAP data structures is strongly desired
Experience with Airflow is a plus
Conceptual, logical and physical data modeling through use of data modeling tools is a plus
Experience working with BI tools (MicroStrategy, Cognos, OBIEE, etc) is desired
Victor, New York
Chicago, Illinois, Dallas, Texas, San Francisco, California, Virtual - US
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).
If you have taken a moment to unwind with a bottle of beer, toast with glass of wine, or celebrate with a cocktail, chances are that you have shared that moment with Constellation Brands. We are passionate producers of iconic beer, wine and spirits brands that consumers love. From Corona Extra, to Robert Mondavi Wines, to SVEKDA Vodka, we produce over 100 premium brands with sales in nearly 100 countries, making us the number one multi-category beverage alcohol company in the U.S.