• Solutions Architect - Onsite

    MSys Inc. (Mcallen, TX)


    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.