Remote Etl Architect

Come join the largest beer distributor in the United States and be a part of our Performance Promise where we live out our company’s purpose of connecting customers, consumers and brands every day, everywhere we operate.

At Reyes Beverage Group, we’re proud to be the largest beer distributor in the United States — and distribute a growing number of spirits brands, too. We deliver over 325 million cases annually to over 115,000 retail accounts across the nation. We are committed to being the distributor of choice by providing unparalleled service and continually striving to grow our customers’ profitability.

Are you ready to start or propel your beer career with the largest and fastest growing distributor? We represent the best brands in the country including Modelo, Miller Lite, Coors Light, Corona, White Claw, Heineken, Truly, Pacifico, Yuengling, Lagunitas, Blue Moon, and more! We offer competitive pay and benefits, best-in-class training, and advancement opportunities that will turn this job into a career. Tap into your talent by applying today!

Pay Transparency Statement: 
The compensation philosophy reflects the Company’s reasonable expectation at the time of posting. We consider a number of factors when making individual compensation decisions including, but not limited to, skill sets, experience and training, and other business needs. This role may also be eligible to participate in a discretionary incentive program, subject to the rule governing the program. 

Position Summary:
The ETL Architect is responsible for designing, developing, and supporting data ingestion and transformation solutions that will be utilized in reporting, analytics, or within other applications.  The position will also perform data analysis, construct technical designs, communicate with team members and business stakeholders, and support existing data ingestion and transformation pipelines.  This position will also coordinate and review the work activities of offshore development and support resources.
 
Position Responsibilities may include, but not limited to:

• Responsible for the design, development, and support of data ingestion and transformation solutions
• Perform data analysis and create data models for peer review
• Provide guidance and direction to offshore support/development resources
• Communicate with other BI team members, offshore team members, and cross-IT staff on support and project activities
• Assist with task identification and effort estimates for ETL development
• Assist with risk and issue identification
• Provide off-hour/weekend support (on a rotating basis)
• Other projects or duties as assigned

Required Skills and Experience:

• Bachelor’s Degree in Computer Science, Information Systems, or in a related discipline
• 4+ years of ETL development experience
• 2+ years of ETL design experience
• Design and development experience utilizing scheduling/automation tools preferably in the Azure environment
• Strong communication skills, including written and verbal communication skills
• Strong problem solving and analytical skills
• Strong ETL design skills
• Excellent ETL development skills utilizing an ETL tool, preferably utilizing Azure Data Factory
• Excellent SQL skills
• Strong understanding of Dimensional Modeling and other modeling techniques
• Strong understanding of SDLC best practices with an emphasis on DW/BI/Analytics practices
• This position must pass a post-offer background and drug test

Preferred Skills and Experience:

• Experience with orchestration in the Azure environment
• Snowflake data warehouse experience
• Azure DevOps experience
• GitHub experience
• MS Power BI experience
• Azure Blob Storage / ADLS experience with Data Storage, Analysis
• Data modeling experience
• Experience working with both structured and semi-structured data sources
• JavaScript and Python for stored procedures and scripting
• Experience leading offshore resources
• Microsoft Azure, Snowflake, and other relevant certifications

Physical Demands and Work Environment:
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  Due to the nature of our business in regard to such things as delivery schedules, order inputs, selection, and Department of Transportation Hours of Service, overtime, attendance and punctuality are essential job functions.  Should an individual in this classification not be able to adhere to this requirement due to a disability, they should contact their Human Resources department to see what, if any, reasonable accommodation may be made.