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 large‐scale 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 once—scoping, designing, and deploying MSquared’s 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