Cloud Data Solutions Architect

Description 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. This role is based in our Ridgefield, CT office with employees working at least 2-3 days on site to support the business. Compensation Data This position offers a base salary typically between $140,000 and $222,000. This position may be eligible for a role specific variable or performance based bonus and or other compensation elements. For an overview of our benefits please click here. (https://www.boehringer-ingelheim.com/us/careers/benefits-rewards) ​ Duties & 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 Value of the Role This role ensures reliable, transparent data flow from source to insight, enabling scalable data products, trusted analytics, and enterprise‑ready AI on a unified, well‑governed data foundation. 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

Additional:

Experience with agile delivery models and willingness to travel occaisionally as needed. Added Advantage Qualifications 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. Eligibility Requirements 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. All qualified applicants will receive consideration for employment without regard to a person's actual or perceived race, including natural hairstyles, hair texture and protective hairstyles; color; creed; religion; national origin; age; ancestry; citizenship status, marital status; gender, gender identity or expression; sexual orientation, mental, physical or intellectual disability, veteran status; pregnancy, childbirth or related medical condition; genetic information (including the refusal to submit to genetic testing) or any other class or characteristic protected by applicable law.