Our WhyDatacom works with organisations and communities across Australia and New Zealand to make a difference in people's lives and help organisations use the power of tech to innovate and grow.About the Role (your why)The Support Developer is responsible for:developing, deploying and maintaining data warehousing artefacts, ETL artefacts, and providing operational support on these artefacts in a BAU environment,supporting BAU BI Solutions by monitoring and tuning queries and data loads, addressing issues regarding data Integrity, monitoring performance and communicating functional and technical issues,debugging, monitoring, optimising and troubleshooting database solutions,contributing to the design and development of data models, developing and performing ETL processes to meet business requirements,researching and delivering best practices methodologies.What you'll doMaintaining and supporting the enterprise data/reporting platform so that it can provide reliable, timely, performant and accurate information to business users.Providing assistance and support to all Datacom users with respect to the data/reporting platform, including internal users who are using and manipulating data.Adhering to data warehouse design and quality best practices in accordance with established principles and design philosophy within Group Data.Design and development of efficient queries, stored procedure and functions for reportingDefine and clarify requirements, propose and develop appropriate solutions, and provide feedback to the reporting team and internal customers.Monitoring and evaluating key performance indicators, forecasting and trends.Takes reasonable care that their actions (or inactions) do not harm the Health and Safety of self or others. Reports all incidents, hazards or unsafe work practices as per Datacom policyEstablish and maintain automation processes with a large range of internal and external data sourcesCreate and maintain required documentationServes as the subject matter expert for Microsoft SQL Server related toolsEnsure that issues encountered in production environments are resolved in a timely manner.Perform performance tuning / query optimisationConduct regular maintenance and improvements to queries and databasesAdapt quickly and effectively to changes in departmental or strategic priorities by responding to requests for additional ad hoc requestsPerform data reconciliation/verification of reporting requirementsWhat you'll bringStrong analytical skills and experience of writing complex SQL queriesStrong working knowledge of SQL Server RDBMS including SQL Server Integration Services (SSIS)Working knowledge of any other business intelligence/data visualisation tools e.g. Tableau, Microsoft Power BI, Qlik, SAS Visual analyticsBusiness Requirements Analysis and DocumentationDemonstrates strong verbal and numerical skills (complex calculations, data analysis and reconciliation, numerical and verbal logical reasoning)Ability to develop strong relationships with key contactsChange ManagementStrong problem-solving skillsStrong attention to detailTime management & ability to work under pressureMinimum 1 year experience working in a BI, Analytics, Reporting, Database management roleStrong Database systems experienceStrong ETL experienceAwareness of Business Intelligence and analytical concepts, data visualisation techniquesWhy join us here at Datacom?Datacom is one of Australia and New Zealand's largest suppliers of Information Technology professional services. We have managed to maintain a dynamic, agile, small business feel that is often diluted in larger organisations of our size. It's our people that give Datacom its unique culture and energy that you can feel from the moment you meet with us.We care about our people and provide a range of perks such as social events, chill-out spaces, remote working, flexi-hours and professional development courses to name a few. You'll have the opportunity to learn, develop your career, connect and bring your true self to work. You will be recognised and valued for your contributions and be able to do your work in a collegial, flat-structured environment.We operate at the forefront of technology to help Australia and New Zealand's largest enterprise organisations explore possibilities and solve their greatest challenges, so you will never run out of interesting new challenges and opportunities.We want Datacom to be an inclusive and welcoming workplace for everyone and take pride in the steps we have taken and continue to take to make our environment fun and friendly, and our people feel supported.
#J-18808-Ljbffr