Senior Data Architect - Cloud Analytics & Fabric Platform

Kforce Inc; Lenexa (KS); On-site; USD 125,000 - 180,000; Full time

Benefits offered by this job

Health insurance

HSA

FSA

401(k)

Life, disability & ADD insurance

Paid time off for salaried staff

Job summary

Kforce Inc. in Lenexa, KS is seeking an experienced Data Architect to own the target-state data architecture across Fabric and on‑premises SQL Server.

You will define ingestion, governance, data models, and reference architectures while aligning with stakeholders and business needs. Responsibilities include designing the data architecture, directing CDC/incremental patterns, and partnering with SQL Server DBAs and Data Engineers on HA/DR and archival.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Management, or a related field.
• 5+ years designing and delivering enterprise data solutions, including 2+ years in data architecture or lead data engineering.
• Experience with modern cloud analytics platforms; Fabric strongly preferred; Synapse/Databricks experience welcomed.
• Deep SQL Server experience: T-SQL, indexing, partitioning, and performance tuning on‑premises.
• Experience integrating on‑premises sources with cloud platforms and with CDC / incremental patterns.
• Proficiency in dimensional modeling, medallion architecture, ETL/ELT design, and data governance.
• Proficiency with Power BI semantic modeling, DAX; PySpark/Python for large transformations; Git/Azure DevOps for data assets.
• Strong written and verbal communication for executive audiences.

Responsibilities

• Own the target-state data architecture spanning Fabric and on-premises SQL Server.
• Define ingestion, governance, and data-mesh/architecture standards.
• Design logical/physical data models and maintain enterprise data model and glossary.
• Produce reference architectures and review significant designs with stakeholders.
• Architect SQL Server–Fabric integration and select appropriate data movement patterns.
• Define CDC, incremental-load, and watermarking strategies to keep Fabric current.
• Partner with DBA/Data Engineer on HA/DR, retention, archival, and on-prem design.
• Design tenant/workspace topology and promotion paths across environments.
• Maintain ownership boundaries: IT ingestion through Gold, FP&A business logic, BI consumption.
• Set Direct Lake as connectivity standard and establish monitoring and cost controls.

Skills

Data architecture

Cloud analytics platforms

Power BI modeling

DAX

Python / PySpark

Git / Azure DevOps

Communication skills

Education

Bachelor's degree in CS / IS / Data Management

Tools

Microsoft Fabric

Synapse

Databricks

Azure DevOps

SQL Server

Power BI

Git

Job description

Kforce Inc. in Lenexa, KS is seeking an experienced Data Architect to own the target-state data architecture across Fabric and on‑premises SQL Server.

You will define ingestion, governance, data models, and reference architectures while aligning with stakeholders and business needs. Responsibilities include designing the data architecture, directing CDC/incremental patterns, and partnering with SQL Server DBAs and Data Engineers on HA/DR and archival.