Data Architect - Airflow

Infocepts - Boston, MA

Full-time - Senior

Boston, MA

1,001-5,000 employees

About the position

As a Senior Data Integration Architect (DBT), you will be responsible for the development and optimization of data solutions using Snowflake and DBT. This role focuses on ensuring efficient data integration, transformation, and real-time analytics while collaborating with cross-functional teams to translate business requirements into technical solutions. You will maintain data integrity and compliance, driving innovation in data engineering practices.

Responsibilities

• Design, build, and maintain robust Snowflake architectures and data pipelines using DBT.
• Optimize the performance of Snowflake databases and DBT models to ensure high efficiency and scalability of data solutions.
• Ensure data integrity, quality, and compliance with data governance and security policies.
• Work closely with analysts and business stakeholders to understand requirements and deliver effective data solutions.
• Drive innovation in data engineering practices and continuously improve processes and tools to enhance data capabilities.

Requirements

• Minimum of 8+ years of experience in data engineering, with a focus on Snowflake and DBT.
• Deep understanding of Snowflake architecture, data warehousing, and performance optimization.
• High proficiency in SQL.
• Strong skills in developing, testing, and deploying DBT models for data transformation and pipeline management.
• Expertise in data modelling (both relational and dimensional) and designing efficient ETL processes.

Nice-to-haves

• Basic knowledge of integrating machine learning models and AI algorithms with data pipelines.
• Experience with DevOps practices and continuous integration/continuous deployment (CI/CD) pipelines.
• Understanding of compliance standards such as GDPR, HIPAA, etc.
• Pharmaceutical experience in Commercial Operations and Patient Engagement.

Benefits

• Competitive salary
• Health insurance
• 401k plan
• Flexible work hours
• Professional development opportunities