01
Microsoft Fabric
Required
TRCD-26-04041
Senior Azure Data Warehouse Architect (Healthcare Revenue Cycle)
Contract role in Bangalore for a senior, hands-on data warehouse architect/engineer who has built schemas and written production code (not just architecture docs). Must bring deep healthcare revenue cycle expertise (payer/provider and healthcare financial data models) plus strong Azure data platform skills (Fabric, ADLS Gen2, ADF, Synapse, Azure SQL) and advanced SQL/T-SQL performance tuning. The role also needs strong dimensional modeling (Kimball, star schema, SCD) and Power BI semantic model integration (Import and DirectQuery).
Position summary
- Location
- India
- Workplace
- On-site
- Employment
- Contract
- Experience
- Minimum 15 years and Maximum 16 years
Role overview
Why This Role Matters.
Contract role in Bangalore for a senior, hands-on data warehouse architect/engineer who has built schemas and written production code (not just architecture docs). Must bring deep healthcare revenue cycle expertise (payer/provider and healthcare financial data models) plus strong Azure data platform skills (Fabric, ADLS Gen2, ADF, Synapse, Azure SQL) and advanced SQL/T-SQL performance tuning. The role also needs strong dimensional modeling (Kimball, star schema, SCD) and Power BI semantic model integration (Import and DirectQuery).
Your Impact
Deliver Enterprise Value
Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.
Collaboration
Work Across Teams
Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.
Growth
Learn Continuously
Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.
Career Path
Grow With Ubique
Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.
Responsibilities
What You'll Be Doing.
Every role at Ubique contributes directly to solving meaningful business challenges for our clients.
Technology stack
Tools & Technologies.
The platforms and technologies you'll use to build modern, enterprise-grade solutions.
02
Azure Data Lake Storage Gen2
Required
03
ADLS Gen2
Required
04
Azure Data Factory
Required
05
ADF
Required
06
Azure Synapse Analytics
Required
07
Synapse
Required
08
Azure SQL
Required
09
T-SQL
Required
10
SQL
Required
11
Azure Blob Storage
Required
12
Azure Document Storage
Required
13
Power BI
Required
14
DirectQuery
Required
15
Import mode
Required
16
Kimball
Required
17
Dimensional Modeling
Required
18
Star Schema
Required
19
SCD
Required
20
Databricks
Required
Requirements
Skills & Experience.
We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.
Essential
Required Qualifications
Hands-on data warehouse design and build (coding and schema implementation)
Healthcare domain expertise in revenue cycle
Payer/provider data models and healthcare financial data modeling
Azure data platform: Microsoft Fabric
Azure Data Lake Storage Gen2 (ADLS Gen2)
Azure Data Factory (ADF)
Azure Synapse Analytics
Azure SQL
Azure Blob/Document Storage
Strong SQL and T-SQL
Query optimization on large datasets
Indexing strategy
Performance tuning
Dimensional modeling and star schema design
Kimball methodology
Fact and dimension design
Slowly Changing Dimensions (SCD) handling
Power BI integration (data models/semantic layers)
Power BI Import and DirectQuery performance considerations
Ability to work independently
Preferred
Nice to Have
Azure Databricks
Delta Lake
Unity Catalog
Databricks notebooks for data engineering
Chunking and vectorization pipelines for unstructured document data
RAG (Retrieval-Augmented Generation) / AI agent data pipelines
Familiarity with Oracle Cerner Millennium data models
Cerner Stage1 tables
Cerner CCL
Cerner revenue cycle schema
Azure OpenAI integration
Azure AI Search integration
Experience designing data models for natural language to SQL agent workloads
Prior experience at a healthcare IT consulting firm or analytics vendor
What you'll gain
More Than Just A Job.
We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.
Global Exposure
Collaborate with international clients and multicultural teams on enterprise programmes.
Continuous Learning
Expand your expertise through mentoring, certifications and hands-on project experience.
Career Growth
Take ownership, develop leadership skills and grow your consulting career over time.
Flexible Working
Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.
People First
Join a supportive culture where collaboration, respect and long-term relationships come first.
Enterprise Projects
Work on meaningful technology initiatives for leading organisations across industries.
Apply
Apply for Senior Azure Data Warehouse Architect (Healthcare Revenue Cycle)
One page, about two minutes. We only ask for what we actually need to have a first conversation.