Reyes Beer Division
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: Bachelors 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: Masters 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
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: Bachelors 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: Masters 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