Data & Reporting Analyst: Excel, SQL & GenAI Automation

JPS Tech Solutions Pvt Ltd; Mount Laurel Township (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd in Mount Laurel, NJ is seeking a data/operations-oriented professional to develop and maintain reports, dashboards, and metrics. You will leverage advanced Excel, SQL, and GenAI coding to provide actionable insights for engineering leadership.

You will coordinate with engineering teams, vendors, and finance to ensure accurate reporting and governance, while identifying automation opportunities to improve efficiency and decision-making.

Qualifications

• Advanced Excel skills with XLOOKUP/VLOOKUP, Pivot Tables, Macros, VBA scripting.
• Strong SQL database build and querying experience.
• Experience with generative AI coding (Claude).
• Ability to analyze large datasets to provide actionable insights.
• Develop and maintain engineering metrics, scorecards, trackers, and reports.
• Support vendor management activities and reporting.
• Maintain knowledge repositories and governance artifacts.
• Prepare recurring and ad hoc reports, presentations, and reviews.
• Handle sensitive information with confidentiality and integrity.
• Coordinate with multiple teams to support operational objectives.
• Identify process improvements and automate manual activities.

Responsibilities

• Develop and maintain engineering metrics, scorecards, trackers, and reports.
• Prepare recurring and ad hoc reports and leadership presentations.
• Coordinate with engineering, vendors, project managers, finance, HR, and leadership.
• Analyze data, validate results, and provide actionable insights.
• Identify and automate manual processes to improve efficiency.
• Maintain governance artifacts and operational documentation.

Skills

Excel advanced skills (XLOOKUP/VLOOKUP

Pivot Tables

Macros & VBA scripting

SQL querying & data modelling

Generative AI coding (Claude)

Data analysis & reporting

Dashboards & metrics development

Analytical problem solving

Tools

SQL

Claude

Excel

Job description

JPS Tech Solutions Pvt Ltd in Mount Laurel, NJ is seeking a data/operations-oriented professional to develop and maintain reports, dashboards, and metrics. You will leverage advanced Excel, SQL, and GenAI coding to provide actionable insights for engineering leadership.

You will coordinate with engineering teams, vendors, and finance to ensure accurate reporting and governance, while identifying automation opportunities to improve efficiency and decision-making.