Utah Staffing
Data Warehouse Engineer (Draper, UT)
Design large scale data models in Snowflake. Use Azure Synapse Analytics to extract and transform data, ensuring seamless integration and real-time updates. Build and maintain secure and compliant data processing pipelines, tables, views, procedures and datasets. Utilize APIs to extract information from second and third-party data sources, Parquet, JSON and XML formats, and transform information to improve operational efficiency and accuracy. Integrate, transform, and consolidate data from various structured and unstructured systems into Kimball data modeling to support analytics, data science and Machine Learning. Engineer data profiling and quality using Python and SQL. Review ETL/ELT code and pipelines and assess tools and procedures for enhanced data validation, code quality and engineering efficiency. Develop and deploy microservices. Configure and manage CI/CD pipelines to automate deployment of data projects, ensuring rapid and reliable releases in Agile framework. Monitor, troubleshoot and resolve issues in production environments. Requires: Master's Degree in Business Analytics, 1 year of experience in job offered, and proficiency with Azure Synapse or Matillion, Snowflake or BigQuery, Azure DevOps or GitLab, SQL server, APIs, Parquet, JSON, Machine Learning, Python, ETL, CI/CD, and Agile. Come and join our Sparkling team! Swire Coca-Cola is an equal employment opportunity and affirmative action employer that participates in the E-Verify program as required by law. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status or other legally protected characteristics. Swire Coca-Cola does not sponsor applicants for work visas.
Design large scale data models in Snowflake. Use Azure Synapse Analytics to extract and transform data, ensuring seamless integration and real-time updates. Build and maintain secure and compliant data processing pipelines, tables, views, procedures and datasets. Utilize APIs to extract information from second and third-party data sources, Parquet, JSON and XML formats, and transform information to improve operational efficiency and accuracy. Integrate, transform, and consolidate data from various structured and unstructured systems into Kimball data modeling to support analytics, data science and Machine Learning. Engineer data profiling and quality using Python and SQL. Review ETL/ELT code and pipelines and assess tools and procedures for enhanced data validation, code quality and engineering efficiency. Develop and deploy microservices. Configure and manage CI/CD pipelines to automate deployment of data projects, ensuring rapid and reliable releases in Agile framework. Monitor, troubleshoot and resolve issues in production environments. Requires: Master's Degree in Business Analytics, 1 year of experience in job offered, and proficiency with Azure Synapse or Matillion, Snowflake or BigQuery, Azure DevOps or GitLab, SQL server, APIs, Parquet, JSON, Machine Learning, Python, ETL, CI/CD, and Agile. Come and join our Sparkling team! Swire Coca-Cola is an equal employment opportunity and affirmative action employer that participates in the E-Verify program as required by law. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status or other legally protected characteristics. Swire Coca-Cola does not sponsor applicants for work visas.