Data Analysis and Reporting Specialist
Must-have:PythonDataFinTechSecurity
We are looking for a detail-oriented specialist to join our B2B Department. The successful candidate will work with SQL databases, prepare and maintain reports, analyze data, and support the accuracy and timely delivery of reporting outputs.
- Extract, process, and analyze data from SQL databases.
- Write, maintain, and improve SQL queries used for reporting and analysis.
- Prepare and deliver recurring and ad hoc reports within established deadlines.
- Validate report outputs and investigate data discrepancies, working with relevant teams to resolve issues.
- Identify missing, duplicate, inconsistent, or incorrect data and support improvements in data quality.
- Maintain existing reports and develop new reports and dashboards based on business requirements.
- Improve and automate repetitive data processing and reporting tasks.
- Document SQL queries, report definitions, calculation rules, and reporting procedures.
- Interpret analytical results and communicate findings clearly to relevant colleagues.
- Handle sensitive information in accordance with the company’s confidentiality, information security, and data access requirements.
- At least two years of relevant experience in data analysis, reporting, or a similar role.
- Strong practical SQL skills, including joins, aggregations, subqueries, CTEs, and window functions.
- Advanced MS Excel skills, including PivotTables, data validation, and Power Query.
- Experience preparing, checking, and maintaining recurring reports.
- Understanding of relational databases and data quality principles.
- Strong analytical and problem-solving skills, with high attention to accuracy and detail.
- Ability to work independently, manage reporting deadlines, and collaborate with other teams.
- Ability to explain findings clearly to colleagues without a technical background.
An Advantage
- Experience with Power BI or Tableau.
- Knowledge of Python or R for data processing and automation.
- Experience in credit reporting, banking, or other financial services.