Data Warehouse Architect
4 days ago
Syracuse
Job Description Job Title: Data Architect Company Introduction: 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 8:00 AM - 5:00 PM Job Summary: We are seeking an experienced Data Warehouse Architect to join our G&C Business Solutions Group. This is a pioneering role that reports 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 business users to perform ad hoc analyses independently while also supporting our software engineering team in developing data-driven applications. We are specifically looking for candidates with proven experience in building data warehouses from the ground up. Ideal candidates will not only bring technical expertise but also the perspective gained from overcoming challenges and setbacks throughout the development process. We value individuals who have demonstrated resilience, humility, and the ability to learn from failure—qualities that we believe are critical to delivering innovative and effective solutions. 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., • 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). At G&C, we believe exceptional people deserve exceptional rewards. When you join our team, you’re not just taking a job, you’re stepping into a career with a company that invests in your growth, values your contribution, and celebrates your success. Our Benefits Package Includes: • Competitive Health Coverage – Medical plans starting at just $24.73/week, plus comprehensive vision, dental, and a 401(k) with company match to secure your future., • Company-Paid Life Insurance – Because your peace of mind matters., • Performance-Based Bonuses – Earn up to the equivalent of five additional weeks’ pay each year based on your impact and results., • Onsite Fitness & Wellness Centers – Stay active and healthy without leaving the workplace., • Flexible Scheduling Options – Designed to support your life outside of work., • Company Culture Perks – From team cookouts and appreciation events to seasonal holiday gifts, we celebrate our people year-round., • Exclusive Employee Product Discounts – Access unbeatable prices on a wide range of products, available only to our team., • Career Advancement – Clear pathways to grow within the company, backed by leadership who invest in your success., • Open-Door Leadership – Access to decision-makers who listen, act, and value your input., • Annual Flu Clinics – Convenient, no-cost health support right at work. Contact/Application Information: If you’re interested, please apply through Indeed. If you have any questions, you can email . Thank you for your interest, and we look forward to meeting you! #ADP1