Data Analyst

Donnelly & Moore Corporation; New York (NY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Donnelly & Moore Corporation seeks a Data Analyst in New York, NY to support EV data analysis and reporting initiatives with strong SAS and SQL capabilities. The role emphasizes extracting, transforming, and communicating insights through diagnostic and predictive analytics.

The position requires 5+ years of data analysis experience, advanced SQL, and SAS programming, with collaboration across business and technical teams to deliver data-driven insights.

Qualifications

• Bachelor’s degree in Statistics, Mathematics, Computer Science, Data Science, or related field.
• 5+ years of professional data analysis experience.
• Advanced SQL, including complex joins, window functions, and query optimization.
• Strong SAS programming experience, including SAS Macro development and PROC SQL.
• Experience with data visualization and reporting tools.

Responsibilities

• Design, maintain, and analyze complex datasets.
• Extract and mine data from primary and secondary sources.
• Clean, transform, and organize data for analysis and reporting.
• Develop and optimize complex SQL queries.
• Present analytical findings to non-technical stakeholders.

Skills

Strong SQL querying

SAS programming

Data analysis

Communication

Education

Bachelor's degree in Statistics / Mathematics / Computer Science / Data Science

Tools

PROC SQL

SAS Macro

Data visualization tools

Python

Job description

This contract Data Analyst role in New York, NY supports data analysis and reporting initiatives focused on electric vehicle (EV) data. The position emphasizes strong SAS and SQL capabilities to extract, transform, analyze, and communicate insights through diagnostic and predictive analytics.

Role Responsibilities

• Design, maintain, and analyze complex datasets.
• Extract and mine data from primary and secondary sources.
• Clean, transform, and reorganize data for analysis and reporting.
• Identify trends, patterns, and anomalies within large datasets.
• Support diagnostic and predictive analytics initiatives.
• Develop and optimize complex SQL queries.
• Perform data validation and troubleshoot data-quality issues.
• Identify and correct coding and data-related errors.
• Develop reports and data visualizations to communicate findings.
• Collaborate with business and technical teams to understand data requirements.
• Present analytical findings and technical concepts to non-technical stakeholders.
• Support ongoing data-quality and process-improvement initiatives.

Required Qualifications

• Bachelor’s degree in Statistics, Mathematics, Computer Science, Data Science, or a related field.
• 5+ years of professional data analysis experience.
• Advanced SQL, including complex joins, window functions, and query optimization.
• Strong SAS programming experience.
• Experience with SAS Macro development and PROC SQL.
• Experience analyzing large and complex datasets.
• Experience with data visualization and reporting tools.
• Strong analytical, problem-solving, and critical-thinking skills.
• Excellent written and verbal communication skills.
• Ability to explain technical data concepts to non-technical audiences.

Preferred Qualifications

• Experience with EV or electric vehicle data, or transportation-related datasets.
• Experience with Python or other programming languages.
• Experience supporting predictive or diagnostic analytics.
• Experience working in an Agile/Scrum environment.
• Experience with cloud-based data environments.

Technologies

• SAS
• SQL
• PROC SQL
• SAS Macro
• Data visualization and reporting tools
• Python

Location, Work Arrangement, and Contract Details

• Location: New York City, NY
• Work Arrangement: Hybrid, 2-3 days onsite per week
• Job Type: Contract
• Experience Level: 5+ years

Core Skills

• SAS
• SQL
• PROC SQL
• SAS Macros
• Data Analysis
• Data Mining
• Data Quality
• Statistical Analysis
• Data Visualization
• Predictive Analytics
• Business Data Analysis