Milo’s Tea Company is one of the fastest growing beverage companies in the US. Our culture and operations are built on the belief that we can make a difference in the world. That’s why we put People First and strive to continually reduce our environmental impact on the planet. We leverage our world class operations and decades-long distribution partnerships to grow the footprint of our core products and create new, innovative beverage products.
The Data Engineer is responsible for assisting with data management, modeling, development, transformation, and reporting activities.
Identify business needs, determine possible solutions, and develop solutions that include systems components, and process improvements with data driven decision making.
Work with business groups to design and develop reporting and analytics solutions that will improve efficiency and effectiveness.
Designs, implements, tests, troubleshoots, documents, and supports data models, programs, scripts, and ETL (Extract, Transform, and Load) processes.
Develop, maintain, and curate large datasets from multiple platforms. Develop reporting capabilities to support business needs by creating and supporting SQL queries, data extraction packages, and interfaces. Explores ways to enhance data quality and reliability.
Perform data validation between analytical and source systems to support ongoing data management capabilities and data governance. Perform data testing to ensure the accuracy of data transformation.
Develop data analytics, reports, and dashboards using Power BI and other business intelligence tools.
Uphold and participate in all Corporate Responsibility programming including recycling, social advocacy and MMAD volunteering opportunities.
Invest in and is an example of Milo’s Responsibility commitment which includes environmental, social, and corporate governance components.
Other duties as assigned
Supervisory: This role does not have supervisory responsibilities.
BA in computer science, information systems, statistics, applied math, or any other related field.
Up to 3 years of experience in information systems or related field.
Strong experience with SQL server solutions (queries, functions, stored procedures, views, etc.).
Cloud based computing and data solutions.
Proficient with Excel and Business Intelligence tools (Power BI, Power Query, Tableau, etc.).
Understanding of relational databases and data warehouses. Hands-on experience with SQL database design.
Experience with Microsoft SQL stack (SSIS, SSRS, SSAS, etc); Experience with cloud-based data technologies, Azure preferred.
Experience working in a SharePoint environment; Experience with Python, R or other programming languages.
Experience in non-traditional SQL (noSQL, etc.) solutions.
Experience with machine learning and predictive analytics.