Back to jobs

Senior Data & AI Engineering Consultant

Reads like a Data Engineer role: pipelines and data infrastructure.

Pay
Pay not listed
Work setting
Working pattern needs review — work setting source
Listed location: Hybrid
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Not stated

What you’ll work on

Full posting
  • Lead client discovery and turn findings into a delivery plan

  • Design data lake, lakehouse and warehouse architectures on Azure and Fabric

  • Build ingestion and transformation pipelines using Fabric and Azure services

  • Build analytics-ready data models and governed datasets for BI and AI

  • Establish data quality checks, monitoring, and pipeline troubleshooting

From the employer’s posting
Lead client discovery to understand business goals, the data landscape, constraints, and success metrics, then translate findings into a clear delivery plan.
Design and recommend data lake, lakehouse, data warehouse, and analytical data store architectures on Azure and Microsoft Fabric aligned to client needs.
Implement, or guide implementation of, ingestion, transformation, and orchestration pipelines using Microsoft Fabric experiences and Azure services such as Data Factory, Synapse, and Databricks.
Build and maintain analytics-ready data models and schemas
Establish data quality practices, including validation, reconciliation, testing, and monitoring; troubleshoot failures and continuously improve pipeline resiliency.

What you’ll bring

All qualifications

Core experience

  • Experience designing and delivering modern analytics platforms using lakehouse and/or data warehouse patterns on Azure and/or Microsoft Fabric, including client-facing delivery.
  • Strong SQL skills with experience building transformations and dimensional or analytical models.
  • Hands-on experience with Spark (PySpark/Spark SQL) and/or KQL for data engineering and analytics workloads.
  • Experience applying software engineering practices to data solutions, including modular design, source control, automated testing, code review, and technical documentation.
  • Experience building reliable data pipelines, including orchestration, scheduling, error handling, and automated monitoring.
  • Knowledge of data quality practices, including validation, reconciliation, testing, incident triage, and root-cause analysis.

Preferred experience

  • Experience with Azure services commonly used in data platforms, such as Azure Data Factory, Synapse, Databricks, ADLS Gen2, and Key Vault.
  • Familiarity with AI-enablement patterns - such as preparing governed enterprise data for Azure AI Search or Microsoft Foundry, retrieval-augmented generation, or agent-based solutions—is valued.
  • Experience implementing CI/CD and Infrastructure as Code, including environment strategy and release management for data solutions.
  • Familiarity with semantic modeling and BI enablement patterns, including Power BI datasets, self-service analytics, and governance guardrails.
Qualification wording
Experience designing and delivering modern analytics platforms using lakehouse and/or data warehouse patterns on Azure and/or Microsoft Fabric, including client-facing delivery.
Strong SQL skills with experience building transformations and dimensional or analytical models.
Hands-on experience with Spark (PySpark/Spark SQL) and/or KQL for data engineering and analytics workloads.
Experience applying software engineering practices to data solutions, including modular design, source control, automated testing, code review, and technical documentation.
Experience building reliable data pipelines, including orchestration, scheduling, error handling, and automated monitoring.
Knowledge of data quality practices, including validation, reconciliation, testing, incident triage, and root-cause analysis.
Experience with Azure services commonly used in data platforms, such as Azure Data Factory, Synapse, Databricks, ADLS Gen2, and Key Vault.
Familiarity with AI-enablement patterns - such as preparing governed enterprise data for Azure AI Search or Microsoft Foundry, retrieval-augmented generation, or agent-based solutions—is valued. Deep agent application development experience is not required.
Experience implementing CI/CD and Infrastructure as Code, including environment strategy and release management for data solutions.
Familiarity with semantic modeling and BI enablement patterns, including Power BI datasets, self-service analytics, and governance guardrails.

About Interlink Cloud Advisors

Interlink is a nationally recognized IT consultancy, offering the flexibility of a small company while providing stability and benefits usually found at enterprise firms.

In the employer’s words · Read in context

Apply at Interlink Cloud Advisors

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Oct 30, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 6 and day 56.

From 14,770 similar postings that came down. Coming down is not always a hire.

