Senior Associate, Data Engineer, Amazon Web Service (AWS)

at  Publicis Sapient

New York, NY 10014, USA -

Start DateExpiry DateSalaryPosted OnExperienceSkillsTelecommuteSponsor Visa
Immediate02 Jun, 2024USD 154000 Annual03 Mar, 2024N/AData Modeling,Python,Spark,Data Validation,Code Review,Database Systems,Continuous Integration,Mysql,Oracle,Sql,Computer Science,Sql Server,Java,Javascript,Optimization,Platform Design,Scala,Dbt,Implementation ExperienceNoNo
Required Visa Status:
CitizenGC
US CitizenStudent Visa
H1BCPT
OPTH4 Spouse of H1B
GC Green Card
Employment Type:
Full TimePart Time
PermanentIndependent - 1099
Contract – W2C2H Independent
C2H W2Contract – Corp 2 Corp
Contract to Hire – Corp 2 Corp

Description:

Your Daily Duties & Impact:

  • Combine your technical expertise and problem-solving passion to work closely with clients, turning complex ideas into end-to-end solutions that transform our clients’ business
  • Lead, design, develop and deliver large-scale data systems, data processing and data transformation projects that delivers business value for clients
  • Automate data platform operations and manage the post-production system and processes
  • Conduct technical feasibility assessments and provide project estimates for the design and development of the solution
  • Provide technical inputs to agile processes, such as epic, story, and task definition to resolve issues and remove barriers throughout the lifecycle of client engagements
  • Creation and maintenance of infrastructure-as-code for cloud, on-prem, and hybrid environments using tools such as Terraform, CloudFormation, Azure Resource Manager, Helm, and Google Cloud Deployment Manager
  • Mentor, help and grow junior team members

QUALIFICATIONS

Your Technical Skills & Experience:

  • Demonstrable experience in data platforms involving implementation of end to end data pipelines
  • Hands-on experience with Amazon Web Services Cloud Platform
  • Implementation experience with column-oriented database technologies (i.e., Redshift, Vertica), NoSQL database technologies (i.e., DynamoDB, Cosmos DB, etc.) and traditional database systems (i.e., SQL Server, Oracle, MySQL)
  • Experience in implementing data pipelines for both streaming and batch integrations using tools/frameworks like Glue ETL, Lambda, Spark, Spark Streaming, etc.
  • Ability to handle module or track level responsibilities and contributing to tasks hands-on
  • Experience in data modeling, warehouse design and fact/dimension implementations
  • Experience working with code repositories and continuous integration
  • Data modeling, querying, and optimization for relational, NoSQL, timeseries, and graph databases and data warehouses and data lakes
  • Data processing programming using SQL, DBT, Python, and similar tools
  • Logical programming in Python, Spark, PySpark, Java, Javascript, and/or Scala
  • Data ingest, validation, and enrichment pipeline design and implementation
  • Cloud-native data platform design with a focus on streaming and event-driven architectures
  • Test programming using automated testing frameworks, data validation and quality frameworks, and data lineage frameworks
  • Metadata definition and management via data catalogs, service catalogs, and stewardship tools such as AWS Glue Catalog, OpenMetadata, DataHub, Alation, and similar
  • Code review and mentorship
  • Bachelor’s degree in Computer Science, Engineering or related field.

COMPANY DESCRIPTION

Publicis Sapient is a digital transformation partner helping established organizations get to their future, digitally-enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value

Responsibilities:

  • Combine your technical expertise and problem-solving passion to work closely with clients, turning complex ideas into end-to-end solutions that transform our clients’ business
  • Lead, design, develop and deliver large-scale data systems, data processing and data transformation projects that delivers business value for clients
  • Automate data platform operations and manage the post-production system and processes
  • Conduct technical feasibility assessments and provide project estimates for the design and development of the solution
  • Provide technical inputs to agile processes, such as epic, story, and task definition to resolve issues and remove barriers throughout the lifecycle of client engagements
  • Creation and maintenance of infrastructure-as-code for cloud, on-prem, and hybrid environments using tools such as Terraform, CloudFormation, Azure Resource Manager, Helm, and Google Cloud Deployment Manager
  • Mentor, help and grow junior team member


REQUIREMENT SUMMARY

Min:N/AMax:5.0 year(s)

Information Technology/IT

IT Software - DBA / Datawarehousing

Software Engineering

Graduate

Computer science engineering or related field

Proficient

1

New York, NY 10014, USA