Data Architect

Overview Analyze the current data landscape, client capabilities, and business requirements to design scalable, high‑performance, and highly available data solutions. Lead cross‑functional teams in designing and developing data solution configurations aligned with the proposed architecture. Recommend best‑fit approaches to address development, integration, and performance challenges in data warehouse and business intelligence environments. Define strategic direction and create implementation roadmaps for enterprise data initiatives. Serve as the primary point of contact for architecture, design, and development‑related queries. Apply deep expertise in both modern and traditional data technologies to guide architectural decisions. Identify, evaluate, and adopt emerging technologies and methodologies to improve performance, automation, and scalability. Support business development by shaping solution architectures for proposals and participating in client meetings with the sales team. Experience and Qualifications 15+ years of experience in data engagements, leading data strategy, roadmaps, and end‑to‑end implementation programs. Expertise in enterprise data strategy, alignment with business objectives, transformation initiatives, and warehouse architecture models. Strong understanding of information flow, integration and interfacing approaches, business information models, logical and canonical data models, and data lifecycle management. Experience with analytical, regulatory, and compliance reporting models. Mandatory banking industry experience with strong domain expertise. Extensive experience in data migration strategy, planning, costing, execution, retention, archival, and disposal. Master Data Management (MDM) across multi‑domain environments using tools such as Informatica MDM, Stibo PIM, and Talend Data Fabric. Data governance capability assessment (as‑is/to‑be), framework design, model development, roadmap creation, and execution. Proficiency with architecture tools such as PowerDesigner, ArchiMate, Toad, and ERWin. Strong foundation in normalized/denormalized design, ER modeling, star schema design, hierarchical models, and Inmon and Kimball methodologies. Hands‑on experience with platforms including Postgres, Oracle, SQL Server, DB2, Teradata, Hive, Pig, Impala, MongoDB, Cassandra, HBase, and Snowflake. Additional Skills Programming and scripting: MS SQL, PL/SQL, NoSQL, Shell scripting, VBA, T‑SQL, DAX. Reporting and UI tools: MS SSRS, Oracle Forms (6i, 9i, 10g), Intellimatch, MS Access. RDBMS experience: Oracle 9i/10g, MS SQL Server 2008–2014, Oracle 9i AS/10g. Web and cloud technologies: Sitecore, AWS, WordPress, Google Analytics/GTM. Management tools: MS Project, MS Office Suite, JIRA, rLean. Frameworks and certifications: TOGAF, DAMA‑DMBOK.