Interlink Cloud Advisors is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Databricks
  • Power BI
  • Spark
  • PySpark
Where the posting names them
• Build and maintain analytics-ready data models and schemas; implement enrichment, business rules, and reusable patterns for consistency across projects. • Enable multiple compute engines - SQL, Spark/PySpark, Spark SQL, and KQL - against shared datasets to support diverse analytics scenarios. • Prepare governed data products and reusable datasets for BI, advanced analytics, and AI use cases, including retrieval-ready data patterns when relevant.
• Experience designing and delivering modern analytics platforms using lakehouse and/or data warehouse patterns on Azure and/or Microsoft Fabric, including client-facing delivery. • Strong SQL skills with experience building transformations and dimensional or analytical models. • Hands-on experience with Spark (PySpark/Spark SQL) and/or KQL for data engineering and analytics workloads.
• Strong SQL skills with experience building transformations and dimensional or analytical models. • Hands-on experience with Spark (PySpark/Spark SQL) and/or KQL for data engineering and analytics workloads. • Experience applying software engineering practices to data solutions, including modular design, source control, automated testing, code review, and technical documentation.
~ Client-Facing (Discovery/Architecture/Delivery) ~ Microsoft Cloud (Azure & Microsoft Fabric) ~ Data Engineering (Trusted Data Foundations for Analytics & AI)
~ Data Engineering (Trusted Data Foundations for Analytics & AI) Interlink Cloud Advisors is looking for a Senior Data & AI Engineering Consultant to help clients build modern, scalable data platforms on Microsoft Azure and Microsoft Fabric. In this client-facing role, you'll lead discovery, design pragmatic architectures, and deliver end-to-end solutions that turn raw data into trusted, analytics-ready datasets for BI, reporting, advanced analytics, and AI use cases. You'll work across Fabric (OneLake, Lakehouse, Warehouse) and Azure data services to ensure solutions are secure, governed, maintainable, cost-conscious, and operationally ready. WHAT YOU'LL DO
• Lead client discovery to understand business goals, the data landscape, constraints, and success metrics, then translate findings into a clear delivery plan. • Design and recommend data lake, lakehouse, data warehouse, and analytical data store architectures on Azure and Microsoft Fabric aligned to client needs. • Implement, or guide implementation of, ingestion, transformation, and orchestration pipelines using Microsoft Fabric experiences and Azure services such as Data Factory, Synapse, and Databricks.
• Design and recommend data lake, lakehouse, data warehouse, and analytical data store architectures on Azure and Microsoft Fabric aligned to client needs. • Implement, or guide implementation of, ingestion, transformation, and orchestration pipelines using Microsoft Fabric experiences and Azure services such as Data Factory, Synapse, and Databricks. • Integrate data from operational systems, APIs, and third-party sources and transform raw data into curated datasets ready for consumption.
• Implement logging, metrics, and operational runbooks, and support deployments, cutovers, and hypercare as needed. • Design and implement security, governance, and compliance controls, including access, least privilege, data protection, and lineage across Azure and Fabric. • Facilitate workshops and communicate architecture tradeoffs, partnering with client stakeholders, architects, analysts, and BI developers to deliver trusted datasets.
Required Qualifications • Experience designing and delivering modern analytics platforms using lakehouse and/or data warehouse patterns on Azure and/or Microsoft Fabric, including client-facing delivery. • Strong SQL skills with experience building transformations and dimensional or analytical models.
• Direct experience with Microsoft Fabric components - OneLake, Lakehouse, Warehouse, Data Factory in Fabric, and Real-Time Analytics/KQL databases - including platform administration, capacity planning, and standards. • Experience with Azure services commonly used in data platforms, such as Azure Data Factory, Synapse, Databricks, ADLS Gen2, and Key Vault. • Working knowledge of Azure architecture fundamentals across identity, networking, storage, monitoring, resiliency, and cost management.
• Experience with Azure services commonly used in data platforms, such as Azure Data Factory, Synapse, Databricks, ADLS Gen2, and Key Vault. • Working knowledge of Azure architecture fundamentals across identity, networking, storage, monitoring, resiliency, and cost management. • Familiarity with AI-enablement patterns - such as preparing governed enterprise data for Azure AI Search or Microsoft Foundry, retrieval-augmented generation, or agent-based solutions—is valued. Deep agent application development experience is not required.
• Working knowledge of Azure architecture fundamentals across identity, networking, storage, monitoring, resiliency, and cost management. • Familiarity with AI-enablement patterns - such as preparing governed enterprise data for Azure AI Search or Microsoft Foundry, retrieval-augmented generation, or agent-based solutions—is valued. Deep agent application development experience is not required. • Experience implementing CI/CD and Infrastructure as Code, including environment strategy and release management for data solutions.
• Familiarity with semantic modeling and BI enablement patterns, including Power BI datasets, self-service analytics, and governance guardrails. • Current Microsoft certifications relevant to the role are valued, especially Microsoft Certified: Fabric Data Engineer Associate (DP-700), Microsoft Certified: Power BI Data Analyst Associate (PL-300), and, for broader architecture responsibilities, Microsoft Certified: Azure Solutions Architect Expert (AZ-305). Equivalent current Microsoft credentials and experience mentoring or enabling client teams are also welcome. About Us
• Knowledge of data quality practices, including validation, reconciliation, testing, incident triage, and root-cause analysis. • Working knowledge of Power BI, including semantic modeling concepts, to support end-to-end analytics delivery; Power Apps experience is a plus. • Understanding of security and governance concepts for data platforms, including access controls, least privilege, compliance, and lineage.
• Experience implementing CI/CD and Infrastructure as Code, including environment strategy and release management for data solutions. • Familiarity with semantic modeling and BI enablement patterns, including Power BI datasets, self-service analytics, and governance guardrails. • Current Microsoft certifications relevant to the role are valued, especially Microsoft Certified: Fabric Data Engineer Associate (DP-700), Microsoft Certified: Power BI Data Analyst Associate (PL-300), and, for broader architecture responsibilities, Microsoft Certified: Azure Solutions Architect Expert (AZ-305). Equivalent current Microsoft credentials and experience mentoring or enabling client teams are also welcome.

