Azure Data Architect
Posted an hour ago
Worldwide
⭐
10+ years experience
Please mention DailyRemote when applying
AI Summary
Design and deliver business-aligned Gold layer datasets on Databricks to support insurance analytics and reporting. Transform refined data into high-quality datasets while optimizing data pipelines and ensuring seamless consumption for Power BI.
This is a remote position.
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
Required Skills & Competencies:
- Strong experience in Azure Data Platform (Azure Databricks, ADLS, Azure Data Factory)
- Deep expertise in Databricks (PySpark / SQL) and Delta Lake
- Proven experience in data modelling (dimensional modelling, star/snowflake schemas)
- 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
Benefits
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.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
