Job description
Who is Swire Coca-Cola? We are one of the largest bottlers of Coca-Cola and other beverage brands in America. Our 7,200 hardworking and passionate employees produce and distribute more than 50 brands and flavors across 13 states. We have as many careers as we have flavors, and regardless of which role you choose, you have a direct impact on Swire Coca-Cola, our products, and the communities we call home.At Swire Coca-Cola, our commitment to excellence is what guides our actions with our employees. We offer a comprehensive benefits package for full-time associates which includes: Medical, Dental, Vision, 401K, Paid Vacation, Paid Holidays and Company Discounts.
As part of Swire’s Enterprise Data Warehouse Team, the Data Engineer will help business users and analysts throughout the organization access the data they need to operate and grow the business. The Data Engineer will work with end users and IT staff to gather requirements, build and maintain secure, compliant data processing pipelines using different services, tools and techniques. They will ensure that data pipelines and data objects are high-performing, efficient, organized, and reliable.
Responsibilities:
- Build and maintain secure, compliant data processing pipelines, tables, views, procedures and datasets
- Integrate, transform, and consolidate data from various structured and unstructured data systems into structures that are suitable for building analytics solutions and/or performing analysis
- Ensure that data pipelines tables, views, procedures, and datasets are high-performing, efficient, organized, and reliable
- Design, develop, operate and tune data & analytics services (various)
- Monitor the data pipelines and data stores responding to issues in a timely manner
- Monitor, troubleshoot and resolve issues in production environments
- Help business users and analysts understand what data are available and how to interpret them.
- Coordinate with CONA BI team to ensure Swire’s solution integrates with CONA’s solution.
- Attend regular meetings with and participating in CONA BI data warehouse design and development activities and adapting Swire’s solution to be compatible.
- Collaborate with the CONA data warehouse team, third-party consultants and third-party data/service providers during the development and maintenance of Swire’s data warehouse.
- Bachelor’s degree in Computer Science or 6+ years of directly-related work experience
- Preferred: Master’s degree in Computer Science (or similar) or 4+ years of directly-related work experience
- 4+ years in designing, developing, operating and maintaining various data pipelines and data stores following best practices for the given environment
- 4+ years of strong SQL scripting knowledge
- 4+ years working with data processing languages, such as SQL, Scala or Python (or Similar)
- 2+ years working with Cloud-based Data Solutions like Azure SQL Database/Azure Synapse Analytics/Snowflake
- 2+ years working with ETL tools like Azure Data Factory, DBT, SSIS (or similar)
- Good to have knowledge with Power BI or other similar reporting tool(s)
- Knowledge of NoSQL databases
- Experience with parallel processing and data architecture patterns
- Experience with relational and dimensional data modelling
- Onsite standard work week to ensure face-to-face interaction with team members and Swire management.
- Team coordination skills and a good team player
gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.