Add expected salary to your profile for insightsFounded in 1993, Localsearch proudly stands as one of Australia's largest digital marketing powerhouses, empowering over 300,000 local businesses nationwide.Our dedicated teams provide nationwide client support, fostering a culture of collaboration and innovation.What will you do? Localsearch's Analytics and Business Intelligence team services internal business units and is responsible for complex client-facing reporting associated with a large percentage of Localsearch's revenue.Therefore, we are looking for a proficient and experienced BI Developer with strong data warehouse skills to join our high calibre Analytics and Business Intelligence Team.Reporting to the Head of Data, you should understand advanced and modern approaches to cloud data warehousing and Agile development practices.You should be capable of delivering high-quality outcomes for both clients and staff.You should be collaborative in the data space and thrive in a fast-paced environment.You would:Assist in the design and development of robust data warehouse solutions that power our business intelligence initiatives.Contribute technical expertise to cloud migration initiatives and strategic business projects.Create and optimise data pipelines that are resilient, scalable, and ready for growth.Support "Business as Usual" requests by providing technical expertise in Snowflake SQL optimisation.Collaborate with business stakeholders to understand requirements and deliver data solutions.Maintain and enhance our data warehouse documentation and processes.Who are you & what will you bring? You are an experienced data professional who brings:Proven experience with ETL tools and data warehouse development.Expertise in dimensional modelling and data warehouse architecture.Experience with Snowflake cloud data warehouse platform.Strong SQL skills with emphasis on Snowflake SQL development.Strong analytical and problem-solving abilities.Excellent communication and documentation skills.Ability to work independently while contributing to team success.Detail-oriented approach with a focus on quality.Required to have at least 3+ years' experience with:Snowflake cloud data warehouse development and administration.Advanced SQL (including DML, DDL) and JSON data handling.Design and implementation of Operational Data Stores (ODS).Dimensional modelling including fact/dimension design.Data Mart development and presentation layer design.CI/CD pipelines using GitLab or similar version control systems.Desired experience with:Matillion ETL tool for cloud data integration.Design and implementation of metadata-driven ETL frameworks.Experience with real-time data streaming and analytics platforms.Strong understanding of AWS data-related technologies.Kimball dimensional modelling methodology and best practices.Why it's great to work with us! Perks - Paid parental leave, free parking, discounted gym memberships, and a café with barista-made coffee.Location - Directly opposite Robina Town Centre.Culture - We celebrate success!Flexibility - We prioritise work-life balance.Development - We're dedicated to helping you build a meaningful career.Wellbeing - Our comprehensive program addresses various needs.All candidates applying for this position must be a Permanent Resident/Citizen of Australia and be within commutable distance of our Gold Coast office. APPLY NOW! At Localsearch we are committed to providing an inclusive workplace and are proud to be an equal opportunity employer. #J-18808-Ljbffr