Cloud Data Solutions Architect

BoehringerPRD • Brampton, ON

16d • Hybrid

About The Position

Our IT EDP Commercial and Medicine Data Analytics team is seeking a talented and experienced Cloud Solution Data Architect to join our team. The ideal candidate will be responsible for designs and governs scalable, secure, cloud native data architecture. This role converts business and analytics needs into Snowflake models, patterns, and pipelines for consistent data ingestion, transformation, quality, and governance. Expertise in Snowflake, dbt, ELT, and data contracts is essential. Focus Areas: Solution Design • Snowflake • dbt • Data Management. If you are passionate about cloud data architecture and are looking for an exciting opportunity to contribute this is the opportunity. We’re looking for someone like you to bring expertise and energy to our dynamic team. As an employee of Boehringer Ingelheim, you will actively contribute to the discovery, development and delivery of our products to our patients and customers. Our global presence provides opportunity for all employees to collaborate internationally, offering visibility and opportunity to directly contribute to the companies' success. We realize that our strength and competitive advantage lie with our people. We support our employees in a number of ways to foster a healthy working environment, meaningful work, diversity and inclusion, mobility, networking and work-life balance. Our competitive compensation and benefit programs reflect Boehringer Ingelheim's high regard for our employees.

Requirements

• Bachelor degree from an accredited institution with four-plus (4+) years IT experience
• In lieu of a degree, ten-plus (10+) years of relevant IT experience required.
• AWS Cloud experience is preferred.
• One large-scale cloud modernization project.
• Enterprise data architecture experience with Snowflake or similar platforms
• Strong hands‑on ELT/ETL and dbt skills (models, tests, macros, CI/CD)
• Deep understanding of Data Vault and dimensional modeling
• Experience designing and governing data contracts
• Advanced SQL and ELT expertise
• Familiarity with orchestration tools, Git workflows, and governance platforms
• Strong communication and stakeholder engagement skills
• Experience with agile delivery models
• Willingness to travel occasionally as needed.
• Must be legally authorized to work in the United States without restriction.
• Must be willing to take a drug test and post-offer physical (if required).
• Must be 18 years of age or older.

Nice To Haves

• Data Vault 2.0 experience
• Familiarity with Iceberg, external tables, and data catalogs
• Knowledge of analytics layers (Power BI, Tableau, semantic models)
• Exposure to cloud‑native and platform engineering practices
• Pharmaceutical commercial data experience is a plus.

Responsibilities

• Design scalable, cost‑efficient Snowflake‑based data architectures
• Define standardized patterns for ingestion, transformation, modeling, and consumption
• Develop solution blueprints, including data flows, lineage, and integrations
• Establish and govern data contracts (schema, SLAs, validation, evolution)
• Lead conceptual, logical, and physical modeling using tools like SqlDBM and dbt
• Build modular, reusable dbt models with strong testing and CI/CD practices
• Integrate data quality, observability, and metadata‑driven validation
• Design orchestrated pipelines using Airflow, Jenkins, or similar tools
• Ensure compliance with governance, security, and access‑control standards
• Partner across data, platform, and governance teams; mentor engineers and analysts

Benefits

• Competitive compensation and benefit programs

What This Job Offers

• Job Type: Full-time
• Career Level: Senior