Your next step

Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.

Applying through Paylocity

  • “Upload your resume and we’ll automatically fill out your application”: the form fills itself from your file, so check it before sending.

Already applied? Track this application

Has Interlink Cloud Advisors posted this job before?

Yes. We’ve followed one other Senior Data & AI Engineering Consultant job there since November 2026. It is still up.

  1. WorkerStill up after 3 days, first seen Nov 18
  2. This jobUp 3 days so far, first seen Nov 18

Job description

View original posting ↗

Description

A senior Microsoft-focused consulting role spanning discovery, architecture, engineering, governance, and client enablement.

~ Client-Facing (Discovery/Architecture/Delivery)

~ Microsoft Cloud (Azure & Microsoft Fabric) 

~ Data Engineering (Trusted Data Foundations for Analytics & AI) 

 

Interlink Cloud Advisors is looking for a Senior Data & AI Engineering Consultant to help clients build modern, scalable data platforms on Microsoft Azure and Microsoft Fabric. In this client-facing role, you'll lead discovery, design pragmatic architectures, and deliver end-to-end solutions that turn raw data into trusted, analytics-ready datasets for BI, reporting, advanced analytics, and AI use cases. You'll work across Fabric (OneLake, Lakehouse, Warehouse) and Azure data services to ensure solutions are secure, governed, maintainable, cost-conscious, and operationally ready.


WHAT YOU'LL DO

• Lead client discovery to understand business goals, the data landscape, constraints, and success metrics, then translate findings into a clear delivery plan.

• Design and recommend data lake, lakehouse, data warehouse, and analytical data store architectures on Azure and Microsoft Fabric aligned to client needs.

• Implement, or guide implementation of, ingestion, transformation, and orchestration pipelines using Microsoft Fabric experiences and Azure services such as Data Factory, Synapse, and Databricks.

• Integrate data from operational systems, APIs, and third-party sources and transform raw data into curated datasets ready for consumption.

• Build and maintain analytics-ready data models and schemas; implement enrichment, business rules, and reusable patterns for consistency across projects.

