What are the responsibilities and job description for the Data Analyst position at TECHProjects?
Greetings!!!
Welcome to TechProjects! We specialize in IT System integration to help with some of the biggest names in the public sectors around New York state. Our company provides exceptional IT solutions for our clients, while also offering top-notch career opportunities for our employees.
At our firm, we work with a diverse range of clients, from cutting-edge startups to established industry leaders.
If you're a tech professional looking for a challenging and rewarding career, we'd love to hear from you. Our company offers competitive salaries, comprehensive benefits packages, and a range of professional development opportunities. Whether you're a seasoned veteran or just starting out in your career, we have a role that's perfect for you.
Thank you for considering our company as your potential employer. We look forward to hearing from you and discussing the exciting opportunities that await you at our firm.
Job Title: Data Analyst
Location: Trenton, NJ (Hybrid)
Duration: Long term
Interview mode: F2F
Job Summary
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.
Key Responsibilities
- 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
Skill | Comments | Years of Experience |
Snowflake SQL (Scripting & Optimization) | Required | 3 |
Python Programming (Data/Automation) | Required | 3 |
Code Review & Interpretation | Required | 3 |
Data Analysis & Profiling | Required | 3 |
Automated Scripting for Ticket Resolution | Required | 3 |
Excellent Communication Skills | Required | 3 |
Cloud Data Warehouse (AWS) | Desired | 3 |