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.
Data Architect – Data Modeling
Job not on LinkedIn
October 27
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.
📋 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 NowSimilar Jobs
October 22
Data Engineer to build out creative intelligence pipeline for marketing assets. Involves ETL processes with ad platforms and AI analysis integration.
ETL
SQL
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.
AWS
Cloud
ETL
NoSQL
Python
SQL
Tableau
Go
October 8
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.
AWS
Azure
Cloud
ETL
Google Cloud Platform
Python
SQL
October 7
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.
September 17
Contract Senior Data Engineer at Superlanet building Databricks pipelines for healthcare supply chain analytics.
ETL