Data Warehouse & Business Intelligence Architect (Microsoft Fabric)

Data Warehouse & Business Intelligence Architect (Microsoft Fabric)

Job Type:

Direct-Hire

Location

Newark

Industry:

Food & Beverage

Category:

Datawarehouse Developer

Compensation Range:

$150,000 - $180,000 Per Year

Job id:

26972

Additional Compensation Info:

10% bonus

Rich Text Widget

Senior Data Platform Architect

About the Role

A confidential organization is seeking a Senior Data Platform Architect to design and build its enterprise data platform using Microsoft Fabric and Azure. This fully remote role will work with business, analytics, and technology teams to deliver data solutions that support a range of organizational functions.

The architect will establish the data warehouse, engineering workflows, pipelines, and models that support the organization’s analytics environment. The ideal candidate has hands-on experience with Microsoft Fabric, Azure data services, SQL, Python, and integrating data from multiple source systems.

Work arrangement: Fully remote
Reports to: Director of Data & Analytics

Key Responsibilities

  • Design end-to-end data architecture using Microsoft Fabric capabilities, including OneLake, Lakehouse, Warehouse, Pipelines, and Dataflows Gen2.
  • Develop data models and schema definitions to support complex analytical workloads.
  • Build and maintain integrations with flat files, APIs, partner data feeds, and third-party SaaS platforms.
  • Support data quality, security, and compliance, including data lineage, classification, and access controls.
  • Establish and document architecture standards for folder structures, naming conventions, version control, CI/CD, and deployment workflows.
  • Improve platform reliability, cost efficiency, and governance through automation and monitoring.
  • Participate in data strategy reviews, architecture sessions, and cross-functional planning.

Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or a related field; a master’s degree is preferred.
  • 7+ years of experience in data engineering, data architecture, or BI development, including 2+ years with Microsoft Fabric or Azure Synapse.
  • Experience designing data warehouses, dimensional models, and ETL/ELT pipelines.
  • Proficiency in T-SQL and Python or PySpark.
  • Experience with Power BI, Azure Data Factory or Fabric Pipelines, OneLake, and Lakehouse architecture.
  • Experience integrating REST APIs, webhooks, and partner data.
  • Familiarity with Delta Lake and Parquet optimization, including Z-ordering, partitioning, and compaction.
  • Knowledge of dimensional modeling, such as Kimball, and medallion architecture.
  • Understanding of data governance, metadata management, and data security.
  • Hands-on experience with Git and CI/CD for data solutions, preferably using Azure DevOps.
  • Strong analytical, problem-solving, and communication skills.
  • Ability to work independently and manage multiple priorities.

Preferred Skills

  • Experience with dbt, Purview, and Power BI performance tuning.
  • Strong documentation and stakeholder communication skills.

Reasonable accommodations are available to applicants who need assistance during the application process.

Pay: $150,000 to $180,000 per year

We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, ethnic origin, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

InfraTech Solutions, a member of the Objective Partners family of specialized talent solution providers, uses AI-assisted tools, including Alex by Apriora, to support our recruiting process. These tools may review application materials and analyze interview responses to provide insights about a candidate's experience and qualifications. AI output informs our recruiters; decisions about whether to advance or present a candidate are made by people. Learn more about our use of AI, including how to request an accommodation: https://www.infratechsolutions.com/ai-in-our-hiring-process.

#LI-CW1 #LI-Remote

Apply Now
Apply Now
Share this Job
Back to Job Search Back to Job Search