Data Engineer
Summary
Designs and builds AWS-based data pipelines and ETL jobs to feed analytics platforms like Mixpanel and Google Analytics, ensuring data accuracy and trust for global marketing and event tracking.
The Data Engineer II performs moderate research, design, and data engineering assignments within a specific engineering functional area or product line in RX Global. The successful candidate will create data architectures, such as databases and large- scale processing systems that are used by our business to monitor, understand, and gain data science-led insights into our global events. The Data Engineer II works as part of a highly motivated, collaborative, enthusiastic, distributed, cross-functional team, using a modern tech stack and agile & develops principles to create data architectures that are of high quality and can be deployed to and used in production with confidence - safely and reliably.
Accountabilities
- Design and develop data pipelines and ETL jobs on AWS Cloud platform based on
functional/non-functional business requirements - Design & implement Data Integration/Ingestion/Extraction solutions based on high
level architecture design - Identify, design, and implement process improvements & delivery optimizations
- Develop data lake solutions leveraging new or existing technology to advance the
company's business - Design, upgrade and implement new data workflows, automation, tools and API
integrations - Write and maintain technical documentation
- Translate business logic into structured, testable, and well-documented datasets
used across teams - Collaborate with analysts, engineers, product managers, or other business
stakeholders to align on requirements, definition of events and ownership. - Locate opportunities to improve data and touchpoint analysis by leveraging
consistent identifiers. - Implement and maintain Mixpanel testing strategies amongst product teams to
ensure data accuracy and trust in data. - Participate in code reviews and ensure product teams are instrumenting events per
best practice. - Be part of a governance oversight committee that ensures product teams are
feeding into global analytics platform as per analytics team standards. - Peer review reports and dashboards created by product teams' prior dissemination
to the wider business.
Qualification
- Bachelor's Degree holder (Engineering/Computer Science preferred but not required)
- Experience dealing with various stakeholders in a global perspective
- 2-4 years' experience as a Data Engineer (or related positions) with focus on data processing and/or relational databases
- Familiar with consent management platforms such as OneTrust and Cookiebot and the implications they have on web tracking.
- Solid understanding of marketing technologies (Meta, Bing, Google Ads etc) and acquisition channels (Paid Search, Paid Social etc.)
- Deep understanding of digital analytics principles and experience implementing systems such as Mixpanel, Google Analytics and ContentSquare
- Experience in utilizing analytics tools such as Mixpanel and Google Analytics
- Experienced with relational databases like MS SQL Server
- Experienced in the following programming/scripting languages: SQL, Python.
- Experienced with AWS Cloud
- Experienced with working on Structured, Semi-Structured, Unstructured datasets
- Monitor, validate, and drive continuous improvement to methods, and propose enhancements to data sources that improve usability and results
- Proven time and project management skills, experience in Agile Methodology is desired
- Good communication and presentation skills
- Analytical, structured, organized, and proactive