Description

You will manage data extraction, transformation, and validation for SEC Form PF regulatory reporting.

This role is on-site.

Responsibilities

• Extract, parse, and transform large datasets from Excel sources and structured/unstructured inputs.
• Design and implement data pipelines using Python for cleaning, transformation, and validation.
• Write and optimize complex SQL queries to aggregate, reconcile, and validate data across systems.
• Map processed data into Form PF templates in accordance with SEC reporting requirements.
• Perform data quality checks to ensure consistency, completeness, and auditability.

Required Skills

• Very strong proficiency in SQL, including complex joins, aggregations, and performance tuning.
• Good Python skills with pandas for data transformation and automation workflows.
• Extensive experience working with Excel-based data ingestion and transformation.
• Ability to work under tight timelines and deliver high-quality outputs with minimal supervision.
• 5+ years of working experience.
• Any Graduate education.

Preferred Skills

• Familiarity with regulatory reporting workflows, preferably Form PF or SEC reporting.

Key Skills

Education

Any Gradute