Make your impact within a rapidly growing Fintech Company
REMOTE – W2 ONLY
Responsibilities:
- You will be responsible for supporting the migration of dbt models from Redshift and Snowflake to Trino (Iceberg) while ensuring compatibility, performance, and best practices in our evolving infrastructure. Your role will require a deep understanding of SQL dialects, data modeling principles, and dbt best practices. You will collaborate with both engineering and analytics teams to ensure seamless model transitions and maintain quality standards.
- Fix Redshift and Snowflake SQL Syntax to Trino Syntax in our dbt models.
- Version control dbt models via Git .
- Refactor and optimize data models, ensuring they align with best practices for Iceberg.
- Work with Tableau assets, ensuring data sources align with the new infrastructure.
- Collaborate with workbook owners to validate and test the impact of migration work.
- Engage in daily standups and work alongside engineers to execute migration priorities efficiently.
Requirements
- 1+ years of experience working in financial services and/or SaaS companies.
- 5+ years of experience in a data engineering
- Experience with BI tools, such as Tableau, and a working knowledge of data source construction.
- Experience in dbt and modern data modeling best practices.
- Version controlling via Git is a must
- BS/BA in Computer Science, Information Systems, Mathematics, or a related technical field (or equivalent work experience).
- Strong proficiency in SQL, with experience in Multiple SQL Syntaxes (Redshift, Snowflake, and Trino (Iceberg).
- Deep understanding of dbt, including model development, macros, and Jinja templating.
- Strong stakeholder communication skills, particularly in guiding teams through infrastructure changes.
- Experience refactoring SQL and dbt models to support infrastructure migrations.
- Experience working in startup environments is a plus.
About SSI People: With over 26 years of industry experience, SSi People has built its reputation and expertise on putting people first. Everything we do works toward delivering exceptional experience for our consultants, our clients, and our internal team. Through a genuine commitment to people in everything we do. We have developed refined processes and a stellar internal team to deliver talent quickly. More importantly, we focus on building long-term relationships, not transactions. Putting people first is just what we do well.
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from SSi People and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here: SSi People Privacy Policy