Job description

This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community.

Purpose of position

Data sits at the heart of the company. This role is to ensure that Awin can leverage the data it has access to across the group, and build out reporting to ensure we are able to make better commercial decisions and provide best-in-class campaign management to support client-facing departments.

As a Data Engineer, your responsibility is to collect data from a different source, sanitize, cleanse, transform, and consolidate these collected data, and make them available for further analysis and/or publishing them as a report.

To thrive in this role you should be able to understand data, business, and technical requirements; write clean and high-quality code that is easy to understand and maintain; clearly understand the various methodologies of data extraction, transformation, and storage and successfully apply your experience and knowledge of scripting, SQL, and conceptual OLTP and/or OLAP database.

Within the role, you will be responsible for the smooth running of the Data Warehouse day to day operation, and be working with a global team of Data engineers, Analysts, and reporting teams amongst other Big Data engineers within the organization.

This is a fixed-term role for 12 months.

Key Tasks & Accountabilities

  • Write a clean, elegant and maintainable code with data warehousing best practices and modeling techniques (Kimball, Star Schema, etc.).
  • Troubleshoot data transformation errors by debugging, and formulate a plan to fix them.
  • Present the findings of bugs and system improvements clearly and confidently to different stakeholders.
  • Create new Azure pipelines and data bricks notebook to add data points to existing and new sources.
  • Add new datapoints to existing AAS cube.
  • Create new reports, and update existing report definitions.
  • Find new innovative ways to improve the performance of existing processes and transformation functions.
  • Accountable for quality and accuracy of data and reports.

Education & Experience

  • A bachelor's degree or higher in Data Science, Data Engineering, Business Intelligence, Business Administration, or similar education with a focus on Data engineering / Intelligence / Analytics is preferred.
  • 2+ years of working experience as a Data Warehouse Developer and Data Engineer with Python or similar
  • Hands-on with full Microsoft Azure data engineering pipelines
  • Strong knowledge of database and dimensional modeling technologies
  • Strong knowledge of Azure Data Factory, Azure Data Bricks, ADLS, Azure Event Hub, Azure SQL DB
  • Strong knowledge of SQL, T-SQL, Python, and PySpark
  • BI stack development (SSIS, SSAS, SSRS) is preferred but not essential.
  • Working knowledge of Scrum and Agile practices
  • Proven communication and analytical skills
  • Ideally, experience working in a Big Data environment, AI/ML framework/libraries, Spark, and JSON is preferred.

Skills & Core Competencies

  • Create complex ETL Python/PySpark functions to support application development.
  • Troubleshoot data-related issues in a timely fashion.
  • Strong ability to learn concepts and apply them to problems
  • Strong passion for problem-solving, customer focus and service attitude
  • Strong mathematical skills
  • Strong communication and interaction skills
  • A team player
  • Get-things-done mentality and a proactive approach to tasks and challenges
  • Good analytical skills to translate the business needs into actions.
  • Good project & process management competencies with a pronounced focus on quality, results and delivering projects on time and within budget.
  • Create a mindset to bring new ideas, and push the data warehouse development with willingness to change and learn.
  • Self-reliance and being able to face existing challenges on your own.

Our Offer

  • Flexi-Week and Work-Life Balance: We prioritize your mental health and well-being, offering you a flexible four-day Flexi-Week at full pay and with no reduction to your annual holiday allowance. We also offer a variety of different paid special leaves.
  • Working Wherever: Do you prefer to work from our cool office, from home, or in a completely different environment? With us, the choice is yours. We offer the flexibility to work wherever you want within our Awin locations.
  • Health & Well-Being: With our support and access to various initiatives and sports offers, you can devote yourself to your mental and physical well-being.
  • Development: We’ve built our extensive training suite Awin Academy to cover a wide range of skills that nurture you professionally and personally, with trainings conveniently packaged together to support your overall development.
  • Remote Working: You will receive a monthly allowance to cover a part of your running costs. In addition, we will support you in setting up your remote workspace appropriately.
  • Appreciation: Thank and reward colleagues by sending them a voucher through our peer-to-peer program, and show your appreciation for colleagues who have gone the extra mile to support you.

Established in 2000, Awin is proud of our dynamic, social, and inclusive culture.

Like all businesses, we’ve had to adapt and nurture our culture in a virtual environment. Our virtual ‘Life @ Awin’ hub brings our colleagues from across the globe together for various social activities.

Diversity & Inclusion are paramount to us, and we proudly pursue and hire diverse team members. We champion uniqueness and authenticity; this is who we are at our core. Our network of affiliate partnerships is diverse and transparent, as are the employees powering our vision to build the world’s leading open partner ecosystem. We welcome all backgrounds, identities, and experiences. If you need support at any point in the application or interview process, please let us know.

Apply now to begin the next stage of your career at a progressive company that supports both your professional and personal development.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.