Data Engineer And Business Intelligence Architect
CurrentDevelop and maintain ETL processes using Python to extract data from various sources, perform transformations using SQL queries, and load it into target databases such as Microsoft SQL Server and Snowflake.Write complex SQL queries to perform data transformations, aggregations, and joins to prepare data for analysis and reporting.Optimize SQL queries and database performance to ensure efficient data processing and minimal downtime.Implement data quality checks and validation procedures to ensure data integrity throughout the ETL process.Automate ETL workflows using Python scripting to schedule and monitor data processing jobs, improving efficiency and reducing manual effort.Document ETL processes, including data mappings, transformation rules, and scheduling details, to facilitate knowledge sharing and maintain data lineage.Assigned to the development of BI projects for the different regions (EMEA, APAC, NCA and SA). * Participating and providing technical leadership in all phases of BI projects: from discovery and planning through implementation and delivery.* Working with cross-functional teams to structure problems, identify appropriate data sources, ETL process and develop integrated information delivery systems solutions.* Development and implementation of dashboards in Qlikview, Qlik Sense and Power BI connected to Snowflake, Oracle and SQL data sources.* Qlik Sense QMC administration and upgrade in multi node scenario. Creation of security rules, administration of licenses and users.