Data Analyst

vTech Solution; Trenton (NJ); Hybrid; USD 90,000 - 120,000; Full time

Job summary

vTech Solution in Trenton, NJ is seeking a Data Analyst for a 11-month contract to deliver technical analysis, automation, and fulfillment of complex data requests. Proficiency in Snowflake, SQL and Python is required to manage data workflows across Cloud environments.

The analyst will write and optimize scripts to automate recurring tasks, audit and improve existing code, and ensure data integrity within Snowflake and AWS as part of Project Nexus modernization initiatives.

Qualifications

• Proficient in Snowflake SQL and Python for data workflows.
• Ability to audit and optimize existing Python/SQL code.
• Experience with data profiling and validation.
• Experience automating ticket resolutions.
• Strong communication skills for cross-team collaboration.
• Familiarity with AWS cloud environment.

Responsibilities

• Snowflake SQL Development: Write, debug, and optimize SQL scripts within Snowflake to fulfill ad-hoc data requests.
• Codebase Auditing: Review Python/SQL code to troubleshoot errors and suggest improvements.
• Support Automation: Develop Python-based scripts to automate recurring data tasks.
• Cloud Data Operations: Profile and validate data in Snowflake and AWS for data integrity.
• Request Fulfillment: Serve as technical contact translating business requirements into deliverables.

Skills

Snowflake SQL

Python Programming

Code Review

Data Analysis

Automated Scripting

Communication Skills

Tools

AWS

Job description

Job Title: Data Analyst

Location: Trenton, NJ

Job Type: Contract 11 Months (Possibility of extension)

Interview: Both Web Cam and In Person Interview

Work Mode: Hybrid for 3 days onsite and 2 days remote

Short 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 client.

Complete Description:

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

Required skills:

• Snowflake SQL (Scripting & Optimization)
• Python Programming (Data/Automation)
• Code Review & Interpretation
• Data Analysis & Profiling
• Automated Scripting for Ticket Resolution
• Excellent Communication Skills

Desired Skills:

• Cloud Data Warehouse (AWS)