Job Title : Senior Data Integration Architect (DBT+ Snowflake) with Pharmaceutical Domain
Work Location : Hybrid, Onsite from Day1. Boston, MA. Prefer local candidates or in Tristate who can relocate to Boston and work onsite in Hybrid mode.
Purpose of the Position : As a Senior Data Integration Architect (DBT), You will be responsible for development, and optimization of data solutions using Snowflake and DBT, ensuring efficient data integration, transformation, and real-time analytics.
This role involves collaborating with cross-functional teams to translate business requirements into technical solutions, maintaining data integrity and compliance, and driving innovation in data engineering practices.
Key Result Areas and Activities :
- Data Architecture and Pipeline Development :
- Design, build, and maintain robust Snowflake architectures and data pipelines using DBT to ensure efficient data integration and transformation.
- Performance Optimization :
- Optimize the performance of Snowflake databases and DBT models to ensure high efficiency and scalability of data solutions.
- Data Quality and Compliance :
- Ensure data integrity, quality, and compliance with data governance and security policies.
- Collaboration and Stakeholder Management :
- Work closely with analysts, and business stakeholders to understand requirements and deliver effective data solutions.
- Innovation and Continuous Improvement :
- Drive innovation in data engineering practices and continuously improve processes and tools to enhance data capabilities.
Must have :
- Deep understanding of Snowflake architecture, data warehousing, and performance optimization, High proficiency in SQL
- Collaborate with analysts and business stakeholders to gather requirements, translate them to business requirements, design scalable and reliable solutions
- 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.
- Agile SCRUM, JIRA and Prior experience in Analytics with PowerBI know how
Good to have
- 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 Commercial Operations, Patient Engagement
Qualifications :
- Minimum of 8+ years of experience in data engineering, with a focus on Snowflake and DBT.
- Proven track record of designing and implementing data solutions in complex environments.
- Relevant certifications in Snowflake and other cloud technologies are highly desirable.
- Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, or a related field.
Senior Cloud Data Architect
Implements data management and data governance processes for cloud data. Experience working with highly sensitive health care information and familiar with HIPAA and other data privacy controls. Administer, configure & support Cloud Database services (Snowflake). Administer and manage internal and e...
Senior Cloud Data Architect - CDA-24-14907
Seeking a Senior Cloud Data Architect to lead the design and implementation of a Cloud Data Platform that will streamline workflows for various local and regional organizations. Implement centralized and decentralized data architectures (Data Warehouse and Data Mesh). Cloud Data Architecture, data w...
Senior Director Strategic Sourcing, R&D and DTE (Data, Technology & Engineering) (hybrid)
Typically requires 12-14 years of specific Sourcing experience, ideally several within a pharmaceutical / biotech industry, with 7+ years of supervisory experience with larger-sized teams. As a key Team Manager and leader in the Strategic Sourcing function, the Senior Director, R&D & DTE (Da...
Senior Manager, Clinical Data Configuration Engineer
While the Clinical Data Standards provides the standards for clinical operation and data flow, the Clinical Data Engineering team drives the data architecture for clinical data. CDCS leads the integration of collected data from all sources by setting up proper configuration of data extraction and ma...
Senior Python Engineer with Data Engineer Background
We are currently partnered with a high level innovation lab within a major pharmaceutical and cosmetics company in the US whose major focus is to spearhead the digital transformation of one of their main business lines to further understand the customer base and to better deliver the right products ...
Senior Data Integrations Engineer ((Oracle Fusion / OIC)
Collaborate with various teams to identify and understand data requirements, ensuring that the data integration solutions meet these needs. Our company is seeking a dynamic and experienced Senior Data Integrations Engineer specializing in Oracle Fusion / OIC to join our team. The successful candidat...
Senior Cloud Data Architect - CDA-24-14907
Seeking a Senior Cloud Data Architect to lead the design and implementation of a Cloud Data Platform that will streamline workflows for various local and regional organizations. Implement centralized and decentralized data architectures (Data Warehouse and Data Mesh). Cloud Data Architecture, data w...
Senior Data Architect
The Executive Office of Health and Human Services - Data Office is seeking a Senior Cloud Data Architect to play a crucial role in Data platform architecture design and implementation. Cloud Data Architecture, data warehousing, data modeling, ETL, enterprise and business information system architect...
Senior Data Replication and Integration Engineer
The demand for high-quality, normalized, and interconnected data has continued to increase, with the emergence of generative artificial intelligence putting a spotlight on the challenges of data quality and data governance. The Administrative Data Management and Reporting Ecosystem (ADMIRE) project ...
SAP SuccessFactors Data Migration & Integration Suite, Senior Associate
SummaryA career in our SAP Human Capital practice, within SAP Consulting services, will provide you with the opportunity to help our clients maximise the value of their SAP investment with offerings that address sales, finance, supply chain, engineering, and human capital. Managing and developing SA...