Data Warehouse Architect (Hybrid)

Stanton Carpet is the leading designer and supplier of decorative high quality self-branded carpet, custom fabricated rugs and hard surfaces.  Stanton sells its products across the mid to high end residential as well as decorative commercial marketplaces.  Stanton is rated #1 Favorite Area Rug Manufacturer for Style, Quality & Service and Top 5 Favorite Carpet Manufacturer among our customers in Floor Focus magazine. Role:    We are looking for a Hybrid Data Warehouse Architect to help Stanton implement and manage our Datawarehouse. The ideal candidate will have extensive experience in designing, implementing and managing data warehouses to ensure data is available to all business areas for Stanton. Candidates should be proficient in project management, database platforms, and programming languages related to data warehouse management.  Responsibility also includes designing, developing, implementing and maintaining data integration solutions to support seamless flow of data sources between different systems and applications.   Key Responsibilities: Plan, design and implement framework and systems for the data warehouse. Create data models, data marts and ETL processes. Ste standards for database operations, query processing and security. Analyze existing data warehouse infrastructure and identify areas for improvement for best practices. Optimization of data warehouse models and servers to ensure top level performance and scalability. Perform thorough testing and validation of data integration process to ensure data integrity and accuracy. Work closely with Information System Director, business analytics team, software developers, and stakeholders to understand data requirements and deliver integrated solutions to meet our business needs. Create and maintain documentation of the data integration process, configuration and best practices. Support data integrations through our Datawarehouse for Salesforce and Tableau. Overall responsible for enterprise data integration architecture and governance   Requirements: Minimum 5 years of experience programming in languages that support data integration. Outstanding programming skill set in project planning, code development, implementation and maintenance. Strong interpersonal and communication skills and ability to work well as a team member. Extensive understanding of Datawarehouse infrastructure design, deployment and management.  . Attention to detail and ability to detect and correct issues in complicated code. Experience with web services and SOA architectures. Experience with integration platforms/tools such as MuleSoft or Boomi. Resolve to complete tasks accurately and on time.   Background   Founded in 1980, Stanton Carpet is a leading designer, marketer and wholesaler of high-quality, self-branded decorative carpets, custom area rugs and luxury vinyl planks.  The company is comprised of five brands, spanning the entire spectrum of the premium flooring market, with an offering of hundreds of styles as well as thousands of SKUs.  Stanton products are primarily distributed through the retail showroom channel, partnering with dealers geographically dispersed across the United States and Canada.  Stanton is recognized for providing unparalleled award-winning products, quality and service, which are a result of its highly driven team.  Stanton is headquartered in Woodbury, NY, maintains its own customer service and distribution center in Calhoun, GA, and a hard surface distribution center located in Pensacola, FL.