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.