Data Engineer — Penrith, Penrith Area

Expired

Data Engineer 2 X permanent full-time opportunities available Responsible for the design, implementation, and maintenance of data solutions on the Azure platform Work with an inclusive and diverse team About us Pacific National (PN) is the largest private provider of diversified rail freight services in Australia. We haul a variety of freight including coal, intermodal containers, steel, and a range of bulk commodities and materials that keep the region's economy, businesses and households running. We are a company built on solid foundations and we are incredibly proud of the essential role we continue to play supporting Australia's supply chain. At Pacific National, we take great pride in delivering our best every day and have a relentless focus on customer service and place safety above all else. We operate nationally with approximately 3,500 staff in over 90 sites across Australia. We respect and care for the communities in which we operate and continue to evolve our community engagement and strengthen relationships through partnerships and investment. We are focused on reducing the carbon emissions of our business, while also enabling the reduction of carbon emissions in the broader supply chain to support the National targets. About the role The Data Engineer is responsible for the design, implementation, and maintenance of efficient and performant data solutions on the Azure platform. The role includes the development of ETL/ELT processes, transforming and loading data from diverse sources, ensuring data integrity is maintained and the design / build of logical and physical data models to support analytic and reporting solutions. Key responsibilities will include: Develop and maintain scalable data pipelines using ADF, Azure Databricks and other relevant technologies to extract, transform, and load ETL data from diverse sources. Implement data integrations and data cleansing processes to ensure data quality and consistency. Optimise data pipelines for performance and efficiency, considering factors like data volume and processing time. Engaging with business users, business/technical analysts, data scientists, data architects and others to understand the data requirements for project deliverables. Monitor and optimise data pipelines, databases, and query performance to ensure efficient and timely data processing. Configure and optimise Azure Databricks for efficient data processing and analysis, ensuring high availability and scalability. Undertake IT application-related problem diagnosis, implementing problem resolution or prevention measures as appropriate. About you: Are you a dynamic and experienced Data Engineer with a passion for transforming data into actionable insights? We are seeking an individual who possesses a unique blend of technical expertise, industry knowledge, and collaborative spirit to join our innovative team. To be successful in the role you will need: 3 plus years as a practicing Data Engineer within a Data and Analytics team. Tertiary qualifications in Computer Science, Information Technology, Engineering, or a related discipline and/or demonstrated competence and experience appropriate to the position. Essential experience with Azure Cloud Technologies and platforms Microsoft Azure SQL Data Warehouse, Synapse and Azure Databricks. Strong skills across a number of scripting, programming and querying languages: PySpark, SQL, TSQL, Python, pandas, PowerShell, Azure CLI. Customer focus and goal orientated with keen attention to detail. Strong communication and interpersonal skills, with an ability to communicate effectively and professionally with the Internal IT team, vendors, partners, and customers. Experience in transport, logistics, engineering, or utilities industries would be advantageous. The benefits At Pacific National we value diversity, inclusion, and the contribution of each team member. Our values underpin our commitment to create an inclusive culture where everyone is accepted and valued for who they are, enabling everyone to bring their authentic selves to work. When you join the Pacific National team, you'll be encouraged to take ownership of your career and we'll be there to support you with a range of exciting initiatives including: Industry leading programs focussed on your growth and career development Paid parental leave up to 12 weeks for primary carers at full pay after 12 months service Opportunity to purchase additional annual leave Flexible working arrangements (subject to business needs) A focus on your mental health and wellbeing through our PeerConnect program Access to our Employee Assistance Program, administered by Benestar, offering confidential counselling services for employees and their eligible family members, paid for by us at no cost to you Access to Unmind, a digital platform that gives you access to tools, training and exercises that will support your mental wellbeing Discounted fitness and wellbeing benefits with membership to WhereFit, our wellbeing benefits partner Novated leasing and discounts on selected health insurance funds, travel, retail brands, vehicles and more. We are proud to be a WORK180 Endorsed Employer for women, and you can visit our Work180 page Pacific National | WORK180 Endorsed Employer https://work180.com/en-au/for-women/employer/pacific-national to find out more including a list of all of our benefits and policies. We are seeking applicants who share our values: Make it simple, Share More, Kindness, Gratitude, Curiosity, and Own it. These values help us achieve strong connections with everyone we work with and play an important part in motivating us all to do our best work. Do you need reasonable adjustments during the recruitment process? If you need an adjustment in the recruitment process, please outline at the time of your application. Closing date Applications close on the 15th of December 2023. Next steps Are you ready to be part of our future? To apply, please click on the 'Apply' button below and follow the prompts. To find out more about Pacific National, our benefits and opportunities we offer, visit our careers page: www.pacificnational.com.au/careers http://www.pacificnational.com.au/careers Acknowledgement of Country We acknowledge the Traditional Custodians of the land on which we work, live and rail. We pay respect to Elders past, present and future and to the continuation of cultural, spiritual and educational practices of all Aboriginal and Torres Strait Islander peoples.