Principal - Data Architect

**Job Title - Principal - Data Architect**

**The Purpose of This Role**

The Individual we are seeking to hire is a hands-on data architect with well-honed design and development skills. This individual is expected to work under consultative direction toward predetermined long-range targets for and offshore program/project delivery on behalf of Fidelity Fund & Investment operations (FFIO) Tech architecture

**The Value You Deliver**
- The incumbent will work at the functional/business unit level to provide technical leadership to programs and projects.
- Develop data architecture for FFIO’s Investment Operations related products and associated data stores cutting across the business domains.
- Data Integration architecture for complex business systems across OLTP, ODS and Data Lake environments
- Supports and communicates relevant IT governance policies, procedures, and processes and contribute to BU Data strategy, Reporting & Analytics roadmap and AI/ML strategy
- Work with DBAs to provide right physical topology for FFIO physical data stores that are resilient, high performing and scalable
- Deliver high performing DB model that can scale and are flexible. Contribute to FFIO data taxonomy and understand the domain to translate business requirements to right DB design
- Guide/develop, communicate and oversee implementation of high-level and low-level design in compliance to roadmap, architecture and design standards defined by Business Unit

**The Skills that are Key to this role**

**Technical / Behavioral**
- You have understanding & experience with all phases of Data Technologies viz., Data Development, Data Movement using ETLs, Data Analytics, and Data Visualization, Data Consumption patterns on Oracle and related RDBMS databases on cloud. You also have good orientation of No SQL DBs & distributed DBs eco-systems.
- You have proven experience on Snowflake platform and FinOps best practices for storage & compute on it
- You have deep expertise in Data Modeling across OLTP, ODS and DWH and can work with analyst to understand the domain and build taxonomy
- You have working knowledge of AWS services - S3, Serverless Compute, EKS etc. You understand roles and access management on cloud
- You have the expertise to right size DB storage and compute, tune DBs for performance and aware of replication strategies. You can configure DB’s physical topology - DR and Read Replicas in collaboration with the DBAs and understand costing and licensing aspects
- You have proven experience in Data Management - Data Quality, Data Lineage, Data Virtualization, Data Migration and Data Archive
- You are familiar with Python/R scripting and big data processing and analytics solutions like Spark
- You have knowledge of advance Oracle features for storing both structured and unstructured data, handling high transaction throughput, configurations for dimensional data models for data warehousing. You have hands on experience in SQL, PL/SQL, Views, Synonyms, Index and Partitioning configurations
- You have hands on experience on at least one ETL and Reporting tool
- You have thorough understanding of database design principles and patterns
- You have hands on experience on Orchestration tools like Control-M. You are familiar with streaming and micro batching design patterns
- You are independent in identifying business critical gaps and discrepancies; actively propose Architectural solutions keeping in mind the enterprise / business unit data strategies
- You define, champion, manage pace, and govern data architecture standards, tools, best practices, and related development methodologies working with the FFIO tech architecture practice group

**The Skills that are Good to Have for this role**
- Strong personal leadership and collaborative skills, combined with comprehensive, practical experience and knowledge in data architecture, data structure and algorithms and strategy domain
- Application Architectural expertise in project, product, and cross product technology strategy
- Experience working with modelling tools like PowerDesigner.
- Cloud deployment and design concepts and reference models
- Prior experience with Fund Investment front, middle and back office operations
- Knowledge of Digital Assets and its eco system
- Domain knowledge of Alternate Investment like Private Equity, Direct lending & REITS

**How Your Work Impacts the Organization**

Fidelity Fund & Investment Operations Technology (FFIO Tech) is the business unit that is responsible for delivering innovative, scalable, industry-leading tools that enable the three core domains viz., Investment Operations, Global Middle Office and Fund Oversight. FFIO Technology products support and enable our front office activities within Asset Management through various critical business processes like Reference Data, Fund Performance, Cash and Positions, Net Asset Values, Tax and Shareholder Reporting. FFIO Tech India is an integral part of the global FFIO Technology organiza