Current jobs related to Enterprise Data Warehouse Manager - Woodcliff Lake, New Jersey - PCHI


  • Woodcliff Lake, New Jersey, United States Party City Full time

    Job OverviewWe 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...


  • Woodcliff Lake, New Jersey, United States Party City Full time

    {"Job Title": "Senior Customer Relationship Manager", "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. The company operates across multiple businesses within its Retail Division and Consumer Products Division.", "Job Overview": "We are...


  • Woodcliff Lake, New Jersey, United States Colonial Surety Company Full time

    About UsColonial Surety Company is a leading insurance provider licensed in every state, recognized by the U.S. Treasury as an approved surety, and rated "A Excellent" by A.M. Best Company. Our innovative digital platform offers a range of liability coverages for small and mid-size businesses.Job SummaryWe're seeking an experienced data analyst to drive our...


  • Woodcliff Lake, New Jersey, United States Colonial Surety Company Full time

    About Colonial Surety CompanyWe are a leading 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 digital product platform has recently expanded to include important liability coverages for small and mid-size businesses.Founded in 1930, we use our...


  • Woodcliff Lake, New Jersey, United States Colonial Surety Company Full time

    About the RoleWe are seeking a highly skilled Ecommerce Data Analyst to join our team at Colonial Surety Company. As a key member of our data-driven organization, you will play a critical role in driving business growth and success through data analysis and strategic recommendations.Key ResponsibilitiesData Analysis and Reporting: Provide support in managing...


  • Woodcliff Lake, New Jersey, United States Party City Canada Full time

    Company SummaryJob Title: Lead Manager, Corporate FinanceLocation: Corp-Hybrid, Woodcliff Lk, NJFull-Time/Part Time: Full-timeCompany Overview:Party City Holdco Inc. (PCHI) stands as a premier entity in the celebrations sector, extending its services across over 70 nations globally. PCHI is recognized as the foremost vertically integrated designer,...

  • Logistics Director

    7 days ago


    Woodcliff Lake, New Jersey, United States Affinity Executive Search Full time

    Director of Logistics/Supply Chain Job DescriptionOur client, a leading Food Manufacturer, is seeking a seasoned Director of Logistics/Supply Chain to drive strategic growth and operational excellence.Key Responsibilities:Oversee daily warehouse and transportation operations to ensure customer satisfaction.Develop and implement scalable logistics strategies...


  • Woodcliff Lake, New Jersey, United States RIT Solutions, Inc. Full time

    Overview:RIT Solutions, Inc. is seeking a skilled Systems Business Analyst to join our team. In this pivotal role, you will integrate the functions of a Business Process Analyst, Integrator, and Application Support Specialist. Your primary objective will be to transform, sustain, and deploy business systems and processes that enhance efficiency and foster...


  • Woodcliff Lake, New Jersey, United States SeaCube Container Leasing Full time

    Company OverviewWelcome to SeaCube, a leader in the acquisition, management, and leasing of containers essential for the global containerized cargo industry. Our containers are vital for the efficient transportation of goods across various modes, including maritime, rail, and road. We focus on establishing long-term leasing agreements with prominent shipping...


  • Woodcliff Lake, New Jersey, United States SeaCube Container Leasing Full time

    Company OverviewWelcome to SeaCube, a leader in the acquisition, management, and leasing of containers that are essential to the global containerized cargo industry. Our containers enable the efficient transportation of goods across various modes, including maritime, rail, and road. We are focused on establishing long-term leasing agreements with prominent...


  • Woodcliff Lake, New Jersey, United States SeaCube Container Leasing Full time

    Company OverviewWelcome to SeaCube, a leader in the acquisition, management, and leasing of containers essential for the global containerized cargo industry. Our containers are pivotal in ensuring the efficient transport of goods across various modes, including maritime, rail, and road. We focus on establishing long-term leasing agreements with prominent...


  • Woodcliff Lake, New Jersey, United States SeaCube Container Leasing Full time

    Company OverviewWelcome to SeaCube, a leader in the acquisition, management, and leasing of containers essential for the global containerized cargo industry. Our containers are vital for the efficient transportation of goods across various modes, including maritime, rail, and road. We are focused on establishing long-term leasing agreements with prominent...


  • Woodcliff Lake, New Jersey, United States SeaCube Container Leasing Full time

    Company OverviewWelcome to SeaCube, a leader in the acquisition, management, and leasing of containers essential for the global cargo trade. Our containers enable the efficient transportation of goods across various modes, including maritime, rail, and road. We focus on long-term leasing agreements with prominent shipping firms. We are currently in search of...


  • Woodcliff Lake, New Jersey, United States SeaCube Container Leasing Full time

    Company OverviewWelcome to SeaCube, a leader in the acquisition, management, and leasing of containers essential for the global containerized cargo industry. Our containers enable efficient goods transportation across various modes, including maritime, rail, and road. We focus on long-term leasing agreements with prominent shipping firms. We are currently in...

  • ERP Administrator

    16 hours ago


    Woodcliff Lake, New Jersey, United States McLaren Engineering Group Full time

    ERP Administrator Job DescriptionAt McLaren Engineering Group, we are seeking a highly skilled ERP Administrator to join our Operations team. As a key member of our team, you will be responsible for maintaining the effective use of Deltek Vision, our enterprise resource planning system.The successful candidate will have a strong background in ERP systems,...


  • Woodcliff Lake, New Jersey, United States TechStar Group Full time

    Fleet Operations Manager Job DescriptionWe are seeking a highly skilled Fleet Operations Manager to join our team at TechStar Group. As a key member of our operations team, you will be responsible for managing the day-to-day activities of our fleet operations, ensuring seamless coordination and execution of fleet-related tasks.Key Responsibilities:Coordinate...


  • Woodcliff Lake, New Jersey, United States Party City Full time

    Job OverviewWe 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...


  • Woodcliff Lake, New Jersey, United States Hudson Technologies Inc Full time

    Job OverviewPosition Title: HR Operations SpecialistReports to: Director of Human ResourcesClassification: Non-exemptEmployment Type: Full-timeLocation: Remote/HybridWork Schedule: Standard business hours, with flexibility for remote workPosition SummaryThe HR Operations Specialist plays a vital role in supporting Hudson's mission by facilitating essential...


  • Woodcliff Lake, New Jersey, United States Net2Source Inc. Full time

    Fleet Manager Job DescriptionAt Net2Source Inc., we are seeking a highly skilled Fleet Manager to join our team. As a key member of our operations team, you will be responsible for managing our fleet of vehicles, ensuring they are properly configured and sourced for service.Main Responsibilities:Configure and Source Vehicles: Work with sales and marketing...


  • Woodcliff Lake, New Jersey, United States Kiewit Corporation Full time

    Requisition ID: 172310Job Level: Senior LevelHome District/Group: Eastern DistrictDepartment: Operational FinanceMarket: TransportationEmployment Type: Full TimePosition OverviewAs a Regional Financial Operations Manager at Kiewit, you will enhance financial outcomes through comprehensive analysis of financial performance, projections, discrepancies, and...

Enterprise Data Warehouse Manager

3 months ago


Woodcliff Lake, New Jersey, United States PCHI Full time

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 in North America.

PCHI operates across multiple businesses within its Retail Division and Consumer Products Division. On the retail side, Party City ([Phone number shown when applying]) 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 in Woodcliff Lake, N.J. with additional locations throughout the Americas and Asia.

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.
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