Senior Associate Data Engineer, AWS Cloud - Los Angeles - hybrid in office 3 days per week
Role summary
Publicis Sapient is seeking a Senior Associate Data Engineer with AWS Cloud expertise in Los Angeles. This hybrid role involves designing, developing, and maintaining scalable Big Data solutions, working with large datasets and real-time processing frameworks on AWS. Responsibilities include leading data system development, automating platform operations, conducting feasibility assessments, and contributing to agile processes. The role requires hands-on experience with data pipelines, AWS services, various database technologies (column-oriented, NoSQL, traditional), data modeling, and infrastructure-as-code tools like Terraform. Proficiency in Python, SQL, and data processing platforms like Spark and Databricks is essential. The position also involves mentoring junior team members and implementing automated testing and data lineage frameworks.
Job Description
Senior Associate, AWS Data Engineering - Los Angeles 3 x per week.
As a Senior Associate Data Engineer, you will be responsible for designing, developing, and maintaining scalable Big Data solutions. You will work with large datasets, real-time processing frameworks, and AWS cloud-based data platforms to enable data-driven decision-making for our clients.
Your 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
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, pyspark,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.
- Experience with data processing platforms such as Databricks
- 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
Additional Information
Pay Range: $103,000 - $145,000
The range shown represents a grouping of relevant ranges currently in use at Publicis Sapient. Actual range for this position may differ, depending on location and specific skillset required for the work itself.
- An inclusive workplace that promotes diversity and collaboration.
- Access to ongoing learning and development opportunities.
- Competitive compensation and benefits package.
- Flexibility to support work-life balance.
- Comprehensive health benefits for you and your family.
- Generous paid leave and holidays.
- Wellness program and employee assistance.
As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at hiring@publicis.sapient.com
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.
Sample Publicis Sapient interview questions
- 1
Maximum Depth of an N-ary Tree Find the maximum depth of an N-ary tree. Input: root = [1,null,2,null,3,null,4] Output: 4 Explanation: The tree is essentially a straight line, requiring a traversal that reaches a maximum depth of 4 layers.
codingmedium - 2
Encode and Decode Strings Encode a list of strings into a single string and decode it back. Input: strs = ["","hello",""] Output: ["","hello",""] Explanation: Prepends chunk lengths and a delimiter (e.g., "0#5#hello0#") to safely encode and perfectly restore empty strings.
codingmedium - 3
Search for a Word in a 2D Board Search for a word in a 2D board of characters. Input: board = [["C","A","A"],["A","A","A"],["B","C","D"]], word = "AAB" Output: TRUE Explanation: DFS traverses adjacent matching letters perfectly, finding "AAB" without improperly revisiting any cells.
codingmedium - 4
Find the majority element in an array. Given an array of size n, find the majority element. The majority element is the element that appears more than ⌊n / 2⌋ times. You may assume that the majority element always exists in the array. Input: nums = [3, 2, 3] Output: 3 Explanation: The number 3 appears 2 times, which is strictly greater than n/2 (1.5).
codingmedium - 5
Top K Frequent Elements Find the top K frequent elements in an array. Input: nums = [4,4,4,4,5,5,6], k = 1 Output: [4] Explanation: The number 4 appears four times, easily making it the single most frequent element in the data structure.
codingmedium
Sign up for a personalized interview prep pack tailored to this role.