Senior Software Engineer - DBT at Sysco

Sri Lanka

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

FoodserviceIndustries

Requirements

A Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related technical field
Proficiency in developing data models and transformation logic using DBT in cloud environments and Dataform in GCP
Strong SQL development skills, with the ability to write complex, performance-optimized queries
Solid understanding of ETL/ELT architecture, data warehousing concepts, and data pipeline

Responsibilities

Designing, Developing, and Maintaining Data Pipelines: Build robust, scalable, and efficient ETL (Extract, Transform, Load) pipelines on Google Cloud Platform utilizing tools such as Cloud Dataflow, Dataproc, BigQuery, and Cloud Composer
Implementing Data Modeling with Data Build Tool (DBT) or Dataform: Develop and manage data models using Data Build Tool (DBT) or Dataform, ensuring clean, reliable, and maintainable transformation logic that aligns with business requirements and analytics use cases
Data Integrations: Integrate diverse data sources, including internal systems, third-party APIs, and external databases, into unified datasets available on the GCP ecosystem (BigQuery)
Data Quality Assurance: Implement and monitor data quality checks, conduct root cause analysis for data inconsistencies, and proactively resolve issues to maintain data integrity
Collaboration: Work closely with data analysts, data scientists, product managers, and business stakeholders to understand data needs and deliver timely solutions
Performance Optimization: Monitor and optimize the performance of data pipelines and queries, ensuring efficient resource utilization and cost management on GCP
Documentation: Create and maintain comprehensive documentation for data models, ETL processes, Data transformation projects, and cloud architecture to support maintainability and team knowledge sharing
Security and Compliance: Adhere to best practices regarding data security, privacy, and compliance, implementing necessary controls and safeguarding sensitive data throughout the pipelines
Automation and CI/CD: Implement CI/CD pipelines for DBT projects and other data processes to ensure robust deployments and version control
Continuous Improvement: Stay abreast of evolving GCP offerings, DBT features, and industry trends to continuously improve and innovate data engineering practices

Skills

Key technologies and capabilities for this role

GCPDBTDataformCloud DataflowDataprocBigQueryCloud Composer

Questions & Answers

Common questions about this position

What is the salary or compensation for this Senior Software Engineer role?

This information is not specified in the job description.

Is this Senior Software Engineer position remote or does it require office work?

This information is not specified in the job description.

What key skills are required for the Senior Software Engineer - DBT role?

The role requires high skills in Google Cloud Platform (GCP), Data Build Tool (DBT) or Dataform, along with expertise in building ETL pipelines using Cloud Dataflow, Dataproc, BigQuery, and Cloud Composer, data modeling, integrations, quality assurance, and performance optimization.

What is the team structure like for this position at Sysco LABS?

The role is part of the growing Data Management Service team, involving close collaboration with data analysts, data scientists, product managers, and business stakeholders.

What makes a strong candidate for the Senior Software Engineer - DBT position?

A strong candidate is highly skilled and innovative in GCP, DBT or Dataform, with experience architecting, developing, and maintaining data workflows, ETL pipelines, data modeling, integrations, quality assurance, optimization, and stakeholder collaboration.

Sysco

Foodservice distribution for restaurants and healthcare

About Sysco

Sysco Corporation specializes in foodservice distribution, primarily serving restaurants, healthcare facilities, and educational institutions. The company offers a variety of products and services, including food items, kitchen equipment, and marketing support, tailored to meet the specific needs of its clients. Sysco differentiates itself from competitors by providing comprehensive solutions, such as the "Restaurants Rising Toolkit" during the COVID-19 pandemic, which helps restaurants adapt to new dining trends. The goal of Sysco is to make running a restaurant easier and more profitable for its clients.

Houston, TexasHeadquarters

1970Year Founded

IPOCompany Stage

Food & AgricultureIndustries

Benefits

Health Insurance

401(k) Retirement Plan

401(k) Company Match

Professional Development Budget

Performance Bonus

Risks

Increased competition from tech-driven solutions could impact Sysco's market share.

Reliance on partnerships for technology advancements may pose risks if results are unmet.

Socially responsible investing trends may pressure Sysco to improve ESG standards.

Differentiation

Sysco offers comprehensive B2B solutions, including food products, equipment, and marketing services.

The company provides flexible payment options and waives delivery minimums for scheduled deliveries.

Sysco's 'Restaurants Rising Toolkit' supports restaurants adapting to new dining trends.

Upsides

Sysco can capitalize on the demand for plant-based and alternative protein products.

The rise of ghost kitchens offers Sysco opportunities for specialized supply chain solutions.

Digital transformation in foodservice allows Sysco to enhance service offerings and engagement.

Land your dream remote job 3x faster with AI

Try Jobo Free