ETL Architect

Reyes Holdings

Rosemont, IL

JOB DETAILS
LOCATION
Rosemont, IL
POSTED
30+ days ago



Position Responsibilities:

+ Design, develop, and support data ingestion and transformation solutions for reporting and analytics as the ETL Architect, while performing data analysis, constructing technical designs, communicating with stakeholders, and coordinating the work of offshore development and support resources

+ Perform data analysis and create data models for peer review, ensuring high standards of data integrity and quality

+ Provide guidance and direction to offshore support and development resources to enhance collaboration and project outcomes

+ Communicate effectively with BI team members, offshore teams, and cross-IT staff regarding support and project activities

+ Assist in task identification and effort estimation for ETL development, contributing to project planning and execution

+ Offer off-hour and weekend support on a rotating basis to ensure the reliability and availability of data solutions

+ Other duties as assigned








Required Education and Experience:

+ Bachelor’s Degree in Computer Science, Information Systems, or in a related discipline and 4 to 6 plus years of related experience or High School Diploma/General Education Degree (GED) and 8 plus years of specific experience

+ 2 plus years of ETL design experience

+ Design and development experience with scheduling and automation tools, preferably in the Azure environment, along with excellent ETL development skills using Azure Data Factory, strong SQL proficiency, and a solid understanding of dimensional modeling and SDLC best practices in DW/BI/Analytics






Preferred Education and Experience:

+ Master’s Degree

+ 4 plus years of ETL development experience

+ Microsoft Azure, Snowflake, and other relevant certifications

+ Experience with orchestration in the Azure environment, Snowflake data warehouse, Azure DevOps, GitHub, Azure Blob Storage/ADLS for data storage and analysis, and proficiency in JavaScript and Python for stored procedures and scripting







Benefits


At the Reyes Family of Businesses, our Total Rewards Strategy prioritizes the holistic well-being of our employees. This position offers a comprehensive benefits package that includes Medical, Dental, Vision coverage, Paid Time Off, Retirement Benefits, and complimentary Health Screenings.


Equal Opportunity Employee & Physical Demands


Reyes Holdings and its businesses are equal opportunity employers. Company policy prohibits discrimination and harassment against any applicant or employee based on race, color, religion, sex, pregnancy or pregnancy-related medical conditions, marital status, sexual orientation, gender identity or expression, age, national origin, citizenship, disability, genetic information, military or veteran status, or any other basis protected by applicable law. In addition, the Company is committed to providing reasonable accommodation to applicants and employees in accordance with applicable law. Requests for accommodation should be directed to your point of contact in the Talent Acquisition or Human Resources departments.


Background Check and Drug Screening


Offers of employment are contingent upon successful completion of a background check and drug screening.


Pay Transparency


Our compensation philosophy embraces diverse factors for fair pay decisions, valuing skills, experience, and the needs of our business. Moreover, this role may have the opportunity to participate in a discretionary incentive program, subject to program rules.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation and gender identity, national origin, disability, or protected veteran status. Drug Free Workplace.

About the Company

R

Reyes Holdings

Reyes Holdings, aligned with leading brewers and foodservice providers, delivers the best-known brands and widest variety of food and beverage items to retailers around the world. Annually, the company delivers over 406 million cases of high-quality beer and food products from more than 90 warehouses in the U.S., Canada, and Ireland as well as Puerto Rico, Central and South America. Today, Reyes Holdings is the 25th largest privately held company in America and one of the largest privately held companies in Chicago with more than 10,300 employees and annual sales in excess of 12 billion dollars. We are dedicated to providing a challenging and rewarding work experience with opportunity for growth.

COMPANY SIZE
100 to 499 employees
INDUSTRY
Restaurant/Food Services
FOUNDED
1956
WEBSITE
http://www.reyesholdings.com/