Data Analyst 1

Job Title: Data Analyst 1
Job Location: (Rockaway, NJ or Morristown, NJ - Hybrid) - 2/3 Days in Onsite
Job Duration: 6 Months (possibility of extension)
Payrate: $32.00/ hr. on w2

Job Summary:

• We are seeking a contract Power BI & Data Analyst to support reporting and dashboard development for our Supply Chain Logistics organization.
• This role will focus on building and maintaining dashboards, cleansing and preparing data, and supporting standardized reporting across warehousing, procurement, order management, and transportation.
• This is a hands-on execution role.
• KPI definitions, reporting requirements, prioritization, and business context will be provided by internal stakeholders.
• The analyst will be responsible for translating those requirements into accurate, timely, and reliable dashboards and datasets.

Key Responsibilities:

Reporting & Dashboards:

• Build and maintain Power BI dashboards and reports based on defined business requirements.
• Update and enhance existing dashboards to improve usability, performance, and clarity.
• Ensure dashboards are refreshed, accurate, and aligned to provided KPI definitions.
• Support ad-hoc reporting and data requests from Logistics leadership.

Data Preparation & Management:

• Query and extract data from Snowflake using SQL.
• Clean, transform, and validate datasets using Power Query and SQL.
• Combine data from multiple sources (Snowflake, ERP extracts, flat files).
• Identify data quality issues and escalate to internal owners when needed.

Analytics Support:

• Perform basic analysis including trend comparisons, variances, and performance tracking.
• Support preparation of charts, tables, and summaries for leadership reviews.
• Assist with documentation of data sources, logic, and report definitions.

Process & Automation Support (Limited Product):

• Support simple automation tasks (e.g., Power Automate flows) under guidance.
• Assist with repetitive reporting or data preparation tasks to reduce manual effort.

Required Experience & Skills:

• 2–4 years’ experience in data analytics or reporting.
• Hands-on experience with Power BI (report building, visuals, basic DAX).
• Proficiency in SQL, with experience querying Snowflake.
• Experience with data cleansing and transformation.
• Comfortable working with structured requirements and defined KPIs.
• Strong attention to detail and data accuracy.
• Ability to work independently and meet deadlines in a fast-paced environment.

Preferred Experience:

• Exposure to supply chain or logistics data (warehousing, procurement, order management, transportation).
• Familiarity with ERP data extracts (e.g., SAP).
• Experience supporting operational or executive reporting.
• Basic experience with Power Automate or similar tools.