Associate Data Architect II

Role Description

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.

Skills

Solution Architecture,Mysql,Database,Healthcare