Finance Data Architect: TM1 & Power BI

Kinetic IT

Canberra

On-site

AUD 120,000 - 160,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Megaport is seeking a Finance Data Specialist to own finance data, develop TM1 models, build Power BI reports, and manage Databricks datasets underpinning planning and reporting.

You will collaborate with Finance, Data, and FP&A teams to ensure data accuracy, governance, and timely delivery of insights for planning and decision-making.

The role requires hands-on TM1, Power BI, SQL, and data modelling skills, with strong stakeholder communication and a finance data background.

Qualifications

  • 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.
  • 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.
  • Experience sourcing and modelling data from ERP systems (e.g. Dynamics 365 F&O, NetSuite).
  • 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.

Responsibilities

  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

Skills

TM1 development
Power BI development
SQL
Data modelling
Analytics
Communication skills

Education

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

Tools

IBM Planning Analytics / TM1
Power BI
Databricks
Git

Job description

Megaport is seeking a Finance Data Specialist to own finance data, develop TM1 models, build Power BI reports, and manage Databricks datasets underpinning planning and reporting.

You will collaborate with Finance, Data, and FP&A teams to ensure data accuracy, governance, and timely delivery of insights for planning and decision-making.

The role requires hands-on TM1, Power BI, SQL, and data modelling skills, with strong stakeholder communication and a finance data background.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Finance Data Architect: TM1, Power BI & Databricks
Finance Data Architect: TM1, Power BI & Databricks

atWork Australia • Gold Coast City

On-site
AUD 180,000 - 240,000
Finance Data Architect: TM1, Power BI & Databricks
Finance Data Architect: TM1, Power BI & Databricks

WebHosting • Brisbane

Hybrid
AUD 120,000 - 170,000
Finance Data Architect — TM1, Power BI & Databricks Expert
Finance Data Architect — TM1, Power BI & Databricks Expert

atWork Australia • Gold Coast City

On-site
AUD 120,000 - 160,000
Finance Data Architect: TM1, Power BI & Databricks
Finance Data Architect: TM1, Power BI & Databricks

Essential Energy • Gold Coast City

On-site
AUD 120,000 - 170,000
Finance Data Specialist
Finance Data Specialist

WebHosting • Brisbane

Hybrid
AUD 120,000 - 170,000
Finance Data & Treasury Analyst
Finance Data & Treasury Analyst

FTI Consulting, Inc • Brisbane

On-site
AUD 110,000 - 150,000
Gis Systems & Data Specialist
Gis Systems & Data Specialist

Essential Energy • Gold Coast City

On-site
AUD 120,000 - 170,000
Finance Data Architect: Tm1, Power Bi & Databricks
Finance Data Architect: Tm1, Power Bi & Databricks

atWork Australia • Gold Coast City

On-site
AUD 120,000 - 160,000
Head Of Bi & Data Strategy (12-Month Contract)
Head Of Bi & Data Strategy (12-Month Contract)

atWork Australia • Gold Coast City

On-site
AUD 180,000 - 240,000
Finance Data Architect — Power BI & Reporting Transformation
Finance Data Architect — Power BI & Reporting Transformation

Sharp & Carter • Brisbane

On-site
AUD 90,000 - 120,000
Top locations