Note: The job is a remote job and is open to candidates in USA. DeWinter Group is a leader in FinTech/SaaS, and they are seeking a skilled Data Engineer to join their team for a 1-year engagement. This role involves supporting the migration of dbt models from Redshift and Snowflake to Trino while ensuring compatibility and performance in their evolving infrastructure.
Responsibilities
- Fixing and translating SQL syntax from Redshift and Snowflake to Trino Syntax in dbt models
- Refactoring and optimizing data models, ensuring they align with best practices for Iceberg
- Collaborating with analytics teams and workbook owners to validate and test the impact of migration work on Tableau assets
- Managing version control for dbt models via Git and engaging in daily standups to execute migration priorities efficiently
- Collaborating with engineering and analytics teams to ensure seamless model transitions and maintain quality data standards
Skills
- 2+ years of experience in a data engineering, BI, or analytics role
- Deep expertise in SQL with experience in multiple syntaxes (Redshift, Snowflake, and Trino), and a deep understanding of dbt, including model development, macros, and Jinja templating
- Demonstrated ability to work autonomously and manage your own time effectively to meet project goals
- Experience with version controlling via Git (a must), BI tools such as Tableau, and experience working in financial services or SaaS companies
- Strong communication skills to provide clear and concise status updates to the project team, particularly in guiding stakeholders through infrastructure changes
Company Overview