SONJ- Data Analyst- 810300

Goodfit; Trenton (NJ); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Goodfit in the United States is seeking a Data Analyst to provide technical analysis, automation, and fulfillment of data requests. Proficiency in Snowflake SQL and Python is required, with cloud experience in Snowflake/AWS. The role offers a hybrid schedule: three days onsite and two days remote in New Jersey.

The analyst will write scripts to automate ticket resolutions, audit and optimize existing code, and perform deep-dive profiling to support modernization initiatives for the NJDOE context.

Qualifications

• Proficiency in Snowflake SQL and Python required.
• Write, debug, and optimize SQL scripts in Snowflake for ad-hoc data requests.
• Audit Python and SQL code to troubleshoot issues and improve automation logic.
• Develop Python-based automations to reduce manual ticket work.
• Perform data profiling/validation in Snowflake and AWS.

Responsibilities

• Write, debug, and optimize Snowflake SQL scripts to fulfill ad-hoc data requests.
• Audit Python and SQL code to troubleshoot issues and improve logic.
• Develop Python-based automations to reduce manual ticket work.
• Perform data profiling and validation in Snowflake and AWS.
• Serve as technical contact for complex data inquiries and deliver precise technical outputs.

Skills

Snowflake SQL

Python (Automation)

Code review

Data analysis

Automation scripting

Communication skills

AWS Cloud

Job description

Job DescriptionData Analyst provides technical analysis, automation, & fulfillment of data requests. Proficiency in Snowflake, SQL and Pythonrequired. Execute complex data requests, perform deep-dive profiling, & resolve data discrepancies tosupport NJDOE.

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.

SkillRequired /DesiredAmount of Experience

• Snowflake SQL (Scripting & Optimization)Required3YearsPython Programming (Data/Automation)Required3YearsCode Review & InterpretationRequired3YearsData Analysis & ProfilingRequired3YearsAutomated Scripting for Ticket ResolutionRequired3YearsExcellent Communication SkillsRequired3YearsCloud Data Warehouse (AWS)Desired3Year