Analytics Data Engineer
Job Summary
The Analytics Data Engineer will design, develop, and maintain data models and ETL processes to support business analytics and reporting. You will collaborate with stakeholders to translate business requirements into end-to-end technical solutions. The role involves leveraging technologies like Snowflake and dbt to ensure data accuracy, performance, and scalability.
Responsibilities
- Design and maintain ETL processes and data models
- Develop End-to-End analytics solutions with Snowflake and dbt
- Collaborate with stakeholders for technical requirements
- Optimize data pipeline performance and quality
Required Skills
- SQL and Snowflake
- dbt (data build tool)
- Python scripting
- Frontend Development (Celonis)
- GitLab/GitHub
- Fluent English
Job Details
Responsibilities:
- Design, develop, and maintain data models and ETL processes from data model creation to frontend design to support analytics and reporting needs.
- Collaborate with data analysts and business stakeholders to understand requirements and translate them into technical solutions.
- Design and implement complete End-to-End data analytics solutions leveraging Snowflake, dbt, and other relevant technologies.
- Develop and maintain dbt models, transformations, and documentation to ensure data accuracy, consistency, and reliability.
- Optimize query performance and data pipeline efficiency to support scalable and high-performance analytics.
- Monitor data quality and troubleshoot issues as they arise, ensuring the integrity of our data assets.
- Stay current with emerging trends and best practices in data engineering and analytics and recommend innovative solutions to enhance our capabilities.
Requirements:
- 2-4 years of work experience in Frontend Development with a focus on Celonis.
- Proficiency in SQL and experience with Snowflake or similar cloud data warehouse platforms.
- Hands-on experience with dbt (data build tool) and strong understanding of data modeling concepts.
- Experience with Python or another scripting language for data manipulation and automation.
- Some experience in Power BI is valued.
- You have experience in version control tools like GitLab or GitHub.
- English fluency is required.
- European Union Citizenship or Portuguese Working Visa / Portuguese Residency.