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. 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.
Solution Architect – Data Migration & Analytics
Location
United States
Posted
7 days ago
Salary
$125.1K - $203.5K / year
Seniority
Mid Level
Job Description
Solution Architect – Data Migration & Analytics
Zensar
Role Description 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. Key Responsibilities - 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 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 - Data Engineering & Pipeline Optimization - 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. - 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 - 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. - 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. - 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. Qualifications - 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. - Experience designing enterprise-scale data platforms. - Strong background in: - Data governance - Report rationalization programs - Performance and cost optimization Benefits - Flexible work arrangements. - Competitive benefits package, including medical, dental, vision, and 401(k).
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
• Develop analyses of financial, operational and corporate indicators; • Build, enhance and maintain dashboards, reports and management panels; • Create, validate and monitor indicators (KPIs), ensuring consistency and adherence to business rules; • Structure and monitor metrics such as EBITDA, Working Capital, Opex, Capex, Headcount, Turnover, Attrition and other strategic indicators; • Perform SQL queries for data investigation, validation and analysis; • Identify inconsistencies in databases, investigate root causes and propose analytical solutions; • Partner with business areas to support decision-making through data; • Document queries, indicators, metrics and business rules; • Collaborate with the CRM Analyst to respond to analytical requests; • Identify needs for database evolution and route them to Data Engineering; • Participate in AI initiatives, predictive analyses and analytical modeling to generate insights; • Drive continuous improvements in indicators, dashboards and analytical processes.
Technical Product and Data Business Analyst, GCP Analytics
Naveera Technology LLCEngineering Production-Ready Data, AI & Cloud Platforms - Scalable, Secure, and Built for Enterprise Growth.
• Collaborate with Product Managers, Business Stakeholders, and Engineering teams to gather, analyze, and document business requirements • Translate business requirements into detailed functional and technical specifications • Define product features, acceptance criteria, user stories, and business workflows • Analyze large datasets to identify trends, business insights, and optimization opportunities • Work with GCP Data Engineering teams to deliver scalable analytics solutions • Develop business dashboards and executive reports
Content Data Analyst/Researcher
McGraw Hill LLC.The work you do at McGraw Hill will be work that matters. We are collectively designing content that will build the future of education. Play your part and experience a sense of fulfilment that will inspire you to even greater heights.
Role Description Are you interested in making a difference in the lives of others? The McGraw Hill Higher Education team thrives on building meaningful relationships with educators to maximize the potential of every learner. This is a unique opportunity to have a far-reaching impact on student success as well as impact the educational technology industry. McGraw Hill, the leading provider of digital and print educational resources, is looking for a Content Data Analyst & Researcher for our Higher Education team. This individual serves as the data and research engine of the Content Courseware and Curriculum Teams, providing the analytical rigor, market intelligence, and curriculum insight necessary to drive evidence-based content decisions. This role partners closely with the Curriculum Strategy Manager and Content Courseware Team to close the feedback loop between content performance, learner outcomes, and market needs. This is a remote position open to applicants authorized to work for any employer within the United States. What you will be doing: - Conduct structured curriculum, market, and competitive research across relevant disciplines, analyzing course structures, learning objectives, topic coverage, industry trends, competitor offerings, pricing, formats, go-to-market strategies, product-market fit indicators, and emerging developments in education, academia, professional fields, and educational technology to identify opportunities, gaps, and future curriculum needs. - Build, maintain, and continuously improve organized research repositories, knowledge bases, content management systems, documentation standards, tagging taxonomies, competitive matrices, trend logs, watchlists, and tracking tools that support scalable operations, AI content ecosystems, prompt development, content accuracy verification, benchmarking, governance standards, and accessible knowledge sharing. - Synthesize and integrate secondary research, primary research, customer feedback, sales data, platform analytics, instructor input, and market intelligence into actionable insights, curriculum recommendations, product proposals, curricular spines, topic hierarchies, investment cases, ROI analyses, and data-driven recommendations that inform portfolio strategy, content planning, and new product development. - Design, maintain, and analyze data collection frameworks, dashboards, QA metrics, content performance indicators, learner engagement trends, quality measures, production velocity data, and dynamic content delivery signals to identify improvement opportunities, measure production impact, support evergreen content updates, and enable AI-driven optimization. - Plan, facilitate, and analyze customer research initiatives—including focus groups, user research sessions, discussion guides, surveys, research instruments, synthesis frameworks, and ongoing feedback repositories—while building relationships with educators, learners, partner institutions, and stakeholders to capture longitudinal insights and ensure product decisions reflect real user needs. - Collaborate closely with the Curriculum Strategy Manager, Content QA Specialist, Pod leadership, and cross-functional stakeholders within an agile environment to communicate research progress and findings, adapt priorities and methodologies, improve workflows and processes, leverage AI tools and emerging research techniques, maintain expertise in analytics and automation technologies, and demonstrate a continuous improvement and fail-fast learning mindset. Qualifications - Bachelor’s degree (or equivalent experience) in Data Science, Research Methods, Education, Business Analytics, Information Science, Communications, or a related field, with a preferred advanced degree in a relevant discipline. - 3+ years of experience in data analysis, market research, content/learning analytics, and conducting qualitative and quantitative research, including synthesizing findings and communicating actionable insights. - Strong analytical and technical skills, including proficiency with data visualization and analytics tools (e.g., Tableau, Power BI), experience with secondary market research, competitive analysis, industry trend tracking, and the ability to contribute to investment case development and ROI analysis. - Demonstrated experience maintaining documentation systems, databases, content repositories, CMS/DAM platforms, content tagging systems, taxonomies, content metadata, learning object analytics, and familiarity with AI-driven content ecosystems. - Excellent written, verbal, and presentation skills, with the ability to communicate complex data to non-technical audiences, facilitate focus groups, user interviews, and other qualitative research activities, and effectively manage stakeholder engagement. - Experience or familiarity with higher education, EdTech, educational publishing, curriculum development, agile or iterative project environments, and a strong ability to manage multiple workstreams in ambiguous, fast-paced settings while leveraging AI tools to enhance research and analysis workflows. Benefits - The pay range for this position is between $71,300 - $92,000 annually. However, base pay offered may vary depending on job-related knowledge, skills, experience, and location. - A full range of medical and/or other benefits may be provided, depending on the position offered.
Senior Analyst, IT - MDM/Data Governance
Builders FirstSourceBuilders FirstSource is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status or status as an individual with a disability.
Role Description The Senior MDM Analyst is responsible for proactive identification, analysis, and support of complex Master Data Management (MDM) solutions and will play a critical role in ensuring the accuracy, consistency, and integrity of our master data. This role will involve working closely with various stakeholders and teams to develop, implement, and maintain effective MDM solutions including supplier, customer, material, and other domains as needed. The Senior MDM Analyst will need to foster relationships throughout the organization to gather data and an understanding of what the data means to the business. This role will be a key participant in transformation initiatives related to MDM and Data Governance at Builders FirstSource. Essential Duties and Responsibilities - Collaborate with team members to ensure understanding of the functional MDM requirements and future strategic direction of the business. - Provide functional guidance and support to other team members and stakeholders regarding MDM best practices. - Translate MDM functional requirements into technical requirements and design. - Participate in solution design and support robust and complex initiatives. - Collaborate with business stakeholders to build master data workflow frameworks and governance rules that enable robust, scalable data quality processes. - Develop and execute complex testing scenarios across system, integration, and user acceptance phases, and support release management activities following required approvals. - Participate in standard data modeling, translate data requirements into effective use diagrams, and analyze existing databases through reverse engineering. - Develop and maintain documentation related to MDM processes and data mappings. - Act as a liaison to domain data owners to establish necessary data stewardship responsibilities and procedures. - Build and maintain existing enterprise data governance policies and procedures in collaboration with domain owners. - Develop tools and processes to improve data quality, accuracy, and consistency across the organization. - Track and report adherence to key MDM and data governance metrics/SLAs. - Perform data integrity gap analysis, identifying areas where application controls are insufficient. - Assist with the maintenance of complex golden records across domains. - Learn business processes and partner with business process owners/SMEs, IT, and data stewardship teams. - Communicate analytical findings through reports, briefings, and presentations. - Apply knowledge of data governance, workflows, and procedures in determining the most effective and actionable data analysis within the project planning frameworks. - Facilitate discussions with business users to understand and translate complex business requirements into master data management solutions aligned to business goals that deliver measurable value to the organization. Qualifications - Bachelor's degree from an accredited college/university. - 4+ years relevant work experience. - MDM Methodologies and Tooling (SAP MDG). - Data Governance and Data Quality experience. - SQL skills. - Experience with Informatica MDM and/or Enterworks is a nice to have. Requirements - Evaluates and analyzes different types of information objectively to identify appropriate solutions. - Communicates with clarity and precision, presenting complex information in a concise format that is appropriate for the audience. - Takes a positive approach to tackling work and embraces change. - Understands and anticipates customer needs and takes action to provide high-quality products and services to exceed expectations. - Demonstrates working knowledge of market, economic, legal, and regulatory environments and how they impact the business. - Understands how agility is leveraged in IT ways of working. - Takes initiative and identifies what needs to be done and acts without waiting to be asked. Benefits - Medical, dental, vision, and disability insurance plans. - 401(k) retirement savings plan. - PTO (including paid sick time). - 8 paid holidays per year (for salaried and hourly team members). Company Description Builders FirstSource is America’s largest supplier of building materials, value-added components, and building services to the professional market. We are committed to creating a diverse and inclusive workplace that welcomes candidates from all backgrounds and experience levels.

