Senior Associate, Data Engineer

Publicis Sapient is seeking a Data Engineer (Senior Associate L1 and L2) to support our Client in Financial Services sector. Working with the latest data technologies in the industry, you will be instrumental in helping our clients evolve for a more digital future.

Visit our website to learn more about the work we do: https://www.publicissapient.com/

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 deliver business value for clients.

* Automate data platform operations and manage the post-production system and processes and ensure the data quality is accurate for the data.

* 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.

* Ensure that the data marts which are built are cost-effective and performant.

Qualifications: Must have background in Financial Services.

Eligibility criteria:

* Applications are limited to ONLY U.S. Citizens and GC — no OPT and H-1B for this role.

* Preference for NYC based candidates.

* Willing to work hybrid with 3 days per week onsite in office.

* Publicis Sapient office location: 375 Hudson Street, New York 10014, United States

Your Technical Skills & Experience:

* Demonstrable experience leveraging AI to design and build data marts and data platforms involving implementation of end-to-end data pipelines such as Glue ETL, Lambda functions, Spark/ Pyspark and DBT.

* Experience applying AI to optimize data processing, transformation, or analytics workflows.

* Hands-on experience with one or more cloud providers: AWS, Azure, GCP.

* Experience designing, deploying, and operating cloud-native data solutions.

* Implementation experience with NoSQL databases (i.e., DynamoDB, Cosmos DB, etc.) and traditional databases (i.e., SQL Server, Oracle, MySQL)

* Experience in data modeling, warehouse design and building fact and dimension tables.

* Experience with modern data lakes such as Databricks and/or Snowflake and Apache Iceberg.

* Logical programming skills using SQL queries, Python, Spark/ PySpark, Java, JavaScript, and/or Scala.

* Cloud-native data platform design with a focus on streaming data pipelines and event-driven architecture.

* Test programming using automated testing frameworks, data validation and quality frameworks, and data lineage frameworks

* Bachelor’s degree in computer science, Engineering or related field.

Top 5 Must Haves:

* AI‑Driven Data Engineering.

* 4-5yrs of experience on either of the cloud platforms (AWS, Azure, GCP).

* Atleast 2years of experience with data lakes such as Databricks and/or Snowflake.

* NoSQL and SQL.

* Implementing data pipelines.

* Proven experience in data modeling, data warehouse design and fact/dimension implementations.

Additional information:

Annual Pay Range (in USD):

For SAL-1: $110,000 - $130,000

For SAL-2: $130,000 - $150,000

The ranges shown above represent a grouping of relevant ranges currently in use at Publicis Sapient. The actual range for this position may vary based on location and the specific skills required for the role.

Benefits include:

* An inclusive workplace that promotes diversity and collaboration.

* Access to ongoing learning and development opportunities.

* Comprehensive health benefits for you and your family.

* Flexible vacation (not limited, allocated, or accrued).

* Parental leave and new parent transition program.

* Corporate gift matching program.

* Generous paid leave and holidays.

* Wellness program and employee assistance.

Publicis Sapient is committed to fostering an inclusive and diverse workplace and upholds equal employment opportunity for all individuals. Employment decisions are made without regard to race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, religion, or any other protected characteristic.

We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans throughout our recruitment process. If you require assistance or an accommodation due to a disability, please contact us at [email protected] or call +1‑617‑621‑0200.