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-10-14

Recommended Jobs

EKG Technician II

One Robert Wood Johnson Place
New Brunswick, NJ

Job Title: EKG Technician II Location: Main Hospital - New Brunswick Department Name: EKG Req #: 0000217910 Status: Hourly Shift: Day Pay Range: $21.12 - $30.10 per hour Pay Trans…

View Details
Posted 2025-10-09

Sales Associate

Balenciaga
Short Hills, NJ

Balenciaga seeks a Sales Associate at Short Hills Mall to provide exceptional customer service and achieve sales goals. The role involves maintaining client relationships, staying informed on fashion …

View Details
Posted 2025-09-27

Radiology Technologist - Per diem

Advanced Orthopedics and Sports Medicine Institute
Freehold, NJ

Per diem position  The Radiology Technologist is responsible for the coordination and performance of the x-ray s for patients including fluoroscopic screening for diagnostic purposes.   Culture …

View Details
Posted 2025-09-25

CEO/ Administrator

Ironside Human Resources
Fort Lee, NJ

A healthcare facility located near Fort Lee, NJ is seeking   a CEO/Administrator   to join their team! Salary: $170,000 - $190,000 / annually CEO/ Administrator Opportunity: Full-time, …

View Details
Posted 2025-09-30

Recovery Specialist - Newark, NJ

201 Lyons Avenue
Newark, NJ

Job Title: Recovery Specialist Location: Newark Beth Israel Med Ctr Department Name: MAT-PDOA Grant Req #: 0000213345 Status: Hourly Shift: Day Pay Range: $16.80 - $26.00 per hour …

View Details
Posted 2025-09-03

Acupuncturist

Select Wellness LLC
Fair Lawn, NJ

Job Description Job Description We are seeking a New Jersey licensed Acupuncturist to join our team. In this role, you will provide comprehensive acupuncture treatments and develop personalized c…

View Details
Posted 2025-10-20

Non-CDL Drivers/Movers

All My Sons Moving & Storage
Cherry Hill, NJ

**ONSITE JOB OFFERS!!!**    Hiring Drivers    We are the largest independently owned local residential moving and storage company. We pride ourselves on taking care of our customers and ou…

View Details
Posted 2025-08-27

Sales Associate

Aromaz Home Improvement Inc
Trenton, NJ

Job Description Job Description Job Description Remarkable flooring and Home Improvement remodeling company looking to recruit new  challenge-driven staff. Through our highly interactive …

View Details
Posted 2025-09-19

Retail Assistant General Manager adidas - Jersey Gardens 6198, Elizabeth, NJ

adidas
Elizabeth, NJ

At adidas we have been challenging the status quo for 70 years and we’re not done yet.  We are calling all Assistant General Managers who don’t accept what “was” or what “is,” but those who want to…

View Details
Posted 2025-08-05