Data Integration & Analytics Specialist for Global Ecommerce

Riskified; New York, Northern (NY, KY); Hybrid; USD 125,000 - 139,000; Full time

Benefits offered by this job

Medical insurance

Stock options

401(k) + matching

Commuter benefits

Catered lunch

Fully stocked kitchen

Team events

Wellness classes

Volunteer opportunities

Udemy access

Job summary

Riskified is seeking a Data Integration Analyst to ensure accurate client data feeds for our AI-powered fraud and risk platform. You will manage the merchant data configuration, design tailored onboarding solutions, and validate data across API and file transfers.

You will also generate data templates and write validation scripts in Python/SQL to maintain data quality in sandbox and production environments.

Qualifications

• 4+ years of experience in a data-centric industry role (Analytics, Data Engineering, ETL, DBA, Consulting, etc.)
• Solid expertise with SQL or NoSQL databases
• Experience with data wrangling (Python, R for data processing)
• Experience optimizing technical processes
• Strong analytical skills and attention to detail
• Strong verbal and written communication skills
• Advantage: experience in designing, constructing, and maintaining efficient data pipelines using DBT or Python

Responsibilities

• Maintain/manage merchant data configuration layer of Riskified’s platform (automated data tagging, transformation, filtering, etc.)
• Combine technical, business, and analytical objectives to come up with tailored solutions for onboarding merchants
• Perform due diligence on merchant websites, business models, and data flows
• Generate tailored data templates (JSON, CSV) to help guide merchant developers/data teams in building high-quality online (API) and offline (file transfer) integrations
• Write queries and scripts using Python, SQL, Spark, Databricks, or R to test, validate, and detect data issues in API calls within both sandbox and production environments. Additionally, transform and upload large historical data files to Riskified APIs
• Ad hoc data wrangling and sanitization
• Monitor automated data alerts - prioritize, track, and communicate merchant data issues/irregularities with internal and external stakeholders
• Work closely with analysts, research, and data science teams to accommodate changes in industry data
• Identify, research, and offer system-wide solutions for common data issues
• Work closely with client-facing teams to engage customers regarding their data integrations
• Support R&D, Product Management, Data Science, Integrations Engineering, Account Management, and Sales as a subject matter expert of Riskified’s product, technology, and merchants

Job description

Riskified is seeking a Data Integration Analyst to ensure accurate client data feeds for our AI-powered fraud and risk platform. You will manage the merchant data configuration, design tailored onboarding solutions, and validate data across API and file transfers.

You will also generate data templates and write validation scripts in Python/SQL to maintain data quality in sandbox and production environments.