Data Engineer

Location: On-premises / Remote

Summary:

We are seeking a skilled Data Engineer to join our dynamic team at Washmen, focusing on optimizing and expanding our data warehousing solutions. The ideal candidate will maintain and enhance our data workflows, primarily involving data synchronization to Redshift and developing dashboards via PowerBI. This role also includes mentoring responsibilities to support a current team member's transition into a data engineering role. Additionally, the candidate will support our product marketing and growth teams by ensuring effective data management, manipulation, and visualization.

Responsibilities:

Data Management:

Implement and maintain robust data sync processes from multiple sources to our Redshift data warehouse.

Design, build, and maintain scalable data pipelines using AWS.

Ensure the reliability and efficiency of ETL processes, implementing reverse ETL processes to sync data back into operational tools.

Act as the liaison between DevOps and revenue teams to translate business needs into technical tickets.

2. Optimization:

Continuously monitor and optimize data storage and retrieval processes to ensure efficient performance and reliability.

3. Validation:

Develop and enforce data validation rules to guarantee the accuracy and integrity of data used across the company.

4. Dashboard Development:

Collaborate with stakeholders to design and refine PowerBI dashboards that provide insightful and actionable analytics.

5. Mentorship:

Actively support and guide a transitioning team member in their development as a data engineer, including hands-on training and project collaboration.

6. Innovation:

Stay abreast of industry trends and technologies that can enhance our data infrastructure and analytics capabilities.

Work closely with data scientists and analysts to support advanced analytics and machine learning models.

7. Data Governance and Compliance:

Establish and enforce data governance policies to ensure data accuracy, security, and compliance with regulatory requirements.

Maintain the accuracy and integrity of marketing, product, and growth-related data.

8. Data Analysis and Insights:

Work closely with cross-functional teams to define key business questions, perform exploratory data analysis, and uncover actionable insights that drive strategic growth.

Develop and manage denormalized tables and reporting tables to optimize query performance and reporting needs.

Requirements:

Bachelor’s degree in computer science, Engineering, or a related field.

Proven experience in data engineering with a solid understanding of data warehouse architecture, particularly AWS Redshift. At least 4-5 years of experience in a mid-senior role.

Strong proficiency with several AWS tools such as Kinesis, Cloud Watch, Sagemaker, Glue, and Appflow.

Strong proficiency in SQL and experience with ETL processes.

Experience with PowerBI or similar business intelligence tools.

Excellent problem-solving skills and the ability to work collaboratively.

Strong communication skills and a commitment to mentoring others.

Proficiency in programming languages including Python, SQL, and Javascript.

Experience with cloud platforms such as AWS, Azure, or Google Cloud.

Familiarity with machine learning infrastructure and tools is a plus.

Preferably a candidate from Eastern Europe or MENA region.

What We Offer:

A collaborative environment where creativity is encouraged and achievements are recognized.

Opportunities to work on projects that are vital to the operational success of the company.