Data Architect

COX'S AUTO
Frisco, TX, United States
28 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$148,500.0 - $247,500.0
Working hours
Regular working hours

Tech stack

Artificial Intelligence Data Analysis Computing Platforms Microsoft Azure Business Intelligence Development Spreadsheets Cyber Security Continuous Integration Data Architecture Information Engineering Data Governance Data Infrastructure
+23 more
Data Integrity Extract Transform Load (ETL) Data Transformation Software Design Patterns Python (Programming Language) Machine Learning Power BI Standard Sql SQL Databases SQL Server Integration Services Tableau (Software) Data Ingestion Informatica Powercenter Apache Spark Gitlab AutoML Data Lakes Data Management Machine Learning Operations Data Pipelines Database Tools and Utilities Alteryx Databricks

Job description

The Principal Data & Solutions Architect will serve as the primary technical and solution architecture owner of the Revenue Data Management Platform (RDMP) , a modernization initiative focused on consolidating revenue data into a governed, centralized Databricks lakehouse. This role partners directly with Revenue, Finance, and D&I COE to architect a medallion data platform, retire legacy workflows (including Alteryx), establish SOX-compliant data infrastructure, and enable advanced analytics - improving reconciliation timelines and enabling trusted, repeatable reporting across the enterprise. KEY RESPONSIBILITIES

  • Platform Architecture - Design and own the end-to-end revenue data platform on Databricks, implementing the DR COE medallion architecture (Bronze, Silver, Gold) using Delta Lake, Unity Catalog, and Databricks Workflows.
  • Alteryx Retirement / Modernization - Lead the migration of Alteryx workflows, manual spreadsheets, and legacy ETL processes into version-controlled, testable dbt models. Translate complex revenue and finance transformation logic - including billing revenue, usage revenue, deferred revenue, and reconciliation logic - into SQL-native models with CI/CD pipeline controls.
  • SOX & Governance - Architect access controls, change management workflows, and audit trails aligned to ITand SOX requirements. Enforce row-level and column-level security through Unity Catalog, design segregation of duties, and ensure end-to-end traceability of revenue data from source systems to reporting layers.
  • Data Modeling - Build and certify Silver and Gold layer data products supporting billing revenue, usage-based revenue, revenue adjustments, deferred revenue, revenue reconciliation, and downstream finance reporting. Define data contracts, automated testing frameworks, referential integrity checks, and canonical data definitions. Experience in MDM and driving end-to-end solutions from problem statements is required.
  • Ingestion & Orchestration - Design ADF-based ingestion pipelines from ERP, billing, CRM, and source systems into the Bronze layer. Orchestrate pipelines using Databricks Workflows with monitoring, alerting, and scalability considerations.
  • Semantic Layer & Reporting - Architect governed semantic layers powering Power BI and Tableau dashboards for revenue reporting, reconciliation, FP&A insights, and executive reporting. Ensure reporting assets are certified, governed, and audit-ready.
  • AI & ML Capabilities - Enable AI/ML-driven insights where applicable, including anomaly detection for revenue variances, predictive trends, and assisted analytics, leveraging Databricks capabilities such as MLflow and AutoML.
  • Stakeholder Partnership - Translate Revenue, Finance, and FP&A requirements into architecture and data product specifications. Lead design reviews, support UAT for certified data products, and communicate effectively with both technical and business stakeholders.
  • Standards & Mentorship - Establish architecture standards, data modeling practices, and governance frameworks across the RDMP program. Mentor engineering teams on Databricks, dbt, and best practices aligned with DR COE., The Senior Lead Cybersecurity Architect is responsible for defining the principles, standards, and design patterns to build secure products and enterprise tools for all of Cox Auto…
  • 3 days ago

Requirements

  • 12+ years of experience in data architecture, solution architecture, or data engineering.
  • 5+ years of hands-on experience with Databricks (Delta Lake, Unity Catalog, Workflows, SQL, Python).
  • Strong experience with dbt including modeling patterns, testing, and CI/CD integration.
  • Strong SQL and Python skills for data transformation and pipeline development.
  • Experience designing SOX-compliant / audit-ready data platforms , including access control and lineage.
  • Proven experience modernizing legacy tools (Alteryx, SSIS, Informatica, spreadsheets) into modern data platforms.
  • Experience with Azure ecosystem (ADF, Azure DevOps, Entra ID).
  • Experience architecting data products for Revenue, Finance, Billing, or FP&A stakeholders .
  • Strong understanding of revenue data concepts including billing, revenue reconciliation, deferred revenue, and reporting.
  • Strong communication skills with both technical and business stakeholders.

PREFERRED QUALIFICATIONS

  • Domain experience in Revenue Data Management , billing systems, revenue reconciliation, deferred revenue, and financial reporting.
  • Databricks certifications (Data Engineer, Spark Developer, or equivalent).
  • Experience with MLflow, AutoML, or basic ML-enabled analytics use cases.
  • Experience with Power BI/Tableau semantic layer design and governed reporting datasets.
  • Experience with CI/CD pipelines (GitLab/Azure DevOps) for data workloads.
  • Familiarity with DR COE architecture, data governance, and enterprise security/compliance standards.
  • Exposure to natural-language query tools (e.g., Databricks Genie) for analytics enablement.

About the company

Cargill is committed to providing food and agricultural solutions to nourish the world in a safe, responsible, and sustainable way. Sitting at the heart of the supply chain, we par…, Cox Automotive

  • Atlanta, GA
  • $163,400 per year Cox Automotive’s architecture group is reimagining the car-buying and service experience from inventory management, consumer shopping, service, and deal inception to close. The CAI…

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…