Offer summary

Qualifications:

8 to 10 years of data experience, 8+ years of complex SQL query writing and optimization, 3+ years of experience with Python, R, or similar analytical programming languages, Proficiency in ETL tools like Informatica and Alteryx..

Key responsibilities:

Provide data wrangling services for structured and unstructured data

Design and model analytical methods and validate data models

Research and troubleshoot complex business and technical problems

Query and join multiple tables in SQL databases to support analytics.

Job description

This is a remote position.

Provide data wrangling services to make data (structured and unstructured), by transformations, normalization, and data mapping, consumable for a variety of downstream purposes such as applications, visualizations, and analytics
Design and model analytical methods based on the statistical methods. Validate, test, and deploy data models and analytical products/tools
Research, troubleshoot and recommend solutions to complex business and technical problems. Prepare and communicate through effective presentations and written communications
Work with large data sets and identify patterns, anomalies, and propose steps for remedial actions
Query and join multiple tables in SQL databases to provide data needed to support analytics and/or process improvement

Requirements

8 to 10 total years of data experience
8+ years writing complex SQL queries and performing query optimization.
3+ years of related, hands-on experience with Python, R or similar analytical programming language
3+ years’ experience in a trade-related, technology position at a financial institution
Demonstrably proficient in ETL tools such as Informatica and Alteryx
Knowledgeable with Jira and agile methodologies
Experience developing data models and analytical products for financial services firms