Data Architect (

San Francisco - California

Date Posted: Jun. 23, 2017

Requisition ID: MAC07438

Job Overview:
The Data Architect will be an integral member of the Data Architecture team within Data Services. This is a highly technical and hands-on role with responsibility to develop data strategy, design, implement and support data architecture deliverables for multiple data integration, data management, data warehousing, business intelligence and analytics projects. Able to deliver solid, extensible, highly-available data architecture model and environment that supports the current and future business and technical requirements.  The candidate will demonstrate both business acumen and technological insight through data analysis, logical & physical data modeling, DDL review and consultation. Provide thought leadership and mentorship while evangelizing data architecture methodologies and best practices.
Continually strive to improve data/information systems through pragmatic recommendations of new paradigms and adoption of technologies that enable data discovery, scalable infrastructure and real-time analytics. Integral to these responsibilities will be an ability to balance and coordinate tactical hands-on development against strategic initiatives. This position requires strong collaboration with enterprise architects, data/solution architects, business/system analysts, DBA, product managers, business partners and development teams to define requirements and design appropriate analytical solutions in alignment with organization digital strategy.  Perform other duties as assigned
Essential Functions:
• Participate in enterprise data strategy & collaborate closely with enterprise architects
• Identify and document best practices, standards and architecture guidelines
• Establish/socialize data governance policies within the team
• Specify overall data architecture for all areas and domains including Data Acquisition, Data Integration, ODS, MDM, Data Warehouse, Data Provisioning, ETL, and BI
• Responsible for developing and supporting a data model and architecture that supports and enables the overall strategy of expanded data deliverables, services, process optimization and advanced business intelligence 
• Partner with business subject matter experts, system analysts, data/application architects and development teams to ensure data design is aligned with business strategy and direction
• Deliver solutions in a complex production environment with concurrent considerations such as:
o Phased migration, consolidation and parallel production states of disparate legacy data environments
o Designs, a multi-platform, multi-tenant systems environment, high volume structured and unstructured data ingestion
o Processing from multiple global sources
o Deliver complex and ambiguous business requirements while elevating data architecture to the next level
• Design and develop architecture for data services ecosystem with prime responsibility as Columnar, NoSQL, In-Memory and Big Data technologies
• Contribute to data architecture strategy aligned with technology strategy and portfolio architecture, develop target architecture, and plan the transition from current state to target state
• Understand, document and communicate policies to store and manage metadata and data dictionary of data assets
• Responsible for data profiling, data analysis, data specification, data flow mappings, and business logic documentation associated with new or modified product data capture requirements
• Identify opportunities to define and drive an operationally effective and sustainable data strategy by assessing internally available toolsets and emerging technology trends
• Conduct data architecture assessments during feasibility, dimensioning, technical reviews and provide in depth architectural support during the various phases of the program/project as required
• Design data models for mission critical and high volume data management, real-time and distributed data process aligning with the business requirements
• Able to quickly identify and resolve data integration issues (data validation and data cleansing) using various data architecture concepts and techniques
• Promote and develop data architecture best practices, guidelines, procedures and repeatable and scalable frameworks
• Provide guidance and mentor the technical and business teams by providing solutions, recommendations and documentation of use cases for continuous improvement
• Contribute to build standards around data governance, data security, privacy, data quality and speed of analysis
• Able to rationalize, consolidate, or simplify multiple, diverse technical configurations, technologies, and processing environments
• Work under general direction and capable of delivering on multiple competing priorities with little supervision
• Consistently demonstrates regular, dependable attendance & punctuality
• Bachelor’s Degree in Computer Science or other related discipline
• 10+ years of proven hands on experience in data architecture, data modelling (relational, dimensional, columnar, big data), data architecture and metadata management
• 7+ years of experience in data modeling tools such as Embarcadero/Erwin/ER Studio or comparable toolsets
• 2+ years of hands-on experience in Big Data Databases (Hive, Hbase/Phoenix)
• Strong SQL skills, including experience querying large, complex data sets and performance analysis
• Strong experience with commercial ETL platforms with in-depth knowledge and understanding of ETL methodology & design supporting data transformations transformation layer
• Experience in In-Memory New SQL, NoSQL and Hadoop Hive/Sqoop/Scala/Spark
• Expert level skill in modelling, managing, scaling and performance tuning of high volume OLTP, OLAP and data warehouse environments
• Advanced knowledge of data management systems, practices and standards
• Experience developing highly performant distributed data processing platform with Big Data technologies
• Experience in the high paced energy of startups as well as experience in the structured world of larger companies
• Proven track record of full life cycle successes from inception to successful completion and production support
• Strong knowledge and experience with Agile/Scrum methodology and iterative practices in a service delivery lifecycle is a PLUS
• Experience with machine learning, statistical techniques, text mining, natural language processing, computational linguistics and information retrieval is a plus
Communication Skills:
• Excellent verbal and written communications skills
Other Skills:
• Capable of delivering on multiple competing priorities with little supervision
• Understanding of systems design and technical concepts in order to communicate effectively with other cross-functional teams
• Willing to strive for the ideal design process while still working within the framework of the organization, project, and environment
• Ability and desire to thrive in a proactive, high-pressure, client-services environment
• Retail or Customer or marketing analytics background is a plus
• Strong estimating, planning skills and proven ability as a problem-solver
Work Hours:
• Ability to work a flexible schedule based on department and company needs
Company Profile:
• Ability to work a flexible schedule based on department and store/company needs. As the fastest growing part of Macy's Inc. business, is achieving record sales and broadening our workforce. With offices in New York and San Francisco, is the best of all worlds. The entrepreneurial thinking of a Web business complements the stability and support of a national brand. Creativity and ingenuity partner with business acumen and tech savvy to build a unique business poised for continued growth. Employees at have long term opportunities and are encouraged to utilize their Supervisors and Human Resources for cross-functional movement to further their careers. At we are committed to giving back to the community by partnering with local charitable organizations.  By skillfully combining the power of the Internet with the best in retailing, is reaching new heights.
This job description is not all inclusive. Macy’s Inc. reserves the right to amend this job description at any time. Macy's Inc. is an Equal Opportunity Employer, committed to a diverse and inclusive work environment.
Macy's Inc., including Macy's and Bloomingdale's, will consider for employment qualified applicants with criminal histories in a manner consistent with SF PC Art. 49 and LA MC ch. XVIII Art. 9.