> Markdown version of [/jobs/ext/1239786-software-solution-architect-ii](https://www.wearedevelopers.com/jobs/ext/1239786-software-solution-architect-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Software Solution Architect II - **Company:** TekWissen LLC - **Location:** Frisco, TX, United States - **Experience:** Expert - **Salary:** $68,900.0 - $131,100.0 - **Contract:** Temporary contract - **Skills:** Artificial Intelligence, Data Analysis, Software Applications, Computing Platforms, Microsoft Azure, Business Intelligence Development, Spreadsheets, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Data Infrastructure, Data Integrity, Extract Transform Load (ETL), Data Transformation, Python (Programming Language), Machine Learning, Power BI, Standard Sql, SQL Databases, SQL Server Integration Services, Tableau (Software), IT General Controls (ITGC), Data Ingestion, Informatica Powercenter, Apache Spark, Gitlab, Data Lakes, Data Management, Machine Learning Operations, Data Pipelines, Database Tools and Utilities, Alteryx, Databricks - **Published:** July 11, 2026 - **Apply:** https://www.careerjet.com/jobad/usc7516d1f81476d723c1bc48a2c36c5eb ## About the Role * 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 ## Description * 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [WeAreDevelopers LIVE - Modern DevOps for IoT Devices and More](https://www.wearedevelopers.com/videos/1805-wearedevelopers-live-modern-devops-for-iot-devices-and-more) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Enabling automated 1-click customer deployments with built-in quality and security](https://www.wearedevelopers.com/videos/83-enabling-automated-1-click-customer-deployments-with-built-in-quality-and-security) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence)