Senior Data & Analytics Architect

Company Overview

Waterfield Tech enables companies to select, design, and deploy tailored customer engagement solutions from the world’s leading providers enhanced by cutting edge Applied AI. The results are happier customers, enhanced insights, and lower costs.

Once live, we empower companies to support, optimize, and modernize those solutions and AI applications, leading to lower risk and increased efficiency. Our client-centric process and track record of success have earned the trust of clients around the world when it comes to customer interaction.

We value our people—their diversity, their dedication, and their commitment to customer satisfaction. We encourage each other. We understand the value of hard work and the importance of a healthy balance. We’re all on the same page… even though we may get there from different perspectives. All in all, it’s a pretty cool place to be and we’re growing our global team of engineers, sales professionals, and creative souls.

Position Summary

This position owns the design, implementation, and ongoing operation of Waterfield Tech’s data and analytics solutions, with Microsoft Fabric as the primary platform. The Senior Data & Analytics Architect stands the platform up end to end (tenant, capacity, workspaces, security, governance, and ALM) and builds the data engineering backbone that brings Dynamics 365 and other enterprise sources into OneLake through Fabric Link and a Medallion architecture.

The same person then designs the Gold layer, authors the semantic models, ships the Power BI dashboards, and enables the Copilot experiences that Sales, Finance, Project Operations, People & Culture, and Customer Support use to make decisions.

The role combines platform administration, data architecture, data engineering, and business intelligence delivery. The mandate is to make the data and analytics environment safe, governed, reliable, and cost efficient, and to demonstrate its value through useful analytics that our internal clients rely on every day. Hands-on work includes enterprise data integration, lakehouse design, semantic modeling, dashboard delivery, and Copilot enablement, using Microsoft Fabric and complementary tools where appropriate.

Key Responsibilities

Own the end-to-end architecture, implementation, and ongoing operation of Microsoft Fabric and related data and analytics solutions for Waterfield Tech.

Administer the Fabric tenant, including admin portal settings, domains, workspace taxonomy, role assignments, and tenant-level security posture.

Manage F-SKU capacity, including sizing, autoscale, pause and resume where appropriate, and ongoing cost monitoring.

Configure and operate Fabric Link for Dynamics 365 Finance & Operations and Dataverse, bringing data into OneLake through no-ETL shortcuts.

Design and build the Medallion Architecture: Bronze (raw via shortcuts), Silver (cleansed, MDM, data quality), and Gold (analytics ready).

Implement Master Data Management, including validation tables, dynamic data quality scripts, deduplication, enrichment, and golden record creation.

Stand up and operate Microsoft Purview, including the unified catalog, lineage, data classification, sensitivity labels, endorsements, business glossary, and data dictionary.

Implement platform security, including Row-Level Security, Object-Level Security, Role-Based Access Control, on-premises and VNET data gateways, and sensitivity labeling.

Develop Power BI semantic models and dashboards across Sales (global sales, invoice, product line), Finance (AP/AR aging, cash flow, days to pay versus collect), Project Operations (cost, budget, forecast, invoice), People & Culture, Inventory, Production, and Quality/OEE.

Enable AI and Copilot across Fabric workloads (Data Engineering, Data Warehouse, Data Factory, and Power BI) and explore Azure ML and Azure AI Studio integrations for predictive use cases.

Own ALM and DevOps for the data and analytics solutions delivered by this role, including Git integration, deployment pipelines, environment promotion across Dev/Test/Prod, and Fabric REST API automation.

Produce capacity, cost, and usage dashboards, and partner with the IT Director on chargeback and showback for business units.

Partner with the IT Director, business stakeholders, and the AI/Product team to prioritize the backlog, run demos, and drive adoption.

Produce and maintain architecture diagrams, runbooks, SOPs, and data stewardship documentation, and onboard future analytics engineers and BI developers onto the platform.

Three to five years delivering data platform and analytics solutions, including proven experience migrating customers or workloads onto Microsoft Fabric. Be ready to walk through at least one end-to-end migration you personally led, covering source systems, architecture decisions, cutover approach, and outcomes.

Microsoft Fabric administration. Tenant and admin portal configuration, F-SKU capacity sizing and autoscale, workspace taxonomy, role assignments, domains, and tenant-level security settings.

OneLake, Direct Lake, Parquet, and Delta Lake. Deep familiarity with OneLake shortcuts and mirrored databases, and with how Direct Lake differs from Import and DirectQuery for Power BI.

Medallion Architecture implementation. Hands-on Bronze, Silver, and Gold design; you should be comfortable defending your layer boundaries.

