The Law Society of NSW is Australia's largest and most influential membership association for solicitors. We're not all lawyers, but we work together to support the legal profession and ensure a just society for all.

We are currently looking for a Data Integration Developer (Boomi & Oracle) to join our Information Management team.

About the role

The Data Integration Developer is dedicated to designing and implementing data integration and movement solutions across systems, with a strong focus on ensuring data accuracy through quality assurance testing. In this role you will be developing and maintaining the Society’s data integration platforms, particularly Boomi, while also contributing to the support of the data platform on Azure. You will support and enhance the existing regulatory platform on Oracle and leading the migration from Oracle BPM to Boomi.

You will also play a critical role in designing, implementing, and managing seamless data integration solutions that enhance efficiency and drive innovation within the organisation, and in advancing the Society’s digital transformation initiatives.

What you'll be doing

Boomi Integration and Flow development
- Design, develop, and manage end-to-end Boomi integration processes and flows
- Build efficient workflows to connect diverse systems, ensuring seamless data exchange
- Troubleshoot, enhance, and optimize existing Boomi flows for performance and reliability
Oracle Database expertise
- Develop, test, and maintain complex PL/SQL scripts, stored procedures, and triggers
- Optimize Oracle database performance, ensuring data integrity and scalability
- Collaborate with teams to design efficient database schemas and streamline workflows
Define the Data and Data Integration strategy
- Focus on business decision automation through quality information
- Develop a single source of information truth for all business users
Administer and apply data-fixes to both internally and externally developed business-critical systems
Troubleshoot and correct issues on various application databases such as Oracle and Azure SQL
Identify potential faults within the Data Integrations and Data Warehouse and take a proactive approach to address the issue
Pro-actively engage with various business stakeholders to encourage adoption and automation using the Information Management services
Collaborate with cross-functional teams to analyse business requirements and deliver integrated solutions
Provide technical guidance and mentoring to other developers and team members
Document system processes, configurations, and best practices
Ensure clear processes are in place for new request management
Collaborate with cross-functional teams with the maintenance of our Azure Data & Integration platform
Report on task/project progress to manager
Focus on improving / maintaining the perception of IT within the business
Provide training to staff (both internally and externally) on IT IM Services
IT Reporting
Ensuring all policies, procedures and processes are followed at all times
Maintain all documentation for continual use and ease of new staff joining the team
Any other reasonable tasks / requests as directed by IT Management
Support a collaborative and progressive team environment
Standardise and highlight improvements to services
Providing and maintain troubleshooting support and knowledge sharing across IT

About you

3+ years of hands-on experience with Boomi integration and flow development
3+ years of hands-on experience in Oracle PL/SQL and database management
Familiarity or hands-on experience with Azure data services or a strong willingness to learn
3+ years designing and developing Data Integration and Data Warehouse solutions including ETL design and data modelling
5+ years providing support to both internally and externally developed business-critical production
1+ years of Azure Data Factory, Azure SQL, Azure Data Lake, Logic Apps, Power Automate, Databricks
1+ years of Dev-Ops processes (including CI/CD) and Infrastructure as code fundamentals
1+ years of experience with Visual Studio, PowerShell Scripting, and ARM templates
Solid understanding of data integration and ETL/ELT processes
Proficient in Oracle database optimization techniques
Strong data analysis, discovery and problem-solving skills
Fundamental Azure SQL and Oracle SQL database administration skills
Understanding of various Datawarehouse methodologies such as Data Vault and Kimball
Previous experience with architect standards for data integrations
Previous experience with development on data warehouses and data marts using dimensional modelling

Preferred Qualifications

Certifications in Boomi, Oracle Database, or Azure technologies
Experience with big data solutions, real-time data streaming, or machine learning pipelines
Tertiary qualifications in Information Systems, Computing Science or similar

Personal attributes

Strong time management skills and attention to detail
Ability to focus on end user needs and to champion them within the IT Team
Excellent communication skills, both written and verbal, delivering a high level of customer service.
‘Can do’ attitude with the willingness to further develop skills.

To apply

The Law Society of New South Wales is committed to building and maintaining a respectful and inclusive workplace, appointing the best person for the role and supporting diversity.

Applications should contain a CV and cover letter that outlines your key experience and motivations for this role.

The Law Society of NSW

About Us

Latest Jobs

Data Integration Developer (Boomi & Oracle)