Job Summary: Responsible for transforming business needs into reliable data solutions, collaborating with teams on analysis, data quality, and model development. Key Highlights: 1. Advanced data analysis for actionable insights 2. Design and optimization of data flows and ETL pipelines 3. Collaboration on agile methodologies and with executive stakeholders INFORMATION SENIOR CONSULTANT 5 hours ago Description Responsible for analyzing and transforming business needs into reliable data solutions that support decision-making. Collaborates with business units and technical teams to evaluate information, ensure data quality, and develop analytical models and reports using agile methodologies. Requirements **Core Responsibilities** * Advanced data analysis to interpret complex information and deliver actionable insights for decision-making. * Design, build, and operate data flows and ETL/ELT pipelines, ensuring integrity, efficiency, and scalability. * Develop and optimize complex SQL queries on large-scale datasets (BigQuery), integrating multiple data sources. * Evaluate, validate, and ensure data quality throughout the analytical lifecycle. * Design analytical and BI data models (logical and BI) oriented toward analytics and consumption in executive reporting. * Create and refine executive dashboards and reports in BI tools, targeted at leadership audiences. * Maintain clear, structured documentation of analytical flows, models, and processes to facilitate maintenance and scalability. * Translate business requirements into analytical and BI solutions, collaborating with technical teams and executive stakeholders. **Technical Skills** * Advanced data analysis. * Advanced SQL (BigQuery). * Design and operation of ETL/ELT processes. * Analytical and BI data modeling. * Executive-focused data visualization. * Programming applied to data analysis (Python or similar language). * Solid knowledge of statistics and probability. * Experience working in cloud environments (GCP). **Soft Skills** * Strong analytical capability. * Structured thinking. * Self-management and work organization. * Clear communication with technical teams and executives. * Ability to translate business needs into data solutions. * Technical leadership (desirable). **Experience** * Proven experience in data analysis and ETL pipeline development. * Experience developing complex, optimized SQL queries on large-scale datasets. * Practical experience with ETL tools (Dataiku preferred) for data preparation, transformation, and orchestration. * Experience designing data models that feed reports and dashboards. * Experience creating executive dashboards and visualizations in BI tools (Power BI or others). * Experience working with GCP and BigQuery. * Experience integrating data from multiple sources (databases, CSV, Excel, flat files). * Experience collaborating under agile methodologies (SCRUM) (desirable). **Tools:** * Office Suite * SQL * BigQuery * Python * Power BI / Looker * ETL/ELT tools for pipeline construction and operation (Dataiku preferred) Profile **SENIOR CONSULTANT** Location **Huixquilucan, State of Mexico, Mexico (Hybrid)** Experience **4 Years of Experience** o