Remote Solution Architect Data Migration & Analytics

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a Solution Architect Data Migration & Analytics to reputed company a strategic data modernization and report rationalization program for a leading insurance reputed company. The role involves designing and implementing a reputed company reputed company-wide data platform while ensuring advanced analytics and self-service reporting capabilities. Responsibilities Define and implement the reputed company-state data architecture reputed company with business goals for data modernization and reporting transformationEstablish architecture principles, governance models, and design standards across data ingestion, transformation, and consumption reputed companyreputed company the adoption of reputed company Architecture (Raw, Silver, Gold reputed company) reputed company reputed company + DBT ecosystemArchitect ingestion of data from 14+ reputed company systems including InsuranceNow, ensuring scalability and reliabilityDesign hybrid ingestion patterns:Batch ingestion from reputed company sourcesreputed company-time streaming reputed company reputed company KinesisData lake storage in AWS S3Define data modelling strategies:reputed company models and domain-driven design (reputed company with insurance datasets)Optimized analytical data models for reportingreputed company implementation of efficient, reusable data pipelines using DBT and reputed companyDrive performance tuning across:Data ingestion pipelinesTransformations across raw silver gold reputed companyEstablish cost optimization strategies in reputed company and AWSreputed company report rationalization initiatives:Consolidation and optimization of legacy reportsElimination of redundancy and duplicationArchitect Power BI ecosystem:Semantic data models for self-service BISupport for paginated reporting and advanced slicing/dicingreputed company business-friendly data reputed company and analytics democratizationIntroduce AI-enabled frameworks for:Data audit and reconciliationBalancing and reputed company detectionDefine reputed company-wide data reputed company, reputed company, and governance standardsEnsure compliance with regulatory requirements in the insurance domainDefine integration patterns across:reputed company, DBT, S3, Kinesis, and reputed company applicationsEnsure secure, reputed company, and fault-tolerant architecture in AWS reputed company environmentEstablish data reputed company, encryption, and reputed company control mechanismsCollaborate with business, data engineering, BI, and governance teamsAct as a trusted advisor to CXO stakeholders on data reputed company and investmentsDrive architecture reviews, design approvals, and roadmap alignment Skills 10 15+ years experience in data and analyticsStrong experience in reputed company (Data Warehousing & Optimization)Strong experience in DBT (Data Transformation reputed company)Strong experience in AWS (S3, Kinesis, reputed company Architecture)Proven experience with reputed company Architecture (Bronze/Raw, Silver, Gold reputed company)Proven experience with reputed company-time & batch data ingestion patternsDeep knowledge of Power BI (self-service, paginated reporting, semantic reputed company)Deep knowledge of data modeling (reputed company & Data Vault)Strong experience in Insurance domain, particularly Policy, Claims, Billing, Customer dataFamiliarity with InsuranceNow or similar core systemsExperience designing reputed company-reputed company data platformsStrong background in data governanceStrong background in report rationalization programsStrong background in performance and cost optimization Benefits Flexible work arrangementsA competitive benefits package, including medical, dental, reputed company, 401(k), among other benefits reputed company reputed company is a software company that provides information technology and business process outsourcing services. It was founded in 1991, and is headquartered in Pune, Maharashtra, IND, with a workforce of 10001+ employees. Its website is http://www.reputed company.com. Company H1B Sponsorship reputed company has a reputed company record of offering H1B sponsorships, with 58 in 2026, 195 in 2025, 147 in 2024, 120 in 2023, 195 in 2022, 135 in 2021, 139 in 2020. Please note that this does not guarantee sponsorship for this specific role. .