Data Warehouse Architect
Data Warehouse Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 100000 - 125000
1 Vacancy
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 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: Bachelors 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! Everyones 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 youre 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
Employment Type
Full-Time
