Finance Data Specialist

Megaport; Brisbane; On-site; AUD 120,000 - 180,000; Full time

Job summary

Megaport is seeking a Finance Data Specialist to own and govern finance data across TM1, Power BI and Databricks. You will design TM1 models, develop TI processes, administer PAW, and build robust Power BI reports for planning and reporting.

You will collaborate with FP&A, Accounting and the Data team to ensure data accuracy, timeliness and clear data definitions, enabling trusted planning and decision-making.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Finance or related field.
• 3+ years' hands-on experience developing and administering IBM Planning Analytics / TM1.
• 3+ years' experience developing Power BI solutions with DAX, M and data modelling.
• Strong SQL skills; experience with Databricks or similar cloud data platform.
• Experience with data engineering teams and clear data requirements.
• Solid understanding of finance data, GL structures, budgeting and forecasting.

Responsibilities

• Design, develop and maintain TM1 models for budgeting, forecasting, consolidation and reporting.
• Build and maintain TI processes for data loads and automation.
• Administer TM1 PAW, security, backups and upgrades; support PAfE users.
• Design Power BI semantic models, reports and dashboards for finance and management.
• Create data models with Power Query and DAX; ensure performance and reusability.
• Own finance data in Databricks; define data structures, data lineage and governance.

Skills

TM1

Power BI

SQL

Databricks

Data modelling

Governance

Education

Bachelor's degree in Information Systems, Computer Science, Finance or related field

Tools

TurboIntegrator (TI)

PAW

PAfE

Databricks

Job description

The Finance Data Specialist owns the organisation's finance data, planning and reporting platforms. The role develops and administers the IBM Planning Analytics (TM1) environment, builds and maintains Power BI reporting, and acts as the finance data owner for the curated datasets in Databricks that underpin both.

Working within the Finance and Data Platforms team and partnering closely with Financial Planning & Analysis, Accounting and the Data team, the role ensures that finance data is accurate, well-governed, reconcilable to source systems and delivered in a form that supports planning, reporting and decision-making.

The successful candidate combines hands‑on technical capability in TM1 and Power BI, strong SQL and data modelling skills, and a solid understanding of finance data, processes and reporting requirements.

About Megaport

We’re not your typical tech company – and we don’t want to be. Megaport is the global leader in Network as a Service (NaaS), and has transformed the way businesses connect to the cloud, data centers, and each other. We’re publicly listed on the Australian Stock Exchange and partnered with the biggest names in tech like Amazon, Microsoft, Google, Oracle, IBM, and more. Headquartered in Brisbane with a crew of over 600 people spread across Asia‑Pacific, Europe, and the Americas, our employees enjoy an environment that is collaborative, supportive, and (actually) fun.

Our Team Culture

We’re a team of problem solvers, pixel pushers, code slingers, and cloud fanatics. Culture is more than a poster on the wall here – collaboration beats hierarchy, curiosity fuels our growth, and everyone’s voice matters. We take our work seriously, but not ourselves. We work across time zones to execute on our global vision, trust each other to get things done, and never compromise our values for commercial gain. Most importantly, we place our customers at the center of everything we do.

We’re committed to increasing representation in the tech industry and welcome applicants from all backgrounds. Don’t meet every requirement? That’s okay. If you’re excited about this role, we encourage you to apply.

What You’ll Be Doing

Planning Analytics (TM1) Development & Administration

Design, develop and maintain TM1 models supporting budgeting, forecasting, consolidation and management reporting, including cubes, dimensions, hierarchies, attributes, rules and feeders.

Build and maintain TurboIntegrator (TI) processes and chores for data loads, model maintenance and automation.

Administer the Planning Analytics environment, including security, server and instance configuration, backups, performance tuning and version upgrades.

Develop and maintain Planning Analytics Workspace (PAW) books and views, and support Planning Analytics for Excel (PAfE) users.

Support planning and forecasting cycles, including cycle set-up, data preparation, model changes and issue resolution during critical periods.

Maintain model documentation and ensure changes follow development, testing and release controls.

Power BI Development

Design, build and maintain Power BI semantic models, reports and dashboards for financial and management reporting.

Develop robust data models using Power Query (M) and DAX, following best practice for star-schema design, performance and reusability.

