Data Engineer Assistant

3 days ago


Auckland, Auckland, New Zealand University Partnerships Full time

About the opportunity

** This is a 6-month fixed term position with an ideal start date of early April **

We are looking for a highly motivated and fast-learning Data Engineer Assistant to support our Azure Data Lakehouse migration. The ideal candidate should have a strong background in SQL development and optimization, experience working with cloud data platforms (Azure or AWS), and a passion for improving query performance and reporting solutions.

As part of this role, you will be responsible for refactoring SQL Server queries to Databricks Spark SQL, optimizing long-running queries, and rebuilding Power BI reports to align with our new data lakehouse architecture.

Key Responsibilities

  • Refactor SQL Server queries into Databricks Spark SQL for performance and scalability.
  • Optimize complex SQL queries.
  • Work with Azure Data Lakehouse (ADLS, Databricks, ADF) to migrate and transform data.
  • Test Power BI reports to ensure efficient querying and accurate insights.

Required Skills & Experience

  • Strong expertise in SQL & query optimization (CTEs, joins).
  • Familiarity with Power BI development.
  • Ability to analyze and refactor complex queries into efficient execution plans.
  • Fast-learning, strong problem-solving skills, attention to detail, and ability to work independently.

Nice to Have

  • Knowledge about SQL Server and Data Lake Storage (ADLS).
  • Experience with Azure Databricks / Fabric.
  • Familiarity with Delta Lake and Lakehouse architectures.
  • Knowledge of Python / PySpark for data transformations.
  • Previous experience in a data migration project.

Who we are:

UP Education is a leading Australasian dual-sector education group, delivering foundation, vocational and higher education to domestic and international students. At UP Education, we are on a mission: to elevate and empower students to unlock their potential.

What sets us apart from other tertiary providers? It is, quite simply, our people. Our teams come from a wide range of educational and cultural backgrounds and offer a broad diversity of professional experience. But we all have one thing in common – we are all firm believers in the power of education to transform lives and have the drive to make a significant impact in the communities with which we work.

We believe learning should be defined by the exceptional and at UP Education we have an ongoing commitment to the development of our staff.

To find out more about us, please visit https://www.up.education/

Why work with us

  • Flexible working with a hybrid work arrangement balancing between home and our office based in central Ponsonby.
  • Supportive team environment with ongoing commitment to professional development and career progression.
  • Fantastic opportunity to be part of an energising team and growing company.

Our application process:

To apply for this position, please submit your resume and a cover letter detailing your relevant experience and interest in the role.

Questions about your identity help us appreciate the diversity of individuals looking to work at UP Education, ensuring we're attracting applications from people with identities and perspectives that are as diverse as our students. These are voluntary disclosures and candidates can elect not to answer these questions.

We are an equal opportunity employer. As part of our commitment to equity, we work to ensure a fair and consistent interview process. We celebrate diversity and we are committed to an inclusive work environment.

