AI Data Engineer

Plante Moran; Chicago (IL); On-site; USD 83,000 - 138,000; Full time

Benefits offered by this job

Health insurance

401(k)

Flexible time off

Pension plan

Discretionary bonus

Job summary

Plante Moran is building the next generation of its data and analytics platform, and we’re 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.

Qualifications

• Bachelor's degree required.
• 2–4 years in data engineering, analytics engineering, or software development.
• Strong SQL and Python for data transformation and pipeline logic; PySpark/Spark experience.
• Hands-on with Microsoft Fabric (Lakehouse/Data Engineering/Pipelines) and Azure Data Factory; Azure exposure.
• Experience with Databricks (Azure Databricks preferred).
• Working knowledge of Git and CI/CD basics.

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) to 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., Copilot Agents, workflow automation, PR review bots, orchestration assistants), or strong interest in learning agent‑based patterns.
• Use Git and CI/CD 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.

Skills

SQL

Python

PySpark

Databricks

Azure

Power BI

Git

CI/CD

APIs

Data pipelines

Fabric

Education

Bachelor's degree

Tools

Azure Data Factory

Microsoft Fabric

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’re 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.

The 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.

This is an exempt position, so you may have to work hours that exceed the standard 40-hour work week.

What makes us different?

On the surface, we’re 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’re 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. So,what are you waiting for?

Plante Moran enjoys a “Workplace for Your Day” model which, simply put, means we strive for flexibility and balance while staying true to our principally in‑person model. We believe that face‑to‑face interactions are paramount for individual and collective development, but also encourage individuals to work with their supervisor and team to determine their optimal working environment each day.

Plante Moran is committed to a diverse workplace. We strive to create a culture where each person feels accepted and valued. 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.Plante Moran is an Equal Opportunity Employer.

Plante Moran maintains a drug‑free workplace.

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. 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.

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. Generally, experienced hires are not hired at or near the maximum salary range, as compensation decisions take into account a wide variety of factors, including but not limited to: responsibilities, education, experience, knowledge, skills, and geography. For early career roles, including campus hires, we offer standardized, market‑based starting salaries among individuals within the same hiring group. This approach ensures fairness and reflects current industry benchmarks for entry‑level talent.

Under Colorado’s Job Application Fairness Act, you have the right to redact, from any documents that you submit in connection with your application, information that identifies your age, date of birth, or dates of attendance at or graduation from an educational institution. Should you wish to exercise your right to redact such information, please redact it prior to submitting documentation.

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

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.