Mexico City, MX
Full-time
Remote
About Us
The Ksquare Group was established in 2014 in Dallas TX, we are an international company with a presence in different countries such as Mexico, the USA, India, and Dominican Republic currently being more than 250 Ksquarians and growing. We offer technological solutions through multidisciplinary Pods specifically designed to meet our customer’s needs. Depending on the skills required by every project, the best professionals are selected to bring all their talent together to achieve mutual goals. We authentically care about the comfort, wellbeing, and career growth of all our employees making sure integrity, innovation, leadership, accountability, and collaboration continuously stand by one and each one of us. We believe and trust all our outstanding professionals and realize how special they are but what makes us even special is the family we have become through the years.
**Responsibilities**:
Design and maintain conceptual, logical, and physical data models across cloud-based and on-premise data systems
Collaborate with business stakeholders, product owners, and engineers to gather data requirements and translate them into data models
Create and maintain entity-relationship diagrams (ERDs) and data dictionaries
Work with data engineers to ensure model alignment with data pipelines and data lake/warehouse structures
Design models optimized for analytics, reporting, and machine learning, especially in BigQuery
Analyze source systems and map data elements across multiple domains, including structured, semi-structured, and unstructured data
Support Master Data Management (MDM) initiatives by defining common entities and reference data
Use data lineage and metadata tools to ensure visibility into data movement, transformation, and usage
Utilize tools such as Cloud Composer (Airflow) for orchestration and DataProc (Spark) for processing where needed
**Requirements**:
5+ years of experience in data modeling and data analysis
Proficiency with data modeling tools (e.g., Erwin,



SAP PowerDesigner, Lucidchart, dbt)
Strong experience with SQL, BigQuery, and GCP Big Data ecosystem
Experience in building models for data warehouses, data lakes, and reporting platforms
Familiarity with ETL/ELT pipelines, Cloud Composer, and GCP Cloud Storage
Working knowledge of data governance, data security, and lineage
Experience working with MDM platforms or defining canonical data entities across domains
Strong communication and documentation skills to interface with both technical and business teams
**Nice to have**:
GCP Data Engineer or Data Analyst certification
Experience with DataOps practices (CI/CD for data models, versioning, testing)
Understanding of data cataloging tools (e.g., Collibra, Alation, Atlan)
Knowledge of business intelligence tools (e.g., Looker, Tableau, Power BI)
Familiarity with Python, dbt, and Spark is a plus
The Ksquare Group does not and shall not discriminate based on race, color, religion, gender, gender expression, age, national origin, disability, marital status, sexual orientation, or military status, in any of its activities or operations. These activities include, but are not limited to, hiring, and firing of staff, selection of volunteers and vendors, and provision of services. We are committed to providing an inclusive and welcoming environment for all members of our staff, clients, volunteers, subcontractors, vendors, and clients. As an equal-opportunity employer. We will not discriminate and will take affirmative action measures to ensure against discrimination in employment, recruitment, advertisements for employment, compensation, termination, upgrading, promotions, and other conditions of employment against any employee or job applicant on the bases of the conditions previously mentioned.
Why will you love working with us?
We thrive to reach out to tomorrow.
We are a world class team who work together across cultures and disciplines.
Transparency and challenging projects that will let you grow and learn.
We offer to you trust, sensibility and welfare, because you are important to us.

📌 Gcp Data Modeler (Ciudad de México)
🏢 The Ksquare Group
📍 Ciudad de México