Bayone
Technical Solutions Architect
Bayone, Culver City, California, United States, 90232
Job descriptionSony 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 requirementsIdentify the right data sources / data completeness to build the final productProvide design considerations for both deterministic (ID based) and probabilistic (Client) record matchingData profiling to build the entity relationships across multiple sourcesBuild conceptual, logical, and physical data modelsRecommend Data Quality Management methodologies for various projectsReview 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 enhancementsData providers assessment for completeness, aligning to business requirements and qualityRecommend best practices to manage Data Quality and Data integritySolution design for data ingestion pipelines (e.g. refresh rates, error handling, etc.)Contribution of documentation to IT knowledge databaseQualifications:
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 preferredCertified Snowflake SnowPro is preferredData Warehousing development experience - Snowflake and/or other cloud solutionsMaster Data Management tool experience is an added assetKnowledge and experience of at least one data profiling toolExcellent SQL programming skillsExcellent problem-solving skillsExcellent communication skills with both business and technical customersTake a proactive approach to cross-functional communicationActively seek out feedback from management and peers
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 requirementsIdentify the right data sources / data completeness to build the final productProvide design considerations for both deterministic (ID based) and probabilistic (Client) record matchingData profiling to build the entity relationships across multiple sourcesBuild conceptual, logical, and physical data modelsRecommend Data Quality Management methodologies for various projectsReview 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 enhancementsData providers assessment for completeness, aligning to business requirements and qualityRecommend best practices to manage Data Quality and Data integritySolution design for data ingestion pipelines (e.g. refresh rates, error handling, etc.)Contribution of documentation to IT knowledge databaseQualifications:
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 preferredCertified Snowflake SnowPro is preferredData Warehousing development experience - Snowflake and/or other cloud solutionsMaster Data Management tool experience is an added assetKnowledge and experience of at least one data profiling toolExcellent SQL programming skillsExcellent problem-solving skillsExcellent communication skills with both business and technical customersTake a proactive approach to cross-functional communicationActively seek out feedback from management and peers