Data Analyst

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description :

We are looking for a skilled Data Analyst to collect, analyze, interpret, and present business data to support data-driven decision-making. The ideal candidate should have hands-on experience with SQL, Excel, Power BI or Tableau, data visualization, and reporting.

Key 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.

Required Skills :

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.

Preferred Qualifications :

Basic knowledge of Python for data analysis.

Familiarity with ETL processes and data warehousing.

Experience working with large datasets.

Knowledge of business intelligence and reporting practices.

Experience collaborating with business and technical stakeholders.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.