Data Architecture Consultant (Salesforce, Workday, Sitecore exp)
Remote, MA
Data Architect 6-month contract with extensions 100% Remote Our client is looking for a hands-on Data Architect who has experience working with enterprise data from systems such as Salesforce, Workday, and Sitecore, and understands data dependencies within those systems . This individual will assist with the following:
Identify and catalog various business data platforms and sources used
Analyze and document current data design – System agnostic Data Design review of current state
Identify and document data owners and establish a data certification / access approval process
Recommend DevOps opportunities in Analytics space
Design data architecture for various data mart needs and assist with implementing a data mart for one use-case with focus on security, re-usability and establishing a “single source of truth” for the data set
Define a reference architecture and data architecture framework for continued use and development
Required skills:
Expert in data design, data engineering, and data architecture
Experience building and supporting Enterprise data warehouse, data lake and lake house solutions and the likes
Experience working with business systems data from Salesforce, Workday, Sitecore etc and integrate them in a centralized data layer (like a Data warehouse and/or a data lake)
Experience working with executive and business stakeholders to communicate and articulate the findings clearly
Experience writing and understanding SQL and Spark SQL queries
Experience documenting ER diagrams
Familiar with AWS data management toolsets (AWS Glue, AppFlow, S3, AWS EMR, Spark SQL queries etc ) and Azure data management tools (Azure Synapse , ADF, Azure DataLake etc)
Familiar with Master Data Management processes
Excellent verbal and written communication skills
Domo experience a big plus
Following items will be the work product from this engagement (including, but not limited to).
Data dictionary
Data catalog
Business glossary
Data management process documentation (current state) and recommendation (future state)
Mapping of data movement and detailed lineage tracking
Documenting current and future data architecture with technical details