Squadron Energy banner

Databricks and Power BI Report Developer

Squadron Energy

The Role

Overview

Develop data pipelines in Databricks and build Power BI dashboards for renewable energy analytics.

Key Responsibilities

  • power bi
  • databricks
  • etl development
  • data pipelines
  • ci/cd automation
  • data governance

Tasks

Reporting to the Analytics, Compliance and Lifecycle Manager, you will work closely with our Lead Reporting and Data Analyst to help define business needs, transforming these into robust designs and delivering fit-for-purpose data pipelines and BI solutions. Connecting teams to data through prototyping solutions before delivering automated outcomes, this role will assist in delivering end-to-end Business Intelligence solutions for Squadron's fleet of assets across a broad range of operational data sources. Your output will be diverse across a range of skills, focusing on the production and enhancement of data pipelines, models and reports to form an integrated suite of reliable Business Intelligence solutions for the business. This role may involve travel to other office locations and sites to engage and liaise with broader Squadron Energy (SQE) teams and relevant stakeholders. -Leverage Microsoft Copilot internally to supercharge productivity and streamline problem-solving. -Develop complex Reports, Apps and Dashboards in Power BI to produce clear and insightful visualisations to aid effective business decisions -Produce and maintain clear documentation for pipelines, procedures, models and reports, including technical and business user documentation. -Power BI Report development, via simple prototyping through to fully automated production data pipelines and models. -Optimize performance: Tune Spark workloads, cluster configurations, and storage strategies for optimal speed and cost. -Take ownership of issues, incidents & enhancements and drive to successful outcomes with minimal or no supervision. -Facilitate the expansion of self-serve analytics and future Databricks solutions -Collaborate with high-calibre teams of data professionals and business stakeholders to deliver insights that matter. -Mentor data analysts on tools, processes and coding standards. -Harness the power of Databricks AI Assistant and Genie, using natural language prompts to generate SQL and Python code, and natural language exploration of data and analysis and generation of dashboards. -Automation & CI/CD: Implement automated testing, orchestration, and deployment for continuous integration and delivery. -ETL/ELT development: Create modular ETL/ELT workflows using Delta Lake for reliable batch and streaming jobs. -Design and deliver dashboards within Databricks and Power BI. -Design & build scalable pipelines: Develop and manage data pipelines on Databricks to ingest, transform, and load large datasets efficiently. -Gather and document business requirements and translation to deliverable User Stories / Epics through detailed data analysis. -Data quality & governance: Implement data quality checks, lineage tracking, and governance frameworks to ensure reliability and compliance.

Requirements

  • sql
  • python
  • power bi
  • databricks
  • tableau
  • scada

What You Bring

With proven experience and expertise across the project lifecycle, we work with local communities and our customers to lead the transition to Australia's clean energy future. This role requires creative solutions to business problems and keeping experience in current technologies (Databricks). The ability to foster strong relationships and have a strong customer focus with the ability to communicate clearly, accurately, and persuasively is critical. -Knowledge of databases, entity relationship modelling, and dimensional modelling -Experience designing data solutions, architecture, and configuring security -Proficiency in SQL, Python, R, DAX, MDX or similar, translating complex logic into stored procedures, views & indexes -Strong data visualisation skills using Power BI, Tableau, or Grafana -Time management to balance delivery of current business reporting needs with automation and improvements of future-state reporting and analytics tools -Ability to communicate effectively with operational, technical, finance and commercial teams. -Demonstrated knowledge of Databricks and Power BI Experience -Familiarity with real-time data systems like SCADA and Historian -Experience in thinking outside the box and utilising non-BI technical solutions to better enable our customers is highly regarded, notably demonstrated experience in PowerApps and Power Automate. -Skilled in building and optimising complex Power BI reports and semantic models -Operational reporting and analysis experience in energy / asset-intensive industries

Benefits

-Be part of a greenfield build with limited legacy constraints, just modern, scalable solutions which you can help build.

The Company

About Squadron Energy

-Rapidly scaled renewable capacity after 2022 acquisition, becoming Australia’s largest clean energy platform. -Backing from Tattarang and Andrew Forrest. -Uungula Wind Farm (414 MW, 69 turbines) construction began in early 2024. -Clarke Creek hub—a $3 billion dual wind-solar-storage project powering 330,000 homes. -Advancing Port Kembla LNG import terminal and dual-fuel power station in NSW. -Pioneering Koorakee Energy Park with 1 GW wind, solar, and battery capacity each. -Minority stakes in Sun Cable and Windlab for technological diversity. -Weaves together full clean energy spectrum from wind farms to LNG terminals and hydrogen-ready power stations. -Combines fast-tracked gas infrastructure with renewable projects to shape Australia’s energy future.

Sector Specialisms

Energy

Infrastructure

Solar

Wind

Security Clearance

-reference checks -national police check -other applicable background screening