Tiago Carvalhal

Working at a private equity firm specializing in acquiring and managing companies. I focus on standardizing data models and reporting structures across portfolio companies to ensure consistency, accuracy, and efficiency in data-driven decision-making. Key Highlights: - ETL Development: Designing and implementing ETL processes using Azure Data Factory, Databricks, DBT, Redshift, and SQL. - Integrating data from ERP, CRM, and other sources via APIs and custom connectors. - Transforming raw data into structured Business Data Model (BDM) tables and CDC tables. - Managing and optimizing SQL Server databases. - Data Visualization: Developing and maintaining reports in Power BI. - Strategic Alignment: Ensuring data strategies align with business objectives and management needs.

- Development of ETL processes integrations and automations from SQL servers and API endpoints to Azure data factory/Databricks and Power BI Data flow - Building and maintaining Data models and Power BI reports/dashboards with strong knowledge of power query/M language and DAX - Administration of Power BI Premium service, defining roles and creating datasets/dataflows for team members - Delivering and reporting to higher managers, identifying requirements to drive the business to success - Conducting data analysis to identify trends and patterns in key business metrics such as financial, operations and logistics - Monitoring discrepancies and anomalies with strong knowledge of CRM and ERP systems