Enterprise Data Warehouse Manager

2 weeks ago

Woodcliff Lake, United States Party City 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 (partycity.com) 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

  • Chief Information Officer

    6 hours ago

    Woodcliff Lake, United States Party City Holdings Inc Full time

    Chief Information Officer in Woodcliff Lake,NJ at Party City Holdings Inc. The PCHI family of companies is a global leader in the celebrations industry. We design, manufacture, distribute and sell celebration products, services and experiences. And we do it all, start to finish. Here’s your chance to help create lasting memories and make joy easy for...

  • Senior Manager Customer Relationship Management

    4 weeks ago

    Woodcliff Lake, United States Party City Full time

    Job Overview We are seeking a highly experienced Senior Manager of CRM to lead our customer relationship strategy with a specialized focus on personalization and contact strategy. The ideal candidate will be an expert in using CRM tools and analytics to create personalized customer experiences and develop contact strategies that engage customers across...

  • Senior Manager Customer Relationship Management

    3 weeks ago

    Woodcliff Lake, United States Party City Full time

    Job Overview We are seeking a highly experienced Senior Manager of CRM to lead our customer relationship strategy with a specialized focus on personalization and contact strategy. The ideal candidate will be an expert in using CRM tools and analytics to create personalized customer experiences and develop contact strategies that engage customers across...

  • Product Manager

    3 days ago

    Woodcliff Lake, United States Party City Full time

    Company OverviewParty 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 in North America.PCHI team members demonstrate a daily commitment to the company's...

  • Product Manager

    2 weeks ago

    Woodcliff Lake, United States Party City Full time

    Company OverviewParty 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 in North America.PCHI team members demonstrate a daily commitment to the company's...

  • Product Manager

    2 weeks ago

    Woodcliff Lake, United States Party City Full time

    Company OverviewParty 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 in North America.PCHI team members demonstrate a daily commitment to the company's...

  • Senior Manager Customer Relationship Management

    1 week ago

    Woodcliff Lake, United States Coda Search│Staffing Full time

    Job Overview:We are seeking a highly experienced Senior Manager of CRM to lead our customer relationship strategy with a specialized focus on personalization and contact strategy. The ideal candidate will be an expert in using CRM tools and analytics to create personalized customer experiences and develop contact strategies that engage customers across...

  • Senior Manager Customer Relationship Management

    1 week ago

    Woodcliff Lake, United States Coda Search│Staffing Full time

    Job Overview:We are seeking a highly experienced Senior Manager of CRM to lead our customer relationship strategy with a specialized focus on personalization and contact strategy. The ideal candidate will be an expert in using CRM tools and analytics to create personalized customer experiences and develop contact strategies that engage customers across...

  • Sr. Manager, Distribution

    3 weeks ago

    Woodcliff Lake, United States Tata Consumer Products Full time

    At Tata Consumer Products Ltd, we stand #Forbetter – Planet, Sourcing, Nutrition, Communities. And #ForBetter Opportunities …. Here’s an exciting one!How does this job align to our Strategy?At the core of Tata Consumer Products' business approach lie six strategic pillars that serve as the foundation for its growth and success: Strengthening &...

  • Sr. Manager, Distribution

    3 weeks ago

    Woodcliff Lake, United States Tata Consumer Products Full time

    At Tata Consumer Products Ltd, we stand #Forbetter – Planet, Sourcing, Nutrition, Communities. And #ForBetter Opportunities …. Here’s an exciting one!How does this job align to our Strategy?At the core of Tata Consumer Products' business approach lie six strategic pillars that serve as the foundation for its growth and success: Strengthening &...

  • Sr. Manager, Distribution

    3 weeks ago

    Woodcliff Lake, United States Tata Consumer Products Full time

    At Tata Consumer Products Ltd, we stand #Forbetter Planet, Sourcing, Nutrition, Communities. And #ForBetter Opportunities . Heres an exciting one! How does this job align to our Strategy? At the core of Tata Consumer Products' business approach lie six strategic pillars that serve as the foundation for its growth and success: Strengthening & Accelerating...

  • Sr. Manager, Distribution

    3 weeks ago

    Woodcliff Lake, United States Tata Consumer Products Full time

    At Tata Consumer Products Ltd, we stand #Forbetter – Planet, Sourcing, Nutrition, Communities. And #ForBetter Opportunities …. Here’s an exciting one!How does this job align to our Strategy?At the core of Tata Consumer Products' business approach lie six strategic pillars that serve as the foundation for its growth and success: Strengthening &...

  • Ecommerce Data Analyst

    4 weeks ago

    Woodcliff Lake, United States Colonial Surety Company Full time

    ** All employee must maintain business attire.** This position is on-site only. No remote.Ecommerce Data AnalystAbout UsColonial Surety Company is an insurance company licensed for business in every state, listed by the U.S. Treasury as an approved surety, and rated “A Excellent” by A.M. Best Company. Our distinct, digital product platform has recently...

  • Ecommerce Data Analyst

    4 weeks ago

    Woodcliff Lake, United States Colonial Surety Company Full time

    ** All employee must maintain business attire.** This position is on-site only. No remote.Ecommerce Data AnalystAbout UsColonial Surety Company is an insurance company licensed for business in every state, listed by the U.S. Treasury as an approved surety, and rated “A Excellent” by A.M. Best Company. Our distinct, digital product platform has recently...

  • Ecommerce Data Analyst

    1 month ago

    Woodcliff Lake, United States Colonial Surety Company Full time

    ** All employee must maintain business attire.** This position is on-site only. No remote.Ecommerce Data AnalystAbout UsColonial Surety Company is an insurance company licensed for business in every state, listed by the U.S. Treasury as an approved surety, and rated “A Excellent” by A.M. Best Company. Our distinct, digital product platform has recently...

  • Client Relationship Manager

    3 days ago

    Woodcliff Lake, United States Coda Search│Staffing Full time

    Job Overview:We are seeking a highly experienced Senior Manager of CRM to lead our customer relationship strategy with a specialized focus on personalization and contact strategy. The ideal candidate will be an expert in using CRM tools and analytics to create personalized customer experiences and develop contact strategies that engage customers across...

  • Client Relationship Manager

    1 week ago

    Woodcliff Lake, United States Coda Search│Staffing Full time

    Job Overview:We are seeking a highly experienced Senior Manager of CRM to lead our customer relationship strategy with a specialized focus on personalization and contact strategy. The ideal candidate will be an expert in using CRM tools and analytics to create personalized customer experiences and develop contact strategies that engage customers across...

  • Sr. Manager, Distribution

    2 weeks ago

    Woodcliff Lake, United States Tata Consumer Products - USA Full time

    At Tata Consumer Products Ltd, we stand #Forbetter - Planet, Sourcing, Nutrition, Communities. And #ForBetter Opportunities .... Here's an exciting one!How does this job align to our Strategy? At the core of Tata Consumer Products' business approach lie six strategic pillars that serve as the foundation for its growth and success: Strengthening &...

  • Sr. Manager, Distribution

    2 weeks ago

    Woodcliff Lake, United States Tata Consumer Products - USA Full time

    Job DescriptionJob DescriptionAt Tata Consumer Products Ltd, we stand #Forbetter – Planet, Sourcing, Nutrition, Communities. And #ForBetter Opportunities …. Here’s an exciting one!How does this job align to our Strategy? At the core of Tata Consumer Products' business approach lie six strategic pillars that serve as the foundation for its growth...

  • Ecommerce Data Analyst NJ

    2 weeks ago

    Woodcliff Lake, United States Colonial Surety Company Full time

    Ecommerce Data Analyst About Us Colonial Surety Company is an insurance company licensed for business in every state, listed by the U.S. Treasury as an approved surety, and rated “A Excellent” by A.M. Best Company. Our distinct, digital product platform has recently expanded to include important liability coverages for small and mid-size...