Hybrid Data Analyst: Snowflake, Python & Automation

The AES Group; Trenton (NJ); Hybrid; USD 57,000 - 81,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

The AES Group is seeking a Data Analyst in Trenton, NJ, hybrid role combining on-site and remote work. You will perform advanced Snowflake SQL development, Python scripting for automations, and data profiling to support NJDOE initiatives and cloud data operations with Snowflake/AWS.

Responsibilities include auditing existing code, optimizing data workflows, and translating business requirements into precise technical deliverables.

Qualifications

• Snowflake SQL Development: Write, debug, and optimize complex SQL scripts within the Snowflake environment to fulfill ad hoc data requests and perform system-wide data analysis.
• Codebase Auditing: Review and interpret existing Python and SQL code to troubleshoot errors, suggest improvements, and ensure new automations align with established logic.
• Support Automation: Develop and deploy Python-based scripts to automate the resolution of recurring support tickets, significantly reducing manual intervention for common data tasks.
• Cloud Data Operations: Perform data profiling and validation within Snowflake and AWS to ensure data integrity across the Project Nexus ecosystem.
• Request Fulfillment: Serve as the technical point of contact for complex data inquiries, translating business requirements into precise technical deliverables.

Responsibilities

• Snowflake SQL Development: Write, debug, and optimize complex SQL scripts within the Snowflake environment to fulfill ad hoc data requests and perform system-wide data analysis.
• Codebase Auditing: Review and interpret existing Python and SQL code to troubleshoot errors, suggest improvements, and ensure new automations align with established logic.
• Support Automation: Develop and deploy Python-based scripts to automate the resolution of recurring support tickets, significantly reducing manual intervention for common data tasks.
• Cloud Data Operations: Perform data profiling and validation within Snowflake and AWS to ensure data integrity across the Project Nexus ecosystem.
• Request Fulfillment: Serve as the technical point of contact for complex data inquiries, translating business requirements into precise technical deliverables.

Skills

Snowflake SQL

Python

Code Review

Data Analysis

Automated Scripting

Excellent Communication

AWS Cloud Data Warehouse

Job description

The AES Group is seeking a Data Analyst in Trenton, NJ, hybrid role combining on-site and remote work. You will perform advanced Snowflake SQL development, Python scripting for automations, and data profiling to support NJDOE initiatives and cloud data operations with Snowflake/AWS.

Responsibilities include auditing existing code, optimizing data workflows, and translating business requirements into precise technical deliverables.