Solution Architect - Data Migration & Analytics

Why Zensar?We’re a bunch of hardworking, fun-loving, people-oriented technology enthusiasts. We love what we do, and we’re passionate about helping our clients thrive in an increasingly complex digital world. Zensar is an organization focused on building relationships with our clients and with each other—and happiness is at the core of everything we do. In fact, we’re so into happiness that we’ve created a Global Happiness Council, and we send out a Happiness Survey to our employees each year. We’ve learned that employee happiness requires more than a competitive paycheck, and our employee value proposition—grow, own, achieve, learn (GOAL)—lays out the core opportunities we seek to foster for every employee. Teamwork and collaboration are critical to Zensar’s mission and success, and our teams work on a diverse and challenging mix of technologies across a broad industry spectrum. These industries include banking and financial services, high-tech and manufacturing, healthcare, insurance, retail, and consumer services. Our employees enjoy flexible work arrangements and a competitive benefits package, including medical, dental, vision, 401(k), among other benefits. If you are looking for a place to have an immediate impact, to grow and contribute, where we work hard, play hard, and support each other, consider joining team Zensar! Zensar is looking for a Solution Architect – Data Migration & Analytics in North Carolina This position is open for Full Time with excellent benefits and professional growth opportunities.Role OverviewWe 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.Key Responsibilities1. Enterprise Architecture & StrategyDefine 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 & ModernizationArchitect ingestion of data from 14+ source systems including InsuranceNow, ensuring scalability and reliability.Design hybrid ingestion patterns: Batch ingestion from enterprise sourcesReal-time streaming via Amazon KinesisData lake storage in AWS S3Define data modelling strategies: Canonical models and domain-driven design (aligned with insurance datasets)Optimized analytical data models for reporting3. Data Engineering & Pipeline OptimizationOversee implementation of efficient, reusable data pipelines using DBT and Snowflake.Drive performance tuning across: Data ingestion pipelinesTransformations across raw silver gold layersEstablish cost optimization strategies in Snowflake and AWS.4. Reporting & Analytics TransformationLead 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/dicingEnable business-friendly data access and analytics democratization5. AI-driven Governance & Data QualityIntroduce AI-enabled frameworks for: Data audit and reconciliationBalancing and anomaly detectionDefine enterprise-wide data quality, lineage, and governance standardsEnsure compliance with regulatory requirements in the insurance domain6. Integration & Cloud ArchitectureDefine integration patterns across: Snowflake, DBT, S3, Kinesis, and enterprise applicationsEnsure secure, scalable, and fault-tolerant architecture in AWS cloud environmentEstablish data security, encryption, and access control mechanisms7. Leadership & Stakeholder ManagementCollaborate with business, data engineering, BI, and governance teamsAct as a trusted advisor to CXO stakeholders on data strategy and investmentsDrive architecture reviews, design approvals, and roadmap alignmentRequired Skills & ExperienceTechnical Expertise10 – 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 patternsDeep knowledge of: Power BI (self-service, paginated reporting, semantic layers)Data modeling (Dimensional & Data Vault)Domain ExpertiseStrong experience in Insurance domain, particularly: Policy, Claims, Billing, Customer dataFamiliarity with InsuranceNow or similar core systemsArchitecture & LeadershipExperience designing enterprise-scale data platformsStrong background in: Data governanceReport rationalization programsPerformance and cost optimizationZensar 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.Zensar values your privacy. We’ll use your data in accordance with our privacy statement located at: At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.Full timePosting Date: 2026-08-04