Data Analyst

ASB Resources; Trenton (NJ); Hybrid; USD 70,000 - 90,000; Full time

Job summary

ASB Resources is seeking a Data Analyst to drive enterprise data requests within the department's digital infrastructure. The role emphasizes Snowflake SQL and Python to build and optimize data workflows in a cloud environment (Snowflake/AWS).

You will audit and improve existing code, automate recurring tasks, profile data, and act as the technical point of contact for complex data inquiries, translating business needs into precise technical deliverables.

Qualifications

• Proficiency in Snowflake SQL and Python for data workflows.
• Experience automating data tasks and ticket resolutions.
• Familiarity with cloud environments (Snowflake/AWS).
• Ability to audit and optimize existing codebase.

Responsibilities

• Snowflake SQL Development: write, debug, optimize complex SQL scripts.
• Codebase Auditing: review Python and SQL code to troubleshoot and improve.
• Support Automation: develop Python scripts to automate recurring tickets.
• Cloud Data Operations: profiling and validation in Snowflake and AWS.
• Request Fulfillment: act as technical point of contact for data inquiries.

Skills

Snowflake SQL

Python

Tools

Snowflake

AWS

Job description

Hybrid for 3 days onsite and 2 days remote
The Data Analyst is responsible for the technical analysis, automation, and fulfillment 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 for not only writing new scripts to automate ticket resolutions but also for auditing, understanding, and optimizing 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, andoptimizecomplex 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 totroubleshooterrors, 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.