Data Analyst

Software Technology Inc.; New Jersey; Hybrid; USD 70,000 - 100,000; Full time

Job summary

Software Technology Inc. in New Jersey seeks a Data Analyst to provide technical analysis, automate data requests, and ensure data quality within Snowflake/AWS environments. The role emphasizes building and optimizing data workflows and automations.

You will write and refine SQL scripts, audit existing Python code, and implement end-to-end solutions to support modernization initiatives. Hybrid work arrangement applies.

Qualifications

• Proficiency in Snowflake SQL and Python required.
• Experience with SQL scripting and data profiling.
• Ability to automate data tasks and resolve data discrepancies.

Responsibilities

• Provide technical analysis, automation, and fulfillment of enterprise data requests.
• Write, debug, and optimize SQL scripts within Snowflake to meet ad hoc requests.
• Audit and optimize existing Python/SQL code for new automations and reliability.
• Develop Python-based scripts to automate recurring data tasks and tickets.
• Perform data profiling and validation in Snowflake and AWS to ensure data integrity.

Tools

Snowflake

SQL

Python

Job description

Location:100 Riverview Plaza(Hybrid for 3 days onsite and 2 days remote )

Interview Type: Both iLinc Web Cam and In Person Interview

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

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.