Data Architect – Data Modeling

Job not on LinkedIn

October 27

Amazon Redshift

Cloud

SQL

Apply Now
Logo of CompassX Group

CompassX Group

B2B • Consulting • Technology

CompassX Group is a business and technology consulting firm that specializes in delivering services across several sectors including financial services, healthcare, life sciences, and consumer discretionary. Their expertise includes technology advisory, data solutions, business resiliency, and agile product evolution, helping organizations to implement effective strategies and improve operational efficiencies.

11 - 50 employees

Founded 2009

🤝 B2B

📋 Description

• Design and implement **data models** (star schemas, fact and dimension tables, and semantic models) to support analytics and reporting in **Power BI** • Build and optimize **data architecture** within **Amazon Redshift**, ensuring scalability, performance, and data consistency • Develop and maintain **data dictionaries, lineage, and documentation** for key business domains • Partner with data engineers, analysts, and business stakeholders to translate requirements into effective data models • Define and enforce **modeling standards and best practices**, ensuring consistency across projects • Work with **Salesforce** and **Veeva** data sources to model key life sciences datasets (e.g., sales, marketing, CRM, and field activities) • Collaborate with global teams to ensure model alignment and data interoperability across business units

🎯 Requirements

• Strong experience in **data architecture and data modeling**, particularly with **star schema and dimensional design** • Hands-on experience with **Amazon Redshift** or similar cloud data warehouse platforms • Deep understanding of **semantic modeling** and how it supports **Power BI** and self-service analytics • Strong **SQL** skills for model development, validation, and optimization • Experience working with **Salesforce** and/or **Veeva** data in a **life sciences or pharmaceutical** environment • Solid grasp of **data governance, lineage, and metadata management** concepts • Excellent communication skills — able to collaborate effectively with technical and business stakeholders

Apply Now

Similar Jobs

October 22

inBeat Agency

51 - 200

📱 Media

🤝 B2B

Data Engineer to build out creative intelligence pipeline for marketing assets. Involves ETL processes with ad platforms and AI analysis integration.

🇺🇸 United States – Remote

⏳ Contract/Temporary

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

October 15

Castillians

51 - 200

Senior Data Engineer needed to scale and optimize the BI platform for a leader in financial technology. Responsibilities include managing data pipelines and collaborating with stakeholders.

🇺🇸 United States – Remote

⏳ Contract/Temporary

🟠 Senior

🚰 Data Engineer

October 8

Spiral Scout

51 - 200

🤖 Artificial Intelligence

☁️ SaaS

🏢 Enterprise

AI Data Engineer at Spiral Scout combining data engineering and AI orchestration. Building intelligent automated systems and workflows for business processes with cutting-edge tools.

🇺🇸 United States – Remote

⏳ Contract/Temporary

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

October 7

KATBOTZ®

2 - 10

🤖 Artificial Intelligence

📚 Education

Remote SAP Functional Consultant specializing in Data Migration at global IT services company KATBOTZ LLC. Leading end-to-end data migration activities with SAP tools and collaborating across international teams.

🇺🇸 United States – Remote

⏳ Contract/Temporary

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

September 17

Superlanet

51 - 200

⚕️ Healthcare Insurance

🎯 Recruiter

Contract Senior Data Engineer at Superlanet building Databricks pipelines for healthcare supply chain analytics.

🇺🇸 United States – Remote

💵 $70 - $80 / hour

⏳ Contract/Temporary

🟠 Senior

🚰 Data Engineer

Developed by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com