Data Analyst - SQL

About the role

This organization is seeking a Data Analyst to support client-facing data acquisition and migration initiatives across a variety of environments. Based in Northfield, NJ, hybrid flexibility, this role involves working with legacy systems to discover, extract, and transform data using tools such as SQL, Python, and reporting platforms. The position operates within a fast-paced professional services environment, collaborating with cross-functional teams throughout different phases of the SDLC.

Responsibilities

• Work with legacy systems to discover, extract, and transform data using SQL, Python, and reporting platforms
• Extract and transform data from structured, semi-structured, and unstructured data sources
• Gather and analyze system requirements for data acquisition initiatives
• Develop scripts and automation processes to streamline data processing
• Collaborate with cross-functional teams to ensure alignment on project goals and deliverables
• Provide direct client interaction and support during data migration and analysis projects

Requirements

• Bachelor’s degree in Computer Science, Business, Accounting, Finance, or related field (or equivalent experience)
• 1–3 years of experience in professional services, client implementations, or data migration projects
• Strong experience with SQL and relational database management systems (e.g., MSSQL, Oracle, MySQL, AS400)
• Experience extracting and transforming data from various data sources
• Ability to gather and analyze system requirements for data acquisition initiatives
• Strong attention to detail, organization, and analytical thinking skills
• Excellent verbal and written communication skills, especially in client-facing environments
• Experience with scripting languages such as Python, Bash, or PowerShell
• Familiarity with process automation and ETL workflows
• Exposure to reporting tools and data visualization platforms
• Knowledge of accounting, finance, payroll, or general business processes
• Experience working within Agile or SDLC-based project environments

Qualifications

• Technical Skills: 40% (SQL & Database Management, Data Extraction & Transformation, Scripting & Automation, Reporting & Analysis Tools)
• Client Interaction & Requirements Gathering: 25%
• Development of Scripts & Automation Processes: 20%
• Collaboration with Team Members Across Projects: 10%
• Documentation & Quality Assurance: 10%

Skills

• SQL & Database Management: 40%
• Data Extraction & Transformation: 30%
• Scripting & Automation (Python/Bash): 20%
• Reporting & Analysis Tools: 10%

Benefits

• Competitive salary: $70,000-$95,000
• Health, dental, and vision insurance
• 401(k) with employer match
• Paid time off and holidays
• Flexible work environment (remote/hybrid options)
• Professional development and training opportunities