Software Solution Architect II

TekWissen LLC

Frisco, TX

JOB DETAILS
SALARY
$65.14–$65.14
SKILLS
Acceptance Testing, Access Control, Artificial Intelligence (AI), Auditing, Best Practices, Billing, Change Control, Change Management, Cisco Unity, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Customer Relationship Management (CRM) Systems, Data Management, Data Modeling, Data Quality, Data Sets, Database Extract Transform and Load (ETL), DevOps, Diversity, ERP (Enterprise Resource Planning), Ecosystems, Enterprise Protection, Finance, Financial Planning and Analysis (FP&A), Financial Reporting, Informatica, Information Technology & Information Systems, Intelligence Agencies, Master Data Management (MDM), Mentoring, Microsoft Windows Azure, Power BI, Product Support, Python Programming/Scripting Language, Reconciliation, Regulatory Compliance, Regulatory Reports, Reporting Dashboards, Revenue Management, Revenue Recognition, Revenue/Sales Reporting, Risk, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Sarbanes-Oxley Act (SOX), Software Architecture, Spreadsheets, Tableau, Test Harness, Test Patterns, Traceability, Trend Analysis, Use Cases, Workforce Management
LOCATION
Frisco, TX
POSTED
2 days ago
Overview:
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
Position: Software Solution Architect II
Location: Frisco, TX / Bellevue, WA
Duration: 6 Months
Job Type: Temporary Assignment
Work Type:Onsite
Job Description:
About the role:
  • 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.
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 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.
Required Qualifications:
  • 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 Group is an equal opportunity employer supporting workforce diversity.

About the Company

T

TekWissen LLC

WE THE TEKWISSEN PEOPLE

TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.

To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.

Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.

It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.

Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.



COMPANY SIZE
100 to 499 employees
INDUSTRY
Computer/IT Services
FOUNDED
2009
WEBSITE
http://www.tekwissen.com/