Data Architect with MDM

e-IT Professionals Corp.
Frisco, United States of America
22 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Frisco, United States of America

Tech stack

Artificial Intelligence
Computing Platforms
Audit Trail
Azure
Continuous Integration
Data Architecture
Information Engineering
Data Infrastructure
Data Integrity
ETL
Data Transformation
Data Sharing
Data Intelligence
Python
Power BI
Azure
SQL Databases
SQL Server Integration Services
IT General Controls (ITGC)
Data Ingestion
Azure
Informatica Powercenter
Gitlab
Data Lake
Machine Learning Operations
Data Pipelines
Alteryx
Databricks

Job description

  • Platform Architecture Design and own the end-to-end finance Intelligence data platform on Databricks, implementing the DR COE medallion architecture (Bronze, Silver, Gold) using Delta Lake, Unity Catalog, and Databricks Workflows.
  • Alteryx Retirement Lead the migration of 40+ Alteryx workflows to version-controlled, testable dbt models in GitLab. Translate complex Finance data transformation logic including income Finance data provision, deferred Finance data calculations, and jurisdiction models into SQL-native dbt models with full CI/CD pipeline gates.
  • SOX & Governance Architect access controls, change management workflows, and audit trails that satisfy IT General Controls (ITGC) requirements. Enforce row-level and column-level security through Databricks Unity Catalog, design segregation of duties across engineering and analyst roles, and ensure every Finance data figure is traceable end-to-end from source to reporting surface.
  • Data Modeling Build and certify Silver and Gold layer data products: income Finance data provision, deferred Finance data rollforward, effective Finance data rate (ETR) analysis, sales & use Finance data, and property Finance data. Define dbt data contracts, automated testing frameworks, and referential integrity checks across all layers. Experience in MDM and independently, identifying, defining and driving the end-to-end solution from the problem statements.
  • Ingestion & Orchestration Design ADF-based ingestion pipelines from ERP systems and source flat files into the Bronze Delta Lake layer. Orchestrate end-to-end pipeline execution using Databricks Workflows with auto-scaling compute and full monitoring.
  • Semantic Layer & Reporting Architect the Unity Catalog semantic layer powering certified Power BI and Tableau dashboards provision review, ETR analysis, deferred Finance data rollforward. Ensure reporting surfaces are governed, certified, and auditor-ready.
  • AI & ML Capabilities Architect AI-assisted Finance data intelligence features on Databricks: ML-based anomaly detection for accrual variances (AutoML, MLflow), predictive Finance data accrual models (Feature Store, Delta Live Tables), natural-language querying via Databricks Genie, and AI-generated audit narratives via Model Serving.
  • Stakeholder Partnership Translate Finance data SME business requirements into data product specifications. Lead architectural reviews, drive UAT sign-off on certified data products, and communicate technical decisions to both engineering and executive audiences.
  • Standards & Mentorship Establish and enforce solution and data architecture standards across the T-Finance Finance data program. Mentor data engineers on Databricks best practices, dbt modeling patterns, and DR COE reference architecture. Contribute to the broader T-Finance shared data infrastructure.

Requirements

  • 10+ years of experience in data architecture, data engineering, or a closely related field.
  • 5+ years of hands-on experience with Databricks Delta Lake, Unity Catalog, Workflows, and SQL/Python notebooks.
  • Deep dbt expertise: modeling patterns (staging, intermediate, mart), testing frameworks, dbt docs, and CI/CD integration via GitLab or Azure DevOps.
  • Strong SQL proficiency and solid Python skills for data transformation and pipeline development.
  • Demonstrated experience designing and operating SOX-controlled data environments, including ITevidence requirements, access control design, and change management workflows.
  • Proven track record migrating legacy ETL tools (Alteryx, SSIS, Informatica, or equivalent) to modern, code-first, version-controlled data pipelines.
  • Experience with the Azure data ecosystem: Azure Data Factory (ADF), Azure DevOps, and Azure Active Directory / Entra ID for identity and access.

Apply for this position