AI-First Data Engineer: Build Scalable Pipelines

Plante & Moran, PLLC; Southfield (MI); On-site; USD 83,000 - 138,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Discretionary bonus

Job summary

Plante Moran is seeking an AI-native Data Engineer to design and operate scalable data pipelines in a Microsoft-centric stack, including Fabric, Azure Data Factory, and Azure SQL. You will implement the Bronze/Silver/Gold Medallion Architecture, land and transform data, and publish trusted analytics and AI-ready data products.

You will work with PySpark, Python, and SQL to build transformations, ingest data from APIs, and enable AI feature workflows, with strong emphasis on observability,

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field required.
• 2-4 years in data engineering, analytics engineering, or software development.
• Strong SQL plus Python for data transformation and pipeline logic; experience with PySpark/Spark.
• Hands-on with Microsoft Fabric (Lakehouse/Data Engineering/Pipelines) and Azure Data Factory; general Azure exposure (Azure SQL, Storage, APIs).
• Experience with Databricks (Azure Databricks preferred).
• Working knowledge of Git and CI/CD basics (branching, PRs, automated checks/deployments).

Responsibilities

• Build and operate automated, repeatable data pipelines in Microsoft Fabric and Azure (e.g., Data Factory) with strong observability.
• Implement Medallion Architecture (Bronze/Silver/Gold): land raw data, transform/validate/enrich, and publish trusted data products for analytics and AI.
• Ingest data from APIs and enterprise systems into lakehouses and Azure SQL-based stores; model data to support reuse and AI/ML feature needs.
• Develop transformations using Python/PySpark/Spark and SQL/T-SQL.

Skills

SQL

Python

Spark/PySpark

AI/ML feature needs

Education

Bachelor's degree in CS or related field

Tools

Microsoft Fabric

Azure Data Factory

Azure SQL

Databricks

Git/GitHub Actions

Job description

Plante Moran is seeking an AI-native Data Engineer to design and operate scalable data pipelines in a Microsoft-centric stack, including Fabric, Azure Data Factory, and Azure SQL. You will implement the Bronze/Silver/Gold Medallion Architecture, land and transform data, and publish trusted analytics and AI-ready data products.

You will work with PySpark, Python, and SQL to build transformations, ingest data from APIs, and enable AI feature workflows, with strong emphasis on observability,