As a Data Engineer, you will be enabling the business by providing data, reporting, and analytics solutions through developing and supporting Data Ingestion and transformation in our Unified Data Platform (UDP) based on Microsoft Azure Synapse Analytics.The salary for this role is $110k + super and this position is full-time permanent.What will you be doing?Identifying, researching, and integrating new data sources into the Unified Data Platform.Developing and maintaining data ingestion pipelines using Azure Synapse Analytics.Monitoring and sustaining data flows, ensuring seamless integration with various data sources.Documenting all processes and data objects involved in the data ingestion and transformation processes.Collaborating with project teams and analysts to understand and meet their data needs.Designing, testing, and deploying data transformations into production environments.Providing expert guidance on data provisioning for analytics and advanced analytics.Building and maintaining robust data models as specified by analysts.Ensuring data solutions remain effective and update them as necessary.Offering expertise on the capabilities of Azure Synapse Analytics.Creating optimal solutions for pushing data from the Unified Data Platform to other systems.Gathering and documenting user requirements for data integration and data warehouse solutions.Providing ad-hoc support to users of the Unified Data Platform.What are we looking for in you?Tertiary qualification, Bachelors and ideally Masters in a quantitative field such as Computer Science, Information Management, Mathematics, Engineering, Economics, Finance, Statistics, or in a Business/Commerce/Marketing discipline is mandatory.Commercial experience in the field of Data Engineering, preferably in Azure.Demonstrated experience in the development of data transformation processes using ETL (Extract, Transform & Load) tools.Understanding of business, particularly Motoring, Sales, Marketing, and Finance.Cloud Experience understanding of cloud principles and modern data warehousing in the Azure cloud. Experience of building solutions in Microsoft Fabric (Lakehouse, Synapse Data Engineering, Synapse Data Warehouse, and Real-time Intelligence).Experience of working with Delta Lake and Data warehouse.Experience of working on Meta Data Driver Framework.Experience with OCI.Proficient in SQL, Pyspark, PySQL.Proficient in Microsoft Power BI or other Business Intelligence tool.Knowledge of data modelling techniques and tools like ER diagrams, dimensional modelling, and tools like ERwin or Lucidchart.Desired knowledge/experience in real-time data processing and integration with Azure applications (such as MS Dynamics).Understanding of relational database concepts and Data Warehousing concepts.Experience in working with both structured and unstructured data.Advanced problem-solving skills and meticulous attention to detail.An understanding of Business Intelligence and reporting concepts and an awareness of Business Intelligence toolsets.A broad understanding of Information Management, Data Quality, Master Data Management, Data Governance, and Data Stewardship is not required, but would be beneficial.Proficient in the use of Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook.What can we offer you?Working in an environment that is embracing a continuous improvement culture using experimentation to support learning.Time dedicated to your personal development with access to training, development, and certification programs to ensure you can upskill.Being part of empowered, cross-functional agile delivery teams that work with the business to build systems that solve problems.Complete flexibility to choose between working from home or office with flexible hours for a better work-life balance.Building digital systems that will shape the future for the RAC and a better WA.Gain RAC Staff Benefits including free Roadside Assistance and 25% discount on your Insurances, Social Club, and access to Fitness Passport for cheaper gym memberships.About RACAs an Equal Opportunity Employer, RAC values inclusivity and promotes a workplace that actively seeks to welcome contributions from all people. We encourage people of all abilities, Aboriginal and Torres Strait Islanders, diverse cultures and backgrounds, LGBTIQ+ identities, and all age groups to apply.RAC is committed to flexibility. If you need assistance or adjustments to fully participate in the application process, please contact ****** UsRAC is a purpose-led member organisation.Established in 1905, RAC has evolved into one of the most trusted organisations in the state, with more than 1.3 million members. At RAC we don't have shareholders. That means we reinvest our profits for the better of our members and our State.Our Purpose is to be the driving force for a better WA.Our Vision to 2030 is to create a safer, sustainable, and connected future for Western Australians.Our Mission is delivering great member services and experiences, whilst inspiring positive community change that makes life better in WA.RAC is an equal opportunity employer. We continue to build an inclusive workplace where we respect and celebrate differences. We encourage applications from diverse groups including Indigenous and Torres Strait Islander people, physical ability, all ages, LGBTQI+ identities, all languages, and diverse cultures and backgrounds.
#J-18808-Ljbffr