Sr Data Analyst - SQL

Apptad Inc; Massachusetts; On-site; USD 90,000 - 130,000; Full time

Job summary

Apptad Inc. is seeking an experienced SQL / Data Analyst in Boston, MA, to join our financial services technology team. The role focuses on SQL development, data modeling, data quality validation, and Unix/Linux scripting, with collaboration across business and technical stakeholders.

You will work with Sybase, PostgreSQL, and SQL Server, write efficient queries, validate data integrity, and participate in Agile/Scrum ceremonies to deliver reliable data solutions.

Qualifications

• 7+ years of financial services technology experience.
• Hands-on SQL development and data modeling.
• Experience with Unix/Linux scripting and Python.
• Excellent written and verbal communication, and stakeholder collaboration.

Responsibilities

• Develop, execute, and optimize SQL queries for data analysis.
• Work with relational databases (Sybase, PostgreSQL, SQL Server).
• Analyze financial services data and investigate data quality issues.
• Perform data modeling and support database development.
• Use Unix/Linux shell scripting, Bash, and Python for data processing.
• Analyze API requests/responses using APIs, Swagger/OpenAPI, JSON.
• Define, validate, and implement data quality rules and controls.
• Gather business requirements and translate into technical solutions.
• Follow software development best practices and participate in Agile/Scrum ceremonies.

Skills

SQL development

Data analysis

Financial services knowledge

Unix/Linux scripting

Communication

Stakeholder collaboration

Tools

Sybase

PostgreSQL

SQL Server

PL/SQL

Python

Bash

Job description

SQL / Data Analyst

Location: Boston, MA

Job Summary

We are looking for an experienced SQL / Data Analyst with a strong background in financial services technology, relational databases, and data analysis. The ideal candidate will have hands-on experience with SQL development, data modeling, data quality validation, and Unix/Linux scripting, along with the ability to collaborate with business and technical stakeholders.

Key Responsibilities

• Develop, execute, and optimize SQL queries for data analysis, validation, and troubleshooting.
• Work with relational databases, including Sybase, PostgreSQL, and SQL Server.
• Analyze financial services data and investigate data discrepancies and quality issues.
• Perform data modeling and support database-related development activities.
• Use Unix/Linux shell scripting, Bash, and Python for data processing and automation.
• Analyze API requests and responses using APIs, Swagger/OpenAPI, and JSON data structures.
• Define, validate, and implement data quality rules and controls.
• Gather business requirements and collaborate with stakeholders to translate them into technical solutions.
• Follow software development best practices and participate in Agile/Scrum ceremonies.

Required Skills and Qualifications

• At least 7 years of financial services technology experience, with knowledge of financial services data.
• Hands-on experience with relational databases and SQL development, including Sybase and PostgreSQL.
• Strong SQL query-writing, analytical, and troubleshooting skills.
• Solid understanding of relational database concepts and data modeling.
• Working knowledge of Unix/Linux shell scripting, Bash, and/or Python.
• Excellent verbal and written communication skills.
• Ability to work collaboratively with business and technical teams.

Desired Skills

• Strong business analysis, requirements gathering, and stakeholder management experience.
• Experience with Sybase, SQL Server, PostgreSQL, and PL/SQL.
• Familiarity with APIs and Swagger/OpenAPI for data analysis and validation.
• Experience with data quality rules, data validation, and implementation.
• Knowledge of JSON processing and parsing API responses.
• Understanding of software design patterns and development best practices.
• Experience working in Agile environments, preferably Scrum.