Generates data models for the team using firmwide approaches, linear algebra, statistical and geometrical algorithms
Implements database back-up, recovery, and archiving strategy
Evaluates and reports on access control processes to determine effectiveness of data asset security with minimal supervision
Applies reuse-first, AI-assisted practices within delivery and operational routines (e.g., backup/recovery validation and access control review support), ensuring traceability/auditability and alignment to resiliency and security expectations.
Required qualifications, capabilities, and skills
Formal training or certification on data engineering concepts and 5+ years applied experience
Design & build data pipelines (DPL): Own the architecture and implementation of robust batch and event-driven pipelines using PySpark on AWS (ingestion, transformation, publishing, SLAs).
AWS services implementation: Hands-on delivery using AWS services such as:
S3 (data lake design, partitioning, lifecycle)
Athena (query patterns, optimization, metadata integration)
Step Functions (workflow orchestration, retries, error handling)
Airflow (DAG design, scheduling, backfills, dependency management)
EventBridge (event triggers, routing, integrations)
RDS (source integrations, extraction patterns, performance considerations)
Supporting services (IAM, CloudWatch, KMS, networking) as needed
Snowflake engineering: Build curated layers and data products in Snowflake (loading patterns, data modeling, performance/cost tuning, access controls).
Operational excellence: Implement monitoring, alerting, logging, runbooks, and on-call-ready practices; lead root-cause analysis and remediation for pipeline incidents.
Data quality & governance: Embed data validation checks, schema/versioning discipline, metadata/lineage readiness, and secure handling of sensitive data.
Engineering standards: Drive best practices for code quality, testing, CI/CD, documentation, and reusable pipeline frameworks/patterns.
AI automations: Apply Copilot/LLM-based techniques to accelerate delivery (e.g., code scaffolding, test generation, documentation/runbook automation, operational assistants) with appropriate controls.
Demonstrated experience using enterprise-authorized AI capabilities within the work environment to support data engineering workflows with strong validation habits and awareness of data sensitivity.
Ability to review and validate AI-assisted outputs (e.g., model/design summaries or operational checklists) before use, escalating when uncertain and following data handling requirements.