Data Analyst: SQL, Dashboards & BI Insights

Robotic Technologies Automation; Weehawken (NJ); On-site; USD 65,000 - 90,000; Full time

Job summary

Robotic Technologies Automation in New Jersey seeks a Data Analyst to collect, analyze, and present business data to drive decisions. The role requires hands-on SQL, Excel, and data visualization using Power BI or Tableau.

You will build dashboards, validate data, and communicate key findings to stakeholders. Collaboration with business teams to define KPIs and support ad hoc data requests is essential.

Qualifications

• Experience in data analysis or business data reporting.
• Strong knowledge of SQL and relational databases.
• Hands-on experience with Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas).
• Experience with Power BI or Tableau.
• Understanding of data visualization, reporting, and KPI analysis.
• Knowledge of data cleaning, validation, and reconciliation.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Collect, clean, validate, and analyze data from multiple business sources.
• Write and optimize SQL queries to extract and transform data.
• Develop interactive dashboards and reports using Power BI or Tableau.
• Analyze business trends, patterns, and performance indicators.
• Prepare periodic reports and communicate key findings to stakeholders.
• Perform data validation, reconciliation, and quality checks.
• Work with business teams to understand reporting requirements and define KPIs.
• Identify data discrepancies and coordinate with technical teams to resolve issues.
• Maintain reporting documentation, dashboards, and analytical reports.
• Support ad hoc data requests and provide actionable insights to business users.

Skills

SQL

Excel

Power BI

Tableau

Data visualization

KPI analysis

Data cleaning

Communication

Problem solving

Tools

Power BI

Tableau

Job description

Robotic Technologies Automation in New Jersey seeks a Data Analyst to collect, analyze, and present business data to drive decisions. The role requires hands-on SQL, Excel, and data visualization using Power BI or Tableau.

You will build dashboards, validate data, and communicate key findings to stakeholders. Collaboration with business teams to define KPIs and support ad hoc data requests is essential.