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
