Senior BI Developer

• Impactful work that helps make a difference to the Australian people.
• Hybrid work with ability to work in the office and from home
• 1 year fixed term salaried contract

More sense, less common

The Reserve Bank of Australia is embarking on a Core Modernisation (CoreMod) program which involves a major upgrade of core technology infrastructure. This program is a technology driven program to consolidate, migrate and/or replace core infrastructure components across our data centres. It requires Bank-wide involvement to discovery, migration and/or uplift of business applications/services and IT infrastructure, including database, servers, network components.

We are seeking a Senior BI Developer to join our dynamic data team to participate on the CoreMod program. The ideal candidate will have working knowledge in data modelling, data architecture, and the design of scalable, high-performance data solutions. In this role, you will lead efforts to design and optimize data structures, build complex data models, and ensure the integrity and quality of data across multiple systems.

You will work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to ensure that data solutions meet organizational needs. Your skills in data design/modelling, database design, and data preparation for visualisation using MS SQL, PowerBI DAX and Cloudera data flow would be highly desirable. You will also possess advanced technical expertise in database management, optimization, and troubleshooting to contribute to the implementation of database solutions for enterprise-level applications and infrastructure migration.

Objectives

• Migrate business applications/services from the Bank’s legacy data centres to the target state environments, ensuring security, availability, reliability, scalability, and long-term operational sustainability, while mitigating risks from core infrastructure obsolescence and strengthen the resilience of mission-critical systems.

• Provide technical expertise, design and implementation for the data discovery, integration, modelling, transformation, visualisation, and database management activities.

• Undertake the more complex design, programming and problem resolution tasks and ensure that systems and reports are tested for quality assurance.

• Develop and support effective data modelling and development capabilities to deliver the CoreMod program data requirements.

• Develop and support BI technologies such as SQL, Cloudera and data engineering technologies.

• Ensure that system development standards are maintained and participate in code reviews.

• Maintain a working knowledge of tools and software packages used.

• Work collaboratively with business stakeholders to refine business requirements.

• Ensure that system development standards are maintained and participate in code reviews.

• Ensure all system documentation complies with relevant IT Standards.

• Working knowledge of Agile methodologies, processes, principal and practices.

Technical Capabilities

• Demonstrated knowledge in Data Warehousing and data modelling.

• Demonstrated experience in cloud and data engineering technologies such as Azure, Cloudera, Spark, Python.

• Demonstrated knowledge of Microsoft BI technologies including SQL Server, SSRS, SSIS and SSAS.

• Demonstrated knowledge of the BI Development Life Cycle.

• Demonstrated knowledge of unit, integration and performance testing frameworks.

• Demonstrated knowledge of Continuous Integration / Continuous Delivery practices and tools.

• Demonstrated knowledge using the IBM InfoSphere suite such as IBM DataStage, QualityStage, Information Analyser and IGC.

• Design and optimize ETL/ELT pipelines, ensuring data from various sources (e.g., operational systems, third-party APIs, cloud platforms) is transformed and integrated accurately for reporting and analytics.

• Work on optimizing large-scale databases and ensuring efficient data storage and retrieval. Perform database tuning and query optimization to support high-performance applications and analytics.

• Work closely with business analysts, product teams, and data engineers to understand data requirements and design models that align with business goals. Advocate for data governance best practices and ensure adherence to data quality standards.

• Define data quality rules, develop data validation procedures, and ensure consistency and integrity across different data systems. Implement and monitor data governance policies to ensure data is accessible, accurate, and secure.

• Maintain comprehensive documentation of data models, architecture, and design decisions. Create and update data dictionaries, standards, and guidelines for other teams to follow.

Application Close :

.