• Enable multiple compute engines - SQL, Spark/PySpark, Spark SQL, and KQL - against shared datasets to support diverse analytics scenarios.

• Prepare governed data products and reusable datasets for BI, advanced analytics, and AI use cases, including retrieval-ready data patterns when relevant.

• Establish data quality practices, including validation, reconciliation, testing, and monitoring; troubleshoot failures and continuously improve pipeline resiliency.

• Optimize transformations, query performance, and pipeline execution to meet client service level and cost objectives.

• Implement logging, metrics, and operational runbooks, and support deployments, cutovers, and hypercare as needed.

• Design and implement security, governance, and compliance controls, including access, least privilege, data protection, and lineage across Azure and Fabric.

• Facilitate workshops and communicate architecture tradeoffs, partnering with client stakeholders, architects, analysts, and BI developers to deliver trusted datasets.

• Produce clear consulting deliverables, including design documents, diagrams, implementation guides, and enablement materials, to support adoption and a smooth handoff.

Requirements

Required Qualifications

• Experience designing and delivering modern analytics platforms using lakehouse and/or data warehouse patterns on Azure and/or Microsoft Fabric, including client-facing delivery.

• Strong SQL skills with experience building transformations and dimensional or analytical models.

• Hands-on experience with Spark (PySpark/Spark SQL) and/or KQL for data engineering and analytics workloads.

• Experience applying software engineering practices to data solutions, including modular design, source control, automated testing, code review, and technical documentation.

• Experience building reliable data pipelines, including orchestration, scheduling, error handling, and automated monitoring.

• Knowledge of data quality practices, including validation, reconciliation, testing, incident triage, and root-cause analysis.

• Working knowledge of Power BI, including semantic modeling concepts, to support end-to-end analytics delivery; Power Apps experience is a plus.

• Understanding of security and governance concepts for data platforms, including access controls, least privilege, compliance, and lineage.

• Strong communication skills, with the ability to present recommendations, align stakeholders, and manage expectations in a client environment.


Preferred Qualifications

• Direct experience with Microsoft Fabric components - OneLake, Lakehouse, Warehouse, Data Factory in Fabric, and Real-Time Analytics/KQL databases - including platform administration, capacity planning, and standards.

• Experience with Azure services commonly used in data platforms, such as Azure Data Factory, Synapse, Databricks, ADLS Gen2, and Key Vault.

• Working knowledge of Azure architecture fundamentals across identity, networking, storage, monitoring, resiliency, and cost management.

• Familiarity with AI-enablement patterns - such as preparing governed enterprise data for Azure AI Search or Microsoft Foundry, retrieval-augmented generation, or agent-based solutions—is valued. Deep agent application development experience is not required.

• Experience implementing CI/CD and Infrastructure as Code, including environment strategy and release management for data solutions.

• Familiarity with semantic modeling and BI enablement patterns, including Power BI datasets, self-service analytics, and governance guardrails.

• Current Microsoft certifications relevant to the role are valued, especially Microsoft Certified: Fabric Data Engineer Associate (DP-700), Microsoft Certified: Power BI Data Analyst Associate (PL-300), and, for broader architecture responsibilities, Microsoft Certified: Azure Solutions Architect Expert (AZ-305). Equivalent current Microsoft credentials and experience mentoring or enabling client teams are also welcome.


About Us

Interlink is a nationally recognized IT consultancy, offering the flexibility of a small company while providing stability and benefits usually found at enterprise firms. We work with a "family first" attitude, so we look to hire motivated individuals who understand that getting work done while having fun is important. As the winner of The Best Places to Work Award for five consecutive years, we know what it takes to care for our employees and clients. 

Interlink Advantage

We are the premier Microsoft Cloud consulting company based in Mason, OH. We are a team of trusted experts who know how to navigate the intricacies of Microsoft's technologies, guiding and educating clients to avoid overspending on tech licenses while optimizing their tools. At Interlink, we believe working in an innovative, fun, and collaborative environment is key to success. Get to know us and our company culture more at: http://www.interlink.com/about-us/company-culture.   

Interlink Cloud Advisors is an equal-opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status. 

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Hybrid

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.