AI Data Engineer

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

Count on us. Our "we-care" culture is more than just a motto; it's a promise. From day one, we prioritize your growth, well-being, and success. You can count on us to support your career journey and help you achieve your professional goals. Join us.

About the Role

Plante Moran is building the next generation of its data and analytics platform, and we are looking for an AI-Native Data Engineer who is excited to build, experiment, and learn fast. You'll work in a modern Microsoft-centric ecosystem built on Microsoft Fabric, Azure, and Power BI, designing scalable, governed solutions aligned to Medallion Architecture - with AI treated as part of the data engineering lifecycle. This role is ideal for a go-getter: someone who takes initiative, loves problem-solving, is hungry to learn, and has a strong desire to build and create new things.

Your role

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. Experience building AI agentic workloads (e.g., Microsoft Copilot Agents, workflow automation, PR review bots, orchestration assistants), or strong interest in learning agent-based patterns. Use Git and CI/CD (e.g., GitHub/GitHub Actions) for source control, reviews, and deployments; leverage Copilot/AI tools to accelerate delivery and documentation. Partner with architects and stakeholders to translate ambiguous requirements into scalable, governed solutions.

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).
• Must be able to remain in a stationary sitting position for at least 75% of the time.
• Must be able to lift at least 15 lbs- specific job duties may require additional lifting to move, transport, position and install equipment.
• Frequently positions self to bend and lift packages.
• Occasional moving & lifting of equipment; bending, lifting, climbing required to position self to maintain computers during engagements.
• Person in position needs to occasionally move about the inside of the office to access machinery, cabinets, etc.
• Person in position frequently communicates with individuals who have inquires.
• Must be able to exchange information in these situations.
• Ability to work in a high stress environment.
• Reliable transportation and valid driver's license are required including a clean driving record.
• Minimum levels of auto insurance coverage are required.
• Ability to travel locally, work overtime and weekends is required.

Nice to Have's

• Experience building AI agentic workloads (e.g., Microsoft Copilot Agents, workflow automation, PR review bots, orchestration assistants), or strong interest in learning agent-based patterns.
• Familiarity with lakehouse or data warehouse architectures and governance concepts (cataloging/lineage/security).
• Power BI experience with semantic models or tabular modeling.
• PowerShell scripting or automation for deployments and operational workflows.

Benefits Overview

The specific statements above are not intended to be all-inclusive. We are pleased to offer eligible staff a robust benefits package. Eligibility and contribution requirements for some of these benefits vary based on the number of hours staff work per week.

Benefits

• Highlights include health, dental, vision, disability, and life insurance.
• In addition to this, eligible staff are able to take advantage of our Flexible Time Off and various pre-determined holidays, as well as a 401(k) plan, flexible benefits plans, business-related travel expense, lodging, and meal reimbursement for business-related use.
• A pension plan is also available for eligible administrative and paraprofessional staff.
• A discretionary bonus plan is available for eligible staff.
• Plante Moran also offers some contingent staff positions the option to elect health insurance in addition to limited paid sick time.

Culture & Diversity

On the surface, we are one of the nation’s largest audit, tax, consulting, and wealth management firms. But dig a little deeper, and you'll see what makes us different: we are a relatively jerk-free firm (hey, nobody 's perfect) with a world-class culture, consistent recognition as one of Fortune Magazine's "100 Best Companies to Work For," and an endless array of opportunities. At Plante Moran, diversity, equity and inclusion means that all staff members have equitable and fair opportunities to succeed, in an inclusive environment, with their individual, unique identities.

We believe that each person's ultimate potential begins with first acknowledging their inherent dignity. When we can recognize - and celebrate - our many human differences, we're able to create a workplace where all staff feel a sense of belonging and an opportunity to succeed. This allows us to attract and retain the best talent, serve clients through diverse thinking, and better represent and support the various communities in which we live and work.

Equal Opportunity Employer

Plante Moran is an Equal Opportunity Employer.

Plante Moran maintains a drug-free workplace.

Candidates & Application

Due to the high volume of interest in our positions, only candidates selected for interviews will be contacted.

Candidates must be legally authorized to work in the United States without sponsorship, with the exception of qualified candidates who are bilingual in either Japanese and English or Chinese and English.

Unsolicited resumes from search firms or employment agencies, or similar, will not be paid a fee and become the property of Plante Moran.

Compensation

The compensation range reflects the base salary we reasonably expect to pay for this position across our offices in the following regions: CO, IL, OH, and MA. Please review the position description for the applicable geographic location.

The compensation range for this role in CO, IL, OH, and MA is: $82,500 -$137,500.

Application Window

This application window is a good-faith estimate of the time that this posting will remain open. This deadline will be promptly updated if the deadline is extended.

Our founders often referred to our firm as "a people firm disguised as an accounting firm." Why? Because people are at the core of everything we do, and our firm was built on values and principles that support this philosophy to this day.