Data Architect, GCP

3Pillar Global

full-time

Posted on: 9/28/2025

Location Type: Remote

Location: Remote • 🇲🇽 Mexico

Visit company website

✨ AI Apply

Apply

Job Level

SeniorLead

Tech Stack

BigQueryCloudETLGoogle Cloud PlatformPythonSQL

About the role

Support clients to take control of their data and get value by defining reference architectures
Work closely with business leaders and information management teams to define and implement roadmaps on data management, business intelligence, or analytics solutions
Assess existing data components, perform POCs, and consult stakeholders
Propose end-to-end solutions for enterprise data problems, handling collection, extraction, integration, cleansing, enriching and visualization
Design large data platforms to enable Data Engineers, Analysts & scientists
Apply strong exposure to different Data architectures, data lake & data warehouse concepts
Define tools & technologies to develop automated data pipelines, write ETL processes, and develop dashboards & reports
Reassess current state for alignment with architecture goals, best practices and business needs
DB modeling, deciding best data storage, creating data flow diagrams, maintaining related documentation
Ensure performance, reliability, reusability, resilience, scalability, security, privacy & data governance in designs
Recommend best practices in architecture, coding, API integration, CI/CD pipelines
Coordinate with data scientists, analysts, and other stakeholders for data-related needs
Mentor junior practice members, lead initiatives and Data Practice Offerings
Provide thought leadership by representing the Practice/Organization on internal/external platforms

Requirements

Expertise in SQL, Python, ERD, GCP (All services, especially BigQuery, GCS, Cloud Function, Composer), DBT with Active/Heavy hands-on in the last 3~5 years
Possess the knowledge of Modern Data Technology released in the last 2~3 years
Design and optimize conceptual and logical database models
Analyze system requirements, implementing data strategies, and ensuring the efficiency and security
Improve system performance by conducting tests, troubleshooting, and integrating new elements
In-depth understanding of database structure principles
Expertise in implementing and maintaining data pipelines
Deep knowledge of data mining and segmentation techniques
10+ years in data modeling with 3+ years in Big data (100TB+)
Familiarity with data visualization tools
Submission requires Resume/Profile and code assessment result in SQL and Python (e.g. IKM CodeChek/TechChek)

Benefits

Medical Insurance benefits as per company policy.
Life Insurance as per company policy
15 days of paid vacation plus additional days based on tenure
Vacation bonus as per local law
Sick leave and paid holidays as per local law
Profit sharing as per local law
Paternity and maternity leave as per as per local law
Marriage, bereavement and graduation leaves as per company policy
Christmas bonuses as per local law
Work from home allowance as per company policy
Punctuality and attendance bonuses as per company policy
Food tickets as per company policy
Direct deposit of payroll
Paid professional certifications

ATS Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

SQLPythonETLDBTdata modelingdata miningdata visualizationdata architecturedata pipeline developmentBig Data

Soft skills

mentoringthought leadershipstakeholder consultationcollaborationproblem-solvingcommunicationleadershiporganizational skillsanalytical skillsstrategic planning