Data Architect - Financial Services

Job Description

• •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

Primary Skills

• •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.

Attributes

• •Self‑motivated professional with the ability to work independently or collaboratively within project teams.
• •Demonstrated ability to lead, mentor, and guide teams while supporting peers to achieve project outcomes.
• •Strong communication skills with the ability to convey complex technical concepts to diverse stakeholders.
• •Contributes to establishing enterprise‑wide guidelines, standards, and best practices for business intelligence and data solutions.