Data Warehouse Analyst

PNY Technologies
Parsippany, NJ
Main Function

We are seeking a highly skilled and experienced Data Warehouse Analyst to oversee the management and optimization of our data warehouse systems. The successful candidate will lead cross-functional teams, drive data strategies in alignment with business objectives, and ensure seamless integration across various departments.

Qualifications

  • Experience : Minimum of 5 years of experience in data warehousing, business intelligence, or a similar role. Proven experience in data warehousing or a similar role, with a track record of successful data warehouse implementations and ongoing maintenance.
  • Technical Proficiency : Strong understanding of data warehouse technologies, database management systems, and programming languages such as SQL, with expertise in maintaining system performance and updates.
    • Strong foundation in Microsoft SQL Server
    • Experience with cloud platforms like Azure Synapse, Amazon Redshift a plus
    • Familiarity with Data Lake/Lakehouse models
    • Proficiency with ETL tools such as Azure Data Factory, SSIS
    • Power BI expertise including DAX and service admin
  • Analytical Skills : Ability to analyze complex business processes and data sets to optimize data warehouse performance and ensure continuous improvement. Analyze both structured and unstructured data to provide comprehensive insights.
  • Project Management Skills : Excellent organizational and leadership abilities, with proficiency in project management methodologies and tools for both implementation and maintenance phases.
  • Communication Skills : Strong verbal and written communication skills, capable of conveying complex data warehouse concepts to non-technical stakeholders, facilitating ongoing support and training.
  • Problem-Solving Aptitude : Demonstrated ability to troubleshoot issues and implement effective solutions during data warehouse deployment and post-implementation maintenance.
  • Adaptability : Willingness to stay updated with the latest advancements in data warehouse technologies and integrate them into business processes, ensuring the system remains current and efficient.
  • Educational Background : Bachelor’s or Master’s degree in Computer Science, Information Technology, Business Administration, or a related field, with a focus on systems management and maintenance.
    • Relevant certifications (e.g., PMP, data warehousing certifications, BI certifications) are a plus.
  • Experience in Business Intelligence (BI) and Data Warehousing (DW) : Essential for transforming raw data into meaningful information that supports decision-making and enhances business operations and outcomes.
  • Modern Data Architecture & Storage: Cloud Data Warehousing
    • Experience with platforms like Azure Synapse Analytics, Amazon Redshift, or Google BigQuery
Working Conditions

The work environment characteristics are representative of those an employee encounters while performing the essential functions of this job.

Key Relationships

  • Executive Management : Collaborate with senior leaders to align data warehouse strategies with organizational goals and secure necessary resources.
  • Department Heads : Work closely with heads of various departments to identify data integration opportunities and ensure smooth implementation.
  • IT and Development Teams : Coordinate with technical teams to oversee the configuration, customization, and deployment of data warehouse modules. Ensure data warehouse systems comply with data privacy regulations and maintain robust security standards.
  • End Users : Provide training and support to employees to facilitate effective utilization of data warehouse systems.

Duties And Responsibilities

To perform this job successfully, the individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Data Warehouse Strategy : Develop and implement data warehouse strategies that align with the organization's business objectives.
  • Project Management : Lead data warehouse projects from conception through deployment, ensuring timely and within-budget delivery.
  • Cross-Functional Collaboration : Work closely with various departments to identify opportunities for data integration and ensure seamless implementation.
  • Technical Oversight : Supervise the development and optimization of data warehouse systems, ensuring they meet business requirements and performance standards.
  • Training and Support : Conduct training sessions for employees on data warehouse systems and provide ongoing support to ensure effective utilization.
  • Performance Monitoring : Continuously monitor data warehouse system performance, making necessary adjustments to improve efficiency and effectiveness.
  • Compliance Assurance : Ensure all data warehouse implementations comply with data privacy regulations and industry standards.
  • Vendor Management : Manage relationships with data warehouse technology vendors and service providers to facilitate successful implementations.

Compensation

The base salary range for this position is $100,000 to $115,000; the exact salary depends on several factors such as experience, skills, education, and budget.

Benefits Overview

We offer a competitive benefits package that includes medical, dental, vision, basic life and AD&D coverage, short- and long-term disability, a 401(k) retirement plan, annual discretionary salary increases and bonuses. Employees receive paid company holidays, paid time off, and access to company-paid training. Optional benefits include tuition reimbursement, a 529 college savings plan, pet insurance, legal and ID theft coverage, and other voluntary insurance plans.
Posted 2025-09-01

Recommended Jobs

Farm Manager

Farm Job Search
Voorhees, NJ

Farm Manager (6515) Location: Voorhees, New Jersey Job Number: 6515 We are searching for a hands-on Farm Manager with good business sense to join our team. The Farm Manager’s responsibilitie…

View Details
Posted 2025-08-15

Media Sales Consultant - Community Co-Op

Clipp
Cherry Hill, NJ

Job Description Job Description Description: Media Sales Consultant - Community - Co-Op Are you passionate about local businesses, community engagement, and driving real results? We’re look…

View Details
Posted 2025-07-25

Landscape Production Manager

LandCare
Marlboro, NJ

Job Description Job Description Production Managers at LandCare are crucial members of our operations team. Production Managers lead the frontline crews to ensure quality, efficiency, and safety …

View Details
Posted 2025-08-30

Merchandiser

N.K.S. Distributors
Newark, NJ

  Want a career in beer? We are looking for a Merchandiser to join our team!    Job Summary:    This position is responsible for servicing the needs of the Sales and Marketing teams by buildin…

View Details
Posted 2025-08-22

Community Support Counselor (Part Time)

JEVS Human Services
Camden, NJ

JEVS Human Services has an exciting opportunity as a community-based Community Support Counselor.  The Independence Network empowers young adults with disabilities in a supportive community so they…

View Details
Posted 2025-08-27

Data Entry/Office Assistant

GUY J RENZI & ASSOCIATES INC
Hamilton, NJ

Job Description Job Description Data Entry/Office Assistant Busy Court Reporting Agency in Central New Jersey seeking Full-Time Clerical/Data Entry Employee. • Full-time position • On loca…

View Details
Posted 2025-08-05

Seasonal Sales Associate

Coach
Lawrenceville, NJ

Coach is seeking a Seasonal Sales Associate in Lawrenceville, NJ, to provide outstanding customer service and support sales initiatives. This role involves engaging with customers, maintaining visual …

View Details
Posted 2025-08-19

Human Resources Generalist

Glass Meadows
Newton, NJ

Company Overview  At Glass Meadows, Inc. our goal is to cultivate the highest quality cannabis products that provide safe, effective and consistent experiences for our customers. We are committed t…

View Details
Posted 2025-08-18

R&D Packaging Engineer

Saviance Technologies
Franklin Lakes, NJ

Must Have: Package design experience Package testing experience Solid works experience Package equipment knowledge Medical device packaging experience Responsibilities: The incumbent will be re…

View Details
Posted 2025-08-06

Sustainability & Regulatory Analysis Intern - Summer 2026

Henkel
Bridgewater, NJ

About this Position At Henkel, you’ll be part of an organization that’s shaping the future through innovation, sustainability and collaboration. With our trusted brands like Persil®, ‘all®, Loctit…

View Details
Posted 2025-09-05