Data Analyst

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

Role: Data Analyst
Location: Trenton, NJ (Hybrid)
Pay rate: $50/Hr on C2C all inclusive

Let's create our future together at The AES Group!
About The AES Group
The AES Group is a premier technology and engineering consulting company that has been bringing businesses and talent together for over 20 years to deliver innovative solutions that have the greatest positive impact on society. AES has helped over 40 business enterprises, including Fortune 500 companies, engage their customers, empower their employees, and transform their business operations with the power of cloud, data, AI, engineering, and other emerging technologies.

Position Overview:

Data Analyst provides technical analysis, automation, & fulfilment of data requests. Proficiency in Snowflake, SQL, and Python is required. Execute complex data requests, perform deep-dive profiling, & resolve data discrepancies to support NJDOE.

Hybrid for 3 days onsite and 2 days remote

The Data Analyst is responsible for the technical analysis, automation, and fulfilment of enterprise data requests within the Department's digital infrastructure. This role requires a high degree of proficiency in Snowflake SQL and Python to manage complex data workflows. The Analyst will be responsible not only for writing new scripts to automate ticket resolutions but also for auditing, understanding, and optimizing the existing codebase to ensure system continuity. Working within cloud environments (Snowflake/AWS), the analyst will execute complex data requests, perform deep-dive profiling, and resolve data discrepancies to support the Department's modernization initiatives.

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

Skill

• Snowflake SQL (Scripting & Optimization) Required 3 Years
• Python Programming (Data/Automation) Required 3 Years
• Code Review & Interpretation Required 3 Years
• Data Analysis & Profiling Required 3 Years
• Automated Scripting for Ticket Resolution Required 3 Years
• Excellent Communication Skills Required 3 Years
• Cloud Data Warehouse (AWS) Desired 3 Years.