Solution Architect – Data Migration & Analytics

About the role

This organization operates in the technology sector, focusing on supporting clients in navigating the complexities of the digital environment. It emphasizes building strong relationships with clients and fostering a positive workplace culture centered on employee happiness. The company serves diverse industries including banking, financial services, high-tech manufacturing, healthcare, insurance, retail, and consumer services. It offers flexible work arrangements and competitive benefits to support its workforce.

The Solution Architect – Data Migration & Analytics role leads a strategic data modernization and report rationalization program for a major insurance client. The position is responsible for designing and implementing an enterprise-wide, scalable data platform using technologies such as Snowflake, DBT, AWS, and Power BI. This role enables advanced analytics and self-service reporting while supporting both batch and real-time data ingestion, thereby contributing critically to the client’s data transformation efforts.

Responsibilities

• Define and implement target-state data architecture aligned with business objectives
• Establish architecture principles, governance, and design standards for data layers
• Lead adoption of Medallion Architecture within Snowflake and DBT ecosystem
• Architect data ingestion from multiple source systems, ensuring scalability and reliability
• Design hybrid data ingestion patterns including batch and real-time streaming
• Define canonical and domain-driven data modeling strategies
• Oversee development of efficient, reusable data pipelines
• Drive performance tuning and cost optimization in Snowflake and AWS
• Lead report rationalization to consolidate and optimize legacy reports
• Design Power BI semantic data models supporting self-service BI and paginated reporting
• Enable business-friendly data access and analytics democratization
• Introduce AI-enabled frameworks for data audit, reconciliation, and anomaly detection
• Define enterprise-wide data quality, lineage, and governance standards
• Ensure compliance with insurance domain regulatory requirements
• Define integration patterns across cloud and enterprise applications
• Ensure secure, scalable, fault-tolerant AWS cloud architecture
• Establish data security, encryption, and access control mechanisms
• Collaborate with business and technical stakeholders and act as trusted advisor
• Facilitate architecture reviews, design approvals, and roadmap alignment

Requirements

• 10 to 15+ years of experience in data and analytics
• Strong expertise in Snowflake, DBT, and AWS (S3, Kinesis, Cloud Architecture)
• Proven experience with Medallion Architecture and hybrid data ingestion patterns
• Deep knowledge of Power BI including self-service and paginated reporting
• Expertise in dimensional and Data Vault data modeling
• Strong background in the insurance domain, especially policy, claims, billing, and customer data
• Familiarity with InsuranceNow or similar systems
• Experience designing enterprise-scale data platforms
• Expertise in data governance, report rationalization, and performance and cost optimization

Benefits & Perks

• Flexible work arrangements
• Medical, dental, vision insurance
• 401(k) retirement plan