Search Jobs
PDS Inc, LLC
http://www.pdsinc.com
http://www.pdsinc.com
true
The Data Operations team builds capabilities and owns practices that enable seamless data usage across the company. The team collaborates with stakeholders to understand requirements, develop scalable solutions, solicit feedback, deploy models, and ensure high-quality data products.
Engineers on the Data Operations team bring a pragmatic approach to building robust, efficient, and well-documented data models. They balance speed with accuracy, ensuring that our data infrastructure evolves to meet the needs of our growing business.
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.
Specifically, you will:
We look forward to reviewing your application. We encourage everyone to apply - even if every box isn’t checked for what you are looking for or what is required.
PDSINC, LLC is an Equal Opportunity Employer.
Data Engineer
Posted: 03/28/2025
2025-03-28
2025-05-24
Employment Type:
Contract
Job Category: Data Engineering
Job Number: 24513
Workplace Type: Remote
Job Description
The Data Operations team builds capabilities and owns practices that enable seamless data usage across the company. The team collaborates with stakeholders to understand requirements, develop scalable solutions, solicit feedback, deploy models, and ensure high-quality data products.
Engineers on the Data Operations team bring a pragmatic approach to building robust, efficient, and well-documented data models. They balance speed with accuracy, ensuring that our data infrastructure evolves to meet the needs of our growing business.
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.
Specifically, you will:
- 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.
- BS/BA in Computer Science, Information Systems, Mathematics, or a related technical field (or equivalent work experience).
- 2+ years of experience in a data engineering, BI, or analytics role.
- 1+ years of experience working in financial services and/or SaaS companies.
- Experience in dbt and modern data modeling best practices.
- Version controlling via Git is a must
- Experience working in startup environments is a plus.
- 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.
- Experience with BI tools, such as Tableau, and a working knowledge of data source construction.
- Strong stakeholder communication skills, particularly in guiding teams through infrastructure changes.
- Experience refactoring SQL and dbt models to support infrastructure migrations.
We look forward to reviewing your application. We encourage everyone to apply - even if every box isn’t checked for what you are looking for or what is required.
PDSINC, LLC is an Equal Opportunity Employer.
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Philadelphia, PA
Ready to embark on a new career adventure in the vibrant city of Philadelphia, Pennsylvania? Explore our job opportunities in the City of Brotherly Love and discover the countless growth possibilities this historic region offers aspiring professionals. From iconic landmarks like the Liberty Bell and Independence Hall to the mouthwatering Philly cheesesteaks and world-class art galleries such as The Barnes Foundation, Philadelphia is a treasure trove of culture and charm. With renowned theaters like the Walnut Street Theatre, professional sports teams like the Eagles and Phillies, and gorgeous outdoor spaces like Fairmount Park, Philadelphia has something for everyone. Don't miss out on the chance to make your mark in this dynamic city — browse our job listings now and take the first step towards your dream career!
