DBT with Snowflake Architect

Job Overview: 

Responsibilities:

• Design and develop data transformation pipelines using the DBT framework in conjunction with the Snowflake data warehouse.
• Collaborate with data engineers, analysts, and stakeholders to understand data requirements and translate them into DBT models.
• Write complex SQL queries to transform, aggregate, and cleanse raw data into meaningful insights.
• Create and maintain data models, including logical, physical, and semantic layers.
• Develop and enforce best practices for version control, testing, and documentation of DBT models.
• Build and manage data quality checks and validation processes within the DBT pipelines.
• Optimize data pipelines for performance and scalability, taking advantage of Snowflake’s features like clustering keys and materialized views.
• Participate in code reviews and provide constructive feedback to team members.
• Stay up-to-date with industry trends and advancements in data engineering, Snowflake, and DBT.

Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or a related field; Master’s degree is a plus.
• Proven experience working with Snowflake and DBT in a data engineering or analytics role.
• Strong expertise in SQL and data modeling concepts.
• Experience designing and implementing ETL processes and data pipelines.
• Familiarity with version control systems (e.g., Git) and collaborative development practices.
• Ability to optimize SQL queries for performance and efficiency.
• Excellent communication skills to collaborate with cross-functional teams and stakeholders.
• Strong problem-solving skills and a proactive attitude towards challenges.
• Experience with data warehousing concepts, cloud platforms, and analytics tools is a plus.
• Knowledge of Python or other scripting languages is advantageous.

About Us :

Infometry is a leading Advanced Data Analytics product solutions and global services company headquartered in Silicon Valley, California, and Bangalore, India. Infometry products include InfoFiscus & Informatica Cloud Connectors.

InfoFiscus is a Prebuilt Cloud Analytics solution for Finance, Supply Chain, Sales, and Marketing. It’s been featured and listed on Informatica Marketplace.

Informatica Cloud Connectors are built for Google Sheets, Google Drive, Google Ads, Googlcareers@infometry.nete Pub/Sub, Google Big Table, HubSpot, and Adaptive Insights.

In addition to products, Infometry helps customers with Enterprise Data Strategy, Cloud Data Orchestration, Enterprise Service Bus, Snowflake Migration, Data Quality, MDM, Informatica PowerCenter to Cloud Migration, Salesforce Implementation, Big Data and AI/ML Analytics.

We are an engineering partner for multiple Data companies such as Informatica, Matillion, Snowflake, GCP, Tableau, Looker, Talend, Pentaho, Dell Boomi .. etc. We are growing at a rapid pace of 200% every year and we are looking for passionate members for our team. If you feel you are the one? Follow Us on LinkedIn and check our website for regular job updates.