[Hiring] AWS ETL Data Engineer @NTT DATA Services

Role Description

We are currently seeking a AWS ETL Data Engineer - REMOTE to join our team in Halifax, Nova Scotia (CA-NS), Canada (CA). We are seeking an experienced technical resource who could design, develop, support, and enhance enterprise data platforms while ensuring compliance with privacy and data governance requirements. The role combines data engineering, systems integration, analytics, solution design, and operational support.

• Design, develop, and maintain scalable data pipelines using Spark (Scala/Python), AWS Glue, AWS Lambda, and Shell scripting.
• Build and support ETL/ELT processes across AWS platforms, including S3, Hive, Apache Iceberg, and Amazon Redshift.
• Develop and maintain Redshift SQL/PLSQL code, stored procedures, and data-processing frameworks.
• Perform query tuning, performance optimization, and data-sharing implementations.
• Support ingestion and processing of structured and semi-structured data formats including JSON, CSV, XML, ORC, Parquet, and Avro.
• Design, enhance, and support solutions that provide a unified view of customer data across systems.
• Integrate multiple data sources, applications, and business processes to support reporting, analytics, and customer engagement initiatives.
• Collaborate with business and technical teams to define and implement scalable data solutions.
• Manage and support Data Subject Requests (DSRs), including customer data erasure requests.
• Work closely with the DPO team to ensure compliance with privacy regulations and internal policies.
• Maintain and support the MicroStrategy Privacy Compliance module. (Very infrequent once in year or 2 years)
• Contribute to data governance initiatives that improve data quality, consistency, and compliance.
• Analyze and troubleshoot complex data issues using Redshift SQL, MySQL, Python/PySpark, Shell scripting, and Excel.
• Investigate data mismatches, reporting issues, and business data anomalies.
• Support business analysis related to customer tiers, loyalty programs, and email marketability.
• Provide production support and root-cause analysis for critical data platform issues.

Technical Leadership & Collaboration

• Participate in Customer 360, Privacy, Data Governance, and Phaedon initiatives.
• Conduct code reviews and design reviews.
• Provide cross-team technical support and problem resolution.
• Research, design, and develop next-generation data capabilities and products.
• Act as a subject matter expert for customer data platforms.

Primary Technologies

• AWS: S3, EC2, Redshift (RA3/Serverless), S3 Tables, S3 Hive, AWS Glue, Lambda (Python), Kafka, Airflow, Apache Iceberg
• Spark (Scala/Python)
• Redshift SQL/PLSQL, MySQL
• Data Modeling and Query Optimization

Qualifications

• 10+ years of experience in Data Warehouse / Big Data ecosystems.
• 5+ years in a lead / SME role.
• 5+ years with AWS architecture and data engineering, including S3, EC2, Redshift (RA3/Serverless), S3 Tables, S3 Hive, AWS Glue, Lambda (Python), Kafka, Airflow, Apache Iceberg.
• 3+ years with Spark (Scala/Python).
• 5+ years with SQL/PLSQL, MySQL.
• 5+ years strong understanding of:
  • Data architecture & dimensional modeling
  • ETL/ELT frameworks
  • Distributed data processing
  • Cloud data platforms
  • Data governance and security

Preferred Skills

• Experience managing large-scale enterprise data environments.
• Proven track record of delivering complex data programs.
• Excellent communication and stakeholder management abilities.
• Experience in large enterprise or global delivery environments.
• Exposure to data modernization and cloud transformation programs.
• Certifications in cloud platforms or data engineering.
• Experience in regulated industries (Hospitality, Finance, Healthcare, Telecom, etc.).

Benefits

• Starting pay range for this remote role is $86,212 - $133,100 Canadian.
• This position may also be eligible for incentive compensation based on individual and/or company performance.
• This position is eligible for the Company’s comprehensive benefits program in Canada, including customizable health and dental coverage with telemedicine, wellness credits, and gym discounts.
• Employees receive income protection through life, disability, and optional insurance plans, plus access to a 24/7 Employee Assistance Program.
• Additional perks include retirement savings, a remote work allowance for eligible employees, and various discounts and travel insurance.