CIJ / Dataverse Specialist & Data Architect

About the Role

Kopius is delivering Power BI email analytics embedded in Dynamics 365 Customer Insights – Journeys (CIJ) and built on Microsoft Fabric. Business requirements are largely defined. We need a specialist who knows how CIJ processes, stores, and delivers its data — including how it calculates its native KPIs and how segment membership can be obtained at scale.

You will design, lead, and deliver the data flow, mapping, and repeatable processes that this engagement needs, and that future Power BI work on CIJ data will build on. This is a hands-on specialist role with a consultative edge: part of the value is advising the client on how to use CIJ data for reporting going forward.

Key Responsibilities

• Map how CIJ stores email interaction data and how it connects to leads, journeys, and emails
• Determine how CIJ calculates its native KPIs, and validate it by reconciling two to three journeys against the native reports
• Find the supported way to obtain CIJ segment membership at scale, across roughly 3,000 segments
• Set up Link to Microsoft Fabric, define the extraction into the lakehouse, and document the approach
• Advise the client on strategy for additional CIJ data usage in Power BI reporting
• Transfer knowledge so the team can repeat the approach on future projects

Basic Qualifications

• Advanced English, written and verbal, for daily work with a U.S.-based team and client
• Consultative posture: able to advise a client on approach, not only execute against a spec
• Strong documentation practice — what you leave behind is part of the deliverable
• Self-directed, able to be productive within the first week of a short engagement
• Comfortable investigating undocumented platform behavior and proving conclusions with data

Technical Requirements

• 18+ years in IT, data engineering, or CRM data platforms
• 6–10 years as a data architect working with third-party clients in a consulting environment
• 5+ years hands-on with Customer Insights – Journeys (real-time journeys), including expert knowledge of the Dataverse data model, CIJ analytics, and interaction entities
• Experience with Link to Microsoft Fabric or Azure Synapse Link for Dataverse
• Strong Azure data, Fabric, Power BI, and SQL skills, plus the Dataverse Web API

Nice to Have

• PL-400 or PL-600 certification (Dataverse)
• DP-700 or DP-600 certification (Fabric)
• MB-220 certification

Expected Outcomes

• A validated KPI-to-source map, with two to three journeys reconciled against CIJ
• A confirmed segment-membership approach that works at scale
• A documented Fabric extraction design, and knowledge transfer to the team