Remote ETL Developer, Flexible Schedule

About Company Gordon Food Service is a leader in the foodservice distribution industry, serving customers across North America.

With a rich history spanning over 125 years, we are committed to delivering exceptional products and services to restaurants, healthcare facilities, schools, and more.

Our innovative approach extends to our technology, where we leverage data and cutting-edge solutions to drive efficiency and enhance customer experience. We foster a collaborative, inclusive environment where employees are empowered to grow, innovate, and make a real impact.

Job Description Are you an experienced ETL Developer passionate about transforming complex data into actionable insights? Do you thrive in a remote work environment with the flexibility to manage your own schedule?

Gordon Food Service is seeking a talented and self-motivated Remote ETL Developer to join our dynamic data engineering team.

In this pivotal role, you will be instrumental in designing, developing, and maintaining robust ETL processes that power our critical business operations and analytical capabilities.

You'll be working with a vast array of data sources, integrating them into our enterprise data warehouse and various data marts, enabling informed decision-making across the organization.

This position offers the unique opportunity to contribute to a company with a rich heritage and a forward-thinking approach to technology, all while enjoying the autonomy and work-life balance that a remote, flexible schedule provides.

At Gordon Food Service, data is at the heart of our operations, influencing everything from supply chain logistics and inventory management to sales strategies to customer personalization.

As a Remote ETL Developer, your contributions will directly impact our ability to deliver superior service and innovative solutions to our customers.

You will be responsible for designing and implementing scalable and efficient data pipelines that extract data from diverse operational systems, transform it according to business rules, and load it into our enterprise data warehouse and various departmental data marts.

This includes working with both structured and unstructured data, ensuring its accuracy, completeness, and timeliness.

Your expertise will be critical in building and maintaining data assets that support advanced analytics, machine learning initiatives, and critical business intelligence dashboards.

Beyond the technical execution, you will play a key role in understanding business requirements, translating them into technical specifications, and proactively identifying opportunities for data integration and process improvement.

You'll engage in performance tuning of ETL jobs, troubleshoot data discrepancies, and implement robust error handling mechanisms. We are looking for someone who is not just a coder, but a strategic thinker who can contribute to our data strategy and infrastructure growth.

While the role is remote, fostering strong communication and collaboration with team members and business partners is essential. We leverage modern collaboration tools to ensure seamless teamwork and knowledge sharing.

If you are eager to take ownership of complex data challenges, contribute to a vital industry, and thrive in a flexible, results-oriented environment, this is the opportunity for you.

Key Responsibilities • Design, develop, and implement scalable and efficient ETL processes and data pipelines. • Extract data from various source systems (e.g., relational databases, flat files, APIs, cloud sources). • Transform raw data into a structured, consistent, and clean format suitable for analysis and reporting. • Load transformed data into enterprise data warehouses, data marts, and other data repositories. • Optimize and tune existing ETL jobs and data structures for performance, efficiency, and scalability. • Monitor data pipeline health, troubleshoot data quality issues, and resolve data discrepancies promptly. • Collaborate closely with data architects, business intelligence analysts, and business stakeholders to understand data requirements and design optimal data flow solutions. • Ensure data integrity, accuracy, and security across all data integration processes. • Develop and maintain comprehensive documentation for ETL processes, data lineage, and data models. • Participate in data modeling efforts and schema design for new and existing data assets. • Implement robust error handling, logging, and alerting mechanisms for ETL workflows. • Stay current with emerging ETL technologies, data warehousing best practices, and industry trends.

Required Skills • Strong proficiency in SQL for data querying, manipulation, and optimization. • Proven experience with enterprise-level ETL tools (e.g., SSIS, Informatica, DataStage, Talend, AWS Glue, Azure Data Factory). • Solid understanding of data warehousing concepts, including dimensional modeling (Kimball methodology), star schemas, and fact/dimension tables. • Experienc