Svenska
Dansk
Dutch
Deutsch
Français
Norsk
Suomi
NEW
Proxify is bringing transparency to tech team performance based on research conducted at Stanford. An industry first, built for engineering leaders.
Learn more
Carlos N.
Analytics Engineer
Carlos is an experienced Analytics Engineer with nearly nine years of experience in data architecture, transformation, and analytics engineering.
He specializes in SQL, Python, and dbt for data modeling and transformation, and leverages tools such as GitHub, Snowflake, SQL Server, AWS S3, and Power BI to deliver efficient, insight-driven solutions.
One of his most notable achievements was developing an end-to-end data pipeline that powers a dynamic segmentation system. This solution determines which debtors to contact, when, and through which channel—email, SMS, TTS, or phone—by integrating analytical intelligence with business logic to maximize debt recovery and minimize operational effort.
Carlos is recognized for his ability to translate complex data processes into practical business solutions, ensuring that every system he builds delivers clarity, efficiency, and measurable impact.
Main expertise
- Microsoft Power BI 5 years
- SQL 6 years
- T-SQL 3 years
Other skills
- HTML / CSS 5 years
- Python 3 years
- AWS S3 3 years
Selected experience
Employment
Data Developer
Intrum - 3 years 2 months
- Built a complete data pipeline from scratch, defining storage architecture, selecting transformation tools, and setting up the data warehouse platform.
- Developed and deployed Power BI reports delivering real-time dashboards and historical analytics for performance and client reporting.
- Designed and implemented segmentation strategies for the call center, enabling effective debtor profiling and outreach prioritization.
- Created automated follow-up systems for clients, including email, SMS, and TTS reminders.
- Centralized company-wide data to ensure consistent and unified access.
- Built and optimized data transformation workflows using dbt and Airflow.
- Developed and maintained data models and schemas for analytical and operational needs.
- Applied data governance standards, ensuring data quality and integrity.
- Optimized SQL queries, stored procedures, and indexing, improving system performance and scalability.
- Utilized a modern tech stack including Docker, dbt, Snowflake, PL/SQL, Airflow, Python, and Power BI.
Technologies:
- Technologies:
Docker
Python
SQL
AWS S3
Microsoft Power BI
Pandas
Git
Apache Airflow
Snowflake
ETL
dbt
Analytics Engineer
Jumia - 1 year 2 months
- Supervised data deployment processes to the Data Lake, ensuring accuracy, consistency, and compliance with governance standards.
- Optimized SQL stored procedures and views to enhance performance and reduce query execution times.
- Maintained analytical layer reliability through regular quality checks and proactive issue resolution.
- Developed analytical tools to segment products by sales performance, customer preferences, and seasonal trends, supporting targeted stock management strategies.
- Analyzed sales performance to identify top-performing and underperforming products, informing strategic business and marketing decisions.
- Leveraged Power BI, Python, and SQL to extract, analyze, and visualize data for effective inventory management and commercial planning.
- Collaborated with Supply Chain and Sales teams to align inventory strategies with business objectives.
- Built automated reporting solutions to monitor inventory levels, sales trends, and replenishment needs, improving operational visibility and decision-making.
Technologies:
- Technologies:
T-SQL
-
Python
-
SQL
-
Microsoft Power BI
-
Pandas
Apache Hive
-
Git
SSAS
-
ETL
Business Data Analyst
GKN - 1 year 6 months
- Utilized Excel, Power BI, Python, and SQL to analyze data and generate actionable business insights.
- Communicated analytical findings to stakeholders through ad hoc data extractions, presentations, and custom-built Power BI dashboards.
- Developed and maintained SQL stored procedures to transform, update, and load data into analytical tables.
- Automated weekly and monthly business reports, ensuring the timely delivery of key performance insights.
- Led a data transformation project, migrating on-premises data to the cloud to enhance scalability and accessibility.
- Refactored and optimized SQL stored procedures to streamline data flows and improve system efficiency.
- Designed and built Power BI dashboards from the ground up, enabling self-service analytics and data-driven decision-making.
- Leveraged tools such as Power BI, DAX, SQL, Excel, and Python to support robust reporting and advanced analysis.
Technologies:
- Technologies:
-
Python
-
SQL
-
Microsoft Power BI
- HTML / CSS
- DAX
Microsoft Excel
Continuous Improvement Specialist
WEC Lines Ibero - 2 years 11 months
- Rebuilt and maintained master data from the ERP system, ensuring data accuracy and integrity.
- Analyzed company processes and proposed improvements to enhance efficiency and regulatory compliance.
- Presented tools and process recommendations directly to the board, supporting strategic decision-making.
- Ensured adherence to internal controls, policies, and procedures across multiple departments.
- Contributed to the development of organizational best practices, promoting a culture of continuous improvement.
- Supported the refresh and optimization of Finance Workflow procedures to streamline operations.
- Utilized tools such as Confluence, SAP, Excel, and VBA to document, automate, and enhance business processes.
Technologies:
- Technologies:
VBA
- HTML / CSS
SAP
-
Microsoft Excel
Education
Standalone courseData Science
Business Analytics & AI · 2021 - 2022
BSc.Management
Instituto Politécnico do Porto · 2012 - 2015
Find your next developer within days, not months
In a short 25-minute call, we would like to:
- Understand your development needs
- Explain our process to match you with qualified, vetted developers from our network
- You are presented the right candidates 2 days in average after we talk