Senior Data Engineer

Description

Are you driven by technology, data, and innovation? At Triggo.ai, we transform complex challenges into intelligent solutions. We are a Brazilian company focused on Analytics, AI, and digital transformation, helping organizations make more strategic decisions and generate real business impact. We work across diverse market sectors, always combining cutting-edge technology, business insight, and agile execution. If you want to build solutions that make a difference and grow alongside a high-performance team, this could be your place. Join Triggo.ai and build the future with us. **Responsibilities and Duties** * Develop, review, and optimize complex SQL queries in BigQuery; * Build and maintain analytical tables in the Trusted and Refined layers; * Support relational, dimensional, and analytical data modeling; * Create, adjust, and sustain data pipelines orchestrated via Airflow / Cloud Composer; * Implement business logic in SQL with emphasis on traceability, clarity, and performance; * Perform validations across Raw, Trusted, and Refined layers; * Identify and resolve issues related to data volume, duplication, data typing, granularity, and relationships; * Support discrepancy analysis between source systems and consolidated tables; * Work with code versioning, script organization, and engineering best practices; * Build mechanisms for monitoring and validating data quality; * Support data consumers with questions regarding business logic, data origin, granularity, and proper table usage; * Participate in technical discussions to define architecture, performance, partitioning, clustering, and data contracts; * Document rules, workflows, tables, relationships, keys, and validation criteria. **Requirements and Qualifications** * Advanced experience with SQL; * Practical experience with BigQuery; * Knowledge of relational and dimensional data modeling; * Ability to interpret complex business rules and translate them into SQL; * Experience building data pipelines; * Knowledge of Airflow or Cloud Composer; * Experience with cloud environments, preferably GCP; * Familiarity with Data Lake, Data Warehouse, and Raw, Trusted, and Refined layers; * Experience with data processing, standardization, typing, and deduplication; * Knowledge of partitioning, clustering, and query optimization; * Experience with Git or another version control system; * Ability to analyze logs, identify errors, and propose fixes; * Strong communication skills to interact with technical teams and business areas. **Nice-to-Haves:** * Experience with Power BI and semantic modeling; * Knowledge of Tabular Editor; * Knowledge of healthcare, clinical, or financial processes; * Experience with data monitoring, volume tracking, reconciliation, and quality assurance; * Experience with CI/CD for data; * Familiarity with technical documentation and data contracts. We are the **SysMap Group**, comprising the brands **SysMap Solutions, TriggoLabs, and triggo.ai** — an ecosystem of high-impact companies in the market, delivering innovative technology solutions that transform businesses and develop people. Our essence is fueled by **a passion for innovation, collaboration, and continuous growth**. For over **25 years**, we have exceeded expectations by solving complex business challenges, operating across multiple sectors and actively keeping pace with technological evolution. Here, we believe that **technology only delivers value when built by people**. Therefore, we cultivate an ethical, collaborative, and diverse environment where learning is constant and excellence in what we do is part of our identity. **The only way to participate in SysMap Group selection processes is through the company pages on the Gupy platform; there is no participation or hiring fee.**