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!

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.

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.

• 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.
• Data Platform Design & Modernization
• Architect ingestion of data from 14+ source systems including Insurance Now, 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…