Data Analyst

Robotic Process Automation LLC; Trenton (NJ); In loco; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

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

Mansioni

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

Conoscenze

Data analysis

Python

SQL

ETL design

Data modeling

Dashboard development

Stakeholder collaboration

Data quality

Strumenti

Python

SQL

ETL

Descrizione del lavoro

• Requirements Gathering and Business Analysis: Engage with business stakeholders and end-users to identify data and reporting requirements, analyze business needs, and translate functional objectives into detailed technical specifications for data collection, transformation, and processing.
• Data Cleansing and Preprocessing: Develop and implement data cleansing and preprocessing procedures using Python and SQL to identify and address missing values, duplicates, inconsistencies, and data-quality issues, ensuring reliable and accurate datasets for downstream analytics.
• Data Workflow Optimization and System Enhancements: Analyze existing customer data workflows, reporting processes, and dashboard solutions to identify performance gaps and recommend technical enhancements that improve processing efficiency, system performance, scalability, and data accuracy.
• Data Pipeline and Architecture Development: Design and configure data pipeline components by defining data ingestion mechanisms, ETL processes, transformation workflows, storage requirements, and integration with reporting and data visualization platforms.
• Data Modeling and Schema Design: Develop logical and physical data models, entity-relationship diagrams (ERDs), and data-flow diagrams to establish appropriate data structures, relationships, dependencies, and schemas that support efficient data management and analytical processing.
• Reporting and Dashboard Development: Design, develop, deploy, and maintain interactive dashboards, reports, and business intelligence solutions that transform processed data into actionable insights and provide automated reporting capabilities for management and **clients.**
• Data Validation, Testing, and System Maintenance: Conduct data validation, quality checks, end-to-end testing, and system monitoring to verify the accuracy, completeness, and reliability of data pipelines and reporting applications while supporting ongoing maintenance and minimizing system disruptions.
• Technical Documentation and Compliance: Prepare and maintain comprehensive technical documentation covering data processes, system architectures, ETL workflows, pipeline configurations, database schemas, and operational procedures to support system maintenance, knowledge transfer, upgrades, and compliance requirements.
• Cross-Functional Collaboration: Collaborate with data engineers, software developers, business analysts, stakeholders, and other technical professionals to design, implement, troubleshoot, and enhance scalable data solutions aligned with organizational and business objectives.

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.