Implement and maintain row-level security, workspace structure, deployment pipelines, refresh schedules and gateways.

Work with Finance stakeholders to gather reporting requirements and translate them into intuitive, reliable reporting solutions.

Promote self-service reporting through certified datasets, clear documentation and user training.

Finance Data Management (Databricks)

Act as the finance data owner and subject‑matter expert for finance datasets in Databricks, defining how finance data should be structured, related and presented for planning and reporting.

Partner with the Data team, who own ingestion and data engineering, by providing clear requirements, business logic and data definitions for new and changing finance datasets.

Develop and maintain SQL views and finance‑specific models in the curated (reporting) layer that feed TM1 and Power BI.

Validate new and changed datasets before they are used for reporting, and monitor the ongoing completeness and timeliness of finance data.

Define access requirements for sensitive finance data and work with the Data team to apply them through Unity Catalog.

Own the flow of finance data between source systems, Databricks, TM1 and Power BI, ensuring a consistent, single source of truth.

Design and maintain reconciliation and data quality checks so that reported and planning data ties back to the general ledger and source systems.

Maintain finance master data and mappings, including chart of accounts, entities, cost centres, products and other reporting hierarchies, across platforms.

Investigate and resolve data discrepancies, working with system owners and Finance users.

Maintain clear documentation of TM1 and Power BI models, finance business logic, data definitions and data lineage.

Provide support and training to Finance users of TM1 and Power BI.

Proactively identify opportunities to automate manual reporting and data preparation, improve performance and simplify the finance data landscape.

Stay current with developments in Planning Analytics, Power BI / Fabric and Databricks, and recommend improvements.

Project Delivery

Contribute to finance systems and data projects, including new entity onboarding, planning model redesign, reporting uplift and new data sources.

Work with vendors and partners to ensure deliverables meet requirements and quality standards.

What We Are Looking For

Bachelor's degree in Information Systems, Computer Science, Finance, Accounting or a related field.

3+ years' hands‑on experience developing and administering IBM Planning Analytics / TM1, including cubes, rules, feeders, TurboIntegrator processes, security and PAW.

3+ years' experience developing Power BI solutions, with strong DAX, Power Query (M) and data modelling skills.

Strong SQL skills and experience working with Databricks or a comparable cloud data platform (e.g. Snowflake, Synapse, Fabric); familiarity with Python / PySpark is advantageous.

Experience working with data engineering teams, including writing clear data requirements and specifications.

Solid understanding of finance data and processes, including general ledger structures, financial statements, budgeting and forecasting, consolidation and multi‑currency.

Experience sourcing and modelling data from ERP systems (e.g. Dynamics 365 F\&O, NetSuite) and HRIS platforms.

Experience designing data reconciliation and data quality controls.

Understanding of data governance, security and access control in a finance context.

Familiarity with source control (e.g. Git) and structured development, testing and release practices.

Strong analytical and problem‑solving skills with close attention to detail.

Excellent communication skills, with the ability to work closely with Finance stakeholders and explain technical concepts to non‑technical users.

Relevant certifications are advantageous, such as Microsoft Power BI Data Analyst Associate (PL-300), Fabric Analytics Engineer Associate (DP-600), or IBM Planning Analytics certifications.

If you have any questions, please reach out to Megaport's Talent Acquisition Team at *******@megaport.com

NOTE: All Megaport business correspondence is conducted via our business email accounts (@megaport.com). If you have any concerns, please reach out to Megaport's careers team *******@megaport.com directly and we will verify the legitimacy of any communication. Megaport will not ask you to create an account via Microsoft teams, and does not associate with any email accounts under "@megaportau.com".

All applications will be treated in confidence.

Please see Part 2 of our Privacy Policy to see what information Megaport collects from job applicants, why, and how we store and use it. Note that you’re entitled to know what personal data of yours Megaport holds, to request updates, rectification, and in some circumstances restriction or deletion thereof if you object (you being entitled to withdraw your consent to our holding your information at any time). Please see Part 5 of our Privacy Policy for more details on this and how to contact Megaport's data protection officer if you have any further privacy‑related questions. Candidates who met the selection criteria will be invited to attend an interview. Strictly no Recruitment Agencies.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but does not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.