Data Analyst and Reporting Specialist

<h3>📋 Description</h3> • The Data Operations and Automations Analyst plays a critical role in managing, processing, and ensuring the integrity of large data sets within the energy sector. • This position involves data migration, acquisition, validation, and the development of automated tools and custom software solutions to enhance operational efficiency. • The role requires close collaboration with internal teams, clients, and third-party providers to deliver accurate reporting, billing, and data-driven insights that support business objectives. • The role also contributes to process documentation and continuous improvement initiatives. • Data migration: Required when onboarding new major clients with high volumes of data. This requires data to be organised, categorised, converted to the correct format, cleaned, and uploaded to the company systems. Also requires collaboration with other teams and BDMs. • Sourcing data: Deal directly with clients, metering providers, and third parties to request data and escalate data-related requests. • Bulk data downloads: Use third-party software, tools, and APIs to download data. • Converting and uploading data: Convert data to appropriate formats and upload to internal systems. • Reviewing bulk data: Check data for gaps, duplication, overlaps, and consistency, especially after bulk data migration. • Bill and report generation: Use and improve existing templates and tools to gather source data and generate utility bills and reports for tenants and clients. • Development (including coding) of new tools and templates as required: This may include templates/tools for reports, queries, Excel templates, Macros, etc. • Documentation: Maintain clear documentation for developed tools, processes, and software. Produce user manuals and technical guides as needed. • Analytical support: Assist in forecasting, accruals, tariff analysis, data verifications, and billing-related tasks. <h3>🎯 Requirements</h3> • Bachelor’s degree in IT, Data Analytics, Software Engineering, Engineering, or a related analytical discipline. • Minimum of 5 years of experience in data operations, analysis and automation or in a similar role. • Advanced proficiency in data manipulation and analysis using advanced Excel. • Skilled in data visualization tools such as Power BI, Tableau, or similar platforms (e.g., R). • Competence in scripting or programming with Python or R for data cleaning, analysis, and process automation. • Experience with automation using Visual Basic for Applications (VBA) to control Excel, Word, and Outlook. • Familiarity with relational databases and query languages, particularly SQL. • Strong analytical skills with attention to detail, accuracy, and effective problem-solving. • Excellent communication and collaboration abilities, adaptable to independent and team environments. • Proven time management, prioritisation, and a solutions-focused, professional work ethic. • Previous work experience in the Australian energy or finance industry highly desired. <h3>🏖️ Benefits</h3> • Work from home • Monday to Friday 7:00 AM – 4:00 PM PHT (adjustments will be made for daylight saving time) • Opportunities to work with leading companies in Australia and beyond • Comprehensive HMO and government-mandated benefits • Training programmes for career development • Engaging company outings, team activities and wellness sessions • Supportive, inclusive culture • Dedicated managers focused on your growth and success