Data Analyst Data Analyst …

Sapient Corporation
in San Francisco, CA, United States
Permanent, Full time
Be the first to apply
Sapient Corporation
in San Francisco, CA, United States
Permanent, Full time
Be the first to apply
Data Analyst
  • or
Senior Data Analyst

Location: San Francisco, California, United States

Type of job: Permanent

Date published: 10-Oct-2019

Domain: AI, Analytics, & Data

Job ID: 63401


The Publicis Sapient Data group is responsible for data driven strategic thinking and insight across multiple financial services-focused engagements. Were working to discover new paths for growth for our clients through rigorous analysis of consumer data

Your Impact:

  • Transform the business data quality and cleansing rules into technical requirements
  • Work closely with Data Architect and Business Analyst
  • Participate in business analysis sessions, capture data flows, create a data dictionary with detailed business description of the taxonomy
  • Identify and resolve potential gaps between source and target data models and designed reconciliation approach as necessary
  • Execute Data Extraction, Data Profiling, and generate reports for the review with ACRE SMEs for potential solutions
  • Own building staging data model and ETL technical processes
  • Work with EzAccess SMEs
  • Work with ACRE DSAs and SMEs

Your Skills & Experience:

  • At least 5 years of experience working on complex data models; experience working in very large databases
  • Strong hands-on SQL and Oracle database understanding (performance tuning, complex joins & union, materialized view, etc.)
  • Background in using ETL tools
  • Understanding of batch jobs
  • Strong client and team interfacing skills
  • Knowledge of tools and process such as GIT, JIRA, Confluence and Agile

Benefits of Working Here:

  • Flexible vacation policy; time is not limited, allocated, or accrued 
  • 15 paid holidays throughout the year
  • Generous parental leave and new parent transition program
  • Tuition reimbursement
  • Corporate gift matching program

Career Level: Senior Associate

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

© 2019 Publicis Sapient. All Rights Reserved.