Data Engineer

The Experience Youll Create:

• Design build and maintain scalable cloud-native data pipelinesincluding ETL/ELT event-driven and serverless patterns using Azure Functions and related servicesthat ingest transform and load data from Continentals diverse source systems including ERP POS HRIS and finance platforms into a centralized lake or data warehouse.
• Develop and maintain data models within Microsoft Fabric and Azure that support analytics business intelligence and emerging AI use cases ensuring data is structured for both performance and usability.
• Integrate data from disparate systems across Continentals business units into a unified enterprise data model resolving inconsistencies and establishing a single source of truth for key business metrics.
• Implement and enforce data quality validation and monitoring practices that ensure downstream consumersanalysts dashboards and AI modelscan trust the data they are working with.
• Collaborate closely with the Business Analyst and IT AI & Data Manager to understand reporting and analytics requirements translating them into efficient well-documented data solutions.
• Design and implement AI-augmented data engineering solutionsincluding AI agents automated data quality processes and intelligent pipeline componentsthat drive efficiency across Continentals data platform. This is not a support role for AI; were looking for someone who can actively build and deploy AI-driven capabilities within the data engineering workflow.
• Build and optimize semantic models and datasets that power PowerBI dashboards and reports working with analysts to ensure visualizations are backed by performant accurate data.
• Contribute to data governance efforts by maintaining data dictionaries pipeline documentation and lineage tracking so the team can understand trust and build on the work being done.
• Monitor pipeline health troubleshoot data failures and proactively address issues before they impact reporting or downstream business processes.
• Stay current on developments in cloud data engineering AI tooling and the Microsoft data ecosystem bringing new ideas and approaches to the team as the platform continues to mature.
• Support M&A and new business onboarding by connecting new source systems into existing pipelines and data models with minimal disruption to existing operations.

Ingredients for Thriving:

• Bachelors degree in Computer Science Information Systems Data Engineering Mathematics or a related technical field.
• 35 years of experience in data engineering with a portfolio of work that includes building and maintaining production-grade data pipelines and data models.
• Hands-on experience with Microsoft Azure data services and Microsoft Fabricincluding Data Factory Azure Functions Synapse and Lakehouseas the primary stack. Experience with AWS data services is also relevant and viewed favorably particularly where cloud architecture patterns are transferable.
• Strong SQL skills with experience writing complex queries stored procedures and transformations for large multi-source datasets.
• Strong proficiency in Python for data engineering workincluding pipeline development data transformation automation scripting and cloud function development. Familiarity with other modern scripting languages or frameworks used in cloud-native data environments is a plus.
• Experience building semantic models or datasets that serve as the foundation for Power BI reporting with an understanding of how modeling decisions affect performance and usability.
• Demonstrated hands-on experience applying AI within a data engineering contextimplementing AI agents integrating LLM-based processes into pipelines or building AI-driven automation. Extensive experience is not required but practical working knowledge is essential; we want someone who has built something real in this space not just read about it.
• A solid understanding of data quality data governance and data lineage principles and experience applying them in a real production environment.
• Experience integrating data from multiple enterprise systems (ERP POS HRIS CRM or similar) with an ability to navigate source system complexity and build reliable connections between them.
• Strong communication skills with the ability to work alongside business analysts and non-technical stakeholders to understand requirements and explain technical decisions clearly.
• A curiosity-driven growth-oriented mindsetsomeone who keeps up with the evolving data and AI landscape takes ownership of their work end-to-end and is always looking to improve how things are built.

• Prolonged periods of sitting at a desk and working on a computer.
• The role will be hybrid with locations in Sterling Heights and Troy.
• Occasional Travel is required for this role to visit customer sites and warehouses

Savor the Benefits:

• Health Coverage Medical Dental and Vision
• Voluntary Life/AD&D Short-Term and Long-Term Disability Critical Illness
• 401(k)
• Paid Time Off
• Paid Parental Leave
• Wellness Programs
• Additional Perks