"Alerted.org

Job summary:

Title:

Solutions Architect - Onsite

Location:

McAllen, TX, USA

Length and terms:

Long term - W2 or C2C

Position created on 10/14/2025 02:11 pm

Job 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 DevOps, 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.

Contact the recruiter working on this position:

The recruiter working on this position is Fazal(Shaji Team) Uddin

His/her contact number is +(1) (703) 4684697 His/her contact email is [email protected]

Our recruiters will be more than happy to help you to get this contract.