Executive Azure Data Factory Developer Jobs in Missouri

Exavalu Solutions India Pvt Ltd | Full time

Exavalu is a US based consulting firm specialized in Digital Transformation Advisory and Digital Solution Delivery for select industries like Insurance, Healthcare and Financial Services. Our Headquarters is in California, US with multiple offices across US, Canada, and delivery centres in India. We were founded by Industry executives and Consulting principals with deep industry experience that allows us to bring advisory strength and solution expertise to clients. We’re in a hyper growth trajectory growing at over 100% year on year.

Join our diverse and inclusive team where you will feel valued and motivated to contribute with your unique skills and experience.

Exavalu offers permanent remote working model as we believe in going where the right talent is.

Job Description

This is a remote position.

Overview

We are looking for an experienced Azure Data Architect to design and deliver consumption-ready, business-aligned Gold layer datasets on Databricks. The role focuses on transforming refined data into high-quality, analytics-ready datasets that support policy lifecycle reporting, underwriting insights, and downstream data products across multiple policy administration systems.

Key Responsibilities

• Assess and analyse existing Silver layer data structures to identify gaps and optimization opportunities
• Collaborate with business stakeholders to understand analytics and reporting use cases (policy lifecycle, Claims, underwriting, renewals, exposure, premium)
• Design scalable Gold layer data models (star schema, snowflake, or wide tables) aligned to business needs
• Standardize and harmonize data across multiple policy & Claims systems
• Develop and implement business transformation logic including KPIs, derived metrics, and aggregations
• Build and manage Delta Lake tables in Databricks for Gold layer consumption
• Optimize data pipelines and storage for performance using partitioning, indexing, caching, and query tuning
• Enable seamless data consumption for Power BI and downstream data products
• Perform data validation and reconciliation with business stakeholders to ensure accuracy and usability
• Drive best practices in data architecture, modelling, and governance
• Deep expertise in Databricks (PySpark / SQL) and Delta Lake
• Experience working with insurance/policy systems (Duck Creek, Guidewire, or similar) preferred
• Strong understanding of Medallion Architecture and modern Data Lakehouse design
• Hands‑on experience in performance tuning and optimization in big data environments
• Experience enabling BI tools such as Power BI
• Strong stakeholder management and communication skills
• Strong problem-solving and analytical thinking
• Ability to translate business requirements into technical solutions
• Effective collaboration with business and engineering teams
• Ownership mindset with focus on delivering high-quality data products

Requirements

Nice to have:

• Experience with data governance tools (e.g., Microsoft Purview)
• Knowledge of data quality frameworks and reconciliation techniques
• Exposure to domain-driven design in data platforms

Qualifications:

• 15+ years of experience in Data Engineering / Data Architecture roles, with strong focus on Azure Data Platform
• Proven experience in designing and implementing Databricks-based lakehouse architectures and Gold layer data models
• Hands‑on expertise in Azure Databricks, ADLS, Azure Data Factory, and Delta Lake
• Strong background in dimensional data modeling (star schema, snowflake, wide tables) and analytics data design
• Experience working on enterprise-scale data platforms, preferably in Insurance/Policy domains
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or related field
• Relevant certifications such as Microsoft Certified: Azure Data Engineer Associate, Azure Solutions Architect Expert, or Databricks certifications are preferred

Diversity Inclusion

At Exavalu, we are committed to building a diverse and inclusive workforce. We welcome applications for employment from all qualified candidates, regardless of race, color, gender, national or ethnic origin, age, disability, religion, sexual orientation, gender identity or any other status protected by applicable law. We nurture a culture that embraces all individuals and promotes diverse perspectives, where you can make an impact and grow your career. Exavalu also promotes flexibility depending on the needs of employees, customers and the business. It might be part-time work, working outside normal 9-5 business hours or working remotely. We also have a welcome back program to help people get back to mainstream after a long break due to health or family reasons.