Data and Analytics Architect – MS Fabric

This is a fully remote position, open to applicants in Arizona, +7 more states.

📋 Description

• Spearhead the design of contemporary data and analytics platforms utilizing Microsoft Fabric.

• Collaborate with clients, business analysts, and stakeholders to transform business requirements into scalable data and analytics solutions.

• Evaluate existing data environments, establish target architectures, and create phased roadmaps.

• Choose architecture patterns and communicate associated trade-offs to stakeholders.

• Create comprehensive Microsoft Fabric architectures encompassing OneLake, Lakehouse, Warehouse, data integration, data modeling, semantic models, and reporting.

• Develop integrations from ERP, CRM, SaaS, APIs, files, and streaming sources using batch, incremental, and change data capture methodologies.

• Lead the modernization and migration of SQL Server, SSIS/SSAS, Azure Synapse Analytics, and Power BI Premium workloads to Microsoft Fabric.

• Design semantic layers and reporting standards while guiding report developers.

• Size, monitor, and optimize Fabric capacity and consumption costs, addressing performance bottlenecks.

• Establish data governance, quality, lineage, and metadata practices, collaborating with Security on privacy and compliance.

• Conduct architecture reviews and assessments, recommending scalable, secure, and high-performance solutions.

• Provide technical leadership to data engineers, analysts, and team members.

• Work collaboratively across organizational practices to ensure quality and security standards are met.

• Assist in sales pursuits through solution approaches, estimates, SOW inputs, and client presentations.

• Stay actively involved from discovery and design through to delivery and handoff.

⛳️ Requirements

• Proficiency in data modeling (dimensional and normalized), data warehousing, and lakehouse and medallion design.

• Expertise in data integration across various sources, ETL/ELT development, pipeline orchestration, and performance optimization.

• Knowledge of data governance, data quality, metadata management, lineage, and master data concepts.

• Understanding of data security and compliance considerations within the analytics framework.

• Familiarity with source control and CI/CD using Azure DevOps or GitHub, with experience in Agile/Scrum methodologies.

• Experience with Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure SQL, and SQL Server.

• In-depth knowledge of Microsoft Fabric across OneLake, Lakehouse, Warehouse, Eventhouse, Data Factory, Dataflows Gen2, Spark notebooks, semantic models, workspaces, capacities, security, governance, Git integration, and deployment pipelines.

• A minimum of eight years of professional experience in data and analytics, with at least three years in an architect role.

• Involvement as an architect in at least two production Microsoft Fabric implementations.

• Participation in at least one full-lifecycle greenfield architecture engagement.

• Bachelor’s degree in computer science, Data Science, Information Systems, or a related field, or equivalent professional experience.

• Facilitation of requirements elicitation, design, and brainstorming sessions with internal and client teams.

• Ability to communicate clearly and professionally, both in writing and verbally, to technical and business audiences at all levels.

• Business acumen to align solution design with client requirements.

• Capability to participate in ad hoc meetings on short notice with groups of varying sizes.

• Preferred qualifications include Microsoft certifications, exposure to Databricks, Snowflake, or other cloud data platforms, pre-sales and estimating experience, and familiarity with AI/ML analytics workflows.

🏝️ Benefits

• Health Care Plan (Medical, Dental & Vision)

• Retirement Plan (401k)

• Life Insurance (Basic, Voluntary & AD&D)

• Paid Time Off (Vacation, Sick & Public Holidays)

• Family Leave (Maternity, Paternity)

• Long Term Disability

• Training & Development

• Work Life Balance

• No company politics.

• Strong employee-focused culture