Role Proficiency:

Leverage expertise in a technology area (e.g. Informatic Transformation Terradata data warehouse Hadoop Analytics); responsible for System Architecture.

Outcomes:

     Implement any two of either/or data extract and transformation or a data warehouse(ETL Data Extracts Data Load Logic Mapping Work Flows stored procedures data warehouse ) or implement data analysis solution implement data reporting solutions or implement cloud data tools in any one of the cloud provider(AWS/AZURE/GCP)      Understand business workflows and related data flows and develop strategies for data acquisitions data transformation data modelling data storage; applying business intelligence on data and design of data fetching and dashboard      Create design by preparing data models; designing information structure work-and dataflow and navigation. Define backup recovery and security specifications      Define and enforce naming standards and data dictionary for data models      Provided guidance to business to create use cases for data services      Provide or guide team to perform estimates      Help team to develop proof of concepts (POC) and solutions relevant to customer problems; able to trouble shoot problems while developing POCs      Hold certification in Architect/Big Data Speciality Certification in one of AWS or Azure or GCP with exposure and understanding of other cloud and Big Data platforms

Measures of Outcomes:

     Percent of billable time spent in a year for developing and implementing data architecture      Number of RFP response given in a year      Number of best practices documented in any new tool and technology emerging in the market      Number of associates trained on the data service practice Number of Proof of Concepts developed

Outputs Expected:

Strategy & Planning:

Develop and deliver long-term strategic goals for data architecture vision and standards in conjunction with data users
department managers
clients
and other key stakeholders Create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap Establish processes for governing the identification
collection
and use of corporate data assets and metadata; take steps to assure metadata accuracy and validity Implement methods and procedures for tracking data quality
completeness
redundancy
and improvement. Ensure that data strategies and architectures meet regulatory compliance requirements. Engage external stakeholders including standards organizations
regulatory bodies
operators
and scientific research communities.

Operational Management :

Establish governance
stewardship
and frameworks for managing data across the organization Develop and contribute data management methodologies and standards Provide support in implementing the appropriate tools
software
applications
and systems to support data technology goals Collaborate with project managers and business teams for all projects involving enterprise data Analyse data-related issues with systems integration
compatibility
and multi-platform integration Act as a first point of connect for data management
including coaching
training. Implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data architecture Document and track the data architecture and environment in order to maintain a current and accurate view of the larger data picture Identify and develop opportunities for data reuse
migration
or retirement

Project Control and Review :

Perform data architecture design review Identify opportunities for optimization of cost
time
and asset utilization in complex projects and advise relevant teams accordingly where possible Provide advice to teams facing complex technical issues in the course of project delivery Conduct planned and unplanned technical audits for complex projects as applicable Define and measure project and program specific architectural and technology quality metrics

Knowledge Management & Capability Development :

Publish and maintain a repository of solutions
best practices and standards and other knowledge articles for data management Conduct and facilitate knowledge sharing and learning sessions across the team Gain industry standard certifications on technology or area of expertise Support technical skill building (including hiring and training) for the team based on inputs from project manager /RTE’s Mentor new members on the team in technical areas Gain and cultivate domain expertise to provide best and optimized solution to customer (delivery) Create architecture on-boarding/KT documents for the program

Requirement gathering and Analysis:

Work with customer. business owners and other teams to collect
analyze and understand the requirements including NFRs/define NFRs Analyze gaps and trade-offs based on current system context/ industry practices and clarify the requirements by working with the customer Define the systems and sub-systems that define the programs

People Management:

Set goals and manage performance of technical specialists and team engineers Provide career guidance and mentor technical specialists Alliance Management Identify alliance partners based on the understanding of service offerings and client requirements Collaborate with Architect to create a compelling business case around the offerings Conduct beta testing of the offerings and relevance to program

Technology Consulting:

In collaboration with Architect 2
3
analyze application/ technology landscape
process
tools and arrive at the architecture options best fit for the client
program Analyze Cost Vs. Benefits of solution options Support Architect 2
3 to create a technology/ architecture roadmap for the client Define Architecture strategy for the program

Innovation and Thought Leadership:

Participate in internal and external forums (seminars
paper presentation etc.) Understand clients existing business at the program level and explore new avenues to save cost and bring process efficiency Identify business opportunities to create reusable components/accelerators and reuse existing components and best practices Support the patent filing process for the IP assets created (applicable to some CoEs)

Sales Support and Project Estimation:

Provide support in developing RFPs and collaterals for proposals from a technical Architecture/ estimation/ risks perspective Conduct demos
and arrange for the demos based on client profiles
if required Anchor proposal development with cross-linkages across multiple competency units to arrive at a coherent solution proposal with focus on presenting unique value propositions and clear differentiators

Project Management Support:

Assist the PM/Scrum Master/Program Manager to identify technical risks and come-up with mitigation strategies

Stakeholder Management:

Monitor the concerns of internal stakeholders like Product Managers & RTE’s & external stakeholders like client architects
on Architecture aspects; follow through on commitments and achieve timely resolution of issues Conduct initiatives to meet client expectations Work to expand professional network in the client organization at the Team and Program levels

New Service Design:

Identify potential opportunities for new service offerings based on customer voice/ partner inputs Support the development of business case for investments for approval from management Work with partners to co-develop a joint GTM (as applicable) Develop IP/tools and framework to address the opportunity technically Conduct beta testing / POC as applicable Develop collaterals
guides for GTM

