Dbt Developer Jobs in Novi, MI (NOW HIRING)

Microsoft Fabric - L55 - Fabric Architect/Engineer

Join our AI & Engineering team in transforming technology platforms, driving innovation, and helping make a significant impact on our clients' success. You'll work alongside talented professionals reimagining and re-engineering operations and processes that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

AI & Engineering leverages cutting-edge engineering capabilities to build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions are powered by engineering for business advantage, transforming mission-critical operations. We enable clients to stay ahead with the latest advancements by transforming engineering teams and modernizing technology & data platforms. Our delivery models are tailored to meet each client's unique requirements.

Recruiting for this role ends on 9/19/26.

Work You'll Do

As a Lead Data Engineer II on the AI & Data team, you will be responsible for leading the design and delivery of modern data and analytics solutions for client engagements. In this role, you will bring genuine, hands-on, lived-in experience leading Microsoft Fabric implementation and migration engagements - spanning Lakehouse, Warehouse, and OneLake - applying practical, proven strategies to deliver scalable, production-grade unified data platforms.

• Lead small engagements or key workstreams within large, complex data and analytics transformations across industries
• Design and implement cloud and hybrid data architectures, migration approaches, and technology solutions across data and analytics platforms
• Manage day-to-day stakeholder relationships and align technical delivery to business and program objectives
• Oversee quality of team deliverables and recommendations while contributing to hands-on solution delivery across distributed teams
• Support practice growth through proposal development and deal shaping, thought leadership and AI-driven accelerators, and coaching junior practitioners
• Lead delivery of Microsoft Fabric implementation and migration engagements, applying practical, proven architecture and migration patterns across Lakehouse, Warehouse, and OneLake workloads
• Own hands-on build of the Fabric environment and its unified data platform end-to-end across workloads, translating architecture decisions and recommendations into scalable, flexible, working implementations
• Design and build out medallion (bronze/silver/gold) layers in Fabric, and implement role-based access control and data classification definitions
• Stand up ETL/pipeline work using Spark Notebooks, Dataflow Gen2, Fabric Data Factory with close attention to lineage preservation
• Advise across the full breadth of Fabric architecture - workspace organization/structure, CI/CD, data protection planes and best practices, capacity management, backup/DR strategy, and guidance on best fit Fabric items
• Stay current with evolving data and analytics technology platform capabilities, proactively evaluating and applying new capabilities to client solutions

Qualifications

Required:

• 6+ years experience with relevant technology project experience in data architecture, data engineering, enterprise architecture, or a related discipline
• 3+ years hands-on experience architecting and delivering end-to-end Microsoft Fabric-based solutions, including lakehouse and warehouse implementations built on Delta Lake table formats, medallion architectures, ingestion pipelines, semantic models, and governance frameworks

• Experience implementing Fabric governance and security constructs, including role-based access control (RBAC), data classification, data protection best practices, and integration with Microsoft Purview for enterprise data governance
• Experience with dimensional modeling and star schema design in support of semantic models and BI reporting
• Working understanding of the latest Microsoft Fabric platform capabilities - such as Fabric IQ, Ontology, Graph, and Real-Time Intelligence - and how to apply them to deliver business value, including grounding agentic AI experiences in enterprise semantic and ontology layers
• Experience building ETL/pipeline solutions using Fabric Notebooks and/or Dataflow Gen2, with attention to data lineage preservation, and with dbt for transformation orchestration and modeling workflows
• Experience with Fabric platform architecture, including workspace organization/structure, CI/CD and deployment pipelines (e.g., Fabric Git integration and deployment pipelines across dev/test/prod), capacity management, and backup/DR strategy
• Experience supporting deal pursuit and shaping activities, including defining architecture, migration patterns, and implementation approaches
• 4+ years hands-on experience with SQL/T-SQL and Python, including PySpark/Spark SQL for data transformation and analytics modeling, with working knowledge of REST API-based data ingestion and CI/CD practices (e.g., Azure DevOps, GitHub)

• 4+ years experience leading, managing and delivering complex AI&Data solutions engagements
• Bachelor's or Master's degree in Computer Science, Engineering, Data Science, AI, or related field
• Ability to travel up to 50% on average, based on the work you do and the clients and industries/sectors you serve
• Limited immigration sponsorship may be available

Preferred:

• Experience with Databricks, Snowflake, Google BigQuery and Redshift
• Experience in consulting and client-facing delivery roles
• Experience in creating critical collaterals for client workshops and customer interactive sessions
• Experience presenting technical content to both large and small audiences

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $151,000 to $253,000.

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.

