Data Architect

Sensiple Inc is a New Jersey corporation with over two decades of expertise in technology-driven solutions specialising in Customer Experience, Contact Center Solutions, Digital Transformation, Cloud Computing & Independent Testing.

With an expert team that has enriched experience in executing & developing sustainable IT strategies in Healthcare, Technology, Retail, Logistics, Education, Telecommunications, Government and Media, we help our diverse customers to envision the future.

By developing highly scalable and consistent solutions, our primary goal is to deliver excellence at all levels and delight our customers and drive them to a better future.

Position: Data Architect

Work Location: New York City, NY (Hybrid)

Duration: Long Term Contract

Job Description:

We are seeking an experienced Data Architect with deep expertise in ETL/ELT pipeline design and the Snowflake AI Data Cloud platform. In this role, you will lead the strategy design and implementation of our enterprise data platform. You will bridge business requirements with cloud data architecture modernizing legacy data warehouses and constructing scalable, high-performance data integration pipelines.

Key Responsibilities:

• Architect, build and optimize scalable enterprise cloud data warehouses, data lakes, and lakehouse platforms.
• Design robust Snowflake architectures using advanced features including Snowpipe, Dynamic Tables, Streams, Tasks, Data Sharing and Snowpark.
• Lead end-to-end data integration strategies.
• Architect scalable data pipelines using tools such as dbt, Apache Airflow, Azure Data Factory, Informatica or Talend.
• Establish conceptual logical and physical data models for high-throughput analytical workloads.
• Optimize query performance, warehouse sizing, and storage costs within Snowflake.
• Implement enterprise data governance, metadata management, and security patterns including Role-Based Access Control, row-level security and data masking.
• Partner with BI engineers, data scientists and business stakeholders to translate strategic objectives into scalable technical pipelines.

Required Qualifications:

• Bachelor s or Master s degree in Computer Science, Information Technology or a related field.
• 10+ years of experience in data engineering, enterprise architecture or large-scale data modeling.
• 4+ years of hands-on experience designing and optimizing Snowflake cloud data environments.
• ETL/ELT Proficiency Deep experience in batch and real-time streaming ingestion API-driven integrations, and orchestration tools.
• Hands-on experience integrating Snowflake with AWS, Azure or Google Cloud Platform cloud infrastructures.
• Expert-level SQL tuning, data warehousing principles and schema optimization.
• Familiarity with CI/CD pipelines, Git and Infrastructure as Code.

Preferred Qualifications:

• Certifications: Snowflake SnowPro Advanced Architect or SnowPro Core certified.
• Migration Experience: Proven track record of modernizing on-premise legacy platforms to cloud platforms.