#J-18808-Ljbffr
  • Cyber Security Engineer

    27 minutes ago


    Auckland, Auckland, New Zealand Ntt Data Full time

    **Job Description:**Ntt Data is seeking a skilled Cyber Security Engineer to join our team. As a Cyber Security Engineer, you will be responsible for performing a variety of Endpoint security, vulnerability management, and Security Incident response based engineering activities.This includes applying your analytical, reasoning & specialised technical...

  • Ms Engineer

    5 hours ago


    Auckland, Auckland, New Zealand Ntt Data Full time

    Job Description Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible.We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society.Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Your day at NTT DATAThe...


  • Auckland, Auckland, New Zealand Xero Full time

    About XeroXero is a leading cloud-based accounting software company that empowers small businesses to supercharge their financial management. Our innovative solutions help businesses automate routine tasks, gain actionable insights, and connect with the right data, advisors, and apps.The Role of the Head of Engineering - DataWe are seeking an experienced and...

  • Data Engineer

    1 day ago


    Auckland, Auckland, New Zealand Dataengine Full time

    SummaryWe're looking for a skilled Data Engineer with a strong data engineering background to be a part of our consulting practice.This role focuses on implementing and optimising scalable data architectures, including data lakes, data warehouses, and data pipelines.The ideal candidate has deep expertise in data engineering, modelling, and cloud-native...


  • Auckland, Auckland, New Zealand UP Education Full time

    About The OpportunityThis is a 6-month fixed term position with an ideal start date of early April.We are looking for a highly motivated and fast-learning Data Engineer Assistant to support our Azure Data Lakehouse migration. The ideal candidate should have a strong background in SQL development and optimization, experience working with cloud data platforms...


  • Auckland, Auckland, New Zealand Aboitiz Data Innovation Full time

    Aboitiz Data Innovation (ADI) is one of the leading up and coming start-ups in the field of Data Science and Artificial Intelligence.We believe data can drive change for a better world by advancing businesses across industries and communities.We are seeking a skilled Senior, Frontend Engineer with expertise in Next.js to join our innovative team.The ideal...

  • Next.js Engineer

    2 days ago


    Auckland, Auckland, New Zealand Aboitiz Data Innovation Full time

    At Aboitiz Data Innovation, we believe that data can drive change for a better world by advancing businesses across industries and communities. We are seeking a skilled Senior, Frontend Engineer with expertise in Next.js to join our team and help us create innovative web applications.Key ResponsibilitiesDesign and develop high-quality, responsive web...


  • Auckland, Auckland, New Zealand Fulcrum Decision (Fdl) Full time

    About UsFulcrum Decision (Fdl) is a renowned provider of Business Intelligence, Data Warehouse and Data Integration services, boasting over 20 years of experience in the industry. Our team consists of high-calibre data professionals with extensive technical expertise and industry knowledge, working together to deliver top-notch solutions for our clients...

  • Engineering Manager

    7 days ago


    Auckland, Auckland, New Zealand Xero Full time

    About XeroXero is a global leader in cloud-based accounting software, empowering small businesses to simplify their financial management. Our innovative solutions help businesses automate routine tasks, surface actionable insights, and connect with the right data, advisors, and apps.The Role of the Head of Engineering - DataWe are seeking an experienced and...

  • Data Engineer

    3 days ago


    Auckland, Auckland, New Zealand Asb Bank Full time

    Opportunity for a Data Engineer to join the Sanctions Squad.ETL/ELT, Design, Build, and maintain ASB's Sanctions technology, helping us fight the bad guysGreat team culture with opportunities to learn and grow.Flexible working options, development opportunities and banking benefits.If you're a Data Engineer who loves data, configuration, integration,...


  • Auckland, Auckland, New Zealand The Warehouse Group Full time

    Company DescriptionWelcomeKia OraThis isn't your average Data Engineer role.We're on the hunt for a seasoned Data Engineering professional with hands-on experience in Snowflake and DBT implementations to join our growing team.As we modernize our Data Engineering toolset with new technologies, you'll play a key role in major migration and refactoring...


  • Auckland, Auckland, New Zealand Comspek International Full time

    At Comspek International, we are seeking a highly skilled Data Lead to join our dynamic data engineering team. The ideal candidate will possess technical expertise and leadership skills to drive best practices in data engineering, governance, and risk management.We are looking for a professional who can provide guidance and oversight for key data projects,...


  • Auckland, Auckland, New Zealand Fulcrum Decision (Fdl) Full time

    We are looking forsenior Data Engineers, ETL Developers and Data Consultantsto join our Data Engineering practice in Auckland as we grow in 2025.Fulcrum Decision has been providing Business Intelligence, Data Warehouse and Data Integration servicesfor over 20 years.We are a team of high calibre data professionals with extensive technical expertise and...


  • Auckland, Auckland, New Zealand Kpmg Full time

    KPMG is one of the most trusted and respected global professional services firms.Through depth of expertise, clarity of insight and strength of purpose we help our clients solve complex problems, steer change, strengthen, transition and grow.We are looking for talented people who share our purpose of inspiring confidence and empowering change for our...


  • Auckland, Auckland, New Zealand SkyCity Full time

    Sky City is one of Australasia's most popular casino and hospitality destinations who welcome and delight millions of customers each year.We are on a data journey and seeking a visionary Head of Data Engineering to lead our Data Engineering team and shape the future of our data infrastructure.Reporting to the Group GM Engineering and Technical Assurance, the...


  • Auckland, Auckland, New Zealand Skycity Full time

    SkyCity is one of Australasia's most popular casino and hospitality destinations who welcome and delight millions of customers each year.We are on a data journey and seeking a visionary Head of Data Engineering to lead our Data Engineering team and shape the future of our data infrastructure.Reporting to the Group GM Engineering and Technical Assurance, the...


  • Auckland, Auckland, New Zealand Serko Ltd. Full time

    Serko is a cutting-edge tech platform in global business travel & expense technology.When you join Serko, you become part of a team of passionate travellers and technologists bringing people together, using the world's leading business travel marketplace.We are proud to be an equal-opportunity employer, we embrace the richness of diversity, showing up...

  • Senior Data Engineer

    5 hours ago


    Auckland, Auckland, New Zealand Serko Ltd Full time

    Serko is a cutting-edge tech platform in global business travel & expense technology.When you join Serko, you become part of a team of passionate travellers and technologists bringing people together, using the world's leading business travel marketplace.We are proud to be an equal-opportunity employer, we embrace the richness of diversity, showing up...

  • Data Engineer Lead

    6 days ago


    Auckland, Auckland, New Zealand Serko Full time

    Serko is a leading-edge technology platform in global business travel and expense solutions.Company OverviewWe are a team of passionate technologists and travellers committed to bringing people together using the world's leading business travel marketplace.Job DescriptionWe are seeking a Senior Data Engineer to join our team for a 12-month fixed-term...


  • Auckland, Auckland, New Zealand Serko Ltd. Full time

    About SerkoSerko Ltd. is a pioneering technology firm in the business travel and expense industry, dedicated to revolutionizing the way companies manage their travel and expenses.Our MissionWe aim to create a platform that empowers businesses to streamline their travel and expense processes, making it easier for them to focus on what matters most - growing...