Apply now Job no: 493272 Work type: Permanent full time Location: Adelaide Categories: Information Technology Active is looking to appoint SQL Report Developer to be based in either Adelaide or SydneyThis role reports to the Reporting Manager. Working in the reporting team, collaborating with Analysts to deliver reporting solutions. Leveraging relational database knowledge and core Business Intelligence best practices to provide a solid foundation to support analysts in developing and serving reports that support operational and management decision making processes.In this role you will:Develop, maintain, and optimize SQL databases, tables, views, stored procedures, and functions.Design and implement efficient and accurate ETL processes for data extraction, transformation, and loadingDevelop and improve solutions spanning data processing activities into SSASDevelop and improve Microsoft Analysis Services cubes (tabular and dimensional)Be proficient in MDX and DAXAssist analysts with the design, development, and maintenance of interactive dashboards and reports using industry-leading BI tools. Work with the reporting team to deliver on the reporting strategy.Work closely with other analysts, developers and other stakeholders to deliver on required reporting. Track all work in JiraEffectively communicate with stakeholders on the delivery of reports.Monitor database performance, conduct regular performance tuning, and recommend optimization strategies. Identify and resolve data quality issues, performance bottlenecks, and other database-related problems. Implement and enforce data security measures, ensuring compliance with relevant regulations and standards. Document database structures, processes, and procedures for future reference and knowledge sharingWhat can we offer you:Flexible working from home arrangementsA market competitive remuneration package between $100,000 and $120,000 plus superannuationLaptop and phone providedEmployee Benefits – Discounts on products and servicesGenerous carbon neutral organisation that cares for the environment, wildlife and promotes from withinA positive and collaborative culture that allows you to own and grow your ideasWhat we are looking forBachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience)Experience in the Vegetation Management industry highly desirable. Proven experience as an SQL and reporting DeveloperProficiency in SQL programming, database design, and optimization techniquesSolid experience with ETL processes and toolsUnderstand and experience with Microsoft BI Stack (specifically PowerBI, SSRS, SSIS & SSAS)Possess a strong understanding of data visualisation best practices, data modelling concepts, and have hands-on experience with BI reporting tools such as Power BIExcellent communication and collaboration skills, cross teams with a mix of technical areas as well as non-technical operations and managementFamiliarity with data modelling and database administrationAbout ActiveWe are an Australian family-owned essential service with a national footprint and a workforce of 800 committed to delivering arboriculture, vegetation management, and green asset consultancy services. Comprising of Active Tree Services, Active Green Services and Aerial Access, we have been around for 45 years, and work to keep our communities safe and green while making sure our teams safety comes first.Visit our website to learn more about our people, customers and communities in which we work. Learn about the practical support we provide to many Australia run charities.If you want to Make Australia Your Office click "Apply Now"Advertised: 11 Jun 2024 Cen. Australia Standard TimeApplications close:Update your details, view your application and progress >> Login #J-18808-Ljbffr