Skill Examples:

     Use Domain/ Industry Knowledge in order to understand business requirements. Create POC to meet business requirements contextualize the solution to the industry under guidance. Create architecture interact with SMEs at various stages of the development; translate business requirements to system requirements and perform impact analysis of changes in requirements      Use Technology Knowledge to create Proof of Concept (POC) / (reusable) assets. Assist in performance troubleshooting and complex troubleshooting. Define decide and defend the technology choices made review solutions      Use knowledge of Technology Trends to provide inputs on potential areas of opportunity for UST      Use knowledge of Architecture Concepts and Principles to create architecture catering to functional and non-functional requirements under guidance of the specialist. Re-engineer existing architecture solutions under the guidance of the specialist. Provide training on best practices in architecture under guidance      Use independent knowledge of Design Patterns Tools and Principles to create high level design for the given requirements. Evaluate multiple design options and choose the appropriate options for best possible trade-offs. Conduct knowledge sessions to enhance team's design capabilities. Review the low level and high level design created by Specialists for efficiency (consumption of hardware memory and memory leaks etc.)      Use knowledge of Software Development Process Tools & Techniques to identify and assess incremental improvements for software development process methodology and tools. Take technical responsibility for all stages in the software development process. Conduct optimal coding with clear understanding of memory leakage and related impact. Implement global standards and guidelines relevant to programming and development come up with 'points of view' and new technological ideas      Use knowledge of Project Management & Agile Tools and Techniques to support plan and manage medium size projects/programs as defined within UST; identify risks and mitigation strategies      Use knowledge of Project Metrics to understand relevance in project. Collect and collate project metrics and share it with relevant stakeholders      Use knowledge of Estimation and Resource Planning to create estimate and plan resources for specific modules / small projects with detailed requirements or user stories in place   Use knowledge of Knowledge Management Tools & Techniques to leverage existing material and re-usable assets in knowledge repository. Independently create and update knowledge artefacts. Create and track project specific KT plans. Provide training to others write white papers/ blogs at internal level write technical documents/ user understanding documents at the end of the project   Use knowledge of Technical Standards Documentation & Templates to create documentation appropriate for the project needs. Create documentation appropriate for the reusable assets best practices and case studies   Use knowledge of Requirement Gathering and Analysis to support creation of requirements documents or user stories and high level process maps. Identify gaps on the basis of business process analyse responses to clarification questions and produce design documents. Create and review estimates and solutions at project level/program level. Create and review design artefacts update resourcing and schedule based on impacted areas identified. Create design specifically for the non-functional requirements   Strong proficiencies in understanding data workflows and dataflows   Attention to details   High analytical capabilities   Creativity in developing solutions   Self-learning Resilience in solving problems

Knowledge Examples:

     Skilled in writing design documents usage of Power Point Visio      Data visualization streaming      Data migration      RDMSs (relational database management systems) SQL      Databases such as NoSQL and cloud computing      Hadoop technologies like MapReduce Hive and Pig      Programming languages especially Python and Java      Operating systems including UNIX and MS Windows      Cloud solutions   Backup/archival software   Understanding of data security

Additional Comments:

Job Summary: We are seeking an experienced Data Architect with a strong background in SQL, T/SQL, and data modeling to lead the design and optimization of enterprise data solutions. The ideal candidate will have expertise in the Health Payer domain (preferably with FACETS or similar tools). This role requires hands-on technical leadership, the ability to troubleshoot critical data issues, and the ability to manage multiple projects in parallel while leading a team of 15 resources. Key Responsibilities: Data Architecture & Design Design and review data architecture to ensure scalability, performance, and compliance with industry standards. Identify opportunities for cost, time, and asset utilization optimization in complex data projects. Conduct technical audits and data architecture reviews to improve efficiency. Define and measure architectural quality metrics for data solutions. Data Modeling & Optimization Develop and maintain logical and physical data models for various business use cases. Work with stakeholders to analyze gaps and trade-offs based on system context and industry practices. Define systems and sub-systems that align with program and enterprise goals. Technical Leadership & Mentoring Lead a team of 15 data engineers, providing technical mentorship and performance management. Support hiring, training, and skill-building activities for the team. Conduct knowledge-sharing sessions and maintain best practices in data management. Create onboarding and knowledge transfer (KT) documents for new programs. Collaboration & Stakeholder Management Work with business owners, customers, and cross-functional teams to gather and define requirements (including non-functional requirements - NFRs). Partner with architects to analyze technology landscapes, processes, and tools to define the best-fit architecture strategy. Collaborate with alliance partners and vendors to drive business value. Strategic & Risk Management Define technology roadmaps and drive architectural strategy for the program. Analyze cost vs. benefits of different solution architectures. Assist project managers and Scrum Masters in identifying technical risks and mitigation strategies. Innovation & Thought Leadership Participate in industry forums, conferences, and technical discussions to share knowledge. Explore new avenues for cost savings and process efficiencies within data operations. Conduct demos and presentations for internal and external stakeholders. Process Improvement & Automation Leverage scripting to automate data processes and improve efficiency. Continuously explore opportunities for cost savings and process efficiency in data operations. Cloud & Infrastructure Management Work with cloud environments to deploy, optimize, and scale data solutions. Collaborate with DevOps and Cloud teams to optimize cost, performance, and security. Skills: Expert-level knowledge of SQL and T-SQL. 12+years of experience in IT as Data Engineer / Database Programmer, out of which 3+ years of experience as a Data Architect. 3+ years of experience in data modeling and database design. Experience in the Health Payer Business, preferably with FACETS or similar platforms. Ability to manage multiple projects in parallel and lead a team of 15 resources. Strong understanding of data governance, ETL processes, and data integration frameworks. Experience defining non-functional requirements (NFRs) and system architecture. Strong analytical, problem-solving, and communication skills.