Gcp Data Modeler

Mexico City, MXFull-timeRemoteAbout UsThe 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 systemsCollaborate with business stakeholders, product owners, and engineers to gather data requirements and translate them into data modelsCreate and maintain entity-relationship diagrams (ERDs) and data dictionariesWork with data engineers to ensure model alignment with data pipelines and data lake/warehouse structuresDesign models optimized for analytics, reporting, and machine learning, especially in BigQueryAnalyze source systems and map data elements across multiple domains, including structured, semi-structured, and unstructured dataSupport Master Data Management (MDM) initiatives by defining common entities and reference dataUse data lineage and metadata tools to ensure visibility into data movement, transformation, and usageUtilize 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 analysisProficiency with data modeling tools (e.g., Erwin, SAP PowerDesigner, Lucidchart, dbt)Strong experience with SQL, BigQuery, and GCP Big Data ecosystemExperience in building models for data warehouses, data lakes, and reporting platformsFamiliarity with ETL/ELT pipelines, Cloud Composer, and GCP Cloud StorageWorking knowledge of data governance, data security, and lineageExperience working with MDM platforms or defining canonical data entities across domainsStrong communication and documentation skills to interface with both technical and business teams**Nice to have**:GCP Data Engineer or Data Analyst certificationExperience 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 plusThe 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.