Why this role stands out
Lead a high-impact migration to Microsoft Fabric, leveraging your expertise to design and guide the implementation of a cutting-edge data architecture. If you are a seasoned Data Architect with a passion for cloud-based solutions and ETL modernization, this remote role offers a fantastic opportunity to shape a critical project for a reputable consulting firm. Apply today to make your mark!
Quick overview
Job description
Microsoft Fabric Data Architect (DataStage to Fabric Migration)
100% Remote
Contract Opportunity
About the role:
The client is looking for a hands-on Data Architect to lead the migration of an existing IBM DataStage ETL estate to Microsoft Fabric. The architect will own the target-state design, the migration approach, and delivery guidance for the engineering team, from assessment through cutover.
Key responsibilities:
- Assess the current DataStage landscape, including jobs, sequences, transformers, parameter sets, and dependencies, and build a migration inventory and complexity map.
- Design the target architecture on Microsoft Fabric: OneLake, Lakehouse/Warehouse, Data Factory pipelines, Dataflows Gen2, and Spark notebooks.
- Define migration patterns that map DataStage stages and logic to Fabric equivalents, plus a strategy for rewrite, re-platform, or retire.
- Set standards for data modeling (medallion/layered architecture), naming, orchestration, error handling, and performance tuning.
- Plan and oversee data validation and reconciliation between legacy and target outputs, parallel runs, and cutover.
- Establish governance, security, and lineage (workspace strategy, access control, Purview integration).
- Set up CI/CD and deployment practices for Fabric artifacts (Git integration, deployment pipelines).
- Guide and review the work of data engineers, and act as the technical point of contact for client stakeholders.
Must-have skills:
- 12+ years in data engineering/ETL, with 3+ years in a data architect role.
- Strong hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Factory pipelines, notebooks, OneLake).
- Solid working knowledge of IBM DataStage: parallel jobs, sequences, transformer logic, and reading or reverse-engineering existing jobs.
- Proven experience delivering at least one ETL migration to a cloud platform.
- Strong SQL and PySpark/Spark SQL.
- Data modeling expertise (dimensional, medallion).
Good to have:
- Azure Synapse, Azure Data Factory, or Databricks experience.
- Power BI with Direct Lake / semantic models.
- Microsoft Purview, Azure DevOps/GitHub CI/CD.
- Certifications: DP-600 (Fabric Analytics Engineer), DP-700 (Fabric Data Engineer), or Azure Data Engineer/Architect.
- Experience with automated migration or code-conversion tools.
Similar jobs
- CA
Manager Data Warehouse & Integrations - IT Solutions
Careers at Texas Woman\u2019s University | TWU · Denton · Hybrid 🇺🇸
OraclePL/SQLSQL+20TechnologySalary not listed - FU

Data Architect Auto Apply
Further · Dallas · Hybrid 🇺🇸
DrizzleSQLSOC 2+13TechnologySalary not listed - OT
Data Governance ManagerRecently posted
Omnicell (temp) · Atlanta · Hybrid 🇺🇸
Stakeholder ManagementComplianceContinuous Improvement+4Salary not listed - AX
Director, Enterprise Data & AI StrategyRecently posted Auto Apply
Axogen · Tampa · Hybrid 🇺🇸
Stakeholder ManagementSQLAWS+18Salary not listed - SI

ETL/Informatica Developer (Medicaid) and Data Architect (Medicaid) ---- 100% Remote -- Only W2Recently posted
Siri Infosolutions Inc · United States · Remote 🇺🇸
SQLETLPython+3TechnologySalary not listed - MP
Snowflake Data Architect - Contract on W2Recently posted
Mpower Plus Rezolve AI Group LTD · United States · Hybrid 🇺🇸
ETLSnowflakeDatabricks+3TechnologySalary not listed - OT

AWS Data ArchitectRecently posted
OVS Technologies Inc · Clinton, NJ · Hybrid 🇺🇸
AWSETLTechnologySalary not listed - MA

Sr Data Architect (Full Time)Recently posted
Modern Agile Technologies, LLC · New York, NY · Hybrid 🇺🇸
SQLShellSnowflake+6TechnologySalary not listed - PH

AWS Data ArchitectRecently posted
Purple Hires · Alameda, CA · Hybrid 🇺🇸
SQLApache SparkAWS+14TechnologySalary not listed - RT
Data ArchitectRecently posted
Reveille Technologies · New York, NY · Hybrid 🇺🇸
SQLSnowflakeHadoop+4TechnologySalary not listed - TT
Abinitio Data Architect/ModelerRecently posted
Tech3pillars Technologies · Omaha, NE · Hybrid 🇺🇸
MicroservicesMongoDBOracle+9TechnologySalary not listed - RI

Data ArchitectRecently posted
Rivago infotech inc · New York, NY · Hybrid 🇺🇸
SAFeApache SparkAWS+10TechnologySalary not listed