Mateus Carvalho
Data Analyst | SQL, Power BI, Excel
- mateus.carvalho@example.com
- +1 555 0118
- Dublin, Ireland
- linkedin.example.com/in/mateus-carvalho
Professional summary
Data analyst with six years of experience turning sales, stock and customer data into reports that commercial teams use every week. Strong in SQL and Power BI, comfortable with Python for cleaning and ad hoc analysis, and careful about data quality and metric definitions.
Work experience
Data Analyst
Fennick Home & Garden, Dublin
Mar 2022 – Present
- Built a Power BI sales and margin dashboard used weekly by 30 buyers and store managers, replacing 14 separate Excel reports
- Wrote and maintained SQL views in Snowflake covering 4 million order lines a year across 22 stores and the website
- Analysed promotion performance for the commercial director and showed that 9 of 40 recurring offers lost margin; six were withdrawn the following season
- Found and fixed a join error that double-counted click-and-collect orders, correcting reported online revenue by 6%
- Agreed a single definition of "active customer" with marketing and finance, and documented 35 core metrics in a shared data dictionary
Reporting Analyst
Ashgrove Mutual Insurance, Dublin
Sep 2020 – Feb 2022
- Produced monthly claims and renewals reports from SQL Server, cutting preparation time from two days to four hours with stored procedures and Power Query
- Automated a weekly call-centre report in Excel that had been compiled by hand from five system exports
- Investigated a rise in motor claim handling time and traced most of the delay to one document check; the process change cut the average by 2.5 days
- Ran monthly reconciliation checks between the policy system and the data warehouse, flagging mismatches to IT before reports were issued
Skills
Querying: SQL (Snowflake, SQL Server), window functions, CTEs
Spreadsheets: Excel (Power Query, pivot tables, XLOOKUP)
Visualisation: Power BI (DAX, data modelling), Tableau
Analysis: cohort and trend analysis, A/B test read-outs, Python (pandas)
Practice: requirements gathering, metric definitions, data validation, documentation
Education
BSc Economics and Statistics
Carrowmore University, Dublin
2016 – 2020
Certifications
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
2023
Languages
- Portuguese (native)
- English (fluent)
- Spanish (conversational)