Data Analyst: Pipelines, Dashboards & Data Quality

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

Job summary

Robotic Technologies Automation seeks a data analytics specialist to translate business needs into technical specifications, cleanse and preprocess data with Python and SQL, and optimize data workflows for scalable BI reporting.

Responsibilities include designing data pipelines, modeling schemas, building interactive dashboards, and validating data quality while collaborating with engineers and analysts to deliver actionable insights for clients.

Qualifications

• Experience interpreting business requirements into technical specifications.
• Ability to identify data-cleaning needs and implement quality checks.
• Strong understanding of data workflows, pipelines, and BI tooling.

Responsibilities

• Requirements Gathering and Business Analysis: identify data and reporting requirements and translate objectives into technical specs.
• Data Cleansing and Preprocessing: develop procedures using Python and SQL to address missing values, duplicates, and quality issues.
• Data Workflow Optimization and System Enhancements: analyze workflows and dashboards to improve performance and scalability.
• Data Pipeline and Architecture Development: design data ingestion, ETL, transformation, storage, and integration with BI platforms.
• Data Modeling and Schema Design: create ERDs and data-flow diagrams for efficient analytics.
• Reporting and Dashboard Development: create dashboards and reports for management and clients.
• Data Validation, Testing, and System Maintenance: perform validation, testing, and monitoring to ensure reliability.
• Technical Documentation and Compliance: maintain documentation for data processes and systems.
• Cross-Functional Collaboration: work with data engineers, software developers, and stakeholders to build scalable data solutions.

Skills

Data analysis

Python

SQL

ETL design

Data modeling

Dashboard development

Stakeholder collaboration

Data quality

Tools

Python

SQL

ETL

Job description

Robotic Technologies Automation seeks a data analytics specialist to translate business needs into technical specifications, cleanse and preprocess data with Python and SQL, and optimize data workflows for scalable BI reporting.

Responsibilities include designing data pipelines, modeling schemas, building interactive dashboards, and validating data quality while collaborating with engineers and analysts to deliver actionable insights for clients.