Data Solution Architect

Job Title – Data Solution ArchitectJob Location – Mexico (Remote)Experience level – 8+ YearsJob type – Contract
Job description
Key ResponsibilitiesOwn the technical architecture for Gold-layer pipeline design (dbt/Airflow on a cloud data warehouse platform) and its integration points with the Real-Time Newsroom Web UI and Audience Goals Dashboard.Serve as primary technical liaison to client Data Engineering, Data Collection, and Program Management stakeholders; represent Virtusa in technical design discussions and Q1 joint-discovery sessions.Translate ambiguous or not-yet-final requirements into concrete technical specifications, in coordination with the Solution Lead.Drive resolution of open architectural dependencies: Bronze/Silver readiness handoff, event-tracker instrumentation gaps, reconciliation tolerance thresholds, hosting platform confirmation, and role-based access model.Provide hands-on technical direction to the offshore engineering team (Data, UI Build, UX Design streams); review designs and key implementation decisions.Own delivery risk management for the accelerated-track deliverable given its hard deadline and out-of-band design process.Ensure data quality, parity validation (vs. legacy platform baselines), and observability/runbook standards meet client Data Engineering conventions (dbt, managed workflow orchestration, standard linting/pre-commit tooling).Support sprint-level planning and resourcing decisions, including uneven quarter-over-quarter workload across the program.Escalate scope, timeline, or dependency risks proactively to the Solution Lead.Contribute to post-launch support, knowledge-transfer planning, and documentation handover to the client's Data Engineering team.
Required Skills & Experience8+ years in data/solution architecture roles, including at least 3+ years in cloud data warehouse-based medallion (Bronze/Silver/Gold) architectures (e.g., Snowflake, Databricks, BigQuery).Hands-on experience with event-driven data collection platforms such as Snowplow, Segment, or mParticle as a source system.Strong dbt and workflow orchestration experience (e.g., Airflow); familiarity with managed orchestration bridges (e.g., Astronomer Cosmos) is a plus.Experience architecting real-time or near-real-time analytics pipelines for high-concurrency, low-latency use cases (media/publishing/editorial analytics experience strongly preferred).Experience with data migration/parity validation projects — legacy vendor analytics tool to modern in-house replacement.Working knowledge of front-end/full-stack architecture sufficient to coordinate with a UI-build team (role does not require hands-on front-end development).Experience operating in T&M, staff-augmentation delivery models with a client-owned PMO.Strong client-facing communication skills; comfortable representing technical positions directly to enterprise client stakeholders.Experience managing or technically directing offshore delivery teams.Familiarity with SSO/Okta-based role access models and enterprise data governance frameworks.
Nice to HavePrior experience with BI tool (e.g., Tableau) integration/repointing projects.Experience in newsroom/editorial analytics tooling (Parse.ly, Chartbeat, or similar).AWS certification or hands-on AWS/EKS/Istio experience.
Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.