AI Data Engineer
Plante Moran1 month ago
Chicago, IL, USA +4 moreMid Level / Senior
Base Salary
$83k - $138k/yr
Responsibilities
- Build and operate automated, repeatable data pipelines in Microsoft Fabric and Azure with strong observability.
- Implement Bronze, Silver, and Gold Medallion Architecture for raw data ingestion, transformation, validation, enrichment, and trusted data products.
- Ingest data from APIs and enterprise systems into lakehouses and Azure SQL-based stores and model data for reuse and AI/ML feature needs.
- Develop data transformations and pipeline logic using Python, PySpark, Spark, SQL, and T-SQL.
- Build or support AI agentic workloads, including Copilot Agents, workflow automation, PR review bots, and orchestration assistants.
- Use Git and CI/CD workflows for source control, code reviews, automated checks, and deployments.
- Partner with architects and stakeholders to translate ambiguous requirements into scalable, governed solutions.
- Work locally with occasional travel, overtime, and weekend requirements, including physical activities related to maintaining or positioning equipment.
Requirements
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- 2–4 years of experience in data engineering, analytics engineering, or software development.
- Strong SQL and Python skills for data transformation and pipeline logic, with experience using PySpark or Spark.
- Hands-on experience with Microsoft Fabric and Azure Data Factory, plus general Azure exposure including Azure SQL, Storage, and APIs.
- Experience with Databricks, preferably Azure Databricks.
- Working knowledge of Git and CI/CD fundamentals, including branching, pull requests, automated checks, and deployments.
- Ability to remain seated for at least 75% of the time and lift at least 15 pounds, with additional bending, lifting, climbing, and equipment-maintenance duties as required.
- Ability to work in a high-stress environment and communicate effectively with others.
- Reliable transportation, a valid driver's license, a clean driving record, and required auto insurance coverage.
- Ability to travel locally and work overtime and weekends.
- Preferred qualifications include experience with AI agentic workloads, lakehouse or data warehouse architecture and governance, Power BI semantic or tabular modeling, and PowerShell scripting or deployment automation.
Benefits
- Health, dental, vision, disability, and life insurance for eligible staff.
- Flexible Time Off and predetermined holidays.
- 401(k) plan and flexible benefits plans.
- Business-related travel expense, lodging, and meal reimbursement.
- Pension plan for eligible administrative and paraprofessional staff.
- Discretionary bonus plan for eligible staff.
- Some contingent staff may elect health insurance and receive limited paid sick time.
- Workplace for Your Day model with flexibility while remaining principally in person.
- Exempt position that may require more than a standard 40-hour work week.
Tech Stack
Categories
Data Engineering
About Plante Moran
Plante Moran is a partnership-based professional services firm providing audit, tax, consulting, and wealth management to middle-market companies, public sector entities, and nonprofits. The firm generates revenue from advisory and attest engagements and wealth management fees, and also offers technology and business advisory services. Founded in 1924 and headquartered in Southfield, Michigan, it operates from 23 offices across the U.S. and internationally.