✦ Luna Orbit — Consulting & Advisory

Compliance Data & Regulatory Reporting Specialist - Dow Jones Indices

at S&P Global

📍 US - NY NYC - 55 WATER ST 40 HRS Unknown 💰 $85K – $100K USD / year Posted April 18, 2026
Apply Now → ← Browse All Jobs

Position Details

Salary $85K – $100K USD / year
Type Full-Time
Experience mid
Exp. Years 3+ years
Education Not specified
Category Consulting & Advisory

About this role

Serve as a compliance-focused data analyst within Business Intelligence, owning end-to-end preparation and delivery of recurring regulatory reports. Translate Legal/Compliance regulatory definitions into structured internal data tags, labels, and SQL logic, and build automated workflows to replace manual reporting.

Key Responsibilities

  • Own end-to-end preparation and delivery of recurring compliance reports
  • Translate regulatory definitions into data tags, labels, and SQL logic
  • Design and build automated workflows to standardize compliance reporting
  • Maintain audit-ready documentation of reporting logic and regulatory mappings
  • Implement data quality checks to ensure consistency and traceability

Technical Overview

You will develop and maintain SQL-based reporting logic and automate compliance reporting workflows using Python and/or R. The role includes aligning data warehouse schemas to compliance use cases, performing compliance-specific data quality checks, and maintaining audit-ready documentation of definitions and regulatory mappings.

Ideal Candidate

The ideal candidate is a mid-level data analyst with 3+ years of experience in compliance reporting or regulatory operations. They are highly proficient in SQL and comfortable using Python or R to automate reporting workflows, while producing audit-ready documentation and strong data quality checks.

Must-Have Skills

3+ years of experience in data analyticscompliance reportingor regulatory operationsStrong technical proficiency in SQLAt least one scripting language (R or Python)comfortable queryingtransformingand validating large datasetsmethodically investigate data discrepancies and drive them to resolution

Required Skills

data analyticscompliance reportingregulatory reportingSQLPythonRaudit-ready documentationdata quality checksautomation workflowsdata warehousing schemasdata taggingSQL logic

Hard Skills

data analyticscompliance reportingregulatory reportingend-to-end report preparation and deliveryregulatory accuracydocumentation of reporting logicSQLdata tagging and labelsSQL logicdata alignmentdata warehousing structures and schemasprocess automationPythonRdata quality checksaudit-ready documentationad-hoc analysisdata discrepancy investigationlarge datasets querying and transformation

Soft Skills

cross-functional communicationstakeholder communicationtranslation for non-technical stakeholdersindependent researchrelationship managementproactive communicationcollaborative partnership with Legal and Compliance

Industry & Role

Industry Fintech
Job Function Deliver accurate, on-time regulatory reporting through SQL-driven, automated, and auditable data pipelines and documentation.
Role Subtype Regulatory Reporting Analyst
Tech Domains SQL / PostgreSQL, Python

Keywords for Your Resume

Compliance Data & Regulatory Reporting SpecialistData AnalystBusiness IntelligenceCompliance reportingregulatory reportingSQLPythonRdata analyticsaudit-ready documentationdata quality checksdata discrepancydata warehousingschemasautomationworkflow automationregulatory mappingsdata tagsdata labelsSQL logiccross-functional communicationLegal and ComplianceBI Developerad-hoc analysis

Deal Breakers

3+ years of experience in data analytics, compliance reporting, or regulatory operations, Strong technical proficiency in SQL, Must have at least one scripting language: R or Python, Must be comfortable querying/transforming/validating large datasets

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile