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.
- Experience with relational database management systems (e.g., SQL Server, Oracle, PostgreSQL).
- Proficiency in at least one scripting language (e.g., Python, PowerShell) for automation and data processing.
- Excellent problem-solving, analytical, and critical thinking skills.
- Demonstrated ability to work independently, manage time effectively, and deliver results in a remote work setting.
- Strong verbal and written communication skills to articulate complex technical concepts to both technical and non-technical stakeholders.
Preferred Qualifications
- Bachelor's degree in Computer Science, Information Systems, or a related technical field.
- Experience with cloud data platforms and services (e.g., AWS Redshift, Snowflake, Databricks, Azure Synapse Analytics, Google BigQuery).
- Familiarity with big data technologies (e.g., Spark, Hadoop ecosystem).
- Experience with version control systems, preferably Git.
- Knowledge of data governance, data security, and data quality best practices.
- Experience in the foodservice, distribution, or logistics industry.
- Ability to adapt to a flexible schedule while maintaining productivity and meeting deadlines.
Perks & Benefits
- Remote work flexibility with a flexible schedule
- Competitive salary and performance-based bonuses
- Comprehensive health, dental, and vision insurance plans
- 401(k) retirement plan with company match
- Paid time off, including vacation, sick leave, and holidays
- Employee discount programs on Gordon Food Service products
- Opportunities for professional development and continuous learning
- Supportive and collaborative team environment focused on innovation
- Access to modern tools and technologies
- Impactful work contributing to a leading industry player
How to Apply
Interested candidates are invited to apply directly through our official career portal. Please click on the application link below to submit your resume and cover letter. Ensure your application highlights your relevant ETL development experience and your ability to thrive in a remote, flexible work environment. We look forward to reviewing your qualifications!