Data Architect

Compunnel, Inc.; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

A technology consulting firm is seeking an experienced Senior Data Architect with over 10 years of expertise in designing enterprise-level data architecture, particularly in the Banking domain. The role involves creating scalable data ecosystems and leading data transformation initiatives using tools like Informatica, Oracle, PostgreSQL, and Power BI. The ideal candidate will have strong skills in advanced SQL and Unix Shell Scripting, and a solid understanding of data governance and standards. This role is pivotal for driving data-driven decision-making across the organization.

Qualifications

• 10+ years of enterprise-level data architecture experience.
• 10+ years of hands-on experience in data modeling (conceptual, logical, physical).
• 10+ years of experience in data transformation and integration.
• 10+ years of experience in data storage, archival, and performance engineering.
• Strong understanding of enterprise data standards, governance, and security.

Responsibilities

• Design and implement enterprise data architecture frameworks supporting analytics and reporting.
• Develop conceptual, logical, and physical data models aligned with requirements.
• Lead data transformation initiatives ensuring accuracy and consistency across systems.
• Architect data storage and performance optimization strategies.
• Apply advanced SQL and Unix Shell Scripting for complex data operations.

Skills

Informatica or Talend

PostgreSQL, Oracle, or Snowflake

Power BI

Advanced SQL

Unix Shell Scripting

Job description

We are seeking an experienced Senior Data Architect with deep expertise in enterprise-level data architecture within the Banking domain.

The ideal candidate will have 10+ years of experience designing scalable data ecosystems, including data modeling, data transformation, data storage, data archival, and performance engineering.

This role requires strong hands-on experience with Informatica/Talend, PostgreSQL/Oracle/Snowflake, Power BI, advanced SQL, and Unix Shell Scripting.

The Data Architect will collaborate with cross-functional teams to define data strategies, ensure architectural consistency, and enable data-driven decision-making across the organization.

Key Responsibilities

• Design and implement enterprise data architecture frameworks supporting analytics, reporting, and operational systems.
• Develop conceptual, logical, and physical data models aligned with business and technical requirements.
• Lead data transformation initiatives, ensuring accuracy, consistency, and scalability across systems.
• Architect data storage, data archival, and performance optimization strategies.
• Apply advanced SQL and Unix Shell Scripting to support complex data operations.
• Leverage tools such as Informatica, Talend, PostgreSQL, Oracle, Snowflake, and Power BI for enterprise data solution delivery.
• Partner with stakeholders to translate business needs into scalable and secure data architectures.
• Ensure data quality, lineage tracking, and governance adherence across platforms.
• Troubleshoot performance issues and implement improvements at the data model and system level.
• Guide development teams on data architecture best practices and standards.

Required Qualifications

• 10+ years of enterprise-level data architecture experience.
• 10+ years of hands-on experience in:
• Data modeling (conceptual, logical, physical)
• Data transformation and integration
• Data storage, archival, and performance engineering
• 10+ years of experience with:
• Informatica or Talend
• PostgreSQL, Oracle, or Snowflake
• Power BI
• 10+ years of advanced experience in SQL and Unix Shell Scripting.
• Strong understanding of enterprise data standards, governance, and security.
• Ability to design scalable data architecture solutions for large, complex environments.

Preferred Qualifications

• Banking domain experience (highly preferred).
• Exposure to Python, Databricks, and Apache Spark.