
Sr. Data Engineer
Plante Moran2 days ago
Chicago, IL, USA +2 moreSenior
Base Salary
$96k - $158k/yr
Responsibilities
- Build and support end-to-end data pipelines using Microsoft Fabric, Azure Data Factory, and related Azure services.
- Implement Medallion Architecture across Bronze, Silver, and Gold layers for ingestion, transformation, quality, and consumption.
- Ingest data from APIs, enterprise applications, files, and databases into governed lakehouse, warehouse, and Azure SQL data stores.
- Develop scalable data transformations using SQL, T-SQL, Python, PySpark, and Spark.
- Design analytical data products, dimensional models, and Power BI semantic models for self-service analytics.
- Implement data validation, testing, monitoring, alerting, and observability in production solutions.
- Translate business and solution requirements into technical designs, data flows, integration approaches, and delivery plans.
- Apply engineering standards for data modeling, source control, CI/CD, testing, validation, pull-request reviews, and operational support.
- Partner with business stakeholders, analysts, data architects, and platform teams on architecture, security, governance, and platform standards.
- Lead technical workstreams from design through development, testing, deployment, operational handoff, and ongoing support.
- Conduct code reviews and mentor data and analytics engineers.
- Use GitHub Copilot and Microsoft 365 Copilot to improve development, documentation, analysis, and collaboration.
Requirements
- Bachelor’s degree in Software Engineering, Computer Science, Data Science, or a related field.
- 3–6 years of experience in data engineering, analytics engineering, software development, business intelligence, or a related technical field.
- Experience designing, building, deploying, and supporting enterprise data pipelines and analytical data products.
- Experience leading technical workstreams or complex engineering initiatives through production support.
- Experience mentoring engineers, conducting code reviews, or establishing engineering standards and reusable patterns.
- Strong hands-on SQL and T-SQL skills, including data modeling, query optimization, and analytical workloads.
- Strong hands-on Python experience and working knowledge of PySpark or other scalable data-processing frameworks.
- Experience with Microsoft Fabric, including Lakehouse, Data Engineering, Data Factory/Pipelines, OneLake, and warehouse or semantic model concepts.
- Experience with Azure Data Factory, Azure Data Lake Storage, Azure SQL, APIs, and enterprise system integration.
- Working knowledge of data warehousing, dimensional modeling, Medallion Architecture, data governance, lineage, and security.
- Experience with GitHub, pull-request workflows, CI/CD, and deployment automation such as GitHub Actions.
- Experience implementing data quality controls, automated testing, monitoring, observability, and production support practices.
- Candidates must be legally authorized to work in the United States without sponsorship, except qualified candidates bilingual in Japanese and English or Chinese and English.
Benefits
- Flexible, principally in-person Workplace for Your Day model with daily work-location flexibility determined with the supervisor and team.
- Health, dental, vision, disability, and life insurance for eligible staff.
- Flexible Time Off and predetermined holidays for eligible staff.
- 401(k) plan and flexible benefits plans for eligible staff.
- 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 positions may elect health insurance and receive limited paid sick time.
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.