Enterprise Data Warehouse Manager - Woodcliff Lake, United States - Knewin

Knewin Woodcliff Lake, United States

1 week ago

Description

Company Summary

Job Title

Enterprise Data Warehouse Manager
Location

Corporate, Woodcliff Lake, NJ
Full-Time/Part Time

Full-time
Job Description

Company Overview:

Party City Holdco Inc.

(PCHI) is a global leader in the celebrations industry, with its offerings spanning more than 70 countries around the world.

PCHI is also the largest vertically integrated designer, manufacturer, distributor, and retailer of party goods inNorth America.
PCHI operates across multiple businesses within its Retail Division and Consumer Products Division. On the retail side, Party City (

) is the leading omnichannel retailer in the celebrations category, operating more than 750+ company-owned and franchise stores. The Consumer Products Division includes design and manufacturing entity Amscan, an industry leader in celebration décor, tableware, costumes, and accessories.
PCHI is headquartered inWoodcliff Lake, N.J. with additional locations throughout the Americas andAsia.
Job Overview

:

As the hands-on Enterprise Data Warehouse Manager for Party City, you will hold a dual role, leading the EDW team while actively participating in the design and development of the enterprise data warehouse architecture for the entire Snowflake environment.

Your responsibilities will entail overseeing the end-to-end EDW process, from data acquisition and transformation to the creation of scalable data models and analytics solutions, as well as optimizations and Snowflake database maintenance tasks.

By leveraging your technical prowess and leadership skills, you will drive the strategic use of data to optimize business operations and facilitate informed decision-making across the organization.

Additionally, with a hands-on approach, you'll ensure the reliability, scalability, and performance of Party City's data warehouse, enabling efficient data analytics and decision-making processes.

Responsibilities and Duties:

Lead the design, development, implementation and maintenance of Party City's Enterprise Data Warehouse architecture, ensuring scalability, performance, and data integrity across all our Snowflake environments.

Collaborate with cross-functional teams to gather business requirements and translate them into scalable data cloud and EDW solutions that meet organizational needs.

Actively participate in hands-on data modeling, ETL (Extract, Transform, Load) development, and data integration processes within all our Snowflake environments.

Design and implement robust data governance policies and procedures to ensure the accuracy, security, and compliance of the Snowflake data assets across all our Snowflake environments.

Collaborate with cross-functional teams to gather business requirements and translate them into technical solutions.

Develop and maintain data dictionaries, metadata repositories, and documentation to support all PCHI data and EDW governance and usage across all our Snowflake environments.

Provide technical guidance and mentorship to the EDW team, including data engineers as well as junior DBAs, fostering a culture of innovation and continuous improvement.

Stay abreast of emerging trends and technologies in cloud data warehouse, EDW and analytics, evaluating their potential impact on Party City's data strategy.

Collaborate with IT teams to optimize data infrastructure, including data storage, processing, and access mechanisms across our Snowflake environments.

Act as a liaison between business stakeholders, technical teams and Snowflake support, facilitating communication and alignment on EDW initiatives as well as Snowflake technical issues and solutions.

Conduct regular performance reviews and capacity planning exercises to ensure the scalability and reliability of Snowflake databases.
Monitor Snowflake database, EDW performance and usage metrics, conducting regular performance reviews and optimization efforts.
Skills Required:

Proficiency in SQL for data querying, manipulation, and analysis.
Experience with ETL (Extract, Transform, Load) tools and processes.
Strong understanding of database management systems and data modeling techniques.
Familiarity with big data, data warehouse architecture and design principles.
Ability to translate business requirements into scalable EDW solutions.
Expertise in Snowflake architecture, administration, and performance tuning.
Experience with Snowflake security configurations and access controls.
Knowledge of Snowflake's data sharing and replication features.
Streaming Technologies such Kafka/kenesis
Additional Skills Requested:

dbt
Airflo

PHP
python
Experience with cloud-based data warehouse solutions, such as AWS Redshift, Google BigQuery, or Azure Synapse Analytics.
Knowledge of advanced analytics techniques, including machine learning and predictive modeling.
Familiarity with data governance frameworks and best practices.
Proficiency in scripting languages such as Python or Perl for automation and data manipulation.
Certification in data warehousing or related fields from reputable organizations or vendors.
Dynamo Db and other no-sql
Excellent organizational skills with the ability to work on multiple projects simultaneously.
Excellent verbal and written communication skills.
Ability to work within strict time constraints and adapt to changing direction and timelines.
Ability to work independently with a proactive approach.
Experience working with internal and external compliance standards such as PCI, SOX.
GDPR is a plus.
Experience with training of system users and coordinating activity of system consultants, outside programmers, and vendors is preferred.
Basic understanding of accounting, manufacturing, and distribution is preferred
Business Acumen:

