Senior Solution Architect/ Data Integration Specialist

Role Description Senior Solution Architect to lead the delivery of our media-measurement product suite across multiple, concurrent client engagements. You will architect complex data integrations, crunch largescale datasets, and serve as a subject-matter expert on media mix modeling, attribution, and ad-tech ecosystems. This is a hands-on, client-facing role that balances technical execution with project leadership. Key Responsibilities Own end-to-end solution architecture for several clients at oncescoping, designing, and deploying MSquareds media-measurement platform.Lead requirements workshops and translate business needs into scalable data models, ETL pipelines, and reporting frameworks.Design and optimize ETL processes that ingest high-volume, multi-channel marketing data.Crunch big data sets using advanced SQL and Python, delivering actionable insights on media performance.Conduct rigorous QA of both raw data and final outputs to ensure accuracy, consistency, and reliability.Collaborate with cross-functional teams (Solution Architects, Data Engineers, Project Managers) to meet aggressive timelines in a fast-paced environment.Act as the primary point of contact for onboarding new external data vendors and ensuring smooth integration into the enterprise data platform.Collaborate with external vendors to understand their data models, schemas, formats, and delivery mechanisms.Define and standardize data mapping, transformation, and normalization rules to convert vendor-specific data into enterprise-standard formats.Design and establish scalable integration approaches for ingesting data into the Azure Enterprise Data Warehouse.Evaluate and recommend appropriate integration patterns, including APIs, SFTP, event-based integrations, file-based ingestion, and other data exchange mechanisms.Partner with vendors and internal architecture teams to define secure, scalable, and reliable data exchange ("handshake") mechanisms.Develop and enforce data quality rules, validation frameworks, and cleansing processes before data is loaded into the enterprise warehouse.Perform data profiling, identify data anomalies, and work with vendors to resolve data quality issues at the source.Collaborate with Data Engineering, Data Governance, Architecture, and Business teams to ensure enterprise data standards are consistently applied.Document data mappings, integration specifications, validation rules, and onboarding guidelines.Support testing, reconciliation, and production readiness activities for new vendor integrations.Drive continuous improvements in vendor onboarding, data integration, and data quality processes.Knowledge on creating and enhancing Power BI dashboards .