Duration: Initial contract through to October ****, with the possibility of a 6-month extensionWork Arrangements: Versatile work arrangements availableCompany OverviewBLACKROC is partnering with a large Queensland Government department to recruit a Data Architect for a major, high-profile enterprise transformation program currently moving into its build stage.Role PurposeThis is a senior, hands-on-the-design role owning the data architecture across two connected streams: the target analytics architecture in Microsoft Fabric, and the migration architecture moving data out of Appian-based SQL source systems into Microsoft Dataverse.
You'll act as the design authority, setting the standards, principles and patterns, then guiding engineers, analysts, testers and business stakeholders to deliver against them.
The remit is deliberately broad, because the client wants analytics and migration treated as one coherent enterprise data approach rather than two separate technical exercises.Key ResponsibilitiesDefine and govern the end-to-end data architecture across Microsoft Fabric, Dataverse, Azure, migration tooling and reportingEstablish data architecture principles, standards, patterns, naming conventions and modelling approachesDesign the Fabric analytics architecture, OneLake structure, lakehouse and warehouse patterns, medallion layers, curated data products and semantic model alignmentLead the migration architecture from Appian-based SQL sources into Dataverse, covering staging, profiling, mapping, transformation, load sequencing, cutover and rollbackOversee source-to-target mapping, data cleansing, lookup resolution,



alternate key strategy and ownership mappingAct as design authority and provide clear architectural direction to Data Engineers, Data Migration Engineers, Senior Data Analysts and Solution ArchitectsReview and assure data models, transformation logic, reconciliation controls and reporting data sourcesSupport Agile delivery through backlog refinement, design walkthroughs, architecture reviews and release readinessRequired Skills & ExperienceStrong understanding of Microsoft Fabric, OneLake, lakehouses, warehouses, medallion architecture, pipelines, notebooks, SQL analytics endpoints, semantic models and Power BI consumptionStrong experience leading data migration architecture into Microsoft Dataverse, Dynamics 365, Power Platform or comparable enterprise SaaS platformsDemonstrated experience designing migration approaches from SQL-based sources into Dataverse, including staging, transformation, mapping, validation, reconciliation, sequencing, cutover, rollback and post-load verificationStrong understanding of Dataverse data architecture, table design, relationships, alternate keys, ownership, business units, teams, security roles, status/state handling and platform constraintsExperience defining source-to-target mappings,



transformation rules, data quality rules, reconciliation controls and migration acceptance criteriaStrong understanding of data governance, privacy, security, role-based access, lineage, metadata, retention and auditability in enterprise environmentsExcellent communication and stakeholder engagement skills, with the ability to explain complex architecture decisions and trade-offs to technical and non-technical audiencesExperience in Agile delivery environments with formal architecture governance and delivery assurancePreferred Skills & QualificationsFabric Link for Dataverse, Azure Synapse Link, Direct Lake, Dataflow Gen2, Fabric notebooks and Fabric deployment patternsExposure to Appian data models, Appian-backed SQL databases, case management data structures, process history or workflow migrationPower BI semantic models, DAX awareness, row-level and object-level security, sensitivity labels and governed reporting patternsExperience in large-scale legacy replacement, regulatory, licensing, permitting, compliance or case management environmentsMicrosoft Fabric, Azure Data Engineer, Power BI, Dynamics 365, Power Platform or enterprise architecture certificationsAt BLACKROC Recruitment, we are committed to fostering diversity, equity, and inclusion.
We welcome applications from individuals of diverse backgrounds, including those with lived experiences.
If you require any adjustments during the recruitment process, please don't hesitate to reach out to the above-mentioned BLACKROC Consultant.
#J-*****-Ljbffr

📌 Data Architect (Brisbane)
🏢 BLACKROC Recruitment
📍 Brisbane