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 role is a 1 year fixed-term contract.
Key Tasks & accountabilities
- Write 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.
- Presents clearly and confidently findings of bugs and system improvement to stakeholders.
- Create new Azure pipelines, and data bricks notebook to add data points to existing and new sources.
- Add new datapoint 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
- Excellent knowledge of database and dimensional modeling technologies
- Excellent knowledge of Azure Data Factory, Azure Data Bricks, ADLS, Azure Event Hub, Azure SQL DB
- Excellent knowledge of SQL, T-SQL, Python, and PySpark
- BI stack development (SSIS, SSAS, SSRS) is preferred but not essential.
- Have a working knowledge of scrum and Agile practices
- Proven communication and analysis skills
- Ideally, any: 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
- Strong mathematical skills
- Strong customer focus and service attitude
- Strong communication and interaction skills
- A team player with and ability to work on self
- Proactive approach to tasks & challenges
- Pronounces focus on quality and results.
- Get-things-done mentality
- Good analytical skills to translate business needs into actions with a proactive approach to tasks and challenges, delivering projects on time and within budget.
- Good project & process management competencies with a pronounces focus on quality and results
- Create a mindset to bring new ideas and push the data warehouse development and willingness to change and learn or start initiatives.
- Self-reliance and being able to face existing challenges on your own with the courage to make your own decisions if needed.
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.
