New Requirement (contracting 4- 5 months )
Vendor Rate - around $75 per hr
Location - Greenwich , CT (Hybrid)
Role Overview:
The resource will be responsible for supporting the end-to-end preparation of Form PF filings, with a strong emphasis on data handling, transformation, and validation.
Key Responsibilities:
-
Extract, parse, and transform large datasets from multiple Excel sources and other structured/unstructured inputs.
-
Design and implement robust data pipelines using Python for cleaning, transformation, and validation of data.
-
Write and optimize complex SQL queries to aggregate, reconcile, and validate data across systems.
-
Map and populate processed data accurately into Form PF templates in accordance with SEC reporting requirements.
-
Perform data quality checks and ensure consistency, completeness, and auditability of all reported figures.
-
Collaborate with stakeholders to understand data definitions, resolve discrepancies, and ensure timely submission.
Required Skills:
-
Very strong proficiency in SQL (complex joins, aggregations, performance tuning) - MUST HAVE
-
Good Python skills (pandas, data transformation, automation workflows)
- Extensive experience working with Excel-based data ingestion and transformation.
-
Familiarity with regulatory reporting workflows (preferably Form PF / SEC reporting) is a strong plus.
-
Ability to work under tight timelines and deliver high-quality outputs with minimal supervision.
Duration:
4–5 months (high urgency, immediate start preferred)