must have a solid understanding of standard business functions captured in an EDW and enabled by an ERP application including A/R, A/P, G/L, Inventory, Purchasing, Customer Order Processing, Warehouse Management, as well as others a plus.

Qualifications:

Bachelor's degree in Computer Science, Information Systems, or a related field. Advanced degree (Master's or MBA) preferred.

7+ years of hands-on experience in data warehousing, ETL development, and data modeling, with a focus on designing and implementing scalable EDW solutions.

3+ years of hands-on experience as an application database administrator, with at least 2 years of experience specifically with Snowflake.

Strong proficiency in SQL and experience with database management systems (e.g., Snowflake, Azure, Redshift, Teradata, Oracle, SQL Server).
Experience with ETL tools and technologies such as Alteryx, Fivetran, Matillion, Stitch, Informatica, Talend, or Apache NiFi.
Expertise in data modeling techniques, including data vault 2.0, data mesh, cif, 3nf, dimensional modeling and star schema design.
Familiarity with data governance principles and security best practices.
Excellent problem-solving and troubleshooting skills, with the ability to diagnose and resolve complex database issues.
Proven leadership and team management skills, with the ability to lead by example and inspire others to achieve excellence.
Requirements

Skills Required:

Proficiency in SQL for data querying, manipulation, and analysis.
Experience with ETL (Extract, Transform, Load) tools and processes.
Strong understanding of database management systems and data modeling techniques.
Familiarity with big data, data warehouse architecture and design principles.
Ability to translate business requirements into scalable EDW solutions.
Expertise in Snowflake architecture, administration, and performance tuning.
Experience with Snowflake security configurations and access controls.
Knowledge of Snowflake's data sharing and replication features.
Streaming Technologies such Kafka/kenesis
Req Num

7676

#J-18808-Ljbffr

Data Warehouse Manager

1 day ago

Longbridge Financial Paramus, United States

**Company Description** · Longbridge Financial, LLC (LBF) is an innovative company committed to responsibly helping senior homeowners reshape their financial future to improve their retirement. Our mission is to be consistently fair, transparent, and professional at all times wit ...
Warehouse Manager

5 days ago

Red Bull Bronx, United States

**Company Description**: · Reporting to the Operations Manager, the Warehouse Manager will assist the Red Bull Distribution Company (RBDC) management team with warehouse operations which includes inventory management, fleet management, warehouse management safety management, and ...
Warehouse Manager

4 days ago

American Christmas Mount Vernon, United States

American Christmas LLC has been one of the nation's largest commercial Christmas decorating companies since 1968. Fifty years later, and after being acquired by MK Illumination in 2017, we're thriving and looking to grow our team. We create worlds of light and stage places with f ...
Warehouse Manager

4 days ago

Sensational Farm Fresh Elizabethport, United States

Title: Warehouse Manager with Clamp Truck and Box Truck Experience (Night Shift) · Location: [Your Location] · Company: [Your Company Name] · , Night Shift · **Salary**: Competitive, based on experience · Description: · Join our dynamic team as a Warehouse Manager and take charge ...
Warehouse Manager

1 week ago

JOSMO Moonachie, United States

Job Title: Warehouse Worker · Company: Josmo Shoes · Location: 5 Caesar Pl Moonachie, NJ 07074 · We are seeking a motivated and detail-oriented Warehouse Worker to join our team at Josmo. As a Warehouse Worker, you will play a crucial role in ensuring that our Shipments go out co ...
Warehouse Operations Manager

1 week ago

Cold-Link Logistics Holland Holland, United States

Cold-Link Logistics is a rapidly growing Warehousing and Logistics Company built on Family Values. We are dedicated to serving our customer needs with innovative cold storage warehousing and distribution solutions. · To support our rapid team and business growth, we are actively ...
Assistant Warehouse Manager

1 week ago

Crosstown Plumbing East Orange, United States

**Why you should join us**: · - Competitive salary of** $90-100k**: · - Robust health benefits · - Vision insurance · - Dental insurance · - Paid vacation and sick time · - 401k program · - Company SWAG · - Annual holiday party · - Free snacks available for employees · **What you ...
Night Warehouse Manager

