| Urgent Need :: Data Architect at Culver City, CA | Onsite-Hybrid | at Culver, Oregon, USA |
| Email: [email protected] |
| Hi, Please find job description below; No H1b LinkedIn required Job Title: Data Architect Duration: 6+ months Work Location: Onsite in Culver City, but flex on days/amount per week; Remote could be considered for a rockstar Interview Process: 1 hour panel interview Final round Top 3-4 Technical Skills 8+ of years of Data/IT work experience and 4+ years of experience in Data Modeler/Architect role. Certified Snowflake SnowPro is required Data modeling experience with Erwin Media & entertainment strongly preferred Project Overview: This individual will design and deliver an enterprise grade master data management (MDM) solution. The studio has several internal and external datasets with varying degrees of master data maturity. Sonys business sponsors are looking to harmonize these data sets to unlock high-quality title metadata and data interoperability to serve various consumption use cases. Non-technical skills: Problem-solving skills Excellent communication Actively seek out feedback from management and peers Interview Process: 1 hour panel interview Final round Job Description From Client: Sony Pictures Entertainment is looking for a skilled technical architect to design and deliver an enterprise grade master data management (MDM) solution. The studio has several internal and external datasets with varying degrees of master data maturity. Our business sponsors are looking to harmonize these data sets to unlock high-quality title metadata and data interoperability to serve various consumption use cases. The architect will be a highly skilled individual with experience profiling internal systems and multiple 3rd party datasets to produce a solution architecture. Expertise in building conceptual, logical and physical data models suitable for implementation on Snowflake SaaS is required. Evaluating existing databases and schemas in addition to collecting new requirements is key to a solution architecture. Experience with data warehousing and data modeling principles (i.e. Inmon, Kimball) in Snowflake Cloud Computing is key to this project. This project will require developing detailed design and technical documentation for our development team to implement. Experience with Media / Entertainment 3rd party dataset is highly preferred. Responsibilities include Experience with profiling and working with high-volume, complex data sets spanning various subject areas for meta completeness and data integration/harmonization opportunities. Partner with data experts to formulate, understand the solution requirements Identify the right data sources / data completeness to build the final product Provide design considerations for both deterministic (ID based) and probabilistic (ML) record matching Data profiling to build the entity relationships across multiple sources Build conceptual, logical, and physical data models Recommend Data Quality Management methodologies for various projects Review existing and new data assets quality and dependency analysis including connections between them Key outputs include: Technical architecture for master data management, title matching, for current and future enhancements Data providers assessment for completeness, aligning to business requirements and quality Recommend best practices to manage Data Quality and Data integrity Solution design for data ingestion pipelines (e.g. refresh rates, error handling, etc.) Contribution of documentation to IT knowledge database Qualifications: 8+ of years of Data/IT work experience and 4+ years in the similar role of Data Modeler/Architect. Media & Entertainment experience is an added plus. Experience with data modeling concepts (star schemas, snowflake schemas, highly normalized data models) Data modeling experience with Erwin is preferred Certified Snowflake SnowPro is preferred Data Warehousing development experience Snowflake and/or other cloud solutions Master Data Management tool experience is an added asset Knowledge and experience of at least one data profiling tool Excellent SQL programming skills Excellent problem-solving skills Excellent communication skills with both business and technical customers Take a proactive approach to cross-functional communication Actively seek out feedback from management and peers Regards, Vijay Kumar | Lead Recruiter Verve IT Consulting LLC | Astoria, NY 11105 Office: 914-650-4600 Ext: 148 Keywords: machine learning information technology Idaho New York Urgent Need :: Data Architect at Culver City, CA | Onsite-Hybrid | [email protected] |
| [email protected] View all |
| Tue Aug 27 21:31:00 UTC 2024 |