Senior Azure Fabric and Databricks Cloud Data Architect

About the team: 

Capco’s Data Team helps our clients transform every aspect of their business.  We are highly skilled at formulating data strategy, defining business and technology initiatives across the data management lifecycle, and aligning multi-year strategic roadmaps with client’s business goals. As digital technologies advance and regulations tighten, today’s consumers – and, therefore, today’s businesses – are becoming more aware of the importance of good quality data. We work to establish holistic ways to effectively manage data through the modern data supply chain and facilitate consumption through analytics, modelling, AI, machine learning, dashboarding, and reporting.  

About the Job: 

The Senior Azure Fabric and Databricks Cloud Engineer will play a lead role in designing, implementing, and operationalizing modern cloud-based data platforms built on Microsoft Azure and Fabric. This position supports both business development and project delivery by providing deep technical expertise in Azure Fabric, Databricks, and SQL environments, and by rapidly prototyping data solutions that demonstrate value to prospective clients. The engineer will design and deliver production-ready data platforms that enable cross-system integration, analytics, and reporting for clients in nonprofit, education, and workforce development sectors. 

What You’ll Get to Do: 

Solution Design & Delivery 

• Architect and deploy Microsoft Fabric and Azure Databricks environments for enterprise data integration, transformation, and analytics. 

• Build scalable data pipelines that unify data across CRM, financial, LMS, and HR systems. 

• Operationalize Azure SQL-based repositories for analytics, supporting Power BI and SSRS. 

• Implement structured data ingestion workflows for Excel and PDF inputs using Azure Form Recognizer, Power Automate, and Fabric dataflows. 

• Ensure designs align with Microsoft best practices for governance, performance, and security. 

Business Development & Prototyping 

• Develop and demonstrate rapid prototypes showcasing Azure Fabric and Databricks capabilities to prospective clients. 

• Contribute to technical sections of proposals and solution demonstrations during RFP responses and client presentations. 

• Partner with architects and delivery leads to translate client requirements into proof-of-concept environments. 

• Provide pre-sales technical consultation and architecture design support for new engagements. 

Operationalization & Optimization 

• Configure and tune Databricks clusters, pipelines, and workloads for cost and performance efficiency. 

• Set up CI/CD pipelines for data assets using Azure DevOps and Infrastructure-as-Code (ARM or Terraform). 

• Establish change tracking, data lineage, and audit mechanisms to support compliance and historical reporting. 

• Create deployment documentation, architecture diagrams, and handover materials for delivery teams. 

What You’ll Bring with You: 

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or related field 

• 7+ years of experience in cloud data engineering with strong Azure expertise. 

• 3+ years hands-on experience with Azure Databricks and Delta Lake architecture. 

• Experience with Microsoft Fabric (Data Factory, Dataflow Gen2, Power BI integration). 

• Proven track record building and operationalizing Azure SQL and Synapse-based solutions. 

• Demonstrated success supporting solution prototyping and business development activities. 

• Power BI, Power Automate, and integration with M365 / Okta identity systems 

• PySpark, SQL, and Python for data engineering workflows 

• CI/CD automation using Azure DevOps and Terraform 

• Data modeling, lineage, CDC, and orchestration best practices 

• Familiarity with WCAG 2.1 AA accessibility standards for Power Platform-based interfaces 

• Strong collaboration and communication with business and technical stakeholders 

• Ability to prototype rapidly and present solutions in business-friendly terms 

• Demonstrated leadership in cloud solution delivery projects 

• Commitment to data governance, compliance, and operational excellence 

Preferred Certifications:  

• Microsoft Certified: Azure Solutions Architect Expert 

• Microsoft Certified: Azure Data Engineer Associate 

• Microsoft Certified: Fabric Analytics Engineer Associate 

• Databricks Certified Data Engineer Professional 

Why Capco? 

A career at Capco is a chance to help reshape the competitive landscape in financial services.  We launch new banks, transform existing ones, and help our clients navigate complex change.  As consultants, we work on the front-end business design all the way through to technology implementation. 

 We are the largest Financial Services focused consultancy in the world, serving everyone from global banks to emerging FinTechs, from strategy through digital transformation, design, business consulting, data and analytics, cyber, cloud, technology architecture, and engineering. 

Capco is a young and growing firm. We maintain an entrepreneurial spirit and growth mindset, and have minimal bureaucracy. We have no internal silos that get in the way of your career opportunities or  ability to focus on our clients and make a difference to the business.  We offer the opportunity for everyone to learn rapidly, take on tough challenges, and get promoted quickly. We take pride in our creative, collaborative, diverse, and inclusive culture, where everyone can #BYAW.   

 We offer highly competitive benefits, including medical, dental and vision insurance, a 401(k) plan, tuition reimbursement, and a work culture focused on innovation and creation of lasting value for our clients and employees.  

Ready to take the Next Step? 

 If this sounds like you, we would love to hear from you.  This is an opportunity to make a difference and contribute to a highly successful company with a significant growth trajectory.