Onsite Data Analyst — AWS, SQL & Dashboards (Philadelphia)

Robotics Technologies; Philadelphia (Philadelphia County); On-site; USD 86,000 - 123,000; Full time

Job summary

Robotics Technologies is seeking a Data Analyst to support analytics and reporting needs in Philadelphia, PA. This onsite role involves working with large datasets, building models, dashboards, and SQL-based reporting to track key metrics.

You will collect, clean, transform, and analyze data, develop data models, and collaborate with stakeholders to understand reporting requirements. Experience with AWS, SQL, and visualization tools is required.

Qualifications

• Strong experience with AWS cloud services.
• Solid understanding of data modeling and data warehousing.
• Hands-on experience with data analytics and SQL.
• Experience with data visualization tools such as Power BI or Tableau.

Responsibilities

• Collect, clean, transform, and analyze large datasets from multiple sources.
• Develop and maintain data models that support business reporting and analytics.
• Use AWS services to store, process, and analyze data.
• Write, optimize, and maintain SQL queries for data extraction and reporting.
• Create dashboards, reports, and data visualizations to monitor key metrics.
• Analyze trends, patterns, and opportunities that enable process improvements.
• Maintain data accuracy, consistency, quality, and integrity across reporting outputs.
• Collaborate with business stakeholders and technical teams to understand reporting requirements.
• Support ETL/ELT processes and data integration workflows.
• Present analytical findings and recommendations to management.

Skills

AWS cloud services

Data modeling

Data warehousing

SQL

Data analytics

Power BI

Tableau

Tools

AWS

SQL

Power BI

Tableau

ETL

ELT

Job description

Robotics Technologies is seeking a Data Analyst to support analytics and reporting needs in Philadelphia, PA. This onsite role involves working with large datasets, building models, dashboards, and SQL-based reporting to track key metrics.

You will collect, clean, transform, and analyze data, develop data models, and collaborate with stakeholders to understand reporting requirements. Experience with AWS, SQL, and visualization tools is required.