AI Data Engineer

Plante Moran is an audit, tax, consulting, and wealth management firm building the next generation of its data and analytics platform. The AI Data Engineer will design, build, and operate scalable, governed data pipelines and products across Microsoft Fabric and Azure, while incorporating AI, analytics, and machine learning needs into the data engineering lifecycle.

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

Preferred

• 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
• AI Agent Workloads
• Microsoft Copilot Agents
• Workflow Automation
• PR Review Bots
• Orchestration Assistants
• Agent-Based Patterns
• Lakehouse Architecture
• Data Warehouse Architecture
• Data Governance
• Data Cataloging
• Data Lineage
• Data Security
• Power BI
• Semantic Modeling
• Tabular Modeling
• PowerShell Scripting
• Deployment Automation
• Operational Workflow Automation
• Learning Agility

Benefits

• Career growth support and professional development support from day one
• Workplace for Your Day model offering flexibility and balance while maintaining a principally in-person model
• Health insurance for eligible staff
• Dental insurance for eligible staff
• Vision insurance for eligible staff
• Disability insurance for eligible staff
• Life insurance for eligible staff
• Flexible Time Off for eligible staff
• Various predetermined holidays for eligible staff
• 401(k) plan for eligible staff
• Flexible benefits plans for eligible staff
• Business-related travel expense, lodging, and meal reimbursement for business-related use
• Pension plan for eligible administrative and paraprofessional staff
• Discretionary bonus plan for eligible staff
• Option for some contingent staff positions to elect health insurance
• Limited paid sick time for some contingent staff positions

Company

• Accounting and business advisory services, plus wealth management
• Southfield, Michigan, USA
• http://www.plantemoran.com/
• Founded in 1924
• 1001-5000 employees

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)
• Reliable transportation and valid driver's license are required including a clean driving record
• Minimum levels of auto insurance coverage are required
• 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
• 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
• 2–4 years in data engineering, analytics engineering, or software development.

Required skills

• Microsoft Fabric, Azure Data Factory, Azure, SQL, Python, PySpark, Apache Spark, Databricks, Git, CI/CD, Data Engineering, Medallion Architecture

Preferred skills

• Power BI experience with semantic models or tabular modeling

Experience

• 2+ years