Benefits
- Contribute to an innovative data automation project supporting meaningful HR and payroll work
- Work within a collaborative and high-performing Payroll, IT & HR team.
- Flexible working arrangements.
- $50ph-$60ph + Super
The Overview
We're partnering with a respected national not-for-profit organisation to recruit a technically skilled Data Automation Developer. This handson role requires expertise in Python and Excel automation to streamline data workflows, ensure accuracy, and maintain existing workbook structures. You'll work closely with Payroll, HR, and IT teams to automate data processing, append datasets to per-employee Excel files, and preserve formulas and formatting.
What You'll Do
- Develop Python scripts or small automation frameworks to process and clean master datasets (Excel format).
- Group and filter data by employee identifiers and append to employee-specific Excel workbooks.
- Maintain existing workbook formatting and formulas while updating data.
- Log all processing steps and handle missing or invalid files gracefully.
- Collaborate with the IT Project Manager to understand data structures, naming conventions, and file storage locations.
- Ensure the solution is maintainable, documented, and easy for non-developers to run and understand.
What They're Looking For
- Strong Python skills, including experience with pandas, openpyxl/xlsxwriter, and file handling (pathlib/os).
- Proven experience building ETL-style automations involving Excel.
- Ability to read, clean, group, filter, and merge data efficiently.
- Experience maintaining Excel workbook structures and formulas when appending new data.
- Ability to design maintainable scripts with logging, configuration, and error handling.
- Strong attention to detail and accuracy, with the ability to translate business rules into technical workflows.
If you're a detail-oriented Python developer who thrives on automating processes and supporting meaningful work in the not-for-profit sector, we'd love to hear from you - Apply now, or call Bel on 0435 778 351 for a confidential chat.