Solution Architect – Data Migration & Analytics

Zensar Technologies • Raleigh, NC

2d • Onsite

About The Position

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 Overview 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.

Requirements

• 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)
• 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 programs, Performance and cost optimization
• All applicants must be legally authorized to work with Zensar.
• Visa sponsorship may be available for qualified applicants for certain positions.

Responsibilities

• 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.
• 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.
• Oversee implementation of efficient, reusable data pipelines using DBT and Snowflake.
• Drive performance tuning across: Data ingestion pipelines, Transformations across raw → silver → gold layers.
• Establish cost optimization strategies in Snowflake and AWS.
• 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.
• 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.
• 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.
• 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.

Benefits

• medical
• dental
• vision
• 401(k)

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed