Senior Manager, Data Architect
Chicago, IL

Job 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. As digital pioneers with 20,000 people and 53 offices around the globe, our experience spanning technology, data sciences, consulting and customer obsession - combined with our culture of curiosity and relentlessness - enables us to accelerate our clients' businesses through designing the products and services their customers truly value. Publicis Sapient is the digital business transformation hub of Publicis Groupe. For more information, visit publicissapient.com.

Position Summary: The Sr. Data Architect will collaborate within a team of technologists to produce enterprise scale solutions for our clients' needs. Our teams work on the latest data technologies in the Cloud space including BigQuery, Redshift, Spark, etc. This position will be focused on building out a data warehouse, data integration, or machine learning automation projects in various cloud environments.

Responsibilities:

* Be the primary liaison between clients, vendors and Publicis Sapient teams to drive data integration requirements to help realize customer data platform and campaign rollout initiatives.
* Define and build the ETL and data pipelines to enable faster, better, data-informed decision-making within the business
* Transform data into actionable information and convert analytical results into a format that is easy to draw insights from and to share with colleagues and peers.
* Implement solutions to enable a stable architecture for capturing robust data sets
* Responsible for the maintenance, improvement, cleaning, and manipulation of data in the customer data platform and analytics databases
* Work with data analytics teams, data scientists, and software engineers in order to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any issues
* Participate in integrated test sessions of components and subsystems on test and production servers
* Develop and present solutions and recommendations to clients and internal teams
* Use information gained through prior experience, knowledge sharing with other Technology Associates, education and training to resolve issues and remove project barriers
* Deliver quality work on defined tasks with little oversight and direction
* Ensure all deliverables are of high quality throughout the project by adhering to coding standards, best practices and participating in code reviews
* Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed

Requirements:

* BS in Computer Science or equivalent education/professional experience is required.
* 5-7+ years in a data-engineering role with demonstrated experience in data integration and data warehouse projects.
* Experience architecting and building data warehouses, customer profile databases, data marts, etc.
* Experience in data integration projects and automation via ETL Tools (i.e. Talend, Informatica, SSIS, etc.).
* Experience in Hadoop (Hive, Spark, Impala, etc.) ecosystem
* GCP and DE Certified with knowledge of Apache Bream and programming languages including Java and Python
* Google cloud product knowledge (BigQuery, Dataflow, Dataproc, Datastore, Bigtable, Pub/Sub, Transfer Service, GCP Storage, SQL)
* Experience with MPP systems (Google Big Query, AWS Redshift, Azure Datawarehouse)
* Experience with data modeling, warehouse design, and fact/dimension concepts
* Experience working with different query languages (i.e. T-SQL, PostgreSQL, PL-SQL)
* Experience working with code repositories and continuous integration (i.e. Git, Jenkins, etc.)
* Understanding of development and project methodologies
* Ability to work collaboratively in teams with other specialized individuals
* Able to work in a fast-paced, technical environment
* Good verbal and written communication skills

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. As digital pioneers with 20,000 people and 53 offices around the globe, our experience spanning technology, data sciences, consulting and customer obsession - combined with our culture of curiosity and relentlessness - enables us to accelerate our clients' businesses through designing the products and services their customers truly value. Publicis Sapient is the digital business transformation hub of Publicis Groupe. For more information, visit publicissapient.com.

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@publicissapient.com or you may call us at +1-617-621-0200.

Apply Now