Systems Integration Advisor

Req ID:   387430   NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. 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. Day to Day Responsibilities: 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  Key Strengths Strong ownership and accountability Strong AWS Data Engineering stack awareness Ability to bridge business and technical teams Expertise across engineering, analytics, compliance, architecture, and operational support Adaptability and willingness to take on diverse data-related challenges Minimum Requirements: 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.). #LI-NorthAmerica NTT DATA provides a reasonable range of compensation for Canada-based positions. The starting pay range for this remote role is $86,212 - $133,100 Canadian. This range reflects the minimum and maximum target compensation for the position across all Canada locations. Actual compensation will depend on a number of factors, including the candidate’s actual work location, relevant experience, technical skills, and other qualifications. 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. About NTT DATA NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50