Lead Database Architect: Fabric & AI Data Platform

Career Movement; Santa Fe Springs (CA); Hybrid; USD 130,000 - 180,000; Full time

Job summary

Career Movement is partnering with a growing home furnishings retailer to modernize its data infrastructure, moving from legacy SQL Server systems to a Microsoft Fabric environment.

You will own both run-and-build responsibilities, collaborating with a small AI/ML team to ensure data platforms support model development and analytics. The role emphasizes hands-on SQL Server administration, Fabric expertise, and Power BI for enterprise reporting.

Qualifications

• Solid foundation as a SQL Server DBA with performance tuning, backups, and security.
• Hands-on experience with Microsoft Fabric, OneLake, Lakehouse, and Warehouse concepts.
• Familiarity with Azure data services such as Data Factory, Synapse, or Azure SQL Database.
• Experience building or maintaining ETL pipelines, ideally with SSIS.
• Comfort operating in a hybrid environment with legacy and cloud pipelines.
• Proficiency in Power BI or similar BI tooling.
• Collaborative mindset for working with a small AI/ML team.

Responsibilities

• Administer and support SQL Server environments including performance tuning, indexing, backups, and security.
• Lead migration of legacy workloads into Microsoft Fabric, including Lakehouse and Warehouse architectures.
• Design and manage data pipelines within Fabric (Data Factory, Dataflows) alongside SSIS.
• Administer OneLake capacity, workspaces, and governance settings.
• Partner with the AI/ML team to ensure data platforms support model development and deployment.
• Balance day-to-day operational DB work with platform-building projects.
• Support BI reporting through Power BI, including Fabric semantic models.

Skills

SQL Server

Microsoft Fabric

OneLake

Azure Data

Power BI

ETL Pipelines

SSIS

Lakehouse

Data Governance

Hybrid Environments

Tools

Data Factory

Synapse

Azure SQL Database

Power BI

Job description

Career Movement is partnering with a growing home furnishings retailer to modernize its data infrastructure, moving from legacy SQL Server systems to a Microsoft Fabric environment.

You will own both run-and-build responsibilities, collaborating with a small AI/ML team to ensure data platforms support model development and analytics. The role emphasizes hands-on SQL Server administration, Fabric expertise, and Power BI for enterprise reporting.