Responsabilidades principales
In this role you'll:
Design, develop, and maintain reporting solutions using Pentaho Data Integration, Pentaho Report Designer, and related Pentaho tooling.
Build and support ETL processes that extract, transform, validate, and load data from Sage HCM application databases and related data sources.
Develop robust SQL queries, stored procedures, views, and data transformations to support operational, customer-facing, and internal reporting requirements.
Maintain existing HCM reports, resolve defects, improve performance, and ensure reporting outputs remain accurate across product and compliance changes.
Work with product owners and solution designers to translate payroll, HR, and localisation reporting requirements into clear technical solutions.
Analyse data models, source tables, relationships, and business rules to identify the correct data flows and reporting logic.
Investigate reporting issues, data discrepancies, and performance bottlenecks across databases, ETL jobs, and report definitions.
Document data mappings, report logic, transformation rules, and technical decisions to support maintainability and knowledge sharing.
Collaborate with backend developers, QA engineers, and support teams to deliver reliable reporting changes through standard engineering and release processes.
Required Skills and Experience:
Extensive professional software development, database development, reporting, BI, or ETL experience.
Strong hands-on experience with SQL, including complex queries, joins, aggregations, views, stored procedures, and query troubleshooting.
Solid understanding of relational databases, particularly MySQL, including indexing, transactions, data modelling, referential integrity, and performance tuning.
Practical experience building or maintaining ETL workflows, preferably using Pentaho Data Integration / Kettle.
Experience creating, modifying, or supporting reports using Pentaho Report Designer or comparable enterprise reporting tools.
Ability to analyse complex data structures and translate business requirements into reliable reporting logic.
Good understanding of data quality, validation, reconciliation, and error handling within reporting and ETL processes.
Experience working with Git-based workflows, issue tracking tools, release processes, and Agile delivery practices.
Strong troubleshooting skills, attention to detail, and ability to work independently on established systems and legacy reporting assets.
Nice to Have:
Previous experience working with Payroll, HR, HCM, ERP, or compliance-heavy business domains.
Familiarity with Sage HCM data structures, localisation requirements, or customer-facing reporting use cases.
Experience with data warehousing concepts, dimensional modelling, star or snowflake schemas, OLAP, or reporting data marts.
Exposure to scripting or automation using Java, JavaScript, Python, Bash, or similar languages.
Experience with production observability, scheduled job monitoring, logging, alerting, or report execution diagnostics.
Knowledge of AWS, cloud-hosted databases, or modernisation of legacy reporting platforms.
Russian, Ukrainian, or Polish language skills would be beneficial, but are not essential.
Ways of Working
Pragmatic and delivery-focused, able to balance new report development with maintenance, defect resolution, and technical improvement work.
Able to communicate clearly with technical and non-technical stakeholders, especially when explaining data issues, reporting logic, or delivery risks.
Proactive in documentation, knowledge sharing, peer reviews, and improving the maintainability of reporting assets over time.
Strong problem-solving mindset, with the patience and curiosity required to work effectively in a complex, established HCM product ecosystem.
At Sage, we offer you an environment where you can grow professionally without compromising your personal well-being. Our benefits package is designed to provide stability, flexibility, and balance:
Medical and dental insurance: Fully funded medical and dental insurance.
Flexible benefits: Exchange part of your salary and make tax savings on meal and transport vouchers, childcare, and training.
Well-being: Free access to the Calm app (for up to 5 users), 24/7 counselling, and emotional support from our Healthy Mind Coaches. We also offer self-care and parenting resources through the Cleo app.
Flexible working: flexibility of working one hour in, one hour out, shortened workdays on Fridays and during the summer, and the opportunity to work from over 40 countries for up to 10 weeks per year through our Work Away program.
Annual leave: 23 working days of vacation, 5 paid days per year for volunteering.
Extended leave: 7 extra days of maternity leave and 5 extra days of paternity leave, on top of the legal allowance, available after one year of service.
Financial support: Life and disability insurance, salary advances of up to 3.5 times your net monthly pay, a €300 net marriage bonus, and access to Sage's employee stock purchase plan at a discounted rate.
Learning and development: Free premium subscription to external learning platforms
Health and Safety Responsibilities:
Fostering the safety culture, by leading with your own example.
Following established safety procedures and reporting potential hazards promptly helps maintain a secure and efficient workplace.
Participating in safety training sessions and adhering to preventive guidelines and procedures, the objective is minimizing risks and protecting yourself and the rest of your colleagues.
#LI-MD1