1 week ago

Nature's Produce Vernon, United States

Nature's Produce distributes the finest product that Mother Nature has to offer. As we continue to expand our business, we are seeking **NIGHT** **Warehouse Operations Supervisor** to help us keep up with demand for our products and service for our customers. · We're looking for ...
Assistant Warehouse Manager

3 days ago

Mosner Family Brands Hunts Point, United States

**Position Summary** · Mosner Family Brands is seeking an experienced Warehouse Supervisor to lead warehouse personnel and processes for incoming and outgoing fresh and frozen products. Must be able to work full-time Monday-Friday from 3:30a-1pm+. · **Responsibilities** · - Sched ...
Warehouse Dispatch Manager

1 week ago

Crosstown Plumbing East Orange, United States

**Why you should join us**: · - Competitive salary of** $90-100k**: · - Robust health benefits · - Vision insurance · - Dental insurance · - Paid vacation and sick time · - 401k program · - Company SWAG · - Annual holiday party · - Free snacks available for employees · **What you ...
Data Warehouse Manager

1 week ago

Party City Woodcliff Lake, United States

Company Overview: · Party City Holdco Inc. (PCHI) is a global leader in the celebrations industry, with its offerings spanning more than 70 countries around the world. PCHI is also the largest vertically integrated designer, manufacturer, distributor, and retailer of party goods ...
Air Logistics Warehouse Manager

1 day ago

Kuehne+Nagel New York, United States

Are you thinking about improving your career development and your professional growth? We invite you to join one of the most successful international logistics organizations here at Kuehne+Nagel. Our Jamaica, Queens branch is looking for a new Warehouse Manager to join our Air Lo ...
Enterprise Data Warehouse Manager

2 weeks ago

Party City Holdco, Inc. Woodcliff Lake, United States

Company Overview: Party City Holdco Inc. (PCHI) is a global leader in the celebrations industry, with its offerings spanning more than 70 countries around the world. PCHI is also the largest vertically integrated designer, manufacturer, distributor, Warehouse Manager, Enterprise, ...
Enterprise Data Warehouse Manager

5 days ago

Party City Woodcliff Lake, United States

Job Description · Company Overview: · Party City Holdco Inc. (PCHI) is a global leader in the celebrations industry, with its offerings spanning more than 70 countries around the world. PCHI is also the largest vertically integrated designer, manufacturer, distributor, and retai ...
Business Systems Analyst

2 days ago

SeaCube Container Leasing Woodcliff Lake, United States

**Company** · At SeaCube, we acquire, own, manage and lease containers which are essential intermodal equipment used in global containerized cargo trade. This equipment has enabled the growth in global containerized trade because it allows efficient movement of goods via multiple ...
Warehouse Manager

1 week ago

The Tile Shop, Inc. Rochelle Park, United States

Job Description · The warehouse manager coordinates activities of workers engaged in both inbound and outbound shipping. This includes verifying and keeping records on outgoing shipments, preparing items for shipment and managing product storage within the facility. Serves as an ...
Employee (m/f/d) Warehouse / Inventory Management

2 weeks ago

SilverLinx Harrison, NJ, United States Freelance

Are you looking to develop yourself, work independently in an interesting team, and make a real impact? · Then you've come to the right place. As a service and sales company in the field of automation technology, our expertise in this area is recognized by our customers from vari ...
Warehouse Manager

1 week ago

The Williams Company Morganton, United States

We are conducting a search for a Warehouse Manager for a large company located in North Carolina. The Company operates a reputable plant in the United States, and produces very well recognized products. They are able to offer the opportunity for upward mobility. An attractive com ...
Warehouse Manager

1 week ago

Garfield Lumber and Mill Work Garfield, United States

Benefits/Perks · Competitive Pay · Job Summary · ancement · We are seeking an experienced Warehouse Manager to join our team. You will oversee all warehouse operations and ensure receiving, distribution, and storage all run smoothly and efficiently. Responsibilities include e ...
Production And Warehouse Manager

1 week ago

Blackbird Recruiting Suffern, United States

Warehouse & Production Manager · Suffern, NY · Will be responsible for overseeing operations of the warehouse facility, as well as the Production Department. This includes ensuring all incoming and outgoing inventory is processed timely and properly and the production of qualit ...