Software Solution Architect II

• Client's Data & Intelligence organization manages a complex, high-stakes portfolio of enterprise revenue and finance data spanning billing, usage, product revenue, revenue recognition support, deferred revenue, revenue reconciliation, and downstream Finance, FP&A, and regulatory reporting.
• Today, these functions rely on fragmented spreadsheets, Alteryx workflows, and disconnected source systems - creating risk for data integrity, reporting consistency, reconciliation accuracy, compliance, and audit readiness.
• 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., * 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 ITGC and 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.

• 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

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation, information technology and services, Job Description: Established nearly two centuries ago, FM is a leading mutual insurance company whose capital, scientific research capability and engineering expertise are solely…