LCPR_Data_Lake_Architect at PRODAPT NORTH AMERICA INC
Chennai, tamil nadu, India -
Full Time


Start Date

Immediate

Expiry Date

23 Apr, 26

Salary

0.0

Posted On

23 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

AWS, Snowflake, SQL, PostgreSQL, Data Governance, Data Quality, Pipeline Standards, Schema Design, Performance Tuning, Data Modeling, ETL, Data Lake, Incident Triage, Observability, Data Ingestion, Data Transformation

Industry

technology;Information and Internet

Description
Overview ata Lake Architect to stabilize and enhance an existing AWS (Athena) + Snowflake telco data lake, owning end-to-end design improvements across schemas, ontology, and pipeline standards. Responsibilities Own stabilization and enhancement of the existing AWS (Athena) + Snowflake telco data lake. Run discovery/working calls with the incumbent data lake team; drive technical conversations and decisions. Diagnose and fix current issues: broken pipelines, data quality gaps, performance bottlenecks, and model inconsistencies. Define and govern ontology/business definitions, canonical entities, and naming/metadata standards. Design/optimize schemas (Athena tables, partitions, file formats) and Snowflake data models for analytics consumption. Establish pipeline patterns/standards (ingestion, transformation, orchestration, monitoring, retries, rollback). Implement data governance controls (catalog/lineage, access patterns, PII handling, auditability). Improve observability: logging, dashboards, SLAs, and incident triage runbooks. Align stakeholders on target-state architecture, roadmap, and prioritized backlog of fixes/enhancements. Requirements Strong hands-on AWS data lake experience: S3, Athena, Glue (Crawlers/ETL), Lambda, IAM, CloudWatch. Solid Snowflake knowledge: modeling, performance tuning, loading patterns, and cost-aware design. Advanced SQL skills (Athena/Snowflake); able to debug and optimize complex queries. Experience with PostgreSQL (schema design, querying, data extraction/CDC patterns) for source integration. Proven ability to troubleshoot production pipelines/data issues and drive design discussions with existing teams.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities
The Data Lake Architect will stabilize and enhance an existing AWS and Snowflake telco data lake, focusing on design improvements across schemas and pipeline standards. Responsibilities include diagnosing issues, defining governance standards, and aligning stakeholders on architecture.
Loading...