G&C Foods is a leading foodservice redistributor headquartered in Syracuse, NY, with an additional facility in Alachua, FL. Serving 28 states and over 30 countries, we pride ourselves on delivering quality products and exceptional service. Our technology landscape includes an IBM iSeries ERP and WMS running on DB2, a TMS on Microsoft SQL Server, and various homegrown applications.

Location: Syracuse, NY

Schedule: Monday-Friday 8a-5p

Job Summary:

We are seeking an experienced Data Warehouse Architect to join our G&C Business Solutions Group. This is a pioneering role that will report directly to the Director of Software Engineering. The successful candidate will be instrumental in designing, implementing, and maintaining a scalable data warehouse solution that consolidates data from a variety of software applications. This data warehouse will empower our business users to perform ad hoc analyses independently and support our software engineering team in developing data-driven applications.

Duties and Responsibilities:

Collaborate with Stakeholders: Engage with business leaders to identify key business problems and data requirements.
Data Warehouse Design: Architect a robust data warehouse that integrates data from disparate databases, such as IBM DB2, Microsoft SQL Server, and other applications.
Data Labeling and Metadata Management: Develop a consistent labeling system and metadata repository to ensure clear and unequivocal data communication across the organization.
ETL Processes and Data Integration: Oversee the extraction, transformation, and loading (ETL) of data, ensuring temporal alignment and data integrity.
Data Modeling: Create logical and physical data models, including the development of data cubes for efficient querying and analysis.
Data Governance: Implement data quality standards and governance policies to maintain the accuracy and reliability of data.
Support Business Intelligence: Enable self-service BI by integrating tools that allow business users to perform ad hoc analyses without IT intervention.
Collaborate with Teams: Work closely with IT professionals, software engineers, business analysts, project managers, EDI specialists, and instructional designers within the G&C Business Solutions Group.
Technical Leadership: Provide guidance and best practices for data warehousing and analytics to the broader technology team.

Experience and Education Required:

Education: Bachelor’s degree in Computer Science, Information Systems, or significant experience in a related field;
Experience:
- 7+ years of experience in data warehousing, data architecture, and data modeling.
- Proven track record of designing and implementing large-scale data warehouses.
- Experience with ETL tools and processes.
- Familiarity with IBM iSeries systems, DB2, and Microsoft SQL Server. o Experience integrating data from heterogeneous systems.
Technical Skills:
Proficiency in data modeling techniques (both logical and physical).
- Strong understanding of metadata management and data labeling.
- Knowledge of data governance and data quality best practices.
- Experience with BI tools (e.g., Power BI, Tableau, Cognos).
- Understanding of temporal data alignment and time-series data management.
- Soft Skills: Excellent communication and interpersonal skills.
- Strong analytical and problem-solving abilities.
- Ability to work collaboratively in a cross-functional team environment.
- Self-motivated with a proactive approach to identifying and solving problems.
Preferred Qualifications:
- Industry Experience: Experience in the foodservice distribution industry.
Technical Expertise: Knowledge of RPG programming language helpful but not required.
- Experience with cloud-based data warehousing solutions (e.g., AWS Redshift, Azure Synapse Analytics).
- Familiarity with big data technologies (e.g., Hadoop, Spark).
Certifications: Relevant certifications in data management or data warehousing.

Benefits:

EMPLOYEE HOT DEALS! Everyone's favorite benefit for purchasing all kinds of products for crazy discount prices!
Excellent Benefits including medical insurance as low as $17.66/week, Vision, Dental, 401k, company-paid life
Potential for annual associate bonuses of up to an additional 5 weeks’ pay
Onsite gym/wellness center
Flexibility with scheduling needs
Cookouts
Holiday turkey and ham
Opportunity for advancement throughout the company
Open door policy
Annual Flu Clinic... and so much more!

Contact/Application Information:

If you’re interested, please apply through Indeed. If you have any questions, you can email recruiting@gcfoods.com. Thank you for your interest, and we look forward to meeting you!

#ADP1

This job is no longer accepting applications

See open jobs at G&C Food Distributors Inc.See open jobs similar to "Data Warehouse Architect" This is CNY.

See more open positions at G&C Food Distributors Inc

Privacy policy Cookie policy