Data warehouse Architect (Onsite)

Two95 International - King of Prussia, PA

Full-time - Mid Level

King of Prussia, PA

Professional, Scientific, and Technical Services

About the position

The Sr Data Warehouse Solutions Engineer / Architect role focuses on designing and implementing data warehouse solutions, with a strong emphasis on ETL pipeline development and cloud-based data management. This position requires expertise in various cloud platforms and a solid understanding of data security practices, particularly in the pharmaceutical sector.

Responsibilities

• Design and implement data warehouse solutions.
• Develop ETL pipelines for batch and real-time data processing.
• Work with cloud-based data warehouses such as Snowflake, Azure Synapse, and Redshift.
• Implement security setups and best practices in cloud platforms like Azure and AWS.
• Implement master data management (MDM) solutions.

Requirements

• Experience in designing Data Warehouse solutions.
• Proficient in developing ETL pipelines for both batch and real-time data processing.
• Experience with cloud-based data warehouses, including Snowflake, Azure Synapse, and Redshift.
• Knowledge of security setups and best practices in cloud platforms such as Azure and AWS.
• Experience in implementing master data management (MDM) solutions.

Nice-to-haves

• Familiarity with the pharmaceutical industry.