Data Analyst

HireITPeople; Trenton (NJ); On-site; USD 85,000 - 125,000; Full time

Job summary

HireITPeople seeks a Data Analyst to perform technical analysis, automation, and fulfillment of data requests within our enterprise data environment. The role requires hands-on work with Snowflake, SQL, and Python to develop reliable data workflows in a cloud setting (Snowflake/AWS) and to support modernization efforts.

The analyst will translate business requirements into precise technical deliverables, write scripts to automate ticket resolutions, audit existing code, and ensure data integrity

Qualifications

• Proficiency in Snowflake, SQL and Python required.
• Experience with cloud data platforms (Snowflake/AWS) preferred.
• Ability to execute complex data requests and automate tasks.

Responsibilities

• Provide technical analysis, automation, and fulfillment of data requests.
• Write and optimize scripts to automate recurring tasks and ticket resolution.
• Profile data, validate quality, and troubleshoot data discrepancies in Snowflake/AWS.

Skills

SQL

Python

Tools

Snowflake

AWS

Job description

Local candidates preferred for onsite work.

Please make sure the LinkedIn is included on the candidates resume.

JOB DESCRIPTION

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

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, 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 totrouble shoot 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.