Description: Insurance Industry Knowledge * Familiarity with insurance company products and processes (life, guarantee, comprehensive, claims, etc.), with a focus on the i4pro ERP. * Ability to translate complex insurance business rules, parameterized in i4pro, into database logic and analytics. * Experience integrating i4pro data with other insurance systems, financial platforms, CRM, and CCM. Other Technical Skills * Version Control and DevOps: Git/GitLab, CI/CD for SQL scripts and data pipelines. * Cloud Data Platforms (desirable): Azure and AWS, including integration with i4pro ERP data. * Agile Methodologies (desirable): experience working in squads, Scrum/Kanban. * Technical Documentation: ability to create and maintain clear documentation of data models, procedures, and pipelines involving the i4pro ERP. * Data Analytics and Data Science in the Insurance Context * Insurance Platform Expertise: proven experience with the i4pro ERP for managing products, policies, claims, reinsurance, and other insurance operations, including understanding of its modules, tables, and system integrations. * System Integration via APIs and Connectors: knowledge of integration architectures (REST, SOAP, Webhooks, messaging) to consume and expose i4pro ERP data and data from other systems, ensuring security, scalability, and governance. * Data Modeling and Integration: ability to analyze, model, and map complex data originating from the i4pro ERP and other core/legacy systems, ensuring consistency and integrity. * ETL/ELT in Insurance Environments: experience in extracting, transforming, and loading data from multiple sources—especially i4pro—to feed data warehouses, data lakes, and analytical reports. * Statistical Analysis and Machine Learning (desirable): application of statistical techniques, predictive modeling, and advanced analytics (Python, R, SAS or equivalents) on data from the ERP and other insurer systems. * Governance and Compliance: attention to data quality, metadata, LGPD, and regulatory requirements of the insurance market when handling ERP information. 2. SQL Development and Stored Procedures * Advanced SQL: proficiency in complex queries and data manipulation extracted from the i4pro ERP. * Stored Procedures, Functions, and Triggers: ability to develop, optimize, and maintain procedures and functions to automate business rules related to i4pro data. * Performance Tuning: experience identifying bottlenecks and optimizing queries and database structures for improved performance in environments consuming ERP data. * Relational and Dimensional Data Modeling: creation of normalized tables, views, and models for data warehouse/data marts integrating i4pro data. * Database Environments: experience with traditional databases (SQL Server, Oracle, PostgreSQL, MySQL). 2512240202491846559