Role: ETL Developer with strong Snowflake, DBT and SQL exp.
Location: Oaks, PA
Note: Candidate need to work onsite from Oaks, PA location from Day 1 (3 days a week) NO REMOTE
In-person client interview is required from Client office (Oaks, PA) or from Princeton, NJ, Irving, TX, Charleston, WV, Augusta, GA, Chicago, IL, New York, NY
MUST Skillset
Should have strong exp. with ETL, Datastage, Snowflake, DBT and SQL.
Job Description
We are seeking a skilled Mid-Level Developer with expertise in Snowflake and DBT. The ideal candidate will possess strong SQL knowledge and a proven track record of working with data warehousing solutions. This role requires a detail-oriented individual who can effectively collaborate with cross-functional teams to deliver high-quality data solutions.
Responsibilities
- Design, develop, and maintain data pipelines using Snowflake and DBT.
- Write and optimize complex SQL queries for data extraction, transformation, and loading (ETL).
- Collaborate with data analysts and stakeholders to understand data requirements and deliver actionable insights.
- Implement best practices for data modeling and data governance.
- Monitor and troubleshoot data pipeline performance and resolve issues as they arise.
- Document technical specifications and maintain clear communication with team members.
- Participate in code reviews and contribute to team knowledge sharing.
Mandatory Skills
- Proven experience with Snowflake as a primary data warehousing solution.
- Strong knowledge of DBT (Data Build Tool) for data transformation.
- Expertise in SQL, including writing complex queries and optimizing performance.
- Experience with data modeling and ETL processes.
Preferred Skills
- Familiarity with cloud platforms such as AWS, Azure, or Google Cloud.
- Experience with data visualization tools (e.g., Tableau, Power BI).
- Knowledge of Python or other programming languages for data manipulation.
- Understanding of data governance and data quality best practices.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 3-5 years of relevant experience in data engineering or data development roles.
- Strong analytical and problem-solving skills.
- Excellent communication and teamwork abilities.