Solutions Architect - Onsite (Banking Domain Exp required)

Location: McAllen, TX, USA

Length: Long term

Restriction: W2 or C2C

Description:

**** Webcam interview; *** Long term project *** Onsite ****

Job Description:

We are looking for an experienced Data Warehouse Solution Architect with expertise in Snowflake, Azure Data Factory (ADF), and Power BI to lead solution design and delivery for a large-scale data migration and modernization program. The candidate will work closely with business stakeholders and technical teams to define, design, and implement scalable, secure, and high-performance solutions on the Azure cloud data platform. Should have work experience in Banking Domain.

Key Responsibilities: Solution Design & Architecture

• Translate business requirements into end-to-end Data Warehouse solution designs leveraging Snowflake, ADF, and Power BI.
• Define integration, transformation, and reporting strategies for the migration program.
• Ensure solutions meet scalability, performance, security, and compliance requirements.
• Define and implement automation testing in ETL/ELT layers.
• Implement Data Quality and Data controls to in ELT and reporting layer.

Migration & Implementation

• Lead migration from on-prem/legacy systems to Snowflake using Azure cloud services.
• Define standards for data ingestion, ELT/ETL pipelines, and reporting layers.
• Oversee implementation of incremental, batch, and real-time data pipelines.

Collaboration & Leadership

• Partner with architects, engineers, BI developers, and business users to deliver business-ready solutions.
• Provide guidance and oversight to development teams during execution.
• Act as the solution authority in design reviews and project governance forums.

Governance & Best Practices

• Establish solution standards for data modelling, security, CI/CD, and monitoring.
• Ensure compliance with data governance, metadata, and regulatory policies.
• Promote adoption of best practices and reusable design patterns.

Required Skills & Experience

• Proven experience designing Data Warehouse solutions using Snowflake, ADF, and Power BI.
• Strong understanding of data modelling (Star and Snowflake Schema design) and ELT/ETL best practices.
• Hands-on knowledge of Azure ecosystem (ADLS, Key Vault, Databricks/Synapse optional).
• Experience in data migration projects (history loads, incremental refresh, large-scale transformations).
• Expertise in security & access control (RBAC, encryption, data masking).
• Familiarity with DevOps (Azure , CI/CD pipelines).
• Should be able to collaborate with teams and customers across globe.
• Expertise within the banking domain especially strong knowledge of loans and deposits. Understanding of consumer & commercial banking and general ledger functions will be an added advantage.