Microsoft Fabric - L55 - Fabric Architect/Engineer

Join our AI & Engineering team in transforming technology platforms, driving innovation, and helping make a significant impact on our clients' success. You'll work alongside talented professionals reimagining and re-engineering operations and processes that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

AI & Engineering leverages cutting-edge engineering capabilities to build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions are powered by engineering for business advantage, transforming mission-critical operations. We enable clients to stay ahead with the latest advancements by transforming engineering teams and modernizing technology & data platforms. Our delivery models are tailored to meet each client's unique requirements.

Recruiting for this role ends on 9/19/26.

Work You'll Do

As a Lead Data Engineer II on the AI & Data team, you will be responsible for leading the design and delivery of modern data and analytics solutions for client engagements. In this role, you will bring genuine, hands-on, lived-in experience leading Microsoft Fabric implementation and migration engagements - spanning Lakehouse, Warehouse, and OneLake - applying practical, proven strategies to deliver scalable, production-grade unified data platforms.

• Lead small engagements or key workstreams within large, complex data and analytics transformations across industries
• Design and implement cloud and hybrid data architectures, migration approaches, and technology solutions across data and analytics platforms
• Manage day-to-day stakeholder relationships and align technical delivery to business and program objectives
• Oversee quality of team deliverables and recommendations while contributing to hands-on solution delivery across distributed teams
• Support practice growth through proposal development and deal shaping, thought leadership and AI-driven accelerators, and coaching junior practitioners
• Lead delivery of Microsoft Fabric implementation and migration engagements, applying practical, proven architecture and migration patterns across Lakehouse, Warehouse, and OneLake workloads
• Own hands-on build of the Fabric environment and its unified data platform end-to-end across workloads, translating architecture decisions and recommendations into scalable, flexible, working implementations
• Design and build out medallion (bronze/silver/gold) layers in Fabric, and implement role-based access control and data classification definitions
• Stand up ETL/pipeline work using Spark Notebooks, Dataflow Gen2, Fabric Data Factory with close attention to lineage preservation
• Advise across the full breadth of Fabric architecture - workspace organization/structure, CI/CD, data protection planes and best practices, capacity management, backup/DR strategy, and guidance on best fit Fabric items
• Stay current with evolving data and analytics technology platform capabilities, proactively evaluating and applying new capabilities to client solutions

Qualifications

Required:

• 6+ years experience with relevant technology project experience in data architecture, data engineering, enterprise architecture, or a related discipline
• 3+ years hands-on experience architecting and delivering end-to-end Microsoft Fabric-based solutions, including lakehouse and warehouse implementations built on Delta Lake table formats, medallion architectures, ingestion pipelines, semantic models, and governance frameworks

• Experience implementing Fabric governance and security constructs, including role-based access control (RBAC), data classification, data protection best practices, and integration with Microsoft Purview for enterprise data governance
• Experience with dimensional modeling and star schema design in support of semantic models and BI reporting
• Working understanding of the latest Microsoft Fabric platform capabilities - such as Fabric IQ, Ontology, Graph, and Real-Time Intelligence - and how to apply them to deliver business value, including grounding agentic AI experiences in enterprise semantic and ontology layers
• Experience building ETL/pipeline solutions using Fabric Notebooks and/or Dataflow Gen2, with attention to data lineage preservation, and with dbt for transformation orchestration and modeling workflows
• Experience with Fabric platform architecture, including workspace organization/structure, CI/CD and deployment pipelines (e.g., Fabric Git integration and deployment pipelines across dev/test/prod), capacity management, and backup/DR strategy
• Experience supporting deal pursuit and shaping activities, including defining architecture, migration patterns, and implementation approaches
• 4+ years hands-on experience with SQL/T-SQL and Python, including PySpark/Spark SQL for data transformation and analytics modeling, with working knowledge of REST API-based data ingestion and CI/CD practices (e.g., Azure DevOps, GitHub)

• 4+ years experience leading, managing and delivering complex AI&Data solutions engagements
• Bachelor's or Master's degree in Computer Science, Engineering, Data Science, AI, or related field
• Ability to travel up to 50% on average, based on the work you do and the clients and industries/sectors you serve
• Limited immigration sponsorship may be available

Preferred:

• Experience with Databricks, Snowflake, Google BigQuery and Redshift
• Experience in consulting and client-facing delivery roles
• Experience in creating critical collaterals for client workshops and customer interactive sessions
• Experience presenting technical content to both large and small audiences

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $151,000 to $253,000.

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.