> Markdown version of [/jobs/ext/1376807-solution-architect-data-migration-analytics](https://www.wearedevelopers.com/jobs/ext/1376807-solution-architect-data-migration-analytics). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Solution Architect - Data Migration & Analytics - **Company:** Zensar Technologies - **Location:** Raleigh, NC, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Amazon Web Services, Amazon S3, Data Analysis, Bioinformatics, Cloud Engineering, Customer Data Management, Data Architecture, Data Auditing, Information Engineering, Data Governance, Data Infrastructure, Data Transformation, Data Migration, Data Security, Data Vault Modeling, Data Warehousing, Fault Tolerance, Performance Tuning, Power BI, Data Streaming, Enterprise Software Applications, Data Ingestion, Snowflake, Data Strategy, Data Layers, Data Lakes, Data Analytics, Real Time Data, Data Management, Data Pipelines - **Published:** July 22, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1f7b9a9c0a9082ee ## About the Role Technical Expertise * 10 - 15+years experience in data and analytics * Strong experience in: + Snowflake (Data Warehousing & Optimization) + DBT (Data Transformation Framework) + AWS (S3, Kinesis, Cloud Architecture) * Proven experience with: + Medallion Architecture (Bronze/Raw, Silver, Gold layers) + Real-time & batch data ingestion patterns * Deep knowledge of: + Power BI (self-service, paginated reporting, semantic layers) + Data modeling (Dimensional & Data Vault) Domain Expertise * Strong experience in Insurance domain , particularly: + Policy, Claims, Billing, Customer data * Familiarity with InsuranceNow or similar core systems Architecture & Leadership * Experience designing enterprise-scale data platforms * Strong background in: + Data governance + Report rationalization programsPerformance and cost optimization Zensar believes that diversity of backgrounds, thought, experience, and expertise fosters the robust exchange of ideas that enables the highest quality collaboration and work product. Zensar is an equal opportunity employer. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. Zensar is committed to providing veteran employment opportunities to our service men and women. Zensar is committed to providing equal employment opportunities for people with disabilities or religious observances, including reasonable accommodation when needed. Accommodation made to facilitate the recruiting process are not a guarantee of future or continued accommodation once hired. All applicants must be legally authorized to work with Zensar. Visa sponsorship may be available for qualified applicants for certain positions. ## Description We are seeking a seasoned Solution Architect to lead a strategic data modernization and report rationalization program for a leading insurance client. The role will drive the design and implementation of a scalable, enterprise-wide data platform leveraging Snowflake, DBT, AWS, and Power BI , supporting both batch and real-time data ingestion while enabling advanced analytics and self-service reporting., 1. Enterprise Architecture & Strategy * Define and implement the target-state data architecture aligned with business goals for data modernization and reporting transformation. * Establish architecture principles, governance models, and design standards across data ingestion, transformation, and consumption layers. * Lead the adoption of Medallion Architecture (Raw, Silver, Gold layers) within Snowflake + DBT ecosystem. 2. Data Platform Design & Modernization * Architect ingestion of data from 14+ source systems including InsuranceNow , ensuring scalability and reliability. * Design hybrid ingestion patterns: + Batch ingestion from enterprise sources + Real-time streaming via Amazon Kinesis + Data lake storage in AWS S3 * Define data modelling strategies: + Canonical models and domain-driven design (aligned with insurance datasets) + Optimized analytical data models for reporting 3. Data Engineering & Pipeline Optimization * Oversee implementation of efficient, reusable data pipelines using DBT and Snowflake. * Drive performance tuning across: + Data ingestion pipelinesTransformations across raw silver + gold layers * Establish cost optimization strategies in Snowflake and AWS. 4. Reporting & Analytics Transformation * Lead report rationalization initiatives : + Consolidation and optimization of legacy reports + Elimination of redundancy and duplication * Architect Power BI ecosystem : + Semantic data models for self-service BI + Support for paginated reporting and advanced slicing/dicing * Enable business-friendly data access and analytics democratization 5. AI-driven Governance & Data Quality * Introduce AI-enabled frameworks for: + Data audit and reconciliation + Balancing and anomaly detection * Define enterprise-wide data quality, lineage, and governance standards * Ensure compliance with regulatory requirements in the insurance domain 6. Integration & Cloud Architecture * Define integration patterns across: + Snowflake, DBT, S3, Kinesis, and enterprise applications * Ensure secure, scalable, and fault-tolerant architecture in AWS cloud environment * Establish data security, encryption, and access control mechanisms 7. Leadership & Stakeholder Management * Collaborate with business, data engineering, BI, and governance teams * Act as a trusted advisor to CXO stakeholders on data strategy and investments * Drive architecture reviews, design approvals, and roadmap alignment ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)