Log in
  • Home
  • Lead Data Analyst/Architect Post

Lead Data Analyst / Architect

Gap Inc is looking for a highly motivated Data Analyst with a focused background in SQL and data profiling/cleansing/modeling.   You will have the opportunity to be part of a creative team responsible for building a Logistics data-platform supporting our Omni-channel business, seamless inventory management and PRODUCT 3.0 company initiatives. As a Data Analyst, you will design, and build enterprise class Business Intelligence Data Solutions. Your success will be measured on your ability to rapidly develop a keen understanding of Gap’s Information data architecture while working closely with other architecture and development teams to build world-class solutions. 


  1. Ability to translate business needs into functional capabilities and data requirements.
  2. Participate in project inception phase; identifies and evaluates data sources needed to meet business and project requirements.
  3. Understands functional business systems, data integration, business process requirements and analyzes data impacts
  4. Analytical skills including the ability to visualize, articulate and solve complex problems and concepts, and make decisions that make sense based on business requirements as it pertains to data within the analytics domain.
  5. Create/update/design logical data model enhancements that ensure the business requirements fit into the Gap Retail Logical Data Model (GRLDM).
  6. Creation of first-cut Physical Data Model.
  7. Consult on, review and approve data-specific portions of the project functional design stories.
  8. Responsible for adhering to Gap modeling standards and ensuring that the standards are applied across all logical and physical data models.
  9. Facilitates and drives independently, coordinates, and leads data analysis to validate and further refine requirements.
  10. Identifying and evaluating data sources and metrics, assessing current data sources and sourcing feasibility needed to meet project requirements.
  11. Consult on, review and approve source to target field-level logical data mappings and transformations.
  12. Participates in technical design walkthroughs, as required.  
  13. Anticipates data integrity issues (via data profiling) and provides the information to solutions architect and development team for data integrity improvement/quality resolution.
  14. Estimates DA resource (personnel) needs for projects.
  15. Consults on test cases, as required.
  16. Facilitates discussion with DBA team to ensure physical implementation meets business requirements
  17. Working knowledge data modeling tools and methodologies.
  18. General to advanced data mining, profiling, and querying skills (using a variety of tools) to perform required data research and analysis.
  19. Must be self-motivated, detail oriented and able to multi-task.
  20. Must be comfortable in a fast-paced, demanding and dynamic work environment.
  21. Analyst with hands-on experience in managing results, follow-through, managing schedule, overcoming obstacles to achieve outcomes.


  1. BS/BA in Business Admin Computer Science, Engineering, Information Systems and/or equivalent formal training or experience.
  2. Generally has 7+ years of experience in Information Technology, Business Intelligence, Data Analysis, Data Warehousing and Data Modeling.

Database Knowledge:

  1.   Optional:   Teradata or Oracle
  2.   Optional alternatives: Hadoop(HIVE), MySQL, DB2, Postgres, SqlServer


  1.   Erwin (or other data modeling tool)
  2.  Toad
  3.  SqlDelevolper
  4.  Teradata SQL Assist
  5.   Altova XmlSpy; JSON

Functional Domain Knowledge:

  1. Logistics
  2. BI/Analytics
  3.  Retail
  4. Supply Chain
  5.   Finance
  6.   Warehousing/Transportation

Copyright © 2019-20 SF DAMA. All rights reserved.

Powered by Wild Apricot Membership Software