Senior Data Scientist

Role Summary

The Senior Data Engineer / Data Scientist will serve as a hands-on data engineering and analytics specialist responsible for modernizing decades of structured, semi-structured, and document-based data for our client. The role will focus on building secure, traceable, scalable, and AI-ready data assets through robust data pipelines, document processing, data quality, lineage, and governance practices. The ideal candidate will have strong experience designing modern data platforms and ETL/ELT pipelines in AWS environments, along with hands-on expertise in Python, SQL, PostgreSQL, DynamoDB, document processing, OCR, and data-quality management.

Key Responsibilities

* Design, develop, and maintain Bronze, Silver, and Gold layer data pipelines using modern medallion and lakehouse architecture principles. * Ingest and process legacy structured, semi-structured, and unstructured data from multiple sources. * Develop scalable, reproducible, and idempotent ETL/ELT pipelines for large and complex datasets. * Implement data transformation, normalization, validation, cleansing, and quarantine processes. * Maintain comprehensive record-level data lineage from source systems through downstream datasets. * Capture and manage metadata required to support data discovery, traceability, governance, and auditing. * Design and implement relational data structures using PostgreSQL. * Develop appropriate data models and access patterns for DynamoDB and document-oriented data. * Support AWS-based data ingestion, processing, storage, and analytics workflows. * Process scanned permits, certificates, applications, and other document-based records. * Implement OCR and document-intelligence solutions to extract structured information from scanned documents. * Track extracted values back to the originating document, page, and relevant region or location. * Implement field-level confidence scores and validation mechanisms for extracted information. *