Fabric Link for Dynamics 365 Finance & Operations and Dataverse. Hands-on configuration, monitoring, and troubleshooting, not just familiarity.

Synapse-in-Fabric data engineering. Pipelines, Notebooks (Python, Spark, SQL), Spark Jobs, SQL Serverless, Mapping Dataflows, and the Fabric Data Warehouse.

Microsoft Purview. Unified catalog, lineage, classification, sensitivity labels, endorsements (Certified and Promoted), business glossary, data dictionary, and data stewardship.

Master Data Management and data quality delivery. Validation tables, dynamic DQ scripts, deduplication, enrichment, and golden record patterns.

Power BI delivery at a developer level. DAX, Power Query M, star schema semantic models, Row-Level Security, and the Pro/PPU/Premium/Embedded licensing model.

Azure source system integration. Azure Data Lake Gen 2, Azure SQL Database, Azure SQL Managed Instance, Blob Storage, REST and HTTP endpoints, and file-based sources.

Platform security and data governance fundamentals. Practical experience applying RLS, OLS, RBAC, and gateways, with awareness of GDPR, HIPAA, and comparable regulatory frameworks.

DevOps for data and analytics solutions. Git integration, deployment pipelines, Fabric REST API automation, and environment promotion.

Scripting. PowerShell, plus at minimum intermediate Python, Spark (PySpark), and T-SQL.

Communication. Professional written and spoken English, and the ability to run a demo, defend an architecture decision to a non-technical audience, and translate a business question into a data model.

Documentation discipline. Architecture diagrams, runbooks, SOPs, and stewardship documentation produced as part of the work rather than after it.

Education. Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent demonstrable experience.

Additional Requirements

Preferred Microsoft certifications: DP-600 (Fabric Analytics Engineer Associate), DP-700 (Fabric Data Engineer Associate), DP-203 (Azure Data Engineer Associate), DP-500 (Azure Enterprise Data Analyst Associate), and PL-300 (Power BI Data Analyst Associate). AZ-305 (Azure Solutions Architect Expert) is a bonus.

Strongly preferred (not required)

• Power BI developer depth: advanced DAX (time intelligence, complex iterators, UDFs, calculation groups), composite models, aggregations, incremental refresh, Tabular Editor 2/3, DAX Studio, and VertiPaq Analyzer.
• AI and Fabric: production use of Copilot for Data Engineering, Data Warehouse, Data Factory, and Power BI; Azure Machine Learning; Azure AI Studio; and natural language to SQL and text to DAX patterns.
• Dimensional modeling mastery: Kimball methodology, star and snowflake schemas, Slowly Changing Dimensions (Types 1, 2, and 3), role-playing dimensions, bridge and factless fact tables, and Common Data Model alignment.
• Real-Time Intelligence: Data Activator triggers and actions, KQL/Kusto, event stream ingestion, and IoT and sensor telemetry patterns.
• Dynamics 365 Finance & Operations module depth: Sales, Purchase, Inventory, Warehouse Management, Production, Quality, Project Operations, and Finance data models.
• Automation and Infrastructure as Code: PowerShell, Fabric REST APIs, and IaC approaches for Fabric (Terraform, Bicep, or ARM), including self-service capacity provisioning.
• Cost optimization: capacity right-sizing, workload scheduling, and chargeback and showback reporting.
• Consulting or MSP experience: exposure to Microsoft Solution Partner engagements or systems integrator delivery models.
• Engagement: full-time and permanent, working remotely from an offshore location.
• Time zone overlap: a minimum of four hours per day of overlap with US Central Time. Waterfield Tech is headquartered in Tulsa, Oklahoma.
• Reporting: reports to the IT Director and works alongside Sales, Marketing, Project Operations, Finance, Professional Services, Customer Support, People & Culture, and the AI/Product team.
• Availability to work flexible hours as needed.

Physical Requirements

Sitting: Ability to be able to sit for long periods of time.

Lifting: Ability to lift equipment and or tools up to 20 pounds.

Waterfield Tech is proud to be an equal opportunity employer.

Waterfield Tech believes that all persons are entitled to equal employment opportunity and does not discriminate against its Employees or applicants because of race, color, religion, sex (including pregnancy), national origin, ancestry, age, marital status, citizenship status, disability, protected medical condition, military status, genetic information, or any other basis prohibited by applicable federal, state, or local law. This policy extends to all aspects of our employment practices including, but not limited to, recruiting, hiring, training, discipline, promotion, transfers, compensation, benefits, leaves of absence, termination, and all other terms and conditions of employment.