Solution Architect

Houston, TX, US • Posted 6 hours ago • Updated 6 hours ago
Contract W2
12 Months
No Travel Required
Able to Sponsor
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Solution Architect
  • Databricks
  • Microsoft Fabric
  • OneLake
  • lakehouse
  • warehouse
  • Direct Lake
  • Catalog
  • Delta Lake internals
  • Delta Live Tables
  • Databricks SQL.
  • Azure SQL
  • Microsoft Purview
  • MicroStrategy

Summary

Job Title: Solution Architect

Location: Houston, TX

Visa: Any- C2C

Interview Process: Video

Work Schedule: Onsite

 

Job Description:

 Role: Design authority for the target Fabric platform on a Databricks-to-Fabric migration. Owns the decisions the engineering team builds against and represents iLink in design forums with Microsoft ISD and the client. The role is accountable for the technical decisions that cannot be reversed cheaply — the migration patterns, the parity tolerance model, and the gold-layer design.

 

Responsibilities:

 

Target Fabric platform design — OneLake and workspace architecture, capacity model, and the disposition map across the estate

Migration patterns for notebooks, jobs, schemas, tables and the view layer, including the Databricks SQL to Fabric T-SQL dialect conversion

Azure tier decision and design for the regulatory SQL Server estate

Re-platform pattern for the custom applications, including the write-back tier

The parity tolerance model, negotiated and agreed with the client — exact-match classes for regulatory figures, agreed percentages elsewhere

Gold-layer and star schema design suited to Direct Lake

Semantic model architecture across the governed metric estate, with canonical metric definitions agreed with the client

Modernisation sequence and change taxonomy

Technical escalation point; design review and sign-off at each phase gate

 

 

 

 Mandatory skills:

 

Microsoft Fabric at architecture depth — OneLake, lakehouse and warehouse, Direct Lake, capacity and workspace design, deployment pipelines

Databricks at architecture depth — Unity Catalog, Delta Lake internals, Delta Live Tables, Databricks SQL. 

Spark SQL semantics across runtimes — type coercion, decimal and timestamp handling, null behaviour. 

Medallion architecture and dimensional modelling — Kimball, conformed dimensions, grain decisions, star schemas suited to Direct Lake

Large-scale platform migration — source-to-target mapping, disposition mapping, phased cutover, parity-based acceptance

Client-facing design authority — owning a target architecture, chairing design reviews, holding a technical position under commercial pressure

Azure platform — Entra, Key Vault, networking, private endpoints, Azure SQL Managed Instance

 

 

Skills add value: MicroStrategy or SAP BusinessObjects · Regulated-industry delivery with audit and litigation-hold obligations · Microsoft Purview · AI-assisted delivery tooling · working under a prime contractor rather than direct to client

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91089145
  • Position Id: 9146634
  • Posted 6 hours ago

Company Info

About SDH Systems

SDH Systems is a team of creatives with experience in design, content, vision and mission. Using these skills we create creative assets.
We always ensure that our software solutions help your business/organization to enhance their productivity by providing you the unmatched developement solutions tailored to suit your needs. Most of our team has on the job experience in more than one medium, so that we can integrate these to build a creative identity.

About_Company_OneAbout_Company_Two
Contact the job poster
DA

Divya Aleti

Recruiter @ SDH Systems

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.