Senior Data Analyst

SFE; Boston (MA); Presencial; USD 99.000 - 121.000; Tempo integral

Resumo da vaga

SFE in Boston, MA is seeking a Senior Data Analyst to join onsite and drive data solutions across technology and business stakeholders.

You will translate data needs into functional specs, analyze data models, and support data sourcing in relational databases with a focus on quality and performance. Strong SQL, Python/Unix scripting, and 7+ years in financial services are expected.

Qualificações

• 7+ years of financial industry technology experience.
• Knowledge of financial services data.
• Hands-on SQL development with Sybase and PostgreSQL.
• Experience with Unix Bash scripting or Python.
• Strong SQL querying skills.
• Excellent verbal and written communication.

Responsabilidades

• Partner with stakeholders to define data solutions and objectives.
• Translate data requirements into specs and user stories.
• Analyze workflows, integrations and data models across platforms.
• Perform data enquiry, analysis and sourcing in relational databases.
• Understand data pipelines and downstream data consumers.
• Use AI-enabled tools to improve data mapping and quality.
• Respond to queries and provide L3 production support as needed.
• Modify data sourcing mechanisms to evolving requirements.

Conhecimentos

SQL development

Relational databases

Unix Bash

Python

Data modeling

Analytical skills

Troubleshooting

Communication

Ferramentas

Sybase

PostgreSQL

SQL Server

PL/SQL

APIs Swagger

Descrição da vaga

Senior Data Analyst

Location: Boston, MA- Onsite
Hire Type: fulltime

$110K/annum + benefits

What you will do:

• Partner with various tech and business stakeholders to review data needs and define solutions with strategic data objectives
• Translate data requirements into functional specifications and user stories.
• Analyze system workflows, integrations and data models across Marketing platforms
• Perform data enquiry, data analysis and data sourcing in Relational database environments
• Develop a thorough understanding of technology systems, data stores, data pipelines, job streams, and downstream data consumers.
• Use AI-enabled tools to accelerate data mapping, data lineage creation, and data profiling, improving turnaround time and overall data quality.
• Respond to queries from business analysts and developers regarding data access, query design, and performance optimization
• Troubleshoot data issues and collaborate with data providers and upstream teams to identify root causes and drive resolution. Provide Level 3 (L3) production support as needed.
• Modify data sourcing mechanism and related programs to implement changes driven by evolving business requirements

What you will bring

• Hands-on experience working with relational databases and SQL development, including Sybase, PostGres.
• Working knowledge of Unix bash scripting and/or Python
• Strong knowledge of relational databases and data modeling
• Strong SQL query-writing skills
• Strong analytical and troubleshooting skills.
• At least 7 years financial industry technology experience and knowledge of financial services data
• Good verbal and written communication skills coupled with a collaborative approach

Desired Skills:

• Strong business analysis, requirements gathering, and stakeholder management skills.
• Hands-on Experience with Database technologies - proficiency in SQL queries and experience with Sybase, SQL Server, PL/SQL, or PostgreSQL.
• Experience with data modeling
• Working with APIs, Swagger for data analysis
• Experience with Linux shell, Unix/Bash, Python
• Experience and understanding of Data Quality Rules and implementation
• JSON processing working with JSON data structures and parsing responses.
• Good understanding of software design patterns and best practices.
• Agile methodologies preferably Scrum.