Data Engineer (f/m/d)

at  AWIN